Scribd
Upload
168 views18 pages

File System Vs Database Approach

This document discusses a database systems lecture that covers the differences between file-based systems and database approaches. It is a 4-credit course taught by Mr. Amjad Usman. File-based systems can result in data redundancy, inconsistency, and lack of sharing and security. Database systems provide a centralized repository without these issues. A database management system (DBMS) is software that creates and manages user databases, providing controlled access similar to how an operating system manages hardware resources. The lecture also discusses career opportunities in databases.

Uploaded by

hijabi girl
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
168 views18 pages

File System Vs Database Approach

This document discusses a database systems lecture that covers the differences between file-based systems and database approaches. It is a 4-credit course taught by Mr. Amjad Usman. File-based systems can result in data redundancy, inconsistency, and lack of sharing and security. Database systems provide a centralized repository without these issues. A database management system (DBMS) is software that creates and manages user databases, providing controlled access similar to how an operating system manages hardware resources. The lecture also discusses career opportunities in databases.

Uploaded by

hijabi girl
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 18

CSC371 Database Systems 1 Lecture#

Credit Hours: 4 (3+1)


Teacher: Mr. Amjad Usman
CUI WAH Email: [email protected]

File System vs Database Systems


Outline
CUI WAH

 File-based system
 Data redundancy
 Data Inconsistency
 Program data dependency
 Data Sharing
 Data Security
 Database Approach
 Comparison of File System and Database System
 Career opportunities

Prepared By: Mr. Amjad Usman 2


Sayings of Quran
CUI WAH

Prepared By: Mr. Amjad Usman 3


Traditional File Processing Systems
CUI WAH

Traditional File Processing systems


Data is stored in flat files
Each file has a specific format (csv, txt, json, tsv, doc, xls, etc.)
Programs that use these files depend on knowledge about
those file format

Prepared By: Mr. Amjad Usman 4


Basic Terminologies of File Processing System
CUI WAH

Prepared By: Mr. Amjad Usman 5


Traditional File Processing Systems
CUI WAH

File

Field Data

record

Metadata

Prepared By: Mr. Amjad Usman 6


Traditional File Processing Systems
CUI WAH

Order Department Accounting Department HR Department

Program Program Program Program Program Program


A B A B A B

Order Filling System Invoicing System Payroll System

Customer Orders Customer Invoice Employee Salaries

Prepared By: Mr. Amjad Usman 7


Limitations of File Processing
CUI WAH

Major limitations are

Program-Data Dependency
 All programs maintain metadata for each file they use
 The program needs to be changed if there is change in data format

Data redundancy
 Different systems/programs have separate copies of the same data

Prepared By: Mr. Amjad Usman 8


Data Redundancy
CUI WAH

Prepared By: Mr. Amjad Usman 9


Problems with Data Redundancy
CUI WAH

 Waste of space by storing Order Department Accounting Department HR Department

duplicate data Progra Progra Progra Progra Progra Progra


mA mB mA mB mA mB
 Causes more
maintenance issues
Order Filling System Invoicing System Payroll System

Customer Invoice Employ GP


Customer Orders
ee Fund
The biggest problem:
Data changes in one file rather all files cause data inconsistency
Compromises in data integrity

Prepared By: Mr. Amjad Usman 10


Data Inconsistency
CUI WAH

Prepared By: Mr. Amjad Usman 11


Limitations of File Processing
CUI WAH

Limited Data Sharing & lack of security


 No centralized control of data
No standards used
Lengthy Development Times
 Programmers must design their own file formats
Excessive Program Maintenance
 80% of information systems budget

Prepared By: Mr. Amjad Usman 12


The Database Approach
CUI WAH

Central repository of shared data


Data is managed by a controlling agent
Data is stored in a standard format

Prepared By: Mr. Amjad Usman 13


Database System vs File System
CUI WAH

Prepared By: Mr. Amjad Usman 14


Database Management System (DBMS)
CUI WAH

 A software system that is used to create, maintain, and provide controlled


access to user databases

Order Filing
System Database

Invoicing contains
System DBMS Employee data
Order data
Inventory data
Payroll Product data
System Customer data

DBMS manages data resources like an operating system manages hardware resources

Prepared By: Mr. Amjad Usman 15


Database Management System (DBMS)
manages interaction b/w end user and the database CUI WAH

Prepared By: Mr. Amjad Usman 16


Career Opportunities
CUI WAH

Prepared By: Mr. Amjad Usman 17


Thank You So Much

You might also like