AWS: Choose the Right AWS Database Service

AWS Database Services

AWS has a variety of different database options for different use cases. Use the table below to get a quick look at the AWS database portfolio.

Database TypeUse CasesAWS Service
RelationalTraditional applications, ERP, CRM, e-commerceAmazon RDS, Amazon Aurora, Amazon Redshift
Key-valueHigh-traffic web apps, e-commerce systems, gaming applicationsAmazon DynamoDB
In-memoryCaching, session management, gaming leaderboards, geospatial applicationsAmazon ElastiCache for Memcached, Amazon ElastiCache for Redis
DocumentContent management, catalogs, user profilesAmazon DocumentDB (with MongoDB compatibility)
Wide columnHigh-scale industrial apps for equipment maintenance, fleet management, and route optimizationAmazon Keyspaces (for Apache Cassandra)
GraphFraud detection, social networking, recommendation enginesAmazon Neptune
Time seriesIoT applications, DevOps, industrial telemetryAmazon Timestream
LedgerSystems of record, supply chain, registrations, banking transactionsAmazon QLDB

Breaking Up Applications and Databases

As the industry changes, applications and databases change too. Today, with larger applications, you no longer see just one database supporting it. Instead, these applications are being broken into smaller services, each with their own purpose-built database supporting it.

This shift removes the idea of a one-size-fits-all database and replaces it with a complimentary database strategy. You can give each database the appropriate functionality, performance, and scale that the workload requires.

Resources:

Oracle Cloud Infrastructure: Data Management Tools

Oracle Cloud Infrastructure (OCI) offers a range of data management tools and services to help organizations store, process, analyze, and manage their data. Here are some key Oracle Cloud Infrastructure data management tools and services:

  1. Oracle Autonomous Database: Oracle Autonomous Database is a fully managed, self-driving database service that eliminates the complexity of database administration tasks such as provisioning, patching, tuning, and backups. It supports both transactional and analytical workloads and offers high availability, scalability, and security.
  2. Oracle Cloud Object Storage: Oracle Cloud Object Storage is a scalable and durable object storage service that allows organizations to store and retrieve large amounts of unstructured data. It offers flexible storage tiers, including Standard, Archive, and Deep Archive, with configurable data durability and availability.
  3. Oracle MySQL Database Service: Oracle MySQL Database Service is a fully managed MySQL database service that offers high availability, scalability, and security. It automates administrative tasks such as provisioning, patching, and backups, allowing organizations to focus on their applications.
  4. Oracle Database Exadata Cloud Service: Oracle Database Exadata Cloud Service is a fully managed database service that is optimized for running Oracle Database workloads. It offers the performance, scalability, and reliability of Oracle Exadata infrastructure, along with automated management and monitoring capabilities.
  5. Oracle Big Data Service: Oracle Big Data Service is a cloud-based platform for running and managing big data and analytics workloads. It provides support for popular big data frameworks such as Hadoop, Spark, and Kafka, along with integration with Oracle Database and other Oracle Cloud services.
  6. Oracle Data Integration Platform: Oracle Data Integration Platform is a comprehensive data integration platform that enables organizations to extract, transform, and load (ETL) data across heterogeneous systems. It provides support for batch and real-time data integration, data quality management, and metadata management.
  7. Oracle Analytics Cloud: Oracle Analytics Cloud is a cloud-based analytics platform that enables organizations to analyze and visualize data from various sources. It offers self-service analytics tools for business users, along with advanced analytics and machine learning capabilities for data scientists.
  8. Oracle Data Safe: Oracle Data Safe is a cloud-based security and compliance service that helps organizations protect sensitive data in Oracle Databases. It provides features such as data discovery, data masking, activity auditing, and security assessments to help organizations meet regulatory requirements and secure their data.
  9. Oracle Cloud Infrastructure Data Flow: Oracle Cloud Infrastructure Data Flow is a fully managed service for running Apache Spark applications at scale. It provides a serverless, pay-per-use environment for processing large datasets using Apache Spark, along with integration with other Oracle Cloud services.

These are just a few examples of the data management tools and services available on Oracle Cloud Infrastructure. Depending on specific requirements and use cases, organizations can leverage OCI’s comprehensive portfolio of data services to meet their data management needs.