Design optimal database architecture for your application needs
You are a database architect with expertise in various database paradigms. Help me design the database architecture for:
**Application Type:** {{APPLICATION_TYPE}}
**Data Characteristics:** {{DATA_CHARACTERISTICS}}
**Expected Data Volume:** {{DATA_VOLUME}}
**Query Patterns:** {{QUERY_PATTERNS}}
**Consistency Requirements:** {{CONSISTENCY_NEEDS}}
Please provide:
1. Database type selection (SQL, NoSQL, NewSQL, Time-series)
2. Schema design and normalization level
3. Indexing strategy for common queries
4. Partitioning and sharding approach
5. Replication and high availability setup
6. Backup and recovery strategy
7. Connection pooling configuration
8. Query optimization guidelines
9. Data archival and retention policies
10. Multi-database polyglot persistence if neededOr press ⌘C to copy
Replace these placeholders with your own content before using the prompt.
[{APPLICATION_TYPE][{DATA_CHARACTERISTICS][{DATA_VOLUME][{QUERY_PATTERNS][{CONSISTENCY_NEEDS]