Mimer SQL Documentation TOC PREV NEXT INDEX

Mimer SQL Developer Site

http://developer.mimer.com


The Example Environment Structure


The example environment contains the following schemas: the MIMER_STORE schema, the MIMER_STORE_MUSIC schema, the MIMER_STORE_BOOK schema and the MIMER_STORE_WEB schema.

For more information, see the Mimer SQL User's Manual, Appendix A, The Example Environment.

The MIMER_STORE Schema

In this base schema most of the objects supported by Mimer SQL are introduced: collations, databanks, domains, idents, sequences, synonyms, tables and views. They are used to demonstrate some of the functionality that is available - constraints; primary, unique and foreign keys; secondary indices, NOT NULL, default values, and column and table check clauses. The schema also includes examples of PSM routines and triggers.

This schema contains the following tables: currencies, countries, categories, formats, producers, products, images, items, customers, orders, order_items, stop_words.

The MIMER_STORE_MUSIC Schema

This schema groups objects related to music and contains the following tables: artist, titles, tracks, samples

The MIMER_STORE_BOOK Schema

This schema groups objects related to books and contains the following tables: titles, authors, keywords

The MIMER_STORE_WEB Schema

This schema groups objects related to the Web business area and contains the following tables: which contains the following table: sessions



Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
dbtechnology@upright.se
Mimer SQL Documentation TOC PREV NEXT INDEX