Category: Database

By Israel Mendes, Data Engineering leader – Caylent By Washim Nawaz, Analytics Specialist – AWS By Isaac Owusu-Hemeng, Customer Solutions Manager – AWS By Muz Syed, Sr. Partner Solutions Architect – AWS Caylent  In this post, we will discuss how APN Premier partner Caylent leveraged a 3-Day Experience Based Acceleration (EBA) workshop to finalize and […]

This post presents a cost-effective, serverless multi-tenant SaaS architecture utilizing AWS managed services. Users can belong to multiple tenants via HAQM Cognito user groups, and the solution enables seamless tenant switching and allows tenants to define custom roles with HAQM 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 HAQM 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 HAQM 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 HAQM Redshift and HAQM 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 HAQM 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.