ISA PRESENTATION

ISA PRESENTATION: 

ISA PRESENTATION “ DATA RESOURCE MANAGEMENT CONTROLS” Data Administrator TOPIC & Database Administrator

GROUP MEMBERS: 

GROUP MEMBERS SHALINI P. CHANDRA BCA08104 SHILPA METI BCA08119 HARISHAD POWAR BCA08125 SHERRY RAPOSO BCA08128 RICHA TORASKER BCA08137

INTRODUCTION: 

INTRODUCTION D ata is a critical resource that must be managed properly. Data administration or data resource management is an organizational function working in the areas of information systems and computer science that plans, organizes, describes and controls data resources. Data resources are usually stored in databases under a database management system or other software such as electronic spreadsheets . A database administrator (DBA) is a person responsible for the design, implementation, maintenance and repair of an organization's database . They are also known by the titles Database Coordinator or Database Programmer , and is closely related to the Database Analyst , Database Modeler , Programmer Analyst , and Systems Manager .

MOTIVATIONS TOWARD THE DA AND DBA: 

MOTIVATIONS TOWARD THE DA AND DBA Sharability: Different stakeholders in a organization should be permitted to access and use the same data. They should not have to maintain their own separate copies of the same data item. Availability: If Data were to be shared, different stakeholders should be able to access and use the data whenever they needed it. Evolvability: Facilities had to exist that allowed data and its definition to be modified easily in response to changing stakeholder needs. Integrity: If data were to be shared among multiple stakeholders, its authenticity, accuracy, and completeness had to be preserved.

Database Administrator's Roles: 

Database Administrator's Roles Transferring Data Replicating Data Maintaining database and ensuring its availability to users Controlling privileges and permissions to database users Monitoring database performance Database backup and recovery Database security

Data Administrator’s Role: 

Data Administrator’s Role Design and Development Supervisory Advisory ensure backups happen and are done right Implements policies and procedures Codes for storage of data.

Slide 7: 

Function DA responsibilities DBA responsibility Defining data Undertaking strategic data planning; determining user needs; Specifying conceptual and external schema ( user-oriented)definitions Specifying internal schema (computer-oriented) definition. Creating data Advising users on data collection procedures; specifying validation and editing criteria. Preparing programs to create data; assistance in populating database. Redefining/ Restructuring data Specifying new conceptual and external schema definitions; advising users on how to conform with new definition Specifying new external schema definition; altering database to conform with new schema definitions. Retiring data Specifying retirement policies. Implementing retirement policies.

Slide 8: 

Function DA responsibility DBA responsibility Making database available to users Determining end-user requirements for database tools; testing and evaluating end-user database tools. Determining program requirements for database tools; determining database optimization tools required; testing and evaluating programmer and database optimization tools. Informing and Servicing users Answering end-user queries ; educating end users; establishing and promulgating high-level policy information; providing conceptual schema and external schema information. Answering programmers queries; educating programmers; establishing and promulgating low-level policy information; providing internal schema information.

Slide 9: 

Function DA responsibility DBA responsibility Maintaining database integrity Developing and promulgating organization wide standards; assisting end users to formulate application controls. Implementing database controls; assisting programmers to design and implement application controls. Monitoring operations Monitoring end-user patterns of database use. Monitoring programmer patterns of database use; collecting performance statistics; tuning the database.

DEFINING, CREATING, REDEFINING AND RETIRING DATA : 

DEFINING, CREATING, REDEFINING AND RETIRING DATA EXTERNAL SCHEMA 1 EXTERNAL SCHEMA 2 EXTERNAL SCHEMA 3 CONCEPTUAL SCHEMA INTERNAL SCHEMA STORED DATABASE

MAKING THE DATABASE AVAILABLE TO USERS: 

MAKING THE DATABASE AVAILABLE TO USERS Database users need various tools to interrogate and update the database. These tools must be purchased or developed. Someone must monitor the user’s needs, remain aware of the current technology, so DA and DBA both are responsible for making the database available to users. The DA usually has better knowledge of end-user needs. The DBA, on another hand, usually has better knowledge of programmer needs. Tools must be evaluated and tested carefully by DA and DBA.

INFORMING AND SERVICING USERS: 

INFORMING AND SERVICING USERS The DA and DBA are responsible for informing, assisting, educating and training the users so that they can effectively and efficiently employ the tools. To inform and service the users, the DA and DBA must establish good communication with them by the means of documentation, memoranda, websites, electronic bulletin boards and mail messages etc. The DA and DBA must also develop good personal rapport with users if they are to be effective consultants when users encounter problem.

MAINTAINING DATABASE INTEGRITY: 

MAINTAINING DATABASE INTEGRITY DEFINATION CONTROL EXISTENCE CONTROL ACCESS CONTROL UPDATE CONTROL CONCURRENCY CONTROL QUALITY CONTROL

MONITORING OPERATIONS: 

MONITORING OPERATIONS The DA and DBA must monitor operations and performance within the database environment. To monitor the database environment effectively the DA and DBA must be able to identify where changes or difficulties are likely to occur. Auditors might interview the DA and DBA to determine the procedures they use to monitor the database environment.