The distinction between data administration and database administration. The purpose and tasks associated with data administration and database administration. The scope of database security. Why database security is a serious concern for an organization. The type of threats that can affect a database system. How to protect a computer system using computer-based controls | Database Administration and Security Transparencies ©Pearson Education 2009 Objectives The distinction between data administration and database administration. The purpose and tasks associated with data administration and database administration. The scope of database security. Why database security is a serious concern for an organization. The type of threats that can affect a database system. How to protect a computer system using computer-based controls. ©Pearson Education 2009 Data administration and database administration Data Administrator (DA) and Database Administrator (DBA) are responsible for managing and controlling activities associated with corporate data and corporate database, respectively. DA is more concerned with early stages of lifecycle and DBA is more concerned with later stages. ©Pearson Education 2009 Data administration Management and control of corporate data, including: database planning; development and maintenance of standards, policies, and . | Database Administration and Security Transparencies ©Pearson Education 2009 Objectives The distinction between data administration and database administration. The purpose and tasks associated with data administration and database administration. The scope of database security. Why database security is a serious concern for an organization. The type of threats that can affect a database system. How to protect a computer system using computer-based controls. ©Pearson Education 2009 Data administration and database administration Data Administrator (DA) and Database Administrator (DBA) are responsible for managing and controlling activities associated with corporate data and corporate database, respectively. DA is more concerned with early stages of lifecycle and DBA is more concerned with later stages. ©Pearson Education 2009 Data administration Management and control of corporate data, including: database planning; development and maintenance of standards, policies, and procedures; conceptual and logical database design. ©Pearson Education 2009 Data administration tasks ©Pearson Education 2009 Database administration Management and control of physical realization of a database system, including: physical database design and implementation; setting security and integrity controls; monitoring system performance; reorganizing the database. ©Pearson Education 2009 Database administration tasks ©Pearson Education 2009 Comparison of data and database administration ©Pearson Education 2009 Database security Mechanisms that protect the database against intentional or accidental threats. Not only apply to the data held in a database. Breaches of security may affect other parts of the system, which may in turn affect the database. Includes hardware, software, people, and data. Growing importance of security is the increasing amounts of crucial corporate data being stored on computer. ©Pearson Education 2009 Examples of threats and .
