Explain logical database components

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.
What are the database objects? Explain them in brief
Database objects such as tables, primary key, and foreign key describe the structure of the content of a database. These objects also represent the properties of a server.....
Physical database architecture
The physical database architecture describes how the database and files are organized in a SQL server........
What are pages and Extents?
A page is a unit of data storage in SQL. The size of a page is 8Kb. A page has a header and a body. Different types of pages are:......
Post your comment