Difference between file processing and dbms?

Answer 1

File based approach can be attributed to two factors:

1. the definition of the data is embedded in the application programs, rather than being stored separately and independently.

2. there is no control over the access and manipulation of data beyond that imposed by the application programs.

To become more effective, a new approach was required. What emerged were the database and the DBMS (Database management system).

Answer 2

A file processing system and a database management system (DBMS) are two different ways of managing data in a computer system. A file processing system is a traditional method of storing data in which data is stored in separate files, and programs are written to read, write and manipulate these files. A DBMS, on the other hand, is a software system designed to manage databases that can store and retrieve data in an organized and efficient manner.

The main difference between a file processing system and a DBMS is how data is stored and accessed. In a file processing system, data is stored in individual files created and maintained by different programs. These programs are often developed separately and may need help accessing data stored in other files. This can result in data duplication, inconsistency, and inefficiency. Furthermore, file processing systems typically lack mechanisms to enforce data integrity and security, which can result in data loss, corruption, or unauthorized access.

In contrast, a DBMS stores data in a centralized database that can be accessed by multiple programs simultaneously. The DBMS provides all programs with a consistent and unified view of the data, eliminating data redundancy and inconsistency. Additionally, a DBMS provides built-in mechanisms for ensuring data integrity, security, and concurrency control, which prevent data corruption and unauthorized access.

Another key difference between a file processing system and a DBMS is flexibility and scalability. A file processing system is typically designed for a specific application or task and may not easily accommodate new requirements or changes. In contrast, a DBMS is designed to be flexible and scalable, allowing users to add, modify, or delete data and to customize the system to meet changing business needs.

Finally, a DBMS provides a range of advanced features and functionality not available in file processing systems. These include support for complex data types, such as multimedia and spatial data, and advanced query and reporting capabilities. A DBMS also provides features such as data mining, data warehousing, and online transaction processing, which are critical for managing large and complex databases.

In summary, a file processing system and a DBMS are two different ways of managing data in a computer system. While file processing systems are simple and easy to implement, they need more flexibility, scalability, and advanced functionality than DBMSs. DBMSs provide a centralized, secure, and efficient way of storing and retrieving data, offering a range of advanced features critical for managing large and complex databases.

Answer 3

DBMS overcomes all the disadvantage of traditional FPS. The main difference between FPS and DBMS is that FPS do not support data sharing, data security and non redundancy.

Answer 4

A traditional file processing system do not support to ask query . A database management system allows you to ask query . Also DBMS maintain data security and consistency.

Answer 5

There are many differences between a traditional FPS and a DBMS. The main difference is the security and integrity that is maintained in DBMS but not in FPS.

Answer 6

Solve in the lecture.