Category: Database

This post presents a cost-effective, serverless multi-tenant SaaS architecture utilizing AWS managed services. Users can belong to multiple tenants via Amazon Cognito user groups, and the solution enables seamless tenant switching and allows tenants to define custom roles with Amazon DynamoDB transactions. By leveraging AWS services, the architecture provides security, isolation, custom permissions, and flexibility to scale without operational overhead.

In today’s industrial landscape, smart manufacturing is pivotal for sustainability and efficiency gains. However, organizations face challenges in gathering and consolidating data from multiple, often outdated sources on the manufacturing floor. LTIMindtree’s AWS-powered Digital Command Center (DCC) solution addresses this by enabling data acquisition, management, real-time KPI monitoring, and analytics-driven insights.

Learn how to connect the ThoughtSpot analytics platform to an Amazon Aurora MySQL database for real-time operational analytics. This post outlines the steps to create an Aurora MySQL instance, populate it with sample data, create a connection from ThoughtSpot, and build generative AI-powered analytics using natural language search. By integrating ThoughtSpot and Aurora MySQL, businesses can get instant insights from their transactional database.

Comprinno migrated a fitness app’s databases from Google Cloud to AWS to reduce costs. Challenges included migrating large PostgreSQL databases without downtime and accessing Google’s managed subnets. Comprinno established a VPN between clouds, used a SQL proxy to enable the AWS Database Migration Service, and parallelized data loading to meet the tight migration window. By moving to Graviton-based Amazon RDS, the customer reduced database costs by 30%.

Pinecone has developed a novel serverless vector database architecture optimized for AI workloads like retrieval-augmented generation. Built on AWS, it decouples storage and compute and enables efficient intermittent querying of large datasets. This provides elasticity, fresher data, and major cost savings over traditional architectures. Pinecone serverless removes bottlenecks to building more knowledgeable AI applications economically at scale on AWS.

Customer data is critical for modern digital organizations, but is often scattered across tools which can render it useless. Historically, customer data platforms (CDPs) aimed to consolidate data for insights and activation, but organizations now prefer a composable CDP architecture on AWS to sync data from Amazon Redshift and Amazon S3 into downstream tools. Hightouch facilitates this composable CDP approach, making it easy to activate AWS data across channels without engineering work.

As data becomes increasingly valuable, robust security measures are critical. This post reviews how Protegrity’s tokenization integration with Amazon Redshift Dynamic Data Masking enables organizations to effectively protect sensitive data. It provides an overview of key concepts like Protegrity Vaultless Tokenization and Redshift Dynamic Data Masking, including code examples to better safeguard sensitive information within their Redshift data warehouse both at rest and in use.

Leveraging AWS Lambda response streaming functionality enables progressive data delivery from large datasets, enhancing web application performance. This post compares a traditional API implementation to a Lambda streaming API, demonstrating reduced time-to-first-byte latency and quicker, more dynamic client-side rendering. By incrementally sending data, response streaming eliminates lag from waiting on entire dataset transfers, vastly improving user experience for data-intensive applications.

ADP provides cloud-based human capital management solutions to over 1 million clients in 140 countries. Using an active-active multi-region architecture on AWS, ADP built a highly available and resilient Voice of Employee application to collect employee feedback throughout the workforce lifecycle. The multi-region deployment meets availability goals and leverages AWS services to enable rapid disaster recovery.

Brands struggle to deliver personalized customer experiences, giving competitors with real-time end-to-end personalization a competitive edge. Mastering personalization requires unifying customer data across systems into a Customer 360 view. RudderStack and AWS make building a Customer 360 in Amazon Redshift easy, as RudderStack handles complex data unification and automatically generates insights while Redshift provides a scalable, performant data warehouse.