Rajat Srivastavastackup.hashnode.dev·Oct 27, 2024Understanding SQL Server Isolation LevelsDatabase transactions are essential for keeping data accurate in systems where many processes run at the same time. SQL Server offers several isolation levels to balance consistency, concurrency, and performance. In this comprehensive guide, we’ll ex...DiscussDatabases
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...DiscussDatabases
Amr Elhewyhewi.blog·Oct 5, 2024A Bird's-Eye View of Amazon Aurora's Amazing ArchitectureIn this article i’m going to be simply explaining the architecture Amazon’s well known relational database service Aurora; dive deep into why some decisions were made and the impact they had. I’m going to be abstracting a lot of information just so y...Discuss·59 readsAWS
Harsh Saidharshdev.hashnode.dev·Sep 25, 2024What are Relationships in salesforceBefore moving forward with relationships have an basic understanding of what are Objects, Apps, Tabs and fields in salesforce. Objects in Salesforce: In Salesforce, an object is a table that stores data related to specific information. Objects are us...DiscussDBMS
Rajon Deyrajondey.hashnode.dev·Sep 19, 2024Relational DatabaseRelational databases store data in tables consisting of rows and columns. Each table represents an entity (like customers or orders), and rows within the table represent individual records. The structure allows for easy data retrieval and management ...DiscussDATABASE 101Relational Database
Rajon Deyrajondey.hashnode.dev·Sep 19, 2024Relational Databases(SQL) vs. NoSQLRelational databases are structured around tables, rows, and columns. Each table is a collection of related data entries, and each entry is organized as a row with specific columns. This structured approach makes it easy to manage and query data usin...DiscussDATABASE 101SQL
Aniket Purohitaniketpurohit.hashnode.dev·Sep 15, 2024Unleashing the Power of Amazon RDS and EC2: A Step-by-Step Journey!Hey tech enthusiasts! 👋 Ever wondered how you could create your own relational database on Amazon RDS and connect it to a web app hosted on an EC2 instance? Well, you’re in for a treat! 🍿 Today, I’m going to take you through my experience of doing ...Discussec2
Rajat Srivastavastackup.hashnode.dev·Sep 11, 2024Guide to Sharding and Partitioning in Relational DatabasesIntroduction As databases grow in size and complexity, managing and querying large volumes of data becomes more challenging. Two popular techniques to address these challenges are partitioning and sharding. Both methods involve breaking down data int...DiscussDatabase Scalability
Muhammad Abdiel Al Hafizabdiel.hashnode.dev·Sep 7, 2024Pentingnya Normalisasi Database untuk Konsistensi dan Integritas DataData yang konsisten dan akurat merupakan fondasi dalam pengambilan keputusan yang tepat. Untuk memastikan data tetap terstruktur dengan baik dan terhindar dari inkonsistensi, salah satu teknik penting yang digunakan adalah normalisasi. Teknik ini san...Discuss·1 like2NF
Njeri Gitomegracegitome.hashnode.dev·Aug 15, 2024Understanding Data ModelingData essentially refers to raw facts, figures and details that can be collected, measured, analyzed, stored and used for various purposes such as decision making. In the current digital age, we are constantly generating massive volumes of data , howe...Discussdata-engineering
