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
