tailieunhanh - Lecture Database design, application development and administration - Chapter 14: Data and database administration

Chapter 14 - Data and database administration. This chapter describes the responsibilities and tools of data specialists (data administrators and database administrators) and provides an introduction to the different processing environments for databases. | Chapter 14 Data and Database Administration Provides an overview of the responsibilities and tools of database specialists known as data administrators and database administrators. Objectives: · Compare and contrast the responsibilities of database administrators and data administrators · Manage databases using SQL statements for security and integrity · Understand the roles of data dictionary tables and the information resource dictionary - Manage the usage of stored procedures and triggers · Describe the data planning process · Understand the process to select and evaluate DBMSs · Perceive the processing environments in which database technology exists Outline Organizational context Tools of database administration Processes for database specialists Overview of processing environments Organizational context management decision-making goals of information resource management responsibilities of data and database administrators Tools of database administration SQL statements for security and integrity Management of stored procedures and triggers Concepts about data dictionary manipulation Processes for database specialists data planning DBMS selection Processing environments: focus on role of database specialists Transaction processing Data warehouses Distributed processing Object data management Database Support for Decision Making Operational databases directly support major functions such as order processing, manufacturing, accounts payable, and product distribution. The reasons for investing in an operational database are typically faster processing, larger volumes of business, and reduced personnel costs. Operational databases provide the raw materials for management decision-making as depicted in the slide. Lower-level management can obtain exception and problem reports directly from operational databases. However, much value must be added to leverage the operational databases for middle and upper management. The operational . | Chapter 14 Data and Database Administration Provides an overview of the responsibilities and tools of database specialists known as data administrators and database administrators. Objectives: · Compare and contrast the responsibilities of database administrators and data administrators · Manage databases using SQL statements for security and integrity · Understand the roles of data dictionary tables and the information resource dictionary - Manage the usage of stored procedures and triggers · Describe the data planning process · Understand the process to select and evaluate DBMSs · Perceive the processing environments in which database technology exists Outline Organizational context Tools of database administration Processes for database specialists Overview of processing environments Organizational context management decision-making goals of information resource management responsibilities of data and database administrators Tools of database .