Database Management Systems

In this model, data flow diagrams may be used to show how data is processed at different stages in the system.

Global schema defines all the data, which are contained in the distributed database as if it is a centralized system.

Database Buffer Cache is an area in memory that holds all the blocks read in from disk for query or modification in System Global Area.

This component of the RMAN environment is optional when using RMAN stores its metadata in the control file of each target database.

This feature of RMAN describes the level of multiplexing and the number and size of the input and output disk buffers.

In this transaction's properties, once a transaction is committed, the system must guarantee that the results of operations will never be lost independent of subsequent failure.

RMAN can use image copies during RMAN restore and recover operations.

During the execution phase, recovery manager sends the remote procedure calls to the target database, monitors their progress and collects the result.

RMAN can create, backup or recover a physical standby database.

This component of the RMAN environment containing the control files, datafiles and optional archived redo logs.

This transaction's properties requires that if a transaction is interrupted by a failure its partial results are not at all taken into consideration.

This component of the RMAN environment is a separate database created to hold the recovery catalog.

A flash recovery area is a directory and automatic storage management disk group that includes RMAN backup, multiplexed copies of the control file and online redo logs.

This node participating in the session tree sends all of the distributed transaction's SQL statements, remote procedure calls and so forth to the directly referenced nodes thus forming the session tree.

This node participating in the session tree acts as a client when it references information from another node's database.