Databases

Index
Databases Search Criteria/Results grid
Databases Details page

Additional Information
Domain

The Databases table (md_database) is found in the Metadata Administration module of iTopia. Databases contain information about the tables and columns within the tables. The two Databases that are shipped with iTopia are:

  • ibis - this is the database that contains the information about the Integrated Business Intelligence Suite.

  • meta - this is the database that contains the information about the meta data in your iTopia system. Meta data is also known as 'data about data' which is the information about the contents and uses of the data warehouse. Meta data is created by several components of the data warehouse and provides a business and technical view of the data warehouse solution.

The following fields are available in the Databases view and are based on the order in which they appear in the grid on the search page:

  • Database Name - the name of the database.

  • Description Literal Key - the literal key that was created for the database.

  • Client Specific Text - the actual name of the Database.

  • Data Model - display as a link to a multimedia object type column used to displays a PDF version of the database’s data model. Only the ‘meta’ database currently supports the Data Model.

For information on the functionality of each button on the Databases Search Criteria Results/Grid page, click here.

Databases Details Page

When you click on the View Record Details icon Detail for a specific record on the Databases Search/Criteria Grid page, the Databases Detail page opens for that record.

The following list defines every field on the Details page:

  • Description Literal Key - the literal key that was created for the database.

  • Alternate Identifier - serves as an alternate to the database name. One use of this field is to generate the method names for Java Table Objects and their supporting classes.

  • Data Model - displays as a link to a multimedia object type column used to displays a PDF version of the database’s data model. Only the ‘meta’ database currently supports the Data Model.

  • Modification Counter - displays the number of times the Databases view has been modified.

There is also one Related resource 'Domain' located at the bottom of the page.

For information on the functionality of each button on the Databases Details page, click here.