Fujitsu 5.0L10 Manual Do Utilizador

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." 

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. 

 

 

 

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