Postgres Pro
Downloads
Home   >   mailing lists

PCLabs Survey, Part VIII: Data Warehousing and Reporting - Mailing list pgsql-hackers

From The Hermit Hacker
Subject PCLabs Survey, Part VIII: Data Warehousing and Reporting
Date
Msg-id Pine.BSF.4.21.0001311739340.480-100000@thelab.hub.org
Whole thread Raw
List pgsql-hackers
Tree view 
Data Warehousing and Reporting
- availability       - fast loader (direct to disk pages) included       - loader provides data transformation and
cleansingtools        - can load and index simultaneously       - incremental load possible       - can delay
constraintchecking 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       -
scheduledrefresh
 
- 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

pgsql-hackers by date:

Previous
From: The Hermit Hacker
Date:
Subject: PCLabs Survey, Part VII: Embedded Database / Branch Office Support
Next
From: The Hermit Hacker
Date:
Subject: PClabs Survey, Part I: Administration (resend)