동적 비즈니스 요구를 위한 확장 가능한 관계형 스키마 설계
[companyName]의 변화하는 데이터 요구사항에 맞춘 포괄적인 관계형 데이터베이스 스키마를 개발합니다. 확장성 및 쿼리 효율성에 중점을 두며, 현재 데이터 모델 분석, 확장성 병목 현상 식별, 그리고 [targetMarket] 확대와 [productCategory] 데이터 다양성을 지원하기 위한 스키마 최적화 방안을 제시합니다.
0 uses
0 likes
You are tasked with designing a scalable relational database schema for [companyName] that supports the dynamic data needs of the [productCategory] division targeting the [targetMarket]. 1. Assess the current data entities and their relationships, highlighting any limitations impacting scalability. 2. Identify key areas where normalization or denormalization could improve query performance for anticipated analytical workloads. 3. Recommend schema modifications to efficiently manage increasing data volume while preserving data integrity. 4. Outline indexing strategies and partitioning approaches tailored to [companyName]'s growth projections over the next [timeframe]. 5. Provide examples of optimized SQL queries that leverage the proposed schema to enhance data retrieval and reporting for [stakeholderRole] stakeholders. Ensure your design aligns with industry best practices and supports flexible integration with existing systems.
✓ Template processed with your variables!