{"id":2329,"date":"2021-09-07T18:05:28","date_gmt":"2021-09-07T23:05:28","guid":{"rendered":"https:\/\/wiki-cloud.co\/?p=2329"},"modified":"2025-10-08T14:45:08","modified_gmt":"2025-10-08T19:45:08","slug":"aws-database-services-fundamentals","status":"publish","type":"post","link":"https:\/\/wiki-cloud.co\/en\/2021\/09\/aws-database-services-fundamentals\/","title":{"rendered":"AWS Database Services Fundamentals"},"content":{"rendered":"

A database is a collection of information that is organized in a way that can be easily accessed, managed, and updated. Computer databases often contain record sets or data files, which contain information about sales transactions or interactions with specific customers. Databases are important back-end systems used to store, manage, update, and analyze data for all types of applications, from small back-office systems to consumer and mobile web applications on a global scale. Most databases use structured query language (SQL) to write and query data.<\/p>\n

Databases have evolved dramatically since their inception in the early 1960s. Navigation databases, such as the hierarchical database (which was based on a tree-like model and only allowed a one-to-many relationship), and the network database (a more flexible model that allowed multiple relationships), were the original systems used to store and manipulate data. Although simple, these early systems were inflexible. In the 1980s, relational databases became popular, followed by object-oriented databases in the 1990s. More recently, NoSQL databases emergedin response to the growth of the internet and the need for greater speed and processing of unstructured data. Today, the cloud database and separate databases are opening up new ways as to how to collect, store, manage and use the data.<\/p>\n

According to their type, the databases can be classified as relational and non-relational databases. Relational databases became popular in the eighties, the elements of a relational database are organized as a set of tables with columns and rows. Relational database technology provides the most efficient and flexible way to access structured information. NoSQL or non-relational databases allow unstructured and semi-structured data to be stored and manipulated, unlike a relational database, which defines how all the data inserted into the database should be composed. NoSQL databases became popular as web applications became more common and complex.<\/p>\n

<\/p>\n

The databases can also be classified according to their type of workload into operational databases (OLTP - Online Transaction Processing) or analytical databases (OLAP - Online Analytical Processing). OLTP systems are databases oriented to transaction processing. A transaction generates an atomic process (which must be validated with a commit<\/em>, or invalidated with a rollback<\/em>), and that may involve data insertion, modification and deletion operations. The transactional process is typical of operational databases. OLAP systems are databases oriented to analytical processing. This analysis usually involves, generally, the reading of large amounts of data to get to extract some type of useful information that is helpful for decision making, such as sales trends, consumer behavior patterns, elaboration of complex reports, etc.<\/p>\n

<\/p>\n

AWS offers a wide variety of custom databases for your specific application use cases. Our fully managed database services include relational databases for transactional applications, non-relational databases for Internet-scale applications, a data warehouse for analytics, an in-memory database for caching and workloads in real time, and a graphs database to create applications with strongly connected data. With AWS Database Migration Service, migrating existing databases to AWS is easy and cost-effective.<\/p>\n

AWS Databases were designed from the ground up to support the scale, performance, and availability demands of modern globally distributed applications with microservices architectures.<\/p>\n

AWS offers 15 database engines and continues to grow, including relational and non-relational types for every application need. The types of AWS databases are described below:<\/p>\n

Database type<\/strong><\/p>\n\n\n\n\n\n\n\n\n\n\n\n
Database type<\/strong><\/td>\nDescription<\/strong><\/td>\nUse cases<\/strong><\/td>\nAWS service<\/strong><\/td>\n<\/tr>\n
Relational<\/strong><\/td>\nRelational databases store data with predefined schemas and relationships between them. These databases are designed to support ACID transactions, and maintain referential integrity and strong data consistency.<\/td>\nTraditional applications, ERP, CRM, e-commerce<\/td>\n\n

<\/p>\n

Amazon Aurora<\/a><\/p>\n

<\/p>\n

Amazon RDS<\/a><\/p>\n

<\/p>\n

Amazon Redshift<\/a><\/p>\n<\/td>\n<\/tr>\n

Key-value<\/strong><\/td>\nKey-value databases are optimized for common access patterns, typically to store and retrieve large volumes of data. These databases deliver quick response times, even in extreme volumes of concurrent requests.<\/td>\nHigh-traffic web apps, e-commerce systems, gaming applications<\/td>\n\n

<\/p>\n

Amazon DynamoDB<\/a><\/p>\n<\/td>\n<\/tr>\n

In-memory<\/strong><\/td>\nIn-memory databases are used for applications that require real-time access to data. By storing data directly in memory, these databases deliver microsecond latency to applications for whom millisecond latency is not enough.<\/td>\nCaching, session management, gaming leaderboards, geospatial applications<\/td>\n\n

<\/p>\n

Amazon ElastiCache for Memcached<\/a><\/p>\n

<\/p>\n

Amazon ElastiCache for Redis<\/a><\/p>\n

<\/p>\n

Amazon MemoryDB for Redis<\/a><\/p>\n<\/td>\n<\/tr>\n

Document<\/strong><\/td>\nA document database is designed to store semistructured data as JSON-like documents. These databases help developers build and update applications quickly.<\/td>\nContent management, catalogs, user profiles<\/td>\n\n

<\/p>\n

Amazon DocumentDB (with MongoDB compatibility)<\/a><\/p>\n<\/td>\n<\/tr>\n

Wide column<\/strong><\/td>\nA wide column store is a type of NoSQL database. It uses tables, rows, and columns, but unlike a relational database, the names and format of the columns can vary from row to row in the same table.<\/td>\nHigh scale industrial apps for equipment maintenance, fleet management, and route optimization<\/td>\n\n

<\/p>\n

Amazon Keyspaces (for Apache Cassandra)<\/a><\/p>\n<\/td>\n<\/tr>\n

Graph<\/strong><\/td>\nGraph databases are for applications that need to navigate and query millions of relationships between highly connected graph datasets with millisecond latency at large scale.<\/td>\nFraud detection, social networking, recommendation engines<\/td>\n\n

<\/p>\n

Amazon Neptune<\/a><\/p>\n<\/td>\n<\/tr>\n

Time series<\/strong><\/td>\nTime-series databases efficiently collect, synthesize, and derive insights from data that changes over time and with queries spanning time intervals.<\/td>\nIoT applications, DevOps, industrial telemetry<\/td>\n\n

<\/p>\n

Amazon Timestream<\/a><\/p>\n<\/td>\n<\/tr>\n

Ledger<\/strong><\/td>\nSystems of record, supply chain, registrations, banking transactions<\/td>\nSystems of record, supply chain, registrations, banking transactions<\/td>\n\n

<\/p>\n

Amazon QLDB<\/a><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 <\/p>\n