logo for information-management-architect.com
Home
Strategy
Framework
Business Case Analysis
Project Planning
Requirements Analysis
Architecture & Design
Build Phase
Quality Assurance
Transition to Production
Management Information
Business Intelligence
Data Warehouse
Tools
Jobs
Contact David Bowman
leftimage for information-management-architect.com

Data Warehouse Management

Need data warehouse management and want some practical suggestions to ensure rapid project delivery?

An enterprise data warehouse requires an information management framework, which should be established as part of the information management strategic planning process, and operations management, which should be part of data warehouse architecture and design

Information Management and Data Warehouse

Data Warehouse Management

Click here to see more details about how data warehouse is required to ensure a successful data warehouse solution.



Operations Management
Data Warehouse Management

What is a load manager

Load management includes all of the software and utilities required to:
  • Extract source system data and move it to the warehouse environment;
  • Complete basic transformation to ensure that non-essential data is eliminated and other data is converted to appropriate data types;
  • Fast load data into a staging area where it can be subsequently manipulated;
  • Extract data from staging area and load clearing house tables;
  • Extract data from clearing house tables and load the data warehouse; and
  • Extract data from the data warehouse and load data marts.
What is a warehouse manager?

Warehouse management involves all of the software and system management utilities required to:
  • Clean and transform data;
  • Create temporary holding tables to accommodate merging data for analysis or cleansing purposes;
  • Create and/or maintain indexes, views, and table partitions;
  • Aggregate data as necessary;
  • De-normalize data if needed for performance purposes;
  • Archive data in each of the data warehouse environments; and
  • Complete incremental or full back-ups as needed.
What is a query manager?

Reporting management involves the software required to ensure that business intelligence reporting tools direct queries to the data that will provide the quickest query response.

Reporting business intelligence software such as Business Objects or Microstrategy generally handles reporting management with support from custom routines developed using relational database management software.

Summary...

Data warehouse management requires an information management framework, which should be established as part of the information management strategic planning process,  and operations management, which should be part of data warehouse architecture and design


footer for Information management page