View a markdown version of this page

Transactional data - Data Warehousing on AWS

This whitepaper is for historical reference only. Some content might be outdated and some links might not be available.

Transactional data

Transactional data, such as e-commerce purchase transactions and financial transactions, is typically stored in relational database management systems (RDBMS) or NoSQL database systems. The choice of database solution depends on the use case and application characteristics.

  • A NoSQL database is suitable when the data is not well-structured to fit into a defined schema, or when the schema changes often.

  • An RDBMS solution is suitable when transactions happen across multiple table rows and the queries require complex joins.

Amazon DynamoDB is a fully managed NoSQL database service that you can use as an OLTP store for your applications. Amazon Aurora and Amazon Relational Database Service (Amazon RDS) enable you to implement an SQL-based relational database solution for your application:

  • Amazon Aurora is a MySQL and PostgreSQL-compatible relational database built for the cloud.

  • Amazon RDS is a service that enables you to easily set up, operate, and scale relational databases on the cloud.

For more information about the different AWS database services, see Databases on AWS.