Illustrate Physical Database Architecture In Brief?

1.	Illustrate Physical Database Architecture In Brief?
Answer» The physical database architecture describes how the database and files are organized in a SQL server. Pages and extents: these DESCRIBE how the data is STORED. Physical Database Files and File GROUPS:- describes the operating system files used to store data and logs. Space ALLOCATION and Reuse:- Describes the algorithms used for space allocation. Table and Index Architecture:- Describes the way pages for tables can be indexed. The physical database architecture describes how the database and files are organized in a SQL server. Pages and extents: these describe how the data is stored. Physical Database Files and File groups:- describes the operating system files used to store data and logs. Space Allocation and Reuse:- Describes the algorithms used for space allocation. Table and Index Architecture:- Describes the way pages for tables can be indexed.

Answer»

The physical database architecture describes how the database and files are organized in a SQL server.

Pages and extents: these DESCRIBE how the data is STORED.

Physical Database Files and File GROUPS:- describes the operating system files used to store data and logs.

Space ALLOCATION and Reuse:- Describes the algorithms used for space allocation.

Table and Index Architecture:- Describes the way pages for tables can be indexed.

The physical database architecture describes how the database and files are organized in a SQL server.

Pages and extents: these describe how the data is stored.

Physical Database Files and File groups:- describes the operating system files used to store data and logs.

Space Allocation and Reuse:- Describes the algorithms used for space allocation.

Table and Index Architecture:- Describes the way pages for tables can be indexed.

Discussion