Entry: Datawarehouse's Architectural Plan Tuesday, May 31, 2005



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

   0 comments

Leave a Comment:

Name


Homepage (optional)


Comments