|
Explain logical database components.- The logical components are usually used to connect to the database.
- Any object that a user can use to access or connect to the database is a logical component.
- Triggers, tables, procedures, views, keys etc are typical examples of logical database components.
The Logical database component consists two types:
1. Tablespaces
2. Database's schema objects.
1. Tablespace:
- A tablespeace is a logical unit of storage of a database on which the datafile resides.
- It is not visible in the system, hence logical.
- Each table, index etc. is associated with a tablespace.
There are three different types of tablespaces:
a. Permanent
b. Temporary
c. Undo
2. Database Schema objects:
- Schema objects consist of database triggers, operators, sequences, indexes, and stored procedures etc. that together comprise a schema.
- A schema is a logical structure of data and such schema objects.
- Schema objects are stored logically in a tablespace of the database.
- The data for these objects is present in a data file.
|
