advanced
Advanced Data Modeling for Complex Systems
Develop methodologies for designing data models for complex enterprise systems
📝 Prompt Content
Create a comprehensive approach to designing data models for complex enterprise systems with multiple business domains. Address normalization vs. performance trade-offs, temporal data modeling, hierarchical structures, and multi-tenancy considerations. Include strategies for handling slowly changing dimensions, implementing soft deletes, and managing data migration between schema versions. Develop methodologies for documenting data models that serve both technical and business stakeholders.