From: markir@slingshot.co.nz
To: josh@agliodbs.com
To: Mark kirkwood <markir@slingshot.co.nz>
To: pgsql-sql@postgresql.org
Subject: Re: How Postgresql Compares For Some Query Types
Date: Wed, 18 Jul 2001 23:02:12 GMT
Message-ID: <200107182302.f6IN2Ha23201@postgresql.org> (raw)
>
> I'm a little unclear on what a "fact table" is. Can you explain?
Good question... The idea comes from data warehousing where a typical data
construction involves two "types" of table :
dimensions : time, location, ethicity....( essentially denormalized lookups )
facts : observations, accidents, sales ....
facts have a composite primary key , each componant of which is a foreign key
for one of the dimensions.
If drawn with the fact table(s) in the center and dimensions around about, then
the ERD looks like a "star". Hence the names "star schema" and "star query"
A quick search located a vaguely helpful page : ( apologies about the source )
http://www.oradoc.com/ora816/server.816/a76994/schemas.htm
A much better source is Kimball's book "The Data Warehousing Toolkit".
regards
Mark
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: markir@slingshot.co.nz, josh@agliodbs.com
Subject: Re: How Postgresql Compares For Some Query Types
In-Reply-To: <200107182302.f6IN2Ha23201@postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox