330 likes | 332 Views
Learn about the roles of Database Manager and Administrator, responsibilities, functions, and user types in the realm of Database Management. Understand data definition and manipulation languages.
E N D
e – Lesson Module for C-16 Curriculum State Board of Technical Education & Training Andhra Pradesh Year/Semester : III Semester Branch : Computer Engineering Subject : CM-305,DBMS Topic : Concepts of DBMS & RDBMS Sub Topic : Explain Database Manager, Explain Database Administrator and Users Duration : 50 min Prepared by K.Padmaja, Lecturer in CME K.Subrahmanyam, Lecturer in CME At A.A.N.M&V.V.R.S.R POLYTECHNIC , GUDLAVALLERU C_16_CME_305_1.9_1.10
On completion of this period you would be able to Main Objectives of this lesson • Explain data base manager • Explain the Responsibilities of the Database Manager • Explain the Functions and Responsibilities of the Database Administrator • Explain about the Different users in Database Management System C_16_CME_305_1.9_1.10
RECAP In the previous lesson, you have learn • Data definition language • Data manipulation language C_16_CME_305_1.9_1.10
Data definition language: • Specification notation for defining the database schema • A Data base is specified by Data definition language e.g.:- Create, Alter, Drop table C_16_CME_305_1.9_1.10
Data manipulation language: • Enables users to access or manipulate data as organized by the appropriate data model C_16_CME_305_1.9_1.10
What is database? • Collection of data • Contains information about particular enterprise C_16_CME_305_1.9_1.10
Who is a database Manager? • Responsible for ensuring that the database remains in a correct state despite system failures . • Ensures proper functioning of the DBMS Click Here To View Video on Functions of Database Manager C_16_CME_305_1.9_1.10
Responsibilities of Database Manager (DBM) Define various transactions: • Each transaction preserves the consistency of the database(Correct data) Atomicity property: • Failed transaction cause no change on state of the database C_16_CME_305_1.9_1.10
Responsibilities of Database Manager (DBM) Contd . . . Detecting system failures • Restore the database to a state that existed prior to the occurrence of the failure Maintain consistency of the database • To ensure control on the interaction among the concurrent transactions C_16_CME_305_1.9_1.10
Responsibilities of Database Manager (DBM) Contd . . . Security Enforcement • Ensuring that users only have access to information they are permitted to see C_16_CME_305_1.9_1.10
DBM is an interface To provide the interface between the • low-level data stored in database • the application programs • Transactions submitted to the system C_16_CME_305_1.9_1.10
Who is Database Administrator? • Central control of both data and the programs that access those data is called DBA C_16_CME_305_1.9_1.10
Responsibilities of the DBA: • Ensuring security to the database • Providing data Integrity • Restricting accessibility to unauthorized users • Taking backups C_16_CME_305_1.9_1.10
Functions of Database Administrator Schema Definition • Creates the Original database schema • The definitions are translated by DDL compiler to a set of tables stored in the data dictionary C_16_CME_305_1.9_1.10
Functions of Database Administrator Contd . . . Storage structure and Access-method Definition • DBA creates appropriate storage structures and access methods by writing set of definitions • The definitions are translated by Data storage and data definition language compiler C_16_CME_305_1.9_1.10
Functions of Database Administrator Contd . . . Schema and Physical-Organization Modification • DBA allows the users to accomplish modifications in the database schema through a set of definitions Grant of Authorization for Data Access • DBA granting different types of authorizations for data access to various users C_16_CME_305_1.9_1.10
Integrity Constraints Specification Functions of Database Administrator Contd . . . • Integrity Constraints are specified by DBA • The Integrity Constraints are kept in a special system structure that is consulted by the database system C_16_CME_305_1.9_1.10
Database Administrator jobs • Participate in database and application development • Develop procedures for integrity and quality of data • Facilitate changes to database structure • Participate in database design and dictionary • Modify database structure C_16_CME_305_1.9_1.10
Database Administrator jobs Contd . . . • Evaluate and implement new DBMS features • Tune the database • Develop, document, and train staff on backup and recovery procedures • Controlling and monitoring user access to the database • Publish and Maintain data activity standards documentation C_16_CME_305_1.9_1.10
Database Users • The primary goal of a database system is to provide an environment for retrieving information from and storing new information into the database. • The persons who are authorized to use database for storing and retrieval of data. Click Here To View Video on Database Users C_16_CME_305_1.9_1.10
Different types of database users: • Application programmers • Are computer professionals interact with the system through DML calls • Sophisticated Users • Interact with the system without writing programs • They form requests by writing queries in a database query language C_16_CME_305_1.9_1.10
Different types of database users: Contd . . . • Specialized Users • Users are sophisticated users writing special database application programs • These may be CADD Systems, Knowledge-based and expert systems , complex data systems, etc C_16_CME305_1.9_1.10
Different types of database users: Contd . . . • Unsophisticated Users or Naïve Users • Users who interact with the system by using permanent application program e.g: people accessing database over the web, bank tellers, clerical staff C_16_CME_305_1.9_1.10
In this class, you have learnt Summary • Who is Database Manager • Responsibilities of the Database Manager • Who is Database Administrator • Different functions of the Database Administrator • Different Responsibilities of the Database Administrator • Different users of Database system C_16_CME_305_1.9_1.10
Assignment questions 1.What is DBM 2.What is DBA 3.Explain the Responsibilities of the Database Manager? 4. Explain the Responsibilities of the Database Administrator? C_16_CME_305_1.9_1.10
Quiz C_16_CME_305_1.9_1.10
1. DBM act as an interface • No • Yes • Unknown C_16_CME_305_1.9_1.10
1. DBM act as an interface • No • Yes • Unknown C_16_CME_305_1.9_1.10
2. DBM maintains inconsistency of the database • Yes • No • Unknown C_16_CME_305_1.9_1.10
2. DBM maintains inconsistency of the database • Yes • No • Unknown C_16_CME_305_1.9_1.10
3. DBM detects system failures • No • Yes • Unknown CM503.8
3. DBM detects system failures • No • Yes • Unknown C_16_CME_305_1.9_1.10
Thank You C_16_CME_305_1.9_1.10