Drawbacks of database systems, Database Management System

Assignment Help:

Drawbacks of Database systems?


Related Discussions:- Drawbacks of database systems

What was the method in which records are physically stored, What was the me...

What was the method in which records are physically stored in a specified order according to a key field in each record ? A method in which records are physically stored within

What is inheritance, What is inheritance? Define it in detail?  Inheri...

What is inheritance? Define it in detail?  Inheritance Inheritance can be at the levels of types, or at the level of tables we first consider inheritance of types, then i

State in brief about object design, Give the Introduction of OBJECT DESIGN ...

Give the Introduction of OBJECT DESIGN Strategies which are selected during system design are carried out in object-oriented design. In this procedure, objects which are identi

N-ary relationship, For every n-ary relationship type R where n>2, we make ...

For every n-ary relationship type R where n>2, we make a new table S to represent R. We contain as foreign key attributes in s the primary keys of the relations that show the parti

What is online transaction processing, What is OLTP (Online Transaction Pro...

What is OLTP (Online Transaction Processing)? In OLTP - online transaction processing systems relational database design use the discipline of data modeling and generally follo

What is odbc and what is its function, Question: (a) What is ODBC and w...

Question: (a) What is ODBC and what is its function? (b) What is Web application server, and how does it work from a database perspective? (c) What does e-commerce mean

How can you map null values to other values while display, How can you map ...

How can you map NULL values to other values while display? IF( ) , IFNULL( ) keywords are used to do so. They are 'LIMIT' is used for the following kinds of problems: 1) Ans

List any two disadvantages of a database system, List any two disadvantages...

List any two disadvantages of a database system ? The disadvantages of database system are: • Database systems are difficult, complex, and time-consuming to design. • Substanti

What is specialization, What is Specialization? Specialization: Special...

What is Specialization? Specialization: Specialization permits you to describe new types of information (new structural types or latest domains of information), although reusin

Text mining, Text Processing: Use readLines to read SOU.txt into R. Cr...

Text Processing: Use readLines to read SOU.txt into R. Create a vector called Pres containing the names of the presidents giving each speech. To do this, rst identify the lin

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