Database Design

Purpose

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

Prerequisites

?      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

See

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

Result

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

Performance