Types Of Databases
Amazon’s database includes various types of data warehouses. Here’s a quick glossary to explain the differences between these popular database categories:
- Relational database: Relational databases store data in tables with columns and rows, with each row representing a single record, differentiated with a unique ID known as a key, and each column containing data related to that record. Relational databases have been around since the 1970s and are now the most commonly used type of data warehouse. Many relational databases are managed using the programming language SQL.
- Key-value database: Key-value databases are non-relational databases that use a basic key-value method to store data. Data is warehoused in key-value pairs; each key serves as a unique identifier for a single value within the collection. This works in a similar way to a dictionary: the word is the key, and the definition is the value.
- In-memory database: In-memory databases are non-relational databases that rely on memory for data storage, making queries faster by eliminating the need to access disks.
- Document database: They offer flexible, semi-structured, hierarchical storage for use cases like catalogs and user profiles, and content management systems such as blogs and video platforms.
- Wide column database: These are NoSQL databases that use tables, rows, and columns like usual, but unlike a relational database, column names and formats can vary row to row.
- Graph database: Graph databases store data not in tables, but in an interconnected web-like structure that allows complex relationships between data to be mapped and queried.
- Time-series database: These are designed to store and retrieve data points that are associated with timestamps.
- Ledger databases: This databases contain both tables of data and an immutable journal that logs all changes to data, creating a blockchain record of all updates.
AWS Database Services: Complete Guide
AWS Database Services is a group of cloud-based services offered by Amazon Web Services (AWS). These services help businesses and developers manage, process, and analyze their data efficiently and securely. Amazon Web Services (AWS) offers a variety of database services to cater to different application needs. These services are designed to be scalable, reliable, and cost-effective.