— by James Cameron

Insertion, selection, bubble, merge, and quick sort — Ever wonder how the products in an Amazon or any other e-commerce website get sorted when you apply filters like low-to-high or high-to-low, or alphabetically? Sorting algorithms play a vital role for such websites where you have an enormous amount of products listed and you have to make customer interactions…

Indexes in SQL Server helps in faster retrieval of data and thus improving the performance of queries. Indexes are associated with tables or views which makes the retrieval of rows from the table or views fast. Indexes basically contain keys which are built from one or more column in the…

Let us suppose that an e-commerce company wants to expand its business worldwide. As such, the Datawarehouse team wants to store the purchase details country wise, keeping the purchase id continuous. That is, if there are 3 tables {PurchaseID_India, PurchaseID_UK, PurchaseID_Canada} and 5 purchases {2 in India, 1 in the…

Multi-Dimensional Data Modelling — Before going further, it is highly recommended to visit Data Cube. Earlier, data were present in the form of relational tables having multiple joins and views. This made the data retrieval a time taking process. Also, this resulted in a slow turnaround time for complex queries and large size of…

Are you familiar with the terms Data Mart, Data Warehouse, Data Lake? If not, we got you covered. Just hover over each of the terms and it will hardly take 2–3mins to get familiar with the terms. Ever wondered how e-commerce websites store information related to its customers, the stores…

React acting like a complete BOSS! — Document Object Model or DOM is a tree-like structure of a web page, consisting of nodes and objects, that the browsers create when a web page is loaded. Talking specifically, DOM acts as a programming interface for HTML and XML documents. Hence, it can be said that DOM is the…

Ever wondered how the websites that you visit, work? Like other programming languages such as Python, C, and C++, even HTML has a pre-defined structure which is usually not visible to us. Our websites use the concepts of DOM in order to create a structure. DOM stands for Document Object…

Chicken or Egg, what came first? — The chicken or the egg causality dilemma is commonly stated as the question, “Which came first: the chicken or the egg?” The dilemma stems from the observation that all chickens hatch from eggs and all chicken eggs are laid by chickens. Well, worry not. The mystery has been finally solved…