Electronic Data Processing
The Modern Era of Databases
The movement towards the use of the Database Management System
Alex P. Pasion, MIT Instructor
Topics
Why is there a need to study File Processing and DBM?
Historical Perspective.
History of Database Processing.
Preliminaries
Why is there a need to study File Processing and DBM?
Why do we use Databases?
Simply because of ourselves and there is always something that happens around us.
Collect Data Use and Reuse data
Historical Perspective
Historical Perspective
Historical Perspective
Historical Perspective
The Electronic Age:
Diskette
Punch Card
Why do we Humans desire Databases?
Man has always had the desire to record everything around him
The more things we record, the more we need for storage
And these records are desired to be shared and re-used.
The more we are involved in activities that needs information, the more we need the storage to be accessible and faster retrieved by several people.
The Paper-Filing Cabinet Database
Trivia
In 1790, the US decided to record census data (3.9 million people) In 1880, it took the US 7 years to tabulate the recorded data 1890, the population increased by 12 million 1890, the US decided to use tabulating machines using computer (punch cards), tabulation took only 2-3 months.
The Electronic File Database
The issues that faced File Processing
Separation and isolation of data Duplication of data Data dependence Incompatible file formats Fixed Queries/Proliferation of application programs
The Birth of the
Database Management System
So now, what is a Database?
A shared persistent, organized, structured storage of collected interrelated data that has purpose
It may be but not just STORAGE It may be but is not just for RETRIEVAL It is about PURPOSE and the need for generation of meaningful INFORMATION
History
The movement towards the use of the Database Management System
Alex P. Pasion, MIT Instructor
Topics
Why is there a need to study File Processing and DBM?
Historical Perspective.
History of Database Processing.
Preliminaries
Why is there a need to study File Processing and DBM?
Why do we use Databases?
Simply because of ourselves and there is always something that happens around us.
Collect Data Use and Reuse data
Historical Perspective
Historical Perspective
Historical Perspective
Historical Perspective
The Electronic Age:
Diskette
Punch Card
Why do we Humans desire Databases?
Man has always had the desire to record everything around him
The more things we record, the more we need for storage
And these records are desired to be shared and re-used.
The more we are involved in activities that needs information, the more we need the storage to be accessible and faster retrieved by several people.
The Paper-Filing Cabinet Database
Trivia
In 1790, the US decided to record census data (3.9 million people) In 1880, it took the US 7 years to tabulate the recorded data 1890, the population increased by 12 million 1890, the US decided to use tabulating machines using computer (punch cards), tabulation took only 2-3 months.
The Electronic File Database
The issues that faced File Processing
Separation and isolation of data Duplication of data Data dependence Incompatible file formats Fixed Queries/Proliferation of application programs
The Birth of the
Database Management System
So now, what is a Database?
A shared persistent, organized, structured storage of collected interrelated data that has purpose
It may be but not just STORAGE It may be but is not just for RETRIEVAL It is about PURPOSE and the need for generation of meaningful INFORMATION
History