Managing Databases - Overview

In BBj, a database is comprised of a single data dictionary and the corresponding data files defining the tables in the data dictionary. Each database is given a different name or "alias" by the administrator,  which is used to refer to that database. Only those databases that a user has been granted administrative access to can be accessed by that user when using the Enterprise Manager.

The Enterprise Manager provides an interface for:

• Configuring databases
• Creating and modifying database structure and content
• Executing SQL queries
• Viewing statistical data for analysis

The following list provides entry points into each of the major components of the database management functionality in the Enterprise Manager:

• Configuration
• Information
• Tables
• Views
• Procedures
• Type Definitions
• Sequences
• Permissions
• Roles
• SQL
• Query Analysis