Introduction to DBMS

INTRODUCITON TO DBMS

DBMS stands for Database Management System. DBMS means database with management system.

That means a system used to manage database.

Database Management System is a set of programs to store, retrieve and manage data from database.

Examples of DBMS:

• MySQL
• PostgreSQL
• Microsoft Access
• SQL Server
• Oracle

What are the components of DBMS?

• Data
• Software
• Hardware
• SQL
• Query processor
• Database engine
• Data dictionary, etc.

History of DBMS?

Dr Edgar F Codd is father of DBMS. 

In the 1960’s the first DBMS was developed at IBM and was originally called IMS, written for the Apollo program.

In the 1970s, Edgar Codd thought of a way to make things a bit easier. He wrote a paper entitled, A Relational Model of Data for Large Shared Data Banks, in which he proposed replacing these current systems with that of tables and rows. This concept would become relational DBMS

What is the need of DBMS?

• For databse creation
• For database updation.
• For information retrieval from dataabase.
• For database management.

Examples of Database applications:

• Facebook storage system
• Relve reservation system, IRCTC
• College ERP

Advantages of DBMS:

1. Data Sharing.
2. Easily Maintenance.
3. Reduce Data Redundancy.
4. Backup and Recovery.
5. Data Security.
6. Privacy.
7. Data Consistency.
8. Multiple User Interface.

More topics from DBMS to read:

EasyExamNotes.com covered following topics in these notes.

1. Introduction to Database
2. Introduction to DBMS
3. Advantages and disadvantages of DBMS
4. DML, DDL and DCL
5. Domains
6. Introduction to data models
7. Entities and Attributes
8. Relationship among entities 
9. Tuples
10. Attributes
11. Relation
12. Keys
13. Relational Database
14. Twelve rules of CODD
15. Schemas
16. Integrity Constraints
17. Normalization
18. Functional dependency
19. Transaction processing concepts
20. Schedule
21. Serializability
22. OODBMS vs RDBMS
23. RDBMS
24. SQL join
25. SQL functions: SUM(), AVG(), MAX(), MIN(), COUNT().
26. Block, Extent, Segment
27. Oracle Background processes
28. Trigger
29. Oracle cursor
30. Introduction to Concurrency Control

A list of Video lectures

• Click here

References:

1. Korth, Silbertz,Sudarshan, “Fundamental of Database System”, McGraw Hill
2. Atul Kahate , “ Introduction to Database Management System”, Pearson Educations