Define a database

Define a relational database by using the New Database Definition wizard in the Data Definition view. A relational database is a set of tables that can be manipulated in accordance with the relational model of data. A relational database contains a set of data objects that are used to store, manage, and access data. Examples of such data objects are tables, views, indexes, functions, and stored procedures.

Prerequisite: Before you define a database, define a project.

To define a database:

1. Switch to the Data Perspective.

2. From the pop-up menu of a project in the Data Definition view, click New > Database definition. The New Database Definition wizard opens.

3. In the Database name field, type the name of the database that you want to create.

4. Select the database vendor type. When you generate SQL DDL for your schemas, it conforms to the database type that you select here.

5. Click Finish. The new database is displayed under the project folder.

After you define a database, you can add schemas to it that contain your tables, views, and other database objects.

Federated systems
A federated system is a collection of databases, spreadsheets, and flat files from different database management systems.

Creating a table nickname
If you want to use federated databases, create a table nickname. A nickname is an identifier by which the federated system refers to a data source table or view. Nicknames are generally used to make tables on a remote server appear to be local.

 

Parent topic

Defining database objects

 

Related concepts

Federated systems