Data Warehouse Service Description and Assumptions
- Patrick Schmitz (Unlicensed)
Owned by Patrick Schmitz (Unlicensed)
Description
The Data Warehouse service will provide local caching of information gathered across services, to support efficient reporting queries. It is not intended to be a general service for broader EDW needs.
Assumptions
- The data models that underline agnostic services will not support efficient queries that join many different concepts. This will make reporting expensive and difficult. We need to cache data for reporting needs in some tighter relational model, possibly denormalized for reporting needs.
- We can adapt the general models of EDW and reporting support, without designing or developing a general solution.
- We may be able to reuse some other solutions, but we will only do so if they remain fairly simple and lightweight.
Key Concepts
- To be identified.
Dependencies
- This is tightly linked to the Reporting Service.
Background Documentation
- To be identified.