Want to make creations as awesome as this one?

No description

Transcript

Introduction to Database

“Leadership and learning are indispensable to each other."

John F. Kennedy

DataBase

Database is any collection of electronic records that can be processed to produce useful information. The data can be accessed, modified, managed, controlled and organized to perform various data-processing operations. The data is typically indexed across rows, columns and tables that make workload processing and data querying efficient.

Types of Database

Object-orientedRelational Distributed Hierarchical Network

What is DBMS?

Components of DBMS

Database languages.These are components of the DBMS used to access, modify, store, and retrieve data items from databases; specify database schema; control user access; and perform other associated database management operations.

Procedures. While not a part of the DBMS software, procedures can be considered as instructions on using DBMS. The documented guidelines assist users in designing, modifying, managing, and processing databases.

Lorem ipsum dolor sit amet

Software.DBMS is primarily a software system that can be considered as a management console or an interface to interact with and manage databases.

Database manager.Unlike the runtime database manager that handles queries and data at runtime, the database manager performs DBMS functionality associated with the data within databases.

Data. DBMS contains operational data, access to database records and metadata as a resource to perform the necessary functionality.

Runtime database manager.A centralized management component of DBMS that handles functionality associated with runtime data, which is commonly used for context-based database access.

Query processor.As a fundamental component of the DBMS, the query processor acts as an intermediary between users and the DBMS data engine in order to communicate query requests.

Benefits of DBMS

Data securityData sharing.Data sharing.Data access and auditingData integration.Uniform management and administration

+ info

Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat. Ut wisi enim ad minim veniam, quis nostrud exerci tation ullamcorper suscipit lobortis.

Department of Computer Science

Dr. Nauman Riaz

Assistant Professor

Thanks