Server User Manual

Functions for manipulating tables (table manipulation)

Data manipulation SQL statements are used to insert, alter, delete, and reference data in tables. These SQL

statements are used within application programs. For information about how to develop application programs that use

data manipulation SQL statements, refer to the "RDB User's Guide: Application Program Development."

For information about how to use data manipulation SQL statements, refer to the "SQL Beginner's Guide."

1.2 Overview of the SymfoWARE/RDB Database Configurat

ion

As Figure: SymfoWARE/RDB database configuration shows, a SymfoWARE/RDB database consists of multiple

databases and an RDB dictionary and RDB directory file for managing them. The database logical structure, storage

structure, and physical structure definition information is stored in the RDB dictionary. Base tables, which are the

database data, and indexes are stored in database spaces.

[Figure: SymfoWARE/RDB database configuration]

In addition, as Figure: Relationship of logical, storage, and physical structures within databases shows, each database

consists of schemas, base tables, data structure organizations (DSOs), data structure instances (DSIs), and

databases spaces. These items are the basic elements of a three-tier hierarchy composed of the logical structure,

storage structure, and physical structure.