Orientation on Technology

The data warehouse process managers are pieces of software responsible for the flow, maintenance and upkeep of the data, both into and out of the data warehouse database. There are three different data warehouse process managers - load manager, warehouse manager and the query manager. Each process manager has its own responsibilities and complexities, and there are potential overlaps between the responsibilities of each process. It will help to avoid any ambiguities if we draw some strict boundaries within which each process will work.

The other useful feature of having a database-aware backup recovery manager is that the different parts of the database can be addressed by their database names, and not by the often abbreviated and unreadable file names. One last point worth mentioning; ideally, the backup software used should work across clusters or MPP platforms if that is the environment being used. The backup recovery manager should also be capable of this.