Database Management Systems

Oracle is client server application development.

It shows how data is actually stored.

Hash value points to the element exactly using index.

This library file format in Oracle contains both library source code and the complied, platform specific executable code.

This condition in data fragmentation states that all data of the global relation must be mapped into fragments.

This objective in the design of the data distribution can be achieved by having redundant fragment allocation meeting the site requirements.

This is the layer of query processing that decomposes the distributed calculus query into an algebraic query on global relations.

This tool in Oracle distributed database systems is a database administration tool, which allows an user to perform database administration task with the convenience of a Graphical User Interface (GUI).

This feature of heterogeneous service agent or Oracle gateway allows a transaction  that can span both Oracle and non-Oracle systems.

This is the low level and here, data is stored.

The process of designating sub grouping within an entity set is called specialization.

View level is the highest level of abstraction that describes only part of the database and simplifies their interaction with the system.

This is done by sub-schema.

A storage manager is a program module that provides the interface between low-level data stored in the data base and the application program, and the queries submitted by the system. The storage manager is responsible for the interaction with the file manager.

They are represented by the double rectangles.