--- title: "Samuel Sorial (@samuel-sorial) | Hashnode" description: "Backend Developer @ Cloud Imperium Games. Read the latest articles by Samuel Sorial on Hashnode." url: "https://hashnode.com/@samuel-sorial" --- @samuel-sorial # Samuel Sorial @samuel-sorial · Montreal, Canada. · Joined December 2020 Backend Developer @ Cloud Imperium Games [Website](https://samuelsorial.com/) ### [Design of Fault-Tolerant Virtual Machines](https://samuel-sorial.hashnode.dev/design-of-fault-tolerant-virtual-machines?utm_source=hashnode&utm_medium=feed) In 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... 9 min read · [samuel-sorial.hashnode.dev](https://samuel-sorial.hashnode.dev/design-of-fault-tolerant-virtual-machines?utm_source=hashnode&utm_medium=feed) [3](https://hashnode.com/posts/design-of-fault-tolerant-virtual-machines/6492e9ace5199a217935299b) [Jun 21, 2023](https://hashnode.com/posts/design-of-fault-tolerant-virtual-machines/6492e9ace5199a217935299b) ### [The Google File System - Case Study](https://samuel-sorial.hashnode.dev/the-google-file-system-case-study?utm_source=hashnode&utm_medium=feed) Introduction 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 ... 10 min read · [samuel-sorial.hashnode.dev](https://samuel-sorial.hashnode.dev/the-google-file-system-case-study?utm_source=hashnode&utm_medium=feed) [2](https://hashnode.com/posts/the-google-file-system-case-study/645da4db1bd40349280a5268) [May 12, 2023](https://hashnode.com/posts/the-google-file-system-case-study/645da4db1bd40349280a5268) ### [Pessimistic Concurrency Control - 2PL](https://samuel-sorial.hashnode.dev/pessimistic-concurrency-control-2pl?utm_source=hashnode&utm_medium=feed) Introduction 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... 4 min read · [samuel-sorial.hashnode.dev](https://samuel-sorial.hashnode.dev/pessimistic-concurrency-control-2pl?utm_source=hashnode&utm_medium=feed) [Feb 8, 2023](https://hashnode.com/posts/pessimistic-concurrency-control-2pl/63e3a22b1e97db7c25ec3373) ### [Query Optimization](https://samuel-sorial.hashnode.dev/query-optimization?utm_source=hashnode&utm_medium=feed) Introduction 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... 6 min read · [samuel-sorial.hashnode.dev](https://samuel-sorial.hashnode.dev/query-optimization?utm_source=hashnode&utm_medium=feed) [Jan 16, 2023](https://hashnode.com/posts/query-optimization/63c56978e68cd6988f8b5902) ### [Query Execution - Joins](https://samuel-sorial.hashnode.dev/query-execution-joins?utm_source=hashnode&utm_medium=feed) Introduction 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 ... 7 min read · [samuel-sorial.hashnode.dev](https://samuel-sorial.hashnode.dev/query-execution-joins?utm_source=hashnode&utm_medium=feed) [Dec 29, 2022](https://hashnode.com/posts/query-execution-joins/63ada45e97912c20665708bb)