Skip to content

Latest commit

 

History

History
30 lines (22 loc) · 722 Bytes

overview.md

File metadata and controls

30 lines (22 loc) · 722 Bytes

Relational Database Service (RDS) Overview

Relational Databases are comprised of:

  • Tables
    • Data is organized into tables (similar to a spreadsheet)
  • Rows
    • Data items
  • Columns
    • Fields in the database

Data in a relational database is organized into rows and columns, which form a table. Data in a relational database is structured across multiple tables

RDS Engines

  • SQL Server
  • MySQL
  • PostgreSQL
  • MariaDB
  • Amazon Aurora

When to use RDS engines

  • Online transaction processing (OLTP) workloads
    • OLTP is transactional
      • Processing customer orders, bank transaction, etc
    • Designed to process large numbers of small transactions

Not suitable for analyzing large amounts of data