GeekInterview.com
Series: Subject: Topic:
Question: 4 of 89

What is the difference between these two?

I am new here and i am not sure if I am posting this in the correct place. But I have recently started studying to be a programmer but because there is so much out there between these two I am getting more and more confused about how to answer this. Could someone please answer these so I can at least get my head around it all? Thank you!!

This is what the questions are:
After initial review of the existing systems, you have determined that the shipping system used by your company is a Cobol program and files stand alone and are not tied to any other department. In a similar fashion, the receiving department is using a program designed and developed in DBase. The management team wants the two systems integrated.

Your supervisor has asked you how the use of a database management system will improve the overall processing of the information system within the company.

Describe the pros and cons of a file-based verses a server-based solution and what benefits are be gained from using a server-based solution.

Your post should include the following details:
Pros and cons of each solution. The missed opportunity for data sharing using the 2 independent systems. The advantage of using a single database for both shipping and receiving
Asked by: Snowbird | Member Since Apr-2012 | Asked on: Apr 8th, 2012

View all questions by Snowbird

Showing Answers 1 - 1 of 1 Answers

I will refer predominantly to Relational DBMS. In a file system, data is contained in a flattened structure that is often a variable length structure. For example, a shipment received could contain the shipping header (with [Ill abbreviate but you should use proper names] SNO, SNAME, SADDRESS, SHIPPER NO, SHIPPER NAME, etc.) and shipping details (Items shipped, item name, item standard price, shipped quantity, date shipped, date received, who received, etc., and total cost of the shipment. All this might be contained within a single hybrid (variable length) structure. This structure must have integrity with other data within the organization. For example, the Shipper No and Name must be a real shipper, that exists. File systems do not ensure this. IN a file system, the application must ensure that there is integrity between Shipment, Supplier and your company. DBMS ensure integrity. Most DBMSs would split this example into several structures: Shipment, Shipper, Shipment Item, Supplier No, etc., but these structures would be interrelated. -- by the designer who set up the database but once set up would be enforced by the DBMS itself. Besides, DBMSs keep logs to allow you to recover to a particular point, have utilities for fast loading, have a catalog that keeps statistics, has a specific language for access. In general, however, file systems can be faster because they have less overhead. I would also say a database is easier to maintain. There are DBMS statements that allow you to define the database, access it, etc. You can also index a database. For example, we could create a composite index that contained Shipment No, Shipper Name, Item No to allow us to retrieve from all three faster. In file systems, each file is separate. Those are some of the pros and cons of DBMS vs. file systems.

  
Login to rate this answer.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Related Open Questions

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.