Neoview Database Administrator's Guide (R2.2)

• “Materialized View Groups” (page 69)

— “Creating Materialized View Groups” (page 69)

— “Displaying Materialized View Groups and their Properties” (page 70)

— “Changing Materialized View Groups” (page 71)

— “Dropping (Deleting) Materialized View Groups” (page 71)

• “Synonyms” (page 72)

— “Creating Synonyms” (page 72)

— “Displaying Synonyms and Their Properties” (page 73)

— “Changing Synonyms” (page 73)

— “Dropping (Deleting) Synonyms” (page 74)

• “Stored Procedures in Java (SPJs)” (page 74)

Schemas

Your Neoview platform is preconfigured with these schemas:

Is used for...This schema

All tables that database administrators create in the database for end users, including dimension

and fact tables.

All tables created by end users using the DB Admin tool or third-party tools that connect to ODBC

data sources.

USR

Displaying Schemas and Their Objects

1. Start DB Admin and log on using any user ID. The DBA role is intended for this task.

2. Click the Database tab. DB Admin displays existing schemas with their owners:

You can also click the arrow next to Schemas to display a list in the left pane.

38 Managing Database Objects