You're reading from Database Design and Modeling with Google Cloud Learn database design and development to take your data to applications, analytics, and AI

Product type Paperback

Published in Dec 2023

Publisher Packt

ISBN-13 9781804611456

Length 234 pages

Edition 1st Edition

Concepts

Databases

Author (1):

Abirami Sukumaran

View More author details

Table of Contents (18) Chapters

Preface

1. Part 1:Database Model: Business and Technical Design Considerations

2. Chapter 1: Data, Databases, and Design FREE CHAPTER

3. Chapter 2: Handling Data on the Cloud

4. Part 2:Structured Data

5. Chapter 3: Database Modeling for Structured Data

6. Chapter 4: Setting Up a Fully Managed RDBMS

7. Chapter 5: Designing an Analytical Data Warehouse

8. Part 3:Semi-Structured, Unstructured Data, and NoSQL Design

9. Chapter 6: Designing for Semi-Structured Data

10. Chapter 7: Unstructured Data Management

11. Part 4:DevOps and Databases

12. Chapter 8: DevOps and Databases

13. Part 5:Data to AI

14. Chapter 9: Data to AI – Modeling Your Databases for Analytics and ML

15. Chapter 10: Looking Ahead – Designing for LLM Applications

16. Index

Why subscribe?

17. Other Books You May Enjoy

Using an RDBMS for structured data

A Relational Database Management System (RDBMS) is a type of database management system that stores data in a structured format, allowing relationships to be made with other data stored within the database while adhering to the Atomicity, Consistency, Isolation, and Durability (ACID) properties of all transactions. Let’s take a look at these properties.

Atomicity

This property means that the transactions are completed in a manner that ensures that all the changes to data are complete or none of them are. For example, if an application transfers money from Account A to Account B, and if the debit from Account A is successful, then it is assumed that Account B will be credited with the money being transferred.

Consistency

This property means that data is in a consistent state throughout the life cycle of the transaction. For example, in the transaction we spoke about in the previous example, if the state of the transaction is collectively...