Fujitsu J2X0-2273-01EN 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.
3