Data is no longer treated as a byproduct of business operations and has become one of the most valuable organizational assets. Every interaction on a banking application, e-commerce platform, hospital system, logistics network or social media service generates data continuously. As organizations increasingly adopt digital workflows, cloud platforms, machine learning systems and real-time applicati
In modern data-driven organizations, managing and analyzing data efficiently is critical. OLAP (Online Analytical Processing) and OLTP (Online Transaction Processing) are both integral parts of data management, but they have different functionalities. Understanding how they differ, and how they complement each other is essential for anyone working with data systems. Online Transaction Processing (
Fixed-length chunking requires no external services, yet semantic chunking absolutely needs an Embedding API — why? The core idea of semantic chunking is to split text at semantic boundaries. Determining whether "two pieces of text belong to the same topic" requires converting text into vectors and computing similarity — that's exactly what the Embedding API does. Dimension Fixed-Length / Recur
RAG stands for Retrieval Augmented Generation. Why do we even need RAG?? To answer this lets take a look at What LLMs and SLMs are. LLM(Large Language Model). Data on several categories(generalized) will be given as input. From that, a model would be created. What is a model ? To understand this, lets take mathematical equation of a straight line y = mx +c Lets take x values to be 1, 2, 3, ... a
Why Do We Need Specialized Vector Databases? In the first five articles, we figured out how to chunk documents and generate embeddings. Now where do these vectors live, and how are they efficiently retrieved? You might wonder: "Can't I just store vectors in Redis or PostgreSQL?" No — traditional databases are designed for exact queries (e.g., WHERE id = 123), while vector retrieval is Approximat
SQL is widely known for data querying and manipulation but systems do grow; data becomes larger; processes become repetitive and operations become sensitive. SQL has some features which enables it to be considered a fully fledged programming language. Some of the features which I discuss in this article are procedures, functions and transactions. Each of these concepts serve distinct purposes. Sto
In Day-1, we understood about the overview of a RAG system and what are its components and how it helps the LLM to generate more accurate and contextual responses. Now, lets see about the storage of the data using Vector Databases. Lets assume that we have a PDF with us and this would be considered as our private data. Now I want my LLM to have the context about this PDF, So that I could ask any q
Gen AI Based Chatbots, Its quite normal and people are doing it for couple of years now, So what’s Different that I am doing? Well the biggest issue with using AI models now is its Cost, even for a simple FAQ based chatbots. The Cost goes in Thousands.. The result is P.A.I.. It's a chatbot widget that lives in the corner of my portfolio site. Visitors The Architecture at a Glance Before diving