11. Database and Analytics

Operational DBs

Analytical DBs

Other Databases and Analytics Services

Explore

Other Databases and Analytics Services

Database Services

Amazon DocumentDB (with MongoDB compatibility)

Amazon DocumentDB (with MongoDB compatibility) is a fast, reliable, and fully managed database service.

Amazon DocumentDB makes it easy to set up, operate, and scale MongoDB-compatible databases in the cloud.

With Amazon DocumentDB, you can run the same application code and use the same drivers and tools that you use with MongoDB.

It is a database service that is purpose-built for JSON data management at scale.

Storage scales automatically up to 64 TB without any impact to your application.

Supports millions of requests per second with up to 15 low latency read replicas.

Designed for 99.99% availability and replicates six copies of your data across three AZs.

Can migrate from MongoDB using the AWS Database Migration Service (AWS DMS).

⁠

What Is Amazon DocumentDB (with MongoDB Compatibility) - Amazon DocumentDB⁠

⁠

Amazon Keyspaces (for Apache Cassandra)

Amazon Keyspaces (for Apache Cassandra) is a scalable, highly available, and managed Apache Cassandra–compatible database service.

With Amazon Keyspaces, you don’t have to provision, patch, or manage servers, and you don’t have to install, maintain, or operate software.

Amazon Keyspaces is serverless, so you pay for only the resources that you use, and the service automatically scales tables up and down in response to application traffic.

You can build applications that serve thousands of requests per second with virtually unlimited throughput and storage.

Keyspaces enables you to use the Cassandra Query Language (CQL) API code.

Amazon Keyspaces makes it easy to migrate, run, and scale Cassandra workloads in the AWS Cloud.

Consistent, single-digit-millisecond response times at any scale.

99.99% availability SLA within an AWS Region.

⁠

What is Amazon Keyspaces (for Apache Cassandra)? - Amazon Keyspaces (for Apache Cassandra)⁠

⁠

Amazon Neptune

Amazon Neptune is a fast, reliable, fully managed graph database service that makes it easy to build and run applications that work with highly connected datasets.

The core of Neptune is a purpose-built, high-performance graph database engine. This engine is optimized for storing billions of relationships and querying the graph with milliseconds latency.

Neptune supports the popular property-graph query languages Apache TinkerPop Gremlin and Neo4j's openCypher, and the W3C's RDF query language, SPARQL.

Neptune powers graph use cases such as recommendation engines, fraud detection, knowledge graphs, drug discovery, and network security.

Offers greater than 99.99% availability.

Storage is fault-tolerant and self-healing.

DB volumes grow in increments of 10 GB up to a maximum of 64 TB.

Create up to 15 database read replicas.

⁠

What Is Amazon Neptune? - Amazon Neptune⁠

⁠

Amazon Quantum Ledger Database

Amazon Quantum Ledger Database (Amazon QLDB) is a fully managed ledger database that provides a transparent, immutable, and cryptographically verifiable transaction log owned by a central trusted authority.

Ledgers are typically used to record a history of economic and financial activity in an organization. Many organizations build applications with ledger-like functionality because they want to maintain an accurate history of their applications' data.

QLDB uses an immutable transactional log, known as a journal. The journal is append-only and is composed of a sequenced and hash-chained set of blocks that contain your committed data. With QLDB, the history of changes to your data is immutable—it can't be overwritten or altered in place.

Amazon QLDB uses cryptography to create a concise summary of your change history.

Generated using a cryptographic hash function (SHA-256).

Serverless and offers automatic scalability.

⁠

What is Amazon QLDB? - Amazon Quantum Ledger Database (Amazon QLDB)⁠

⁠

Analytics Services

Amazon Timestream

Time series database service for IoT and operational applications.

Faster and cheaper than relational databases.

Keeps recent data in memory and moves historical data to a cost optimized storage tier based upon user defined policies.

Serverless and scales automatically.

⁠

AWS Data Exchange

AWS Data Exchange is a data marketplace with over 3,000 products from 250+ providers.

AWS Data Exchange supports Data Files, Data Tables, and Data APIs.

Consume directly into data lakes, applications, analytics, and machine learning models.

Automatically export new or updated data sets to Amazon S3.

Query data tables with AWS Data Exchange for Amazon Redshift.

Use AWS-native authentication and governance, AWS SDKs, and consistent API documentation.

Benefits

⁠

AWS Data Pipeline

AWS Data Pipeline is a web service that you can use to automate the movement and transformation of data.

With AWS Data Pipeline, you can define data-driven workflows, so that tasks can be dependent on the successful completion of previous tasks. You define the parameters of your data transformations and AWS Data Pipeline enforces the logic that you've set up.

Process and move data between different AWS compute and storage services.

Data sources can also be on-premises.

Data can be processed and transformed.

Results can be loaded to services such as Amazon S3, Amazon RD

⁠

What is AWS Data Pipeline? - AWS Data Pipeline⁠

⁠

What is a Data Lake?

⁠

AWS Lake Formation

AWS Lake Formation helps you centrally govern, secure, and globally share data for analytics and machine learning. With Lake Formation, you can manage fine-grained access control for your data lake data on Amazon Simple Storage Service (Amazon S3) and its metadata in AWS Glue Data Catalog.

AWS Lake Formation enables you to set up secure data lakes in days.

Data can be collected from databases and object storage.

It is saved to the Amazon S3 data lake.

You can then clean and classify data using ML algorithms.

Security can be applied at column, row, and cell-levels.

The data sets can then be used through services such as Amazon Redshift, Amazon Athena, Amazon EMR for Apache Spark, and Amazon QuickSight.

Lake Formation builds on the capabilities available in AWS Glue.

⁠

What is AWS Lake Formation? - AWS Lake Formation⁠

⁠

Lake Formation tag-based access control - AWS Lake Formation⁠

⁠