Data Administration, Database Administration and Data Dictionaries - Database Management - Lecture Slides, Slides of Database Management Systems (DBMS)

Download Data Administration, Database Administration and Data Dictionaries - Database Management - Lecture Slides and more Slides Database Management Systems (DBMS) in PDF only on Docsity!

Data Administration, Database

Administration, and Data

Dictionaries

Docsity.com

Objectives

• Define and compare data administration and database administration.
• List and describe the advantages of data administration.
• List and describe the advantages of database administration.

Objectives

• Explain the concept of metadata.
• List and describe such metadata realizations as passive and active data dictionaries, relational DBMS catalogs, and data repositories.

Database Management

• The “people side” of database management consists of two parts: - Data Administration - Database Administration

Database Administration

• More operationally oriented.
• Responsible for the day-to-day monitoring and management of the company’s various active databases.
• Responsible for providing liaison support to program designers during application development.
• Carries out many of the policies set by data administration.

Advantages of Data and Database

Administration

• Data as a shared corporate resources.
• Efficiency in job specialization.
• Operational management of data.
• Managing externally acquired databases.
• Managing data in the decentralized environment.

Data as a Shared

Corporate Resource

• The effective use of its data can give a company a significant competitive advantage.
• Data, like other resources, tends to be scarce.
• The dedicated departments that manage the company’s data are the data administration and database administration departments.

Efficiency in Job Specialization

• Many of the functions involved in the management of data are highly specialized and require specific expertise.
• This argues for a full-time staff of specialists who do nothing but manage a company’s data and databases.

Managing Externally

Acquired Databases

• Some databases are not designed by a company’s own personnel but are acquired as part of purchased software packages.
• For example, Enterprise Resource Planning (ERP) software.

Managing Data in the Decentralized

Environment

• Permits user departments all over the company to handle some or all of their information systems needs on their own, without having to rely on the central information systems organization.
• Decentralization is a fact of life to a greater or lesser degree in virtually all companies.

The Responsibilities of Data

Administration

11-

♦ Data coordination.

♦ Data planning.

♦ Data standards.

♦ Liaison to systems analysts and programmers.

♦ Training.

♦ Arbitration of disputes and usage authorization.

♦ Documentation and publicity.

♦ Data’s competitive advantage.

Docsity.com

Data Coordination

• In the centralized/decentralized environment, with data and copies of data scattered among mainframe computers, local area network servers, and even PCs, the possibility of inconsistency and error increases.
• Data coordination becomes the job of the data administrators, by which they maintain a reasonable amount of control over the company’s data.

Data Standards

• For example, controlling the way that attribute names, table names, and other data related names are formed.
• For example, insisting on consistency in the way the programs that access the database are written, especially in regard to the database call instructions.

Liaison to Systems Analysts and

Programmers

• Data administrators are responsible for providing support to the systems analysts and programmers in all matters concerning the data needed by an application.
• Data analysts are generally involved in database design at some level, but the decision of what that precise level of involvement should be is dependent on a number of factors.