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

Data Administration, Database Administration and Data Dictionaries, Administration and Database Administration, Database Management, Data Administration, Database Administration, Advantages of Data, Shared Corporate Resource, Job Specialization, Operational Management of Data, Managing Externally Acquired Databases are some points from this Database Management lecture.

Typology: Slides

2011/2012

Uploaded on 12/17/2012

shobi
shobi 🇮🇳

4.3

(52)

75 documents

1 / 52

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
Data Administration, Database
Administration, and Data
Dictionaries
Docsity.com
pf3
pf4
pf5
pf8
pf9
pfa
pfd
pfe
pff
pf12
pf13
pf14
pf15
pf16
pf17
pf18
pf19
pf1a
pf1b
pf1c
pf1d
pf1e
pf1f
pf20
pf21
pf22
pf23
pf24
pf25
pf26
pf27
pf28
pf29
pf2a
pf2b
pf2c
pf2d
pf2e
pf2f
pf30
pf31
pf32
pf33
pf34

Partial preview of the text

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.