Home icon

Bridging data silos: cross-bounded context querying with Vanguard’s Operational Read-only Data Store (ORDS) using Amazon Redshift

Big Data Blog



This article discusses how Vanguard modernized its legacy batch processing system by implementing an Operational Read-only Data Store (ORDS) using Amazon Redshift to bridge data silos across different business domains.

  • Transitioned from a centralized mainframe database to a cloud-native, domain-driven architecture
  • Addressed challenges like resource contention, lack of domain isolation, and scalability constraints
  • Leveraged Amazon Redshift's data sharing capabilities to create logically isolated data domains
  • Implemented zero-ETL functionality to integrate data and enable real-time analytics
  • Used AWS Database Migration Service and Amazon Kinesis for data ingestion from various sources

The solution provides improved data management, cross-domain data access, and enhanced performance while maintaining clear data ownership and enabling autonomous team operations.



Go to article

The AWS News Feed is currently looking for gold sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.

Related articles

Mar 18
2026
How Vanguard transformed analytics with Amazon Redshift multi-warehouse architecture
May 2
2024
Revolutionizing data querying: Amazon Redshift and Visual Studio Code integration
Dec 12
2024
Building end-to-end data lineage for one-time and complex queries using Amazon Athena, Amazon Redshift, Amazon Neptune and dbt
Aug 27
2024
Harness Zero Copy data sharing from Salesforce Data Cloud to Amazon Redshift for Unified Analytics – Part 1

The AWS News Feed is currently looking for silver sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.