Drawbacks of database systems, Database Management System

Assignment Help:

Drawbacks of Database systems?


Related Discussions:- Drawbacks of database systems

Which is a legal expression in sql, Which is a legal expression in SQL? ...

Which is a legal expression in SQL? SELECT NAME FROM EMPLOYEE is a legal expression in SQL.

Creating a view-data control, Creating a view: A query can be embed...

Creating a view: A query can be embedded within the CREATE VIEW STATEMENT A query can have complex select statements containing join, groups and sub- queries A quer

Windows 8 Administrative Tools, Which two tools are used to administer user...

Which two tools are used to administer users for Active Directory?

Database system design and Implementation, Consider a typical sales invoice...

Consider a typical sales invoice that would include the following information. Design a single table to hold all of the information required to store an invoice including this info

The natural join is equal to which product, The natural join is equal to wh...

The natural join is equal to which product? The natural join is equal to Combination of projection and Cartesian product

What is primary key, What is Primary key? Primary Key - Primary key i...

What is Primary key? Primary Key - Primary key is one of the candidate keys which uniquely identifies each row in the relation.

Clinic, Need a sample of a clinic database relationships

Need a sample of a clinic database relationships

Frequecy count, how to calculate frequency count of algorithm

how to calculate frequency count of algorithm

Referential integrity, It can be easily defined as: The database must no...

It can be easily defined as: The database must not have any unmatched foreign key values. The term "unmatched foreign key value" means a foreign key value for which there doe

Define the term- state, State The position of object at any moment is ...

State The position of object at any moment is called state. An object can have many states depend upon time. After receiving some input instructions, the object can change its

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