Re: Example Database

Informix has its "stores" demo database (more as a training exercise that a real demo); some of the extensions include
extensionsto the stores db. 

Not sure there aren't two things:
a) a place to show off features to prospective users. Ideally it tells how it works as well.
b) a playground/demo area for those who have installed one.

I think this thread relates to (a); the SQL demo and informix' demo are both more in category (a).

Greg Williamson
DBA GlobeXplorer LLC

-----Original Message-----
From:    Michael D. Allen [mailto:mallen@erhs.la]
Sent:    Thu 8/21/2003 8:55 PM
To:    pgsql-general@postgresql.org
Cc:
Subject:    Re: [GENERAL] Example Database

> On 18 Aug 2003 at 16:19, Erwin Brandstetter wrote:
> An example database that demonstrates the usage of all the core
> PostgreSQL features. It is one thing to read extensive documentation,
> but it is much more intuitive for me to see an example database, that
> demonstrates the whole thing interacting. I mean, not just the basic
> elements, but an optimized (and maybe nicely documented) database
> getting the best out of views, triggers, indices, rules, stored
> procedures and so on - maybe even a reference database from the
> PostgreSQL developers themselves?

Yes, this would be very nice indeed.  Oracle is an extremely complex
(overgrown)database with a ton of features, but it ships with a set of
example schemas that show off a variety of features pretty well.  I'm
speaking of the set of schemas that try to model a company: OE, HR, etc.
SQL Server ships with Northwind and pubs, as another example.  But, we would
need a good supplementary document that goes along with whatever
materialized, perhaps guiding new users along in a tutorial manner.

--
Michael D. Allen
mallen@erhs.la

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings