| From: | The Hermit Hacker <scrappy(at)hub(dot)org> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | PCLabs Survey, Part VIII: Data Warehousing and Reporting |
| Date: | 2000-01-31 21:40:09 |
| Message-ID: | Pine.BSF.4.21.0001311739340.480-100000@thelab.hub.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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(at)hub(dot)org secondary: scrappy(at){freebsd|postgresql}.org
| From | Date | Subject | |
|---|---|---|---|
| Next Message | The Hermit Hacker | 2000-01-31 21:41:35 | PClabs Survey, Part I: Administration (resend) |
| Previous Message | The Hermit Hacker | 2000-01-31 21:39:33 | PCLabs Survey, Part VII: Embedded Database / Branch Office Support |