Key differences between File Oriented System and Database System

File-Oriented System is an early method of data storage and management where data is kept in separate files created and maintained by individual applications. Each file is designed for a specific purpose, such as payroll, inventory, or student records, and is usually stored in formats like text or binary. This system does not have centralized control, leading to data redundancy, inconsistency, and difficulty in updating or sharing information between applications. Accessing data requires custom programs, making maintenance time-consuming and inefficient. Although simple and inexpensive to implement, file-oriented systems lack flexibility and scalability. They served as the foundation for later database management systems (DBMS) that addressed these limitations through integration and data independence

Functions of File Oriented System:

• Data Storage and File Creation

The fundamental function of a file-oriented system is to provide a structured method for storing data in permanent storage, such as a hard disk. It allows for the creation of individual files, which act as containers for related data. Each file is assigned a unique name within its directory and is formatted according to the needs of a specific application, like a text file, a sequential data file, or a binary file. This system organizes the physical storage of data, managing space on the storage medium and providing the basic framework upon which applications can save and retrieve information.

• Data Retrieval and Report Generation

A core function is to retrieve stored data for use by application programs. Programs are written to open specific files, read the data records in a predefined sequence (often one record after another), and process it. This processed data is then used to generate reports, such as payroll slips, sales summaries, or customer lists. The retrieval logic is hard-coded into each application, meaning the program must contain detailed instructions on the file’s location, structure, and the order in which to read the records to produce the desired output.

• Data Updating and Record Modification

File-oriented systems allow for the modification of existing data. Application programs can be designed to open a file, locate a specific record (e.g., searching for a customer ID), and update its fields, such as changing a customer’s address or marking an invoice as paid. This is typically done by overwriting the old record with the new, updated one. Some systems may use a transaction file that batches all changes, which are later used to update a master file in a separate process, helping to maintain data integrity during the update cycle.

• File Maintenance and Management

This function involves the overall administration of the file system itself, not just the data within. It includes tasks like creating and deleting entire files, reorganizing files to improve performance, creating backup copies of critical data to prevent loss, and restoring files from these backups in case of failure. These are often operating system-level functions that provide the necessary environment for application-specific files to exist and be managed, ensuring the longevity and security of the data storage infrastructure.

Database System

Database System is an organized collection of related data managed by a Database Management System (DBMS) to ensure efficient storage, retrieval, and manipulation of information. It allows multiple users and applications to access shared data securely and consistently. Unlike traditional file systems, a database system minimizes redundancy, maintains data integrity, and supports data independence. It consists of hardware, software, data, users, and procedures working together to manage information effectively. Businesses use database systems to handle large volumes of data for operations like sales, finance, and inventory management. Examples include MySQL, Oracle, and SQL Server. Overall, a database system provides a centralized and structured approach to data management, supporting better decision-making and smooth organizational functioning in the digital age.

Functions of Database System:

• Data Management and Storage

The DBMS provides centralized, integrated storage for all related data. It efficiently manages where and how data is physically stored on disk, shielding users and applications from these complex details. This includes managing data files, indices, and data dictionaries. The system handles low-level tasks like storage allocation, file structuring, and data compression, ensuring data is stored efficiently and reliably. This centralization is the foundation for all other functions, eliminating the redundancy and inconsistency of disparate file-based systems.

• Data Definition and Manipulation

The DBMS provides specialized languages to define and manipulate data. The Data Definition Language (DDL) is used to specify the database schema, defining the structure, data types, and constraints (e.g., CREATE TABLE). The Data Manipulation Language (DML), most commonly SQL, allows users to interact with the data itself. This includes querying data (SELECT), inserting new records (INSERT), updating existing data (UPDATE), and deleting records (DELETE). This function provides a standardized and powerful interface for all data-related operations.

• Data Security and Authorization

A critical DBMS function is to protect the database from unauthorized access and misuse. It includes robust security mechanisms to ensure that only authorized users can perform allowed actions. This is managed through user accounts, passwords, and privileges. The system can grant or revoke specific permissions (e.g., SELECT, INSERT) on specific database objects (e.g., tables, views) to specific users or roles. This prevents data theft, fraud, and malicious modification, ensuring that sensitive information is accessible only to those with a legitimate need.

• Data Integrity Enforcement

The DBMS enforces data integrity, which means ensuring the accuracy and consistency of data throughout its lifecycle. It uses a set of predefined rules and constraints. These include entity integrity (uniqueness of primary keys), referential integrity (validity of foreign keys), and domain integrity (data falling within allowed ranges and formats, like a valid date). By centrally enforcing these rules, the DBMS prevents the entry of invalid data, maintaining the logical correctness and reliability of the entire database, which is crucial for making sound business decisions.

• Transaction Management and Concurrency Control

The DBMS ensures database reliability, especially in multi-user environments, through transaction management. A transaction is a logical unit of work (e.g., a bank transfer). The DBMS guarantees its ACID properties: Atomicity (all-or-nothing execution), Consistency (preserving database rules), Isolation (concurrent transactions don’t interfere), and Durability (committed changes are permanent). Concurrency control mechanisms, like locking, allow multiple users to access data simultaneously without causing inconsistencies, such as lost updates or dirty reads.

• Backup and Recovery

The DBMS provides essential mechanisms to safeguard data against failures. This includes automatic and manual backup procedures to create copies of the database. More importantly, it features sophisticated recovery services. In the event of a hardware failure, software crash, or other disaster, the DBMS uses its transaction logs and backup files to restore the database to a consistent state. This ensures that committed transactions are not lost and that the system can be quickly brought back online, which is vital for business continuity and data preservation.

Key differences between File Oriented System and Database System