SSSamuel Sorialinsamuel-sorial.hashnode.dev·Jun 21, 2023 · 9 min readDesign of Fault-Tolerant Virtual MachinesIn some situations where failure is caused by a hardware failure, it's useful to have replication in hand. There are other types of failures that can't be resolved with replication, such as software bugs or network issues. In this article, we deal wi...03G
SSSamuel Sorialinsamuel-sorial.hashnode.dev·May 12, 2023 · 10 min readThe Google File System - Case StudyIntroduction The Google file system's main goal is to support their applications' workload. Which affected their design decisions, they implemented what they actually need, rather than the de-facto distributed file system. There are 4 main different ...02IA
SSSamuel Sorialinsamuel-sorial.hashnode.dev·Feb 8, 2023 · 4 min readPessimistic Concurrency Control - 2PLIntroduction In today's high-traffic database management systems (DBMS), leveraging the full potential of hardware is essential. With the advent of modern CPUs, the opportunity for parallel processing has increased significantly. However, executing m...00
SSSamuel Sorialinsamuel-sorial.hashnode.dev·Jan 16, 2023 · 6 min readQuery OptimizationIntroduction SQL is a declarative language, which means that when you request a query, you specify the data you want, but not how to get it. The database management system (DBMS) is responsible for determining the most efficient way to retrieve the r...00
SSSamuel Sorialinsamuel-sorial.hashnode.dev·Dec 29, 2022 · 7 min readQuery Execution - JoinsIntroduction Joins are used to combine data from multiple tables in a database and retrieve the combined data as a single result set. This allows us to effectively retrieve data that is spread across multiple tables and can be especially useful when ...00