Drawbacks of database systems, Database Management System

Assignment Help:

Drawbacks of Database systems?


Related Discussions:- Drawbacks of database systems

State the two-way associations, Two-way Associations Mostly, associati...

Two-way Associations Mostly, associations are travel in both directions, although not usually with same frequency. There are three approaches for the implementation. In

Dbms, Retrieve the S&S In-Chapter Database (in Microsoft Access format) fro...

Retrieve the S&S In-Chapter Database (in Microsoft Access format) from the text's Web site (or create the tables in Table 4-5 in a relational DBMS product). Write queries to answer

Reflects organisational structure, Reflects organisational structure: Many ...

Reflects organisational structure: Many organizations are distributed over various locations. If an organisation has many offices in dissimilar cities, databases used in such an ap

Explain stand alone query language in details, Explain Stand Alone Query La...

Explain Stand Alone Query Language in details? Stand alone Query Language - The query language that can be used interactively is known as stand alone query language. It does no

Views, what is view?explain

what is view?explain

Define hash files organization, Define Hash files organization a. Hashi...

Define Hash files organization a. Hashing includes computing the address of a data item by calculating a function on the search key value.   b. A hash function h is a functi

B+ tree, construct a B+ tree for the following set of key value (2,3,5,7,11...

construct a B+ tree for the following set of key value (2,3,5,7,11,19,23,29,31) in ascending order where the pointers that will fit in one node is as follows:A. four B. six C. eigh

Describe data manipulation language, Describe Data Manipulation language ? ...

Describe Data Manipulation language ? Data Manipulation Language (DML) - A data manipulation language is a language which enables users to access or manipulate data as organize

Single-valued dependencies, Single-Valued Dependencies A database is a ...

Single-Valued Dependencies A database is a collection of related information and it is therefore inevitable that some items of information in the database would depend on some

12/5/2013 4:51:07 AM

i)System Failure- When system goes down, users directly involved in accessing must wait until system is functional again. This might need long wait. Moreover, if system or application software fails, there might be permanent damage to database. It is very important, therefore to carefully evaluate all software that would have a direct effect on database to be certain that it is as free as mistakes as possible. If organization does not use database, it is not exposed to this risk, data and its software are distributed.

ii)Overhead Costs- database approach may require investment in both hardware and software. The hardware to run large DBMS has to be capable and will generally require more major memory and disk storage than simpler file-based system. Tape drivers for rapidly backing up database are also required. In adding, the DBMS itself might be quite costly.
DBMS may also require increase operating costs, because it requires new execution time. As in an application system using a DBMS will usually execute further slowly than system not using DBMS.

iii)Need for Sophisticated Personnel- database administration function requires skilled personnel who are capable of coordinating needs of different user groups, designing views, integrating those views into the single schema, establishing data revival procedures and fine tuning physical structure of database to meet acceptable performance criteria. There is threat involved in identification of personnel for the DBA, because if no person having requisite skills can be found, DBA function may not be properly performed. This can result in significant problems and even result in failure of database implementation.

 

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd