Database Management System (DBMS) an Introduction

1. Database Management System (DBMS) an Introduction

2. Intro to DBMS Objectives • Understand why databases are important to modern organizations • Understand how databases work • Understand how organizations can maximize their strategic potential with databases

3. Intro to DBMS • Data is a vital part of any organization. It needs to be stored, organized, managed, accessed, protected and manipulated. • Operational • Use databases to: • Create a book • Track book sales • Set salaries and wages • Pay employees

4. Intro to DBMS Purpose of DBMS • The purpose of a database is to keep track of things • Unlike a list or spreadsheet, a database may store information that is more complicated than a simple list

5. Intro to DBMS Database Management for Strategic Advantage • The Database Approach: Foundational Concepts • DBMS – Database Management Systems • Use a DBMS software to create, store, organize, and retrieve data from a single database or several databases • Example: Microsoft Access

6. Intro to DBMS Database Management for Strategic Advantage • Advantages of the Database Approach • Program-data independence • Minimal data redundancy • Improved data consistency • Improved data sharing • Increased productivity of application development • Enforcement of standards • Improved data quality • Improved data accessibility • Reduced program maintenance

7. Intro to DBMS Database Management for Strategic Advantage • Effective Management of Databases • The database administrator (DBA) : • Works with programmers and analysts to design and implement the database • Works with users and managers to establish database policies • Implements security features and establishes database permissions

8. Intro to DBMS Database Systems • The four components of a database system are: • Users • Database Application • Database Management System (DBMS) • Database

9. Intro to DBMS Database Systems

10. Intro to DBMS Database Systems - Users • A user of a database system will • Use a database application to track things • Use forms to enter, read, delete and query data • Produce reports

11. Intro to DBMS Database Systems – Database Application • A set of one or more computer programs that serves as an intermediary between the users and the DBMS • Application program that read or modify database data by sending SQL statements to DBMS. • Application program to present data to users in the format of forms and reports.

12. Intro to DBMS Database Systems – Database Application : Functions • Create and process forms • Process user queries • Create and process reports • Execute application logic • Control database applications

13. Intro to DBMS Database Systems – DBMS • A computer program used to create, process and administer the database • DBMS receives request encoded in SQL and translates these requests into actions on the database • DBMS is a large, complicated program that is licensed software. Almost majority of the companies never write their own DBMS program.

14. Intro to DBMS Database Systems – Database • The database is a collection of related tables and other structures. • A database is a self-describing collection of related records

15. Intro to DBMS Functions of DBMS • Create databases • Create tables • Create supporting structures • Read database data • Modify database data (insert, update, delete) • Maintain database structures • Enforce rules • Control concurrency • Provide security • Perform backup and recovery

16. Intro to DBMS Organizational DBMS

17. Intro to DBMS Organizational DBMS • Organizational database systems typically: • Support several users simultaneously • Include more than one application • Involve multiple computers • Are complex in design • Have many tables • Have many databases