Determining the Archive Cycle
The most important figure that needs to be decided is the archive cycle or frequency. How often is data archived? Even if data is loaded daily, you may not want to run archiving on a daily cycle. It is often better to use a longer cycle, such as a week, a month, or even a [...]
User Access To Data
The query manager is the software interface between the users and the data. It presents the data to the users in a form they understand. The query manager also controls the user access to the data. In a data warehouse, the raw data will often be an amalgamation of data from many disparate data sources. [...]
Query Scheduling in a Data Warehouse
Scheduling of ad hoc queries is a responsibility of the query manager. Simultaneous large ad hoc queries, if not controlled, can severely affect the performance of any system: in particular if the queries are run using parallelism, where a single query can potentially use all the CPU resource made available to it. Typically this will [...]