AWS Database Blog
Category: Analytics
Real-time serverless data ingestion from your Kafka clusters into HAQM Timestream using Kafka Connect
Organizations require systems and mechanisms in place to gather and analyze large amounts of data as it is created, in order to get insights and respond in real time. Stream processing data technologies enable organizations to ingest data as it is created, process it, and analyze it as soon as it is accessible. In this […]
How a small DevOps team at Deutsche Bahn unlocked analytics for their SaaS product
This is a guest blog post by Oliver Jägle, Software Architect at DB Curbside Management, in partnership with AWS Senior Solutions Architect Ben Freiberg. Have you ever rented a scooter or a bicycle instead of walking or taking a bus? You’re not alone. More and more people around the globe have adopted this sort of […]
Create an AWS Glue Data Catalog with AWS DMS
Businesses need near realtime access to the latest data and metadata available from many silos to perform analytics. AWS Glue is a serverless data integration service that makes it easier to discover, prepare, move, and integrate data from multiple sources for analytics, machine learning (ML) and application development. AWS Glue Data Catalog is a centralized […]
Build a sensor network using AWS IoT Core and HAQM DocumentDB
In this post, we discuss how you can build an Internet of Things (IoT) sensor network solution to process IoT sensor data through AWS IoT Core and store it with HAQM DocumentDB (with MongoDB compatibility). An IoT sensor network consists of multiple sensors and other devices like RFID readers made by various manufacturers, generating JSON […]
Visualize Ethereum ERC20 token data using HAQM Managed Blockchain Query and HAQM QuickSight
Businesses such as Paxos that issue stablecoin USD tokens want to find a way to identify common token metrics such as top holders, daily active users, daily volume, total number of holders, latest transfers, top Decentralized Finance (DeFi) protocols the tokens have been used on, and more. With HAQM Managed Blockchain (AMB) Query and HAQM […]
Archival solutions for Oracle database workloads in AWS: Part 1
This is a two-part series. In this post, we explain three archival solutions that allow you to archive Oracle data into HAQM Simple Storage Service (HAQM S3). In Part 2 of this series, we explain three archival solutions using native Oracle products and utilities. All of these options allow you to join current Oracle data with archived data.
Transform and migrate data from a relational to non-relational database using an AWS Glue Spark ETL job
This post describes a methodology to transform and migrate data from a relational database like HAQM Relational Database Service (HAQM RDS) for MySQL to a non-relational database like HAQM DocumentDB (with MongoDB compatibility) using AWS Glue.
Perform fuzzy full-text search and semantic search on HAQM DocumentDB using HAQM OpenSearch Service
In this post, we show you how to integrate HAQM DocumentDB (with MongoDB compatibility) with HAQM OpenSearch Service using AWS Lambda integration and run full-text search, fuzzy search, and synonym search on an artificially generated reviews dataset. HAQM DocumentDB is a fast, scalable, highly durable, and fully managed database service for operating mission-critical MongoDB API-compatible […]
Data consolidation for analytical applications using logical replication for HAQM RDS Multi-AZ clusters
HAQM Relational Database Service (HAQM RDS) Multi-AZ deployments provide enhanced availability and durability for your RDS database instances. You can deploy highly available, durable PostgreSQL databases in three Availability Zones using HAQM RDS Multi-AZ DB cluster deployments with two readable standby DB instances. With a Multi-AZ DB cluster, applications gain automatic failovers in typically under […]
The role of vector databases in generative AI applications
August, 2024: This post has been updated to reflect advances in technology and new features AWS released, to help you on your generative AI journey. Generative artificial intelligence (AI) has captured our imagination and is transforming industries with its ability to answer questions, write stories, create art, and generate code. AWS customers are increasingly asking […]