Best Gemini prompts for Database Architects

Given a database schema with 50 tables, 200 columns, and 100 relationships, and a set of 20 queries that are executed frequently, use graph algorithms and data mining techniques to identify the optimal schema redesign to reduce query latency by 30% and improve data consistency. Consider the impact of denormalization, indexing, and materialized views on query performance. Provide a step-by-step migration plan, including SQL scripts and example use cases.

Compare and contrast the architecture of Amazon Redshift, Google BigQuery, and Azure Synapse Analytics for a data warehouse with 100 million rows, 100 GB of data, and 10 concurrent users. Evaluate the trade-offs between data loading, querying, and storage costs, as well as the support for advanced analytics and machine learning workloads. Provide a detailed cost-benefit analysis and recommend the most suitable option based on the organization's specific needs and constraints.

Analyze the database performance metrics, including CPU usage, memory usage, disk usage, and query latency, to identify the root cause of a 50% increase in query latency over the past week. Consider the impact of recent schema changes, indexing, and statistics updates on query performance. Use statistical methods and data visualization techniques to pinpoint the underlying issue and provide a set of recommendations to resolve the problem, including index rebuilds, query optimizations, and hardware upgrades.

Design a deployment automation pipeline for a database with 20 schema changes, 10 stored procedures, and 5 data migration scripts, using Git, Jenkins, and AWS CodePipeline. Implement automated testing and validation to ensure data consistency and integrity, including data validation, schema verification, and performance benchmarking. Provide a detailed pipeline configuration, including script examples and testing scenarios, to ensure reliable and repeatable deployments.