Database Design


Database design is the conversion of your logical data model into database objects. The advantages of a well thought out database design include the following:

?      Good performance

?      Parallel data usage

?      Low redundancy

?      Data integrity

?      User friendliness


?      You have created and configured a database instance (see Creating and Configuring a Database Instance).

?      You have designed a logical data model.

Process Flow

Note the Database Design Tips.


       1.      Use DDL (Data Definition Language) statements to define database objects. You can create the following database objects, among others:

0       Tables and view tables

0       Columns (including suitable data types)

0       Value ranges and constraints

0       Primary keys

0       Indexes

0       Database procedures and functions

0       Triggers


SQL Tutorial, Data Definition

SQL Reference Manual, Data Definition

       2.      You create the database users and assign the required authorizations. See

SQL Tutorial, Authorization

SQL Reference Manual, Authorization


You can use either SQL statements or the Loader database tool to add data to the database. See

SQL Tutorial, Data Manipulation

SQL Reference Manual, Data Manipulation

Documentation for the Loader

See also:

Overview of the Database System