Relational Databases are what most of us are all used to. They have been around since the 70s. Think of a traditional spreadsheet.
- Fields (Columns)
Relational Database Types
- SQL Server
- Amazon Aurora
Non-Relational Databases (NoSQL)
- Collection = Table
- Document = Row
- Key Value Pairs = Fields
Used for business intelligence. Tools like Cognos, Jaspersoft, SQL Server Reporting Services, Oracle Hyperion, SAP Netweaver.
Used to pull in very large and complex data sets. Usually used by management to do queries on data (such as current performance vs targets etc)
OLTP vs OLAP
Online Transaction Processing (OLTP) differs from OLAP Online Analytics Processing (OLAP) in terms of the types of queries you will run.
- OLTP Example:
- Order Number 2120121
- Pulls up a row of data such as Name, Date, Address to Deliver to, Delivery Status, etc.
- OLTP Example:
- OLAP Transaction Example:
- Net Profit for EMEA and Pacific for the Digital Radio Product.
- Pulls in large numbers of records.
Sum of radios sold in EMEA Sum of radios sold in Pacific Unit cost of radio in each region Sales price of each radio Sales price - unit cost
Data Warehousing databases use different type of architecture from both a database perspective and infrastructure layer.
ElastiCache is a web service that makes it easy to deploy, operate, and scale an in-memory cache in the cloud. The service improves the performance of web applications by allowing you to retrieve information from fast, managed, in-memory caches, instead of relying entirely on slower disk-based databases.
- ElastiCache supports to open-source in-memory caching engines:
AWS Database Types - Summary
- RDS - OLTP
- DynamoDB - NoSQL
- Redshift - OLAP
- ElastiCache - In Memory Caching