database

system-design-system design 11-key-value data storage-key-value-store-introductoin-to-database-fundamentals-hogantech

Key-Value Store key-value data storage explanation – system design 11

Key-Value Store is a Distributed Hash Table, in which DHT is a decentralized storage method that provides hash table-like search and storage. Hash Table is also an Abstract Data Type (ADT). Its advantage is that it can usually complete the Search operation in a relatively fast time.

Key-Value Store key-value data storage explanation – system design 11 Read More »

Technical Article, System Design, database,
system-design-system design 10-data copy-data-partitioning-introductoin-to-database-fundamentals-hogantech

Data Partitioning What is data partitioning? – System Design 10

Data Partitioning is the process of dividing data in a database into smaller, more manageable sub-blocks. These sub-blocks are called partitions. Data segmentation can be based on a variety of factors, such as time, customer ID, or product category. Why do we need to partition data? For any system that does not scale, the amount of data will continue to grow, and the read and write traffic to the database will continue to increase.

Data Partitioning What is data partitioning? – System Design 10 Read More »

Technical Article, System Design, database,
system-design-system design 09-data replication-data-replication-introductoin-to-database-fundamentals-hogantech-hoganblab

How does Data Replication optimize the database? - System Design 09

Data Replication is an effective method to solve bottlenecks and improve the performance, scalability and availability of the database by replicating data on multiple nodes. This article will introduce the three main models of data replication: master-slave replication (Single-leader replication), multi-leader replication (Multi-leader replication) and point-to-point replication (Leaderless replication), and analyze their advantages and disadvantages.

How does Data Replication optimize the database? - System Design 09 Read More »

Technical Article, System Design, database,
system-design-System Design 08-Introduction to Database Fundamentals-introductoin-to-database-fundamentals-hogantech-hoganblab

Introduction to database basics – system design 08

What is a database? A database is an organized collection of structured information or data, usually stored electronically in a computer system. Databases are usually controlled by a database management system (DBMS). The data and DBMS together with its associated applications are called a database system, often referred to simply as a database.
Data in the most common types of databases running today are typically modeled as rows and columns in a series of tables to increase the efficiency of processing and querying of the data. Data can then be easily accessed, managed, modified, updated, controlled and organized. Most databases use Structured Query Language (SQL) to write and query data.

Introduction to database basics – system design 08 Read More »

Technical Article, System Design, database,
en_USEnglish