Best ChatGPT prompts for Database Architects

Given a relational database with 500 tables, 10,000 rows per table, and an average transaction rate of 1000 inserts/second, design an optimized schema that minimizes data redundancy, reduces query latency by 30%, and ensures data consistency across all tables, considering the constraints of using AWS RDS with a PostgreSQL engine, and provide a step-by-step migration plan from the current schema, including SQL scripts for table alterations, index creations, and data validation checks.

Analyze the following logs from a GCP Cloud Spanner database cluster, which has been experiencing intermittent deadlocks during peak hours, resulting in a 20% increase in latency: [insert log snippets], identify the root cause of the deadlocks, and provide a step-by-step plan to resolve the issue, including modifications to the database schema, transaction isolation levels, and retry mechanisms, as well as recommendations for monitoring and alerting to prevent similar issues in the future.

Design a data warehousing architecture for a big data analytics workload that involves processing 100 million rows of data per day, with a mix of structured and semi-structured data sources, using a combination of Apache Hadoop, Apache Spark, and Amazon Redshift, and provide a detailed plan for data ingestion, processing, and storage, including data validation, data transformation, and data quality checks, as well as recommendations for scaling the architecture to handle increased data volumes and velocities.

Create a GitOps-based deployment pipeline for a cloud-native database application using AWS RDS, GCP Cloud SQL, and Azure Database Services, with infrastructure-as-code definitions in Terraform, and provide a step-by-step guide to automating database deployments, including environment provisioning, database instance creation, schema migrations, and configuration management, as well as recommendations for integrating the pipeline with existing CI/CD workflows and monitoring tools.