- Published on
Database Design Fundamentals For Software Engineers | Introduction & File-based system
- Authors
- Name
- Milad E. Fahmy
- @miladezzat12
1 - Database Design Fundamentals For Software Engineers
You use database at everything you use, for example facebook, youtube, etc.
| Index | Content |
|---|---|
| 1 | Introduction & File-based system |
| 2 | What is Database? |
| 3 | Database Management System (DBMS) |
| 4 | Characteristics of the Database Approach |
| 5 | Benefits of the Database Approach |
1 - Introduction & File-based system
Before Database systems
First, from some decades we hadn't know the database, but we used something called File-base system
File-Base System is a type of software that allows users to access and organize small groups of data. that's mean if you want to save data you can use the files, and the organization and know the location filed depends on you
Advantage of File-Based System
-
Backup It is possible to take faster and automatic back-up of database stored in files of computer-based systems. computer systems provide functionalities to serve this purpose.it is also possible to develop specific application program for this purpose.
-
Data Retrieval Computer-based systems provide enhanced data retrieval techniques to retrieve data stored in files in easy and efficient way.
-
Editing It is easy to edit any information stored in computers in form of files. Specific application programs or editing software can be used for this purpose.
-
Remote Access In computer-based systems,it is possible to access data remotely. so,to access data it is not necessary for a user to remain present at location where these data are kept.
-
Sharing Data stored in files of computer-based systems ca be shared among multiple users at a same time.
Disadvantage of File-Based System
-
Data redundancy A situation that occurs in a database when a field needs to be updated in more than one copy
-
Data inconsistency A situation where various copies of the same data are conflicting, wastes storage space and duplicates effort.
-
Difficult data access A situation where the user must be know the location of every files
-
Security Problems A situation, if one user have access to view his data, he can update it without Authorization
-
Difficult concurrent access To access some data on some file, you must know the file location