Demonstration Database

The DB–Access utility, provided with the database server products, includes one or more of the following demonstration databases:

• For all IBM Informix databases, the stores_demo database illustrates a relational schema with information about a fictitious wholesale sporting-goods distributor. Many examples in IBM Informix manuals are based on the stores_demo database.
• For Extended Parallel Server, the sales_demo database illustrates a dimensional schema for data-warehousing applications. For conceptual information about dimensional data modeling, see Part 4 of this IBM Informix: Database Design and Implementation Guide.

• For Dynamic Server, the superstores_demo database illustrates an object-relational schema. The superstores_demo database contains examples of extended data types, type and table inheritance, and user-defined routines.

For information about how to create and populate the demonstration databases, see the IBM Informix: DB–Access User's Guide. For descriptions of the databases and their contents, see the IBM Informix: Guide to SQL Reference.

The scripts that you use to install the demonstration databases reside in the $INFORMIXDIR/bin directory on UNIX platforms and in the %INFORMIXDIR%\bin directory in Windows environments.