Nov 20, 2025 · 5 min read · 1. Storage Hierarchy Overview SQL Server organizes data in a strict hierarchy. To the Operating System, SQL Server is just reading and writing files. However, internally, it manages a complex filing system. The Hierarchy: Instance → Database → Filegr...
Join discussionJan 17, 2025 · 2 min read · What is Eventual consistency? 🤔 In a distributed data warehouse system, Updates made to the data stored are eventually reflected to data stored in all the nodes. This means that while there might be a temporary period where different nodes show di...
Join discussion
Dec 11, 2023 · 3 min read · What Is a Database? Overview, Types, and Key Components A database is a structured collection of data, organized for efficient storage, management, and retrieval. Various types of databases exist, each with distinct attributes and purposes. Different...
Join discussion
Jun 30, 2023 · 12 min read · Introduction In this article, we will explore B+ Trees, a fundamental data structure extensively utilized in DBMS, especially for table indexes. Building upon our previous discussion of Hash Tables, we will delve into the design considerations, imple...
Join discussion
Jun 4, 2023 · 11 min read · Introduction In the previous article, we delved into the world of database storage, specifically focusing on disk-oriented DBMS and how tuples are stored within pages using different approaches such as the Tuple Oriented Approach, Slotted Pages Appro...
Join discussion