IDS410review12

IDS410review12 - Chapter 12 109 Chapter 12 Data and...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Chapter 12 109 Chapter 12 Data and Database Administration Answers to Review Questions 1. Define the following key terms: a. Data administration A high-level function that is responsible for the overall management of data resources in an organization, including maintaining corporate-wide definitions and standards. b. Database administration A technical function that is responsible for physical database design and for dealing with technical issues such as security enforcement, database performance, and backup and recovery. c. Data steward A person assigned the responsibility of ensuring that organizational applications properly support the organization's enterprise goals. d. Information repository Stores metadata that describe an organization's data and data processing resources. Manages the total information-processing environment. Combines information about an organization's business information and its application portfolio. e. Locking Concurrency control mechanisms that deny access to other users in a multi- user environment while an update is completed or aborted. f. Versioning Concurrency control mechanism that doesn't use record locking. Each transaction is restricted to a view of the database as of the time that transaction started, and when a transaction modifies a record, the DBMS creates a new record version instead of overwriting the old record. g. Deadlock An impasse that results when two or more transactions have locked a common resource, and each waits for the other to unlock that resource. h. Transaction A discrete unit of work that must be completely processed or not processed at all within a computer system. i. Encryption The coding (or scrambling) of data so that humans cannot read them. j. Data availability The concept of data being available to users when needed. Ensuring data availability is of utmost importance to the DBA. k. Data archiving The process of moving inactive data to another location where it can be accessed when needed. l. Heartbeat query A query submitted by the DBA to test the current performance of the database. A heartbeat query is also called a canary query. 2. d backup facilities f biometric device j checkpoint facility g database recovery a database security i granularity h recovery manager b rollback e rollforward c system catalog
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
110 Modern Database Management, Eighth Edition 3. Compare and contrast the following terms: a. D ata administration; database administration Data administration is the overall management of data resources . The second function, that of database administration, has been regarded as responsible for physical database design and for dealing with the technical issues, such as security enforcement, database performance, backup and recovery, associated with managing a database. b.
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 8

IDS410review12 - Chapter 12 109 Chapter 12 Data and...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online