{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

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

Info icon This 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
Image of page 1

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

View Full Document Right 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.
Image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern