쿼리 성능 극대화를 위한 확장 가능한 멀티테넌트 데이터베이스 스키마 설계

Act as a database architect specializing in multi-tenant systems. Design a scalable database schema for [companyName] that supports [productLine] targeting [targetMarket]. Your design must incorporate: 1) tenant data isolation ensuring no cross-access; 2) indexing strategies optimized for frequent complex JOIN and aggregation queries; 3) horizontal partitioning or sharding methods to accommodate data growth over [timeframe]; 4) query optimization techniques minimizing latency for high concurrency; 5) considerations for data security and compliance; 6) strategies for backward-compatible schema migrations; 7) integration points with existing analytics platforms; 8) a plan for monitoring query performance and schema health. Provide a detailed schema outline, rationale for each design decision, and a set of example optimized queries that demonstrate your architecture’s effectiveness.