Data Warehouse [Oracle Database]

This is the consolidated database that stores critical business data, which can be information regarding sales, purchase, promotion effectiveness, payments, returned checks and receivables. The data warehouse typically will be structured to confirm to Star & Snowflake Schema, which is best suited for the purpose of reporting and analytics.