Demonstration Database

The DB–Access utility, which is provided with the database server products, includes one or more of the following demonstration 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.
• The sales_demo database illustrates a dimensional schema for data- warehousing applications. For conceptual information about dimensional data modeling, see the IBM Informix: Database Design and Implementation Guide.
• 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 Appendix A. The stores_demo Database and Appendix B. The sales_demo and superstores_demo Databases.

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.