Discuss the advantages and drawbacks of database.
Discuss the advantages and drawbacks of database.
Ans.
Advantages of Database
Advantages of a database include the following:
(i) Use of a database avoids the duplication of files, the reprocessing of the same data items, and the repeated handling of data. It is thus designed to improve the overall efficiency of a computer system charged with the responsibility of handling sizable amounts of data.
(ii) Use of integrated systems is greatly facilitated.
(iii) Collection of files grouped together as one entity. This collection is tied together by a series of tables and arrays to form one giant integrated file. The tables and arrays serve as an index to define relationships between records and files maintained in the database. In this manner, a transaction in one file of the database can also trigger a series of updates in parts of other files. Thus, data is input only once to the database and is made available to the many files composing it.
(iv) The savings attributed to the use of a database result from the computer sharing of records, reduced processing times, reduction in the use of software and hardware, more efficient use of data processing personnel, and overall an improvement in the flow of data.
(v) The database also maintains an extensive inventory control file. This file accounts for all parts and equipment throughout the maintenance system. It defines the status of each part and its location.
(vi) Information supplied to managers is more valuable because it is based on a comprehensive collection of data instead of files which contain only the data needed for one application.
(vii) The database maintains files related to any of the work assigned to outside service centres. Many parts are repaired by the vendors from whom they were purchased. Data is maintained on the parts that have been shipped to vendors and parts that are outstanding from the inventory. Data relating to the guarantees and warranties of individual vendors are also stored in the database.
(viii) Great deal of programming time is saved because the DBMS handles the construction and processing of files as well as retrieval of data.
(ix) One of the benefits of the database is the timely and accurate reporting of data to all maintenance centres. The same data is available and distributed to everyone.
Drawback of Database
Disadvantages of a database are the following:
(i) Its size, its cost, and the time required to implement such a system. A database requires the use of a large-scale computer system.
(ii) A large full-time staff is also required to design, program, and support the implementation of a database.
(iii) The cost of a database project is a prohibitive factor for many organisations. Database-oriented computer systems are not luxuries, however, and are undertaken when proven economically justifiable.
