{"id":624,"date":"2025-05-19T05:45:20","date_gmt":"2025-05-19T05:45:20","guid":{"rendered":"https:\/\/buhave.com\/courses\/?p=624"},"modified":"2026-06-06T13:21:27","modified_gmt":"2026-06-06T13:21:27","slug":"databases-and-storage","status":"publish","type":"post","link":"https:\/\/buhave.com\/courses\/system-design\/databases-and-storage\/","title":{"rendered":"Databases and Storage"},"content":{"rendered":"<h2><strong>SQL vs. NoSQL<\/strong><\/h2>\n<p><strong>Overview:<\/strong><br \/>\nSQL (Structured Query Language) and NoSQL (Not Only SQL) databases are two broad categories of database technologies, each with different structures, use cases, and benefits.<\/p>\n<h3>SQL Databases<\/h3>\n<p><strong>Definition:<\/strong><br \/>\nSQL databases are relational databases that use structured schemas with rows and columns. Data is stored in tables, and relationships between data are maintained using keys.<\/p>\n<p><strong>Key Features:<\/strong><\/p>\n<ul>\n<li>Structured schema with fixed table definitions.<\/li>\n<li>Uses SQL for defining and manipulating data.<\/li>\n<li>ACID compliance ensures reliable transactions.<\/li>\n<li>Ideal for complex queries and relational data.<\/li>\n<\/ul>\n<p><strong>Common SQL Databases:<\/strong><\/p>\n<ul>\n<li>MySQL<\/li>\n<li>PostgreSQL<\/li>\n<li>SQLite<\/li>\n<li>Oracle Database<\/li>\n<\/ul>\n<h3>NoSQL Databases<\/h3>\n<p><strong>Definition:<\/strong><br \/>\nNoSQL databases are non-relational and store data in flexible formats like key-value pairs, documents, graphs, or wide-columns, allowing for dynamic, scalable data handling. For practical guidance on building scalable data stores, see <a href=\"https:\/\/buhave.com\/courses\/system-design\/designing-core-system-components\/\">Designing Core System Components<\/a>.<\/p>\n<p><strong>Key Features:<\/strong><\/p>\n<ul>\n<li>Flexible schema, can handle unstructured or semi-structured data.<\/li>\n<li>Designed for horizontal scalability and high performance.<\/li>\n<li>Eventual consistency rather than strict ACID compliance (varies by type).<\/li>\n<li>Supports large-scale distributed data systems.<\/li>\n<\/ul>\n<p><strong>Common NoSQL Databases:<\/strong><\/p>\n<ul>\n<li>MongoDB (Document)<\/li>\n<li>Redis (Key-Value)<\/li>\n<li>Cassandra (Wide-Column)<\/li>\n<li>Neo4j (Graph)<\/li>\n<\/ul>\n<h3>Key Differences<\/h3>\n<ul>\n<li>Data Model: SQL uses tables and relations; NoSQL uses flexible formats like JSON or key-value.<\/li>\n<li>Schema: SQL requires predefined schemas; NoSQL allows dynamic schemas.<\/li>\n<li>Scalability: SQL is vertically scalable; NoSQL is typically horizontally scalable.<\/li>\n<li>Use Cases: SQL is ideal for structured data and transactions; NoSQL is great for big data, real-time apps, and distributed systems.<\/li>\n<\/ul>\n<p>These scalability considerations are discussed in <a href=\"https:\/\/buhave.com\/courses\/system-design\/fundamentals-of-scalable-systems\/\">Fundamentals of Scalable Systems<\/a>.<\/p>\n<h2>Indexing, replication, and sharding<\/h2>\n<h3>Indexing, Replication, and Sharding<\/h3>\n<h3>Indexing<\/h3>\n<p><strong>Definition:<\/strong> Indexing is the process of creating data structures that improve the speed of data retrieval operations in a database, typically by reducing the number of records the system needs to scan.<\/p>\n<p><strong>How It Works:<\/strong> When an index is created on one or more columns of a table, the database engine maintains a separate lookup table that maps indexed values to the corresponding records. This works similarly to the index of a book, allowing faster access.<\/p>\n<p><strong>Types of Indexes:<\/strong><\/p>\n<ul>\n<li>Single-column index<\/li>\n<li>Composite (multi-column) index<\/li>\n<li>Unique index<\/li>\n<li>Full-text index<\/li>\n<\/ul>\n<p><strong>Benefits:<\/strong><\/p>\n<ul>\n<li>Faster query performance for search, sort, and filtering operations<\/li>\n<li>Reduces CPU and I\/O cost for frequent read operations<\/li>\n<\/ul>\n<p><strong>Trade-offs:<\/strong><\/p>\n<ul>\n<li>Consumes additional disk space<\/li>\n<li>May slow down write operations (INSERT, UPDATE, DELETE)<\/li>\n<\/ul>\n<h3>Replication<\/h3>\n<p><strong>Definition:<\/strong> Replication is the process of copying data from one database server (primary\/master) to one or more servers (replicas\/slaves) to improve availability and fault tolerance.<\/p>\n<p><strong>How It Works:<\/strong> The primary server handles all write operations and synchronizes data changes to the replicas. The replicas typically handle read-only queries, helping to distribute load and ensure high availability.<\/p>\n<p><strong>Types of Replication:<\/strong><\/p>\n<ul>\n<li>Master-slave (primary-secondary) replication<\/li>\n<li>Master-master (multi-primary) replication<\/li>\n<li>Synchronous vs. asynchronous replication<\/li>\n<\/ul>\n<p><strong>Benefits:<\/strong><\/p>\n<ul>\n<li>High availability and data redundancy<\/li>\n<li>Improved performance by load-balancing read operations<\/li>\n<li>Disaster recovery readiness<\/li>\n<\/ul>\n<p><strong>Trade-offs:<\/strong><\/p>\n<ul>\n<li>Possible data lag in asynchronous replication<\/li>\n<li>Increased complexity in system design and maintenance<\/li>\n<\/ul>\n<h3>Sharding<\/h3>\n<p><strong>Definition:<\/strong> Sharding is a method of database partitioning that distributes data across multiple machines or databases to handle large datasets and improve scalability.<\/p>\n<p><strong>How It Works:<\/strong> Instead of storing all records in a single database, sharding splits them based on a shard key (e.g., user ID, region, etc.). Each shard holds a portion of the data and operates independently.<\/p>\n<p><strong>Shard Strategies:<\/strong><\/p>\n<ul>\n<li>Range-based sharding<\/li>\n<li>Hash-based sharding<\/li>\n<li>Geo-based sharding<\/li>\n<\/ul>\n<p><strong>Benefits:<\/strong><\/p>\n<ul>\n<li>Improves read\/write performance by distributing load<\/li>\n<li>Enables horizontal scaling to handle large volumes of data<\/li>\n<li>Isolates failures to specific shards<\/li>\n<\/ul>\n<p><strong>Trade-offs:<\/strong><\/p>\n<ul>\n<li>Complexity in query routing and data aggregation<\/li>\n<li>Rebalancing shards can be operationally challenging<\/li>\n<\/ul>\n<p>These shard strategies are commonly discussed in <a href=\"https:\/\/buhave.com\/courses\/system-design\/fundamentals-of-scalable-systems\/\">Fundamentals of Scalable Systems<\/a>.<\/p>\n<h2>Caching strategies (Redis, Memcached)<\/h2>\n<p>Caching is a technique used to store frequently accessed data in a high-speed storage layer (cache) to reduce database load, decrease latency, and improve application performance.<\/p>\n<h3>What Is Caching?<\/h3>\n<p>Caching involves temporarily storing copies of data so future requests for that data can be served faster. It reduces the need to repeatedly access slower storage layers such as databases or APIs. For network-level considerations in distributed caches, see <a href=\"https:\/\/buhave.com\/courses\/system-design\/networking-basics\/\">Networking Basics<\/a>.<\/p>\n<p><strong>Why Use Caching?<\/strong><\/p>\n<ul>\n<li>Reduces latency and response times<\/li>\n<li>Decreases load on databases and servers<\/li>\n<li>Improves application scalability<\/li>\n<li>Enhances user experience by speeding up repeated data access<\/li>\n<\/ul>\n<p><strong>Common Caching Strategies<\/strong><\/p>\n<p><strong>1. Write-Through Cache<\/strong><\/p>\n<ul>\n<li>Data is written to the cache and the database simultaneously.<\/li>\n<li>Ensures the cache is always up-to-date.<\/li>\n<li>Slightly slower for write operations due to dual writes.<\/li>\n<\/ul>\n<p><strong>2. Write-Around Cache<\/strong><\/p>\n<ul>\n<li>Data is written only to the database.<\/li>\n<li>Cache is updated only on subsequent reads.<\/li>\n<li>Prevents cache pollution for infrequently read data.<\/li>\n<\/ul>\n<p><strong>3. Write-Back (Write-Behind) Cache<\/strong><\/p>\n<ul>\n<li>Data is written to the cache first, then asynchronously written to the database.<\/li>\n<li>Improves write performance but increases risk of data loss if the cache fails.<\/li>\n<\/ul>\n<p><strong>4. Cache-Aside (Lazy Loading)<\/strong><\/p>\n<ul>\n<li>Data is loaded into the cache only when requested.<\/li>\n<li>Application checks cache first, then fetches from the database if not found.<\/li>\n<li>Most flexible and commonly used strategy.<\/li>\n<\/ul>\n<h3><strong>Popular Tools: Redis vs. Memcached<\/strong><\/h3>\n<p><strong>Redis<\/strong><\/p>\n<ul>\n<li>Data Types: Supports strings, lists, sets, sorted sets, hashes, bitmaps, hyperloglogs, and streams.<\/li>\n<li>Persistence: Offers snapshotting and append-only file (AOF) for data persistence.<\/li>\n<li>Advanced Features: Pub\/Sub, Lua scripting, transactions, geospatial indexing.<\/li>\n<li>Use Cases: Session storage, leaderboards, caching complex objects, message queues.<\/li>\n<\/ul>\n<p><strong>Memcached<\/strong><\/p>\n<ul>\n<li>Data Types: Supports strings only (key-value pairs).<\/li>\n<li>Persistence: No built-in persistence; all data is stored in-memory only.<\/li>\n<li>Simplicity: Lightweight, fast, and easy to set up.<\/li>\n<li>Use Cases: Simple caching needs, session storage, read-heavy workloads.<\/li>\n<\/ul>\n<p><strong>Choosing Between Redis and Memcached<\/strong><\/p>\n<table border=\"1\">\n<thead>\n<tr>\n<th>Feature<\/th>\n<th>Redis<\/th>\n<th>Memcached<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>Persistence<\/td>\n<td>Yes<\/td>\n<td>No<\/td>\n<\/tr>\n<tr>\n<td>Data Structures<\/td>\n<td>Rich (sets, lists, etc.)<\/td>\n<td>Strings only<\/td>\n<\/tr>\n<tr>\n<td>Performance<\/td>\n<td>Slightly heavier but richer<\/td>\n<td>Lightweight and fast<\/td>\n<\/tr>\n<tr>\n<td>Scalability<\/td>\n<td>Cluster support<\/td>\n<td>Supports distributed caching<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>For a broader overview of distributed caches and system design, see Introduction to System Design.<\/p>\n<p><strong>Best Practices<\/strong><\/p>\n<ul>\n<li>Choose appropriate eviction policies (e.g., LRU, LFU).<\/li>\n<li>Set TTLs (Time-to-Live) to automatically expire stale data.<\/li>\n<li>Avoid caching sensitive data unless encrypted.<\/li>\n<li>Monitor cache hit\/miss ratios to optimize performance.<\/li>\n<li>Use consistent hashing for distributed caching systems.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>SQL vs. NoSQL Overview: SQL (Structured Query Language) and NoSQL (Not Only SQL) databases are two broad categories of database [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":625,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[15],"tags":[],"class_list":["post-624","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-system-design"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.1 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Databases and Storage - System Design Course<\/title>\n<meta name=\"description\" content=\"Databases and storage involve systems used to store, manage, and retrieve data efficiently for applications, websites, and services.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/buhave.com\/courses\/system-design\/databases-and-storage\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Databases and Storage - System Design Course\" \/>\n<meta property=\"og:description\" content=\"Databases and storage involve systems used to store, manage, and retrieve data efficiently for applications, websites, and services.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/buhave.com\/courses\/system-design\/databases-and-storage\/\" \/>\n<meta property=\"og:site_name\" content=\"BUHAVE\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/BeYouHave\/\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/naveedsafdarawan\/\" \/>\n<meta property=\"article:published_time\" content=\"2025-05-19T05:45:20+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-06-06T13:21:27+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/buhave.com\/courses\/wp-content\/uploads\/2025\/05\/Databases-and-Storage.webp\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/webp\" \/>\n<meta name=\"author\" content=\"Naveed Safdar\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Naveed Safdar\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/buhave.com\\\/courses\\\/system-design\\\/databases-and-storage\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/buhave.com\\\/courses\\\/system-design\\\/databases-and-storage\\\/\"},\"author\":{\"name\":\"Naveed Safdar\",\"@id\":\"https:\\\/\\\/buhave.com\\\/courses\\\/#\\\/schema\\\/person\\\/04fe0254e118521c9fbb3da39de5acca\"},\"headline\":\"Databases and Storage\",\"datePublished\":\"2025-05-19T05:45:20+00:00\",\"dateModified\":\"2026-06-06T13:21:27+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/buhave.com\\\/courses\\\/system-design\\\/databases-and-storage\\\/\"},\"wordCount\":975,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/buhave.com\\\/courses\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/buhave.com\\\/courses\\\/system-design\\\/databases-and-storage\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/buhave.com\\\/courses\\\/wp-content\\\/uploads\\\/2025\\\/05\\\/Databases-and-Storage.webp\",\"articleSection\":[\"System Design Course\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/buhave.com\\\/courses\\\/system-design\\\/databases-and-storage\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/buhave.com\\\/courses\\\/system-design\\\/databases-and-storage\\\/\",\"url\":\"https:\\\/\\\/buhave.com\\\/courses\\\/system-design\\\/databases-and-storage\\\/\",\"name\":\"Databases and Storage - System Design Course\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/buhave.com\\\/courses\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/buhave.com\\\/courses\\\/system-design\\\/databases-and-storage\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/buhave.com\\\/courses\\\/system-design\\\/databases-and-storage\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/buhave.com\\\/courses\\\/wp-content\\\/uploads\\\/2025\\\/05\\\/Databases-and-Storage.webp\",\"datePublished\":\"2025-05-19T05:45:20+00:00\",\"dateModified\":\"2026-06-06T13:21:27+00:00\",\"description\":\"Databases and storage involve systems used to store, manage, and retrieve data efficiently for applications, websites, and services.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/buhave.com\\\/courses\\\/system-design\\\/databases-and-storage\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/buhave.com\\\/courses\\\/system-design\\\/databases-and-storage\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/buhave.com\\\/courses\\\/system-design\\\/databases-and-storage\\\/#primaryimage\",\"url\":\"https:\\\/\\\/buhave.com\\\/courses\\\/wp-content\\\/uploads\\\/2025\\\/05\\\/Databases-and-Storage.webp\",\"contentUrl\":\"https:\\\/\\\/buhave.com\\\/courses\\\/wp-content\\\/uploads\\\/2025\\\/05\\\/Databases-and-Storage.webp\",\"width\":1200,\"height\":628,\"caption\":\"Databases and Storage\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/buhave.com\\\/courses\\\/system-design\\\/databases-and-storage\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Courses\",\"item\":\"https:\\\/\\\/buhave.com\\\/courses\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"System Design Course\",\"item\":\"https:\\\/\\\/buhave.com\\\/courses\\\/learn\\\/system-design\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Databases and Storage\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/buhave.com\\\/courses\\\/#website\",\"url\":\"https:\\\/\\\/buhave.com\\\/courses\\\/\",\"name\":\"BUHAVE\",\"description\":\"Courses - Learn Online for Free\",\"publisher\":{\"@id\":\"https:\\\/\\\/buhave.com\\\/courses\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/buhave.com\\\/courses\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/buhave.com\\\/courses\\\/#organization\",\"name\":\"BUHAVE\",\"url\":\"https:\\\/\\\/buhave.com\\\/courses\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/buhave.com\\\/courses\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/buhave.com\\\/courses\\\/wp-content\\\/uploads\\\/2025\\\/03\\\/buhave-course.webp\",\"contentUrl\":\"https:\\\/\\\/buhave.com\\\/courses\\\/wp-content\\\/uploads\\\/2025\\\/03\\\/buhave-course.webp\",\"width\":375,\"height\":75,\"caption\":\"BUHAVE\"},\"image\":{\"@id\":\"https:\\\/\\\/buhave.com\\\/courses\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/BeYouHave\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/buhave\",\"https:\\\/\\\/www.youtube.com\\\/@buhave\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/buhave.com\\\/courses\\\/#\\\/schema\\\/person\\\/04fe0254e118521c9fbb3da39de5acca\",\"name\":\"Naveed Safdar\",\"description\":\"I\u2019m Naveed Safdar - SEO Manager with over 10 years of experience in SEO and Digital Marketing. I\u2019ve had the privilege of working with leading national and international companies including Grafdom, PakWheels, Systems Limited, Confiz, Educative, and Dubizzle Labs. My expertise spans technical SEO, content strategy, organic growth, and performance analytics - helping businesses improve visibility, traffic, and ROI.\",\"sameAs\":[\"https:\\\/\\\/www.linkedin.com\\\/in\\\/naveedsafdar\\\/\",\"https:\\\/\\\/www.facebook.com\\\/naveedsafdarawan\\\/\",\"https:\\\/\\\/www.youtube.com\\\/@naveedsafdar\"],\"url\":\"https:\\\/\\\/buhave.com\\\/courses\\\/author\\\/naveed-safdar\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Databases and Storage - System Design Course","description":"Databases and storage involve systems used to store, manage, and retrieve data efficiently for applications, websites, and services.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/buhave.com\/courses\/system-design\/databases-and-storage\/","og_locale":"en_US","og_type":"article","og_title":"Databases and Storage - System Design Course","og_description":"Databases and storage involve systems used to store, manage, and retrieve data efficiently for applications, websites, and services.","og_url":"https:\/\/buhave.com\/courses\/system-design\/databases-and-storage\/","og_site_name":"BUHAVE","article_publisher":"https:\/\/www.facebook.com\/BeYouHave\/","article_author":"https:\/\/www.facebook.com\/naveedsafdarawan\/","article_published_time":"2025-05-19T05:45:20+00:00","article_modified_time":"2026-06-06T13:21:27+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/buhave.com\/courses\/wp-content\/uploads\/2025\/05\/Databases-and-Storage.webp","type":"image\/webp"}],"author":"Naveed Safdar","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Naveed Safdar","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/buhave.com\/courses\/system-design\/databases-and-storage\/#article","isPartOf":{"@id":"https:\/\/buhave.com\/courses\/system-design\/databases-and-storage\/"},"author":{"name":"Naveed Safdar","@id":"https:\/\/buhave.com\/courses\/#\/schema\/person\/04fe0254e118521c9fbb3da39de5acca"},"headline":"Databases and Storage","datePublished":"2025-05-19T05:45:20+00:00","dateModified":"2026-06-06T13:21:27+00:00","mainEntityOfPage":{"@id":"https:\/\/buhave.com\/courses\/system-design\/databases-and-storage\/"},"wordCount":975,"commentCount":0,"publisher":{"@id":"https:\/\/buhave.com\/courses\/#organization"},"image":{"@id":"https:\/\/buhave.com\/courses\/system-design\/databases-and-storage\/#primaryimage"},"thumbnailUrl":"https:\/\/buhave.com\/courses\/wp-content\/uploads\/2025\/05\/Databases-and-Storage.webp","articleSection":["System Design Course"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/buhave.com\/courses\/system-design\/databases-and-storage\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/buhave.com\/courses\/system-design\/databases-and-storage\/","url":"https:\/\/buhave.com\/courses\/system-design\/databases-and-storage\/","name":"Databases and Storage - System Design Course","isPartOf":{"@id":"https:\/\/buhave.com\/courses\/#website"},"primaryImageOfPage":{"@id":"https:\/\/buhave.com\/courses\/system-design\/databases-and-storage\/#primaryimage"},"image":{"@id":"https:\/\/buhave.com\/courses\/system-design\/databases-and-storage\/#primaryimage"},"thumbnailUrl":"https:\/\/buhave.com\/courses\/wp-content\/uploads\/2025\/05\/Databases-and-Storage.webp","datePublished":"2025-05-19T05:45:20+00:00","dateModified":"2026-06-06T13:21:27+00:00","description":"Databases and storage involve systems used to store, manage, and retrieve data efficiently for applications, websites, and services.","breadcrumb":{"@id":"https:\/\/buhave.com\/courses\/system-design\/databases-and-storage\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/buhave.com\/courses\/system-design\/databases-and-storage\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/buhave.com\/courses\/system-design\/databases-and-storage\/#primaryimage","url":"https:\/\/buhave.com\/courses\/wp-content\/uploads\/2025\/05\/Databases-and-Storage.webp","contentUrl":"https:\/\/buhave.com\/courses\/wp-content\/uploads\/2025\/05\/Databases-and-Storage.webp","width":1200,"height":628,"caption":"Databases and Storage"},{"@type":"BreadcrumbList","@id":"https:\/\/buhave.com\/courses\/system-design\/databases-and-storage\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Courses","item":"https:\/\/buhave.com\/courses\/"},{"@type":"ListItem","position":2,"name":"System Design Course","item":"https:\/\/buhave.com\/courses\/learn\/system-design\/"},{"@type":"ListItem","position":3,"name":"Databases and Storage"}]},{"@type":"WebSite","@id":"https:\/\/buhave.com\/courses\/#website","url":"https:\/\/buhave.com\/courses\/","name":"BUHAVE","description":"Courses - Learn Online for Free","publisher":{"@id":"https:\/\/buhave.com\/courses\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/buhave.com\/courses\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/buhave.com\/courses\/#organization","name":"BUHAVE","url":"https:\/\/buhave.com\/courses\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/buhave.com\/courses\/#\/schema\/logo\/image\/","url":"https:\/\/buhave.com\/courses\/wp-content\/uploads\/2025\/03\/buhave-course.webp","contentUrl":"https:\/\/buhave.com\/courses\/wp-content\/uploads\/2025\/03\/buhave-course.webp","width":375,"height":75,"caption":"BUHAVE"},"image":{"@id":"https:\/\/buhave.com\/courses\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/BeYouHave\/","https:\/\/www.linkedin.com\/company\/buhave","https:\/\/www.youtube.com\/@buhave"]},{"@type":"Person","@id":"https:\/\/buhave.com\/courses\/#\/schema\/person\/04fe0254e118521c9fbb3da39de5acca","name":"Naveed Safdar","description":"I\u2019m Naveed Safdar - SEO Manager with over 10 years of experience in SEO and Digital Marketing. I\u2019ve had the privilege of working with leading national and international companies including Grafdom, PakWheels, Systems Limited, Confiz, Educative, and Dubizzle Labs. My expertise spans technical SEO, content strategy, organic growth, and performance analytics - helping businesses improve visibility, traffic, and ROI.","sameAs":["https:\/\/www.linkedin.com\/in\/naveedsafdar\/","https:\/\/www.facebook.com\/naveedsafdarawan\/","https:\/\/www.youtube.com\/@naveedsafdar"],"url":"https:\/\/buhave.com\/courses\/author\/naveed-safdar\/"}]}},"_links":{"self":[{"href":"https:\/\/buhave.com\/courses\/wp-json\/wp\/v2\/posts\/624","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/buhave.com\/courses\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/buhave.com\/courses\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/buhave.com\/courses\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/buhave.com\/courses\/wp-json\/wp\/v2\/comments?post=624"}],"version-history":[{"count":3,"href":"https:\/\/buhave.com\/courses\/wp-json\/wp\/v2\/posts\/624\/revisions"}],"predecessor-version":[{"id":1153,"href":"https:\/\/buhave.com\/courses\/wp-json\/wp\/v2\/posts\/624\/revisions\/1153"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buhave.com\/courses\/wp-json\/wp\/v2\/media\/625"}],"wp:attachment":[{"href":"https:\/\/buhave.com\/courses\/wp-json\/wp\/v2\/media?parent=624"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buhave.com\/courses\/wp-json\/wp\/v2\/categories?post=624"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buhave.com\/courses\/wp-json\/wp\/v2\/tags?post=624"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}