cs8492 database management systems · 2020. 1. 26. · –inconsistent database state.(money...

CS8492 DATABASE MANAGEMENT SYSTEMS

PURPOSE OF DATABASE SYSTEMS

1/26/2020 CS8492 PURPOSE OF DATABASE SYSTEM

P.Poovizhi

AP/IT

1/16

Purpose of Database Systems

• Data redundancy and inconsistency

– Information Duplication(redundancy)

1/26/2020 CS8492 PURPOSE OF DATABASE SYSTEM 2/16

• Difficulty in accessing data.

– conventional file-processing environments do not allow needed data to be retrieved in a convenient and efficient manner.

1/26/2020 CS8492 PURPOSE OF DATABASE SYSTEM

Purpose of Database Systems

3/16

• Data isolation

– scattered in various files

1/26/2020 CS8492 PURPOSE OF DATABASE SYSTEM

Purpose of Database Systems

4/16

• Integrity problems

– difficult to change the programs (adding new constrains)

– Below zero balance ex(in bank)

1/26/2020 CS8492 PURPOSE OF DATABASE SYSTEM

Purpose of Database Systems

5/16

• Atomicity problems

– inconsistent database state.(Money transfer)

– Atomic means the transaction must happen in its entirety or not at all. It is difficult to ensure atomicity in a conventional file processing system.

1/26/2020 CS8492 PURPOSE OF DATABASE SYSTEM

Purpose of Database Systems

6/16

Find the Difference

1/26/2020 CS8492 PURPOSE OF DATABASE SYSTEM 7/16

Concurrent access anomalies • Many systems allow multiple users to update the data simultaneously -

interaction of concurrent updates is possible and may result in inconsistent

data.

1/26/2020 CS8492 PURPOSE OF DATABASE SYSTEM 8/16

Security problems

Enforcing security constraints to the file processing system is difficult

CS8492 PURPOSE OF DATABASE SYSTEM 1/26/2020 9/16

Use of DBMS

• Effective and efficient management of data

• Query processing and management

• Easy to understand and user friendly

• Security and integrity of data

• Better Decision making

• Data sharing and storage

• Better access to accurate data

• Ensures error free information

1/26/2020 CS8492 PURPOSE OF DATABASE SYSTEM 10/16

Assessment - Puzzle

• Is there any relationship between this picture with purpose of database system?

1/26/2020 CS8492 PURPOSE OF DATABASE SYSTEM 11/16

Solution

1/26/2020 CS8492 PURPOSE OF DATABASE SYSTEM

Redundancy

12/16

Assessment - Puzzle

1/26/2020 CS8492 PURPOSE OF DATABASE SYSTEM

• Is there any relationship between this picture with purpose of database system?

13/16

Solution

1/26/2020 CS8492 PURPOSE OF DATABASE SYSTEM 14/16

Reference Link

• https://www.geeksforgeeks.org/need-for-dbms/

1/26/2020 CS8492 PURPOSE OF DATABASE SYSTEM 15/16

Thank you

1/26/2020 CS8492 PURPOSE OF DATABASE SYSTEM 16/16