An Introduction to Transactional Databases
FAQs
A transactional database stores data that results from an interaction between two or more parties.
- High data integrity
- Scalability
- Real-time processing
- Concurrent access
- Auditability
Transactional databases can be relational databases or NoSQL databases. The name transactional database refers to the transaction data stored within the database rather than the actual database management system or type. The type of data database users need to store (e.g., text files within a document database, messaging systems output) often determines whether a relational or non-relational database will be used.
There are two main types of database transactions within transactional databases. They include single transactions, where a unit of work consists of one or more database operations, and multi transactions, where multiple, interdependent transactions that range across a variety of different databases and systems are created.
ACID properties are a part of database management systems (DBMS) best practices that identify standards used to guarantee the reliability of a transactional database. For many organizations, demonstrating ACID compliance is part of their data management strategy as well as data governance structure.
The ACID properties specifically relate to the atomicity, consistency, isolation, and durability of transactions and associated data.
Get started with Atlas today
Get started in seconds. Our free clusters come with 512 MB of storage so you can play around with sample data and get oriented with our platform.
GET STARTED WITH:
- 125+ regions worldwide
- Sample data sets
- Always-on authentication
- End-to-end encryption
- Command line tools