http://www.orationfixation.net Mon, 18 Aug 2008 22:18:40 +0000 http://backend.userland.com/rss092 en The ultimate goal and the responsibility of the load manager is to get data loaded into the data warehouse database. There are a number of different methods for getting the data from the source into the data warehouse. Some of the more commonly used approaches are: loading from flat files, ... http://www.orationfixation.net/data-load-in-a-data-warehouse/ The warehouse manager is responsible for any data movement within the warehouse, such as aggregation creation and maintenance. Any tables, indexes or other objects required will also be created and maintained by the warehouse manager. Aggregation creation and maintenance is a process that should be automated. The warehouse manager needs an ... http://www.orationfixation.net/data-movement-in-a-data-warehouse/ 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 ... http://www.orationfixation.net/data-warehouse-manager/ An amount of data transformation will almost certainly need to be performed. For example, the source may supply more fields than are required; these fields will need to be stripped during the load. The source fields may be in formats different from that of the RDBMS you are using, requiring ... http://www.orationfixation.net/data-transformation/ The load manager is responsible for any data transformation required and for the loading of data into the database. These responsibilities can be summarized as data source interaction, data transformation and data load. The depth and complexity of the requirements placed on the load manager by each of these areas ... http://www.orationfixation.net/load-manager-in-a-warehouse/ 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 ... http://www.orationfixation.net/data-warehouse-process-managers/ The backup software will keep some form of database of where and when each piece of data was backed up. The backup recovery manager must have a good usable front end to that database. If it does not, it will be a nightmare trying to find anything to perform a ... http://www.orationfixation.net/manging-database-backups/ As most backup packages have their own tools for managing backup and recovery, the requirement for a backup recovery manager will probably be met by the backup software itself. Nonetheless, it is worth outlining here the abilities that a tool should have. There are three main features required for the ... http://www.orationfixation.net/database-backup-recovery-manager/ The ad hoc demands placed on the data warehouse will often require the use of temporary tables to store interim results. Space will need to be set aside for this purpose. That space needs to be efficiently managed. The consequence of not managing it efficiently is that either the space ... http://www.orationfixation.net/database-diskspace-required-for-a-data-warehouse/ Memory is a commodity that you can never have enough of. What you need to estimate is the minimum requirement. There are a number of things that affect the amount of memory required. First, there are the database requirements. The database will need memory to cache data blocks as they ... http://www.orationfixation.net/how-much-memory-does-a-database-require/