Orientation on Technology

The warehouse manager is responsible for maintaining the data while it is in the data warehouse. This layer of software also creates and maintains the metadata that describes where everything resides within the data warehouse. The responsibilities of the warehouse manager are data movement, metadata management, performance monitoring and tuning and data archiving.

Given the size and complexity of most data warehouses it is important to automate as many data management operations as possible. The warehouse manager should be designed to deal with all the tasks mentioned above automatically. Extensive reporting capabilities are a must for the warehouse manager; in particular, it should be able to report any failures of data movement, such as aggregation creation failures. These facts need to be taken into account by the data warehouse manager and proper attention given to the main tasks so that aggregation creation failures are minimized to the best possible extent.