Differentiate between Traditional File System and Modern Database System? Describe the properties of Database and the Advantage of Database?
Answer:
Answer:
Traditional File System
- Traditional File system is the system that was followed before the advent of DBMS i.e., it is the older way.
- In Traditional file processing, data definition is part of the application program and works with only specific application.
- File systems are Design Driven; they require design/coding change when new kind of data occurs.
- Traditional File system keeps redundant [duplicate] information in many locations. This might result in the loss of Data Consistency.
- In a File system data is scattered in various files, and each of these files may be in different formats, making it difficult to write new application programs to retrieve the appropriate data.
- Security features are to be coded in the Application Program itself.
Modern Database Systems
- This is the Modern way which has replaced the older concept of File system.
- Data definition is part of the DBMS
- Application is independent and can be used with any application.
- One extra column (Attribute) can be added without any difficulty
- Minor coding changes in the Application Program may be required.
- Redundancy is eliminated to the maximum extent in DBMS if properly defined.
- This problem is completely solved here.
- Coding for security requirements is not required as most of them have been taken care by the DBMS.
Properties of database:
1. A database is a logical collection of data having some implicit meaning. If the data are not related then it is not called as proper database.
E.g. Student studying in class II got 5th rank.
Stud_Name
|
Class
|
Rank
|
Nick
|
II
|
5
|
2. A database consists of both data as well as the description of the database structure and constraints.
E.g
Field Name
|
Type
|
Description
|
Stud_name
|
Character
|
It is the student’s name
|
Class
|
Alpha numeric
|
It is the class of the Student
|
3. A database can have any size and of various complexity. If we consider the above example of employee database the name and address of the employee may consists of very few records each with simple structure.
4. The DBMS is considered as general-purpose software system that facilitates the process of defining, constructing and manipulating databases for various applications.
5. A database provides insulation between programs, data and data abstraction. Data abstraction is a feature that provides the integration of the data source of interest and helps to leverage the physical data however the structure is.
6. The data in the database is used by variety of users for variety of purposes. For E.g. When you consider a hospital database management system the view of usage of patient database is different
From the same used by the doctor. In this case the data are stored separately for the different users. In fact it is stored in a single database. This property is nothing but multiple views of the database.
7. Multiple user DBMS must allow the data to be shared by multiple users simultaneously. For this purpose the DBMS includes concurrency control software to ensure that the updation done to the database by variety of users at single time must get updated correctly. This property explains the multiuser transaction processing.
Advantages of using DBMS
1. Redundancy is reduced
2. Data located on a server can be shared by clients
3. Integrity (accuracy) can be maintained
4. Security features protect the Data from unauthorized access
5. Modern DBMS support internet based application.
6. In DBMS the application program and structure of data are independent.
7. Consistency of Data is maintained
8. DBMS supports multiple views. As DBMS has many users and each one of them might use it for different purposes, and may require viewing and manipulating only on a portion of the database, depending on requirement.
No comments:
Post a Comment