Abhinandan Mishraabhinandanmishra1.hashnode.dev·Dec 29, 2024System Design - Understanding Databases - Part 2What is Isolation? Database isolation is one of the four key ACID properties (Atomicity, Consistency, Isolation, Durability). Isolation ensures that concurrent transactions operate independently, making it appear as if each transaction is the only on...20 likes·119 readsLearning System DesignSystem Design
Mustufa khancoder-class.hashnode.dev·Dec 14, 2024Understanding ACID Principles in Databases: Ensuring Reliable TransactionsExplore the ACID principles in databases—Atomicity, Consistency, Isolation, Durability—and how they guarantee reliable and secure transactions. Learn their importance in database management. In the world of database management, ensuring the integrity...ACID Transactions
Darsh Pateldarsh-patel.hashnode.dev·Dec 11, 2024ACID in Databases!!Introduction Databases are the most precious thing in modern computing systems, powering everything from online shopping to social media, healthcare, and financial services. At the heart of a robust database is the need for reliability, ensuring that...Databases
Shreyansh Guptashreyanshgupta.hashnode.dev·Nov 17, 2024ACID transactions in databasesACID is an acronym that refers to 4 properties. If a database transaction has these 4 properties, it is said to be an ACID transaction. Let’s take a look at these 4 properties. Atomicity All the operations within a transaction execute as an atomic ...Databases
Sai Prasanna Maharanasaimaharana.hashnode.dev·Oct 28, 2024SQL: An IntroductionWhat is SQL? SQL (Structured Query Language) is a standardized programming language used for managing and manipulating relational databases. It allows you to create, read, update, and delete data stored in tables, which are organized into rows and co...SQLSQL
Shreyansh Guptashreyanshgupta.hashnode.dev·Oct 19, 2024Multiple granularities of database locksMultiple granularity locking To understand this concept, first let us take a look at the structure of a database. It can be represented by the following hierarchy. Now, whenever we explicitly apply a lock at any level, all the children nodes are imp...Databases
Vivek Khatritech.peculiarvivek.com·Sep 29, 2024DDIA - Chapter 7 - Transactions - thoughts and notesDisclaimer: This blog has been partially written by the help of LLM. The more I read DDIA the more my trust on databases is vanishing. :’) This chapter on transactions was not that interesting, honestly. Most of it was just how the keywords in ACID a...Databases
S.S.S DHYUTHIDHARsudheendra.hashnode.dev·Sep 23, 2024Introduction to ACID PropertiesWhen we hear 'ACID,' many may first think of chemistry. However, in databases, ACID stands for four properties that ensure reliable transactions. ACID properties are crucial for database transactions as they ensure consistent performance of transact...4 likesSQL transactions
Sanjay Raisanjhiar2133.hashnode.dev·Aug 21, 2024Choosing the Right Database for Your Product: Key Technical and Non-Technical ConsiderationsWhen selecting a database for your product, it's crucial to evaluate both technical and non-technical criteria. The right choice can significantly impact your system's performance, scalability, and maintainability. Here’s a comprehensive guide to hel...1 like#CAPTheorem
Ademola Thompsonsuperhero.hashnode.dev·Jul 23, 2024Understanding atomic transactions in Django: Ensuring data consistencyDjango is a high-level web framework that supports building robust applications quickly and efficiently. One of its notable features is its support for data integrity and consistency through built-in mechanisms that developers can seamlessly integrat...73 readsDatabases