Datawarehouse's Architectural Plan
Components needed to drive an architectural plan of a datawarehouse design are mentioned in requirements definition as below :
Source Data
- Operational source systems
- Computing platforms, operating systems, databases, files
- Departmental data : files, documents, spreadsheets
- External data sources
Data Staging
- Data mapping between data sources and staging area data structures
- Data transformations
- Data cleansing
- Data integration
Data Storage
- Size of extracted and integrated data
- DBMS features
- Growth potential
- Centralized or distributed
Information Delivery
- Types and number of users
- Types of queries & reports
- Classes of analysis
- Front-end DSS applications
Metadata
- Operational metadata
- ETL
- End-user metadata
- Metadata storage
Management and Control
- Data loading
- External sources
- Alert systems
- End-user information delivery
Posted at 02:41 pm by Nanasbonyok
