Relational databases are what most of us are all used to , you can think of a traditional spreadsheet.
Examples of Relational databases on AWS:
SQL server
Oracle
MySQL server
PostgreSQL
Aurora
MariaDB
RDS or Relational Database services has two key features:
- Multi-AZ for Disaster Recovery
- Read Replicas — For performance.
Non-Relational Databases are a group of collections, the collection = Table, Document = Row and Key value pairs = fields
you can have as much as you want of fields per collection or row , but for the RDS you need to keep the consistency between the rows.
Data Warehousing:
Used for business intelligence. Tools like Hyperion, SQL server Reporting. Data Warehousing is used to pull in very large and complex data sets. Usually used by management to do queries on data.
OLTP( Online Transaction Processing) vs OLAP ( Online Analytics processing)
OLTP is different than OLAP in terms of queries you will run.
OLTP will pull up a row of data, but OLAP will pull in large numbers of records.
For Amazon’s DataWarehouse solution is called Redshift.
ElastiCache: a web service that makes it easy to operate. The service improves the performance of web applications by allowing you to retrieve information from from fast in-memory caches. instead of relying entirely on slower disk-based databases.
ElastiCache supports two open-source in-memory caching engines:
- Memcached
- Redis
