
Data Warehousing and Reporting
- availability
        - fast loader (direct to disk pages) included
        - loader provides data transformation and cleansing tools 
        - can load and index simultaneously
        - incremental load possible
        - can delay constraint checking during a bulk load
        - can continue to insert data while index is being built
- precalculation of summary information
        - included OLAP server
        - summary tables (a.k.a. materialized views)
        - summary tables understand dimensional hierarchies (e.g. time)
        - automatic refresh on data change
        - scheduled refresh
- can use data sampling to speed processing
- Top N query
- Top % query
- RANK function
- CUBE and ROLLUP functions

Marc G. Fournier                   ICQ#7615664               IRC Nick: Scrappy
Systems Administrator @ hub.org 
primary: scrappy@hub.org           secondary: scrappy@{freebsd|postgresql}.org 


Mon, 31 Jan 2000 17:40:09 -0400 (AST)
The Hermit Hacker <scrappy@hub.org>
PCLabs Survey, Part VIII: Data Warehousing and Reporting