Which database type should be used with highly structured data and provides support for ACID transactions?

Relational databases are designed specifically for storing highly structured data using a schema-on-write model, where data is organized into tables with predefined columns and data types. A foundational principle of relational database management systems (RDBMS) is their support for ACID (Atomicity, Consistency, Isolation, Durability) transactions. This ensures that database operations are processed reliably and that data integrity is maintained, which is critical for applications like financial systems and online transaction processing.

A. time series: This database type is optimized for handling time-stamped data streams, not for general-purpose, highly structured data, and often prioritizes write performance over strict ACID compliance.

B. document: This NoSQL database type is designed for semi-structured or unstructured data (e.g., JSON/BSON documents) and offers a flexible schema, which is contrary to the "highly structured" requirement.

C. graph: This database is optimized for storing and navigating complex relationships between entities (nodes and edges), not for the tabular structure characteristic of highly structured data.

1. Official Vendor Documentation: Microsoft. (n.d.). Relational databases. Microsoft Azure Documentation. Retrieved from https://azure.microsoft.com/en-us/resources/cloud-computing-dictionary/what-is-a-relational-database/. In the "What is a relational database?" section

it states

"A relational database is a type of database that stores and provides access to data points that are related to one another... The relational model means that the logical data structures—the data tables

views

and indexes—are separate from the physical storage structures." This describes the structured nature.

2. Official Vendor Documentation: The PostgreSQL Global Development Group. (2023). Chapter 13. Concurrency Control. PostgreSQL 16 Documentation. Retrieved from https://www.postgresql.org/docs/16/mvcc.html. Section 13.1

"Introduction

" details how PostgreSQL maintains data consistency

a core tenet of ACID

in a multi-user environment

which is a hallmark of relational systems.

3. University Courseware Context: Kleppmann

M. (2017). Designing Data-Intensive Applications. O'Reilly Media. In Chapter 7

"Transactions

" the text explicitly discusses the concept of ACID and its origins in relational databases like IBM System R. It contrasts this with the weaker guarantees often provided by NoSQL systems. This book is frequently used as courseware in university-level database systems courses.

4. Academic Publication: Codd

E. F. (1970). A Relational Model of Data for Large Shared Data Banks. Communications of the ACM

13(6)

377–387. https://doi.org/10.1145/362384.362685. This foundational paper introduces the relational model

which is inherently based on structured data (relations/tables)

forming the theoretical basis for all modern relational databases and their transactional integrity models.