Neoview Database Administrator's Guide (R2.3)

• “Changing Materialized Views” (page 76)

• “Dropping (Deleting) Materialized Views” (page 77)

• “Materialized View Groups” (page 77)

— “Creating Materialized View Groups” (page 77)

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

— “Changing Materialized View Groups” (page 79)

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

• “Synonyms” (page 79)

— “Creating Synonyms” (page 80)

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

— “Changing Synonyms” (page 81)

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

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

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:

On all schema screens, you can use the buttons at the bottom of the screen to copy data to

your clipboard, a file, or a spreadsheet.

You can also expand Schemas to display a list in the left pane.

36 Managing Database Objects