What are the Advantages of database system over File processing systems?

5 pts.
Tags:
Database
File management
What are the Advantages of database system over File processing systems?

Answer Wiki

Thanks. We'll let you know when a new response is added.

In an office environment, some of the advantages would be improvement of searching and the implementation of right management.

mainly, you should be aware that a database system, I suppose you’re talking about a relational one, is more performant, therefore it’s quicker to find a record which makes it more cheap than a file System, like VSAM and others.

Another advantage would be seamless of data integration. While the diverse file formats of file system could cause interface headaches & inefficiencies.

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Dufault
    As with anything else there are pro's and con of a Database system over a file system. A file system is easier for the average user to setup and use. Often a spreadsheet program like Excel or Lotus is used to create and maintain the files. A data base system uses a DBMS with specialized programs to enter, maintain and extract information. The advantages include multiple simultaneous users and complex reporting ability. Also with a DBMS data can be related to each other, where in a File system it can not.
    60 pointsBadges:
    report
  • Jmendoza143
    Compared to a manual database, a computerized database is more flexible, compact, and faster. It reduces the probability of inconsistent data. When a database is teamed with a computer, many of the problems with a manual database are eliminated. A computerized database Provides: Speed It can find a specific record or information from among thousands or even a million entries within a second. Compact Since the database records stored in filing cabinets can be stored in a single floppy disk Flexible It has the ability to examine information from a number of ways, so you could search for people living in the same city or with persons with the same last names. For more info about this topic, you can check this site: http://www.techyv.com/questions/what-advantage-file-system-and-database-system
    30 pointsBadges:
    report
  • TomLiotta
    Very simplified -- Note that a database normally exists inside of a file system. One possibly should be considered to be a subset of the other. A database management system (DBMS) is a set of programs/routines that provides structures and rules that are applied to a portion of a file system. The structures tend to be similar among different DBMSes which leads to a degree of portability. The rules tend to follow a standard set of rules as well. A database tends to be good at record-keeping where records tend to be collected in sets with similar structures. This is a pretty common thing for businesses to do. A business might have inventories where each inventory item has a number, a description, an amount on hand and other attributes that are mostly the same for every record. If you use Windows Explorer to list the items in a directory, you see that each listed item has mostly the same attributes and they can be listed in tabular format. The tabular format, and things that can be done with it like sorting on different attributes, is somewhat representative of what a database might excel at. In a sense, the file system has its own little built-in "database" that it uses to track directory content. That's very different from what the underlying file system is doing or is capable of doing. Actual objects that are pointed to by the directory entries may have almost no structure at all. A simple text file is often just a string of bytes. It can be almost any any length. There is nothing about a simple text file that says the first ten bytes will always be a product code, the next 50 bytes will always be a product description, and then there will be ten bytes that hold a unit price. In order to have reliable structures, you either need to do a lot of programming to keep structures straight or you use the services provided by a DBMS. You provide the definition of a record structure to the DBMS and you access the storage by calling DBMS routines. Almost all of work of ensuring data integrity can be handled by the DBMS routines (according to the rules you originally provided) from that point on. In short, databases tend to handled structured records well. File systems handle whatever the file system was designed to handle, but they generally have practically no structural rules about content -- any content, structure or rules is up to the program that handles the file. Simplified (very), but maybe useful for thought. Tom
    125,585 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following