Components Of Database Environment

The major components of a typical database environment and their relationships are:

  • ➡ Computer-aided software engineering (CASE) tools

Automated tools used to design databases and application programs. We describe the use of CASE tools for database design and development throughout the text.

  • ➡ Repository

Centralized storehouse for all data definitions, data relationships, screen and report formats, and other system components. A repository contains an extended set of metadata important for managing databases as well as other components of an information system.

  • ➡ Database management system (DBMS)

Commercial software system used to define, create maintain, and provide controlled access to the database and also to the repository.

  • ➡ Database

An organized collection of logically related data, usually designed to meet the information needs of multiple users in an organization. It is important to distinguish between the database and the repository. The repository contains definitions of data, whereas the database contains occurrences of data.

  • ➡ Application programs

Computer programs that are used to create and maintain the database and provide information to users.

  • ➡ User interface

Languages, menus, and other facilities by which users interact with various system components, such as CASE tools, application programs, the DBMS, and the repository User interfaces are illustrated through out this text.

  • ➡ Data administrators

Persons who are responsible for the overall information resources organization. Data administrators use CASE tools to improve the productivity of database planning
and design.

  • ➡ System developers

Persons such as system analysts and programmers who design new application programs. System developers often use CASE tools for system requirements analysis and program design.

  • ➡ End users

Persons through out the organization who add, delete, and modify data in the database and who request or receive information from it. All user interactions with the database must be routed through the DBMS.

Post a Comment