Drawbacks of database systems, Database Management System

Assignment Help:

Drawbacks of Database systems?


Related Discussions:- Drawbacks of database systems

Inheritance, what is relationship inheritance and attribute inheritance

what is relationship inheritance and attribute inheritance

What is a hashing function, What is a hashing function?  What are the prope...

What is a hashing function?  What are the properties of a good hashing function?  Describe the folding technique for hashing functions.      Ans:  Hashing function is a method

Division operation, To do the division operation R1 ÷ R2, R2 should be a co...

To do the division operation R1 ÷ R2, R2 should be a correct subset of R1. In the following example R1 have attributes A and B and R2 have only attribute B so R2 is a correct subse

Define integrity, (a) Explain briefly the three parts of a relational Model...

(a) Explain briefly the three parts of a relational Model. (b) Contrast the following terms with an appropriate example: (i) stored attribute v/s derived attribute (ii) en

State in detail about data flow diagram, What is a Data Flow Diagram?  ...

What is a Data Flow Diagram?  Data Flow Diagram: A data flow diagram is the graph that shows flow of data values from their sources in objects in the course of processes whic

Timestamp type, Do NOT use the timestamp type.  Use separate date and time ...

Do NOT use the timestamp type.  Use separate date and time data types only.  Figure out how to define an SQL insert statement that uses built-in SQL (or MySQL) functions to define

Create a table for database transformation , Step 1 . Using Oracle, create ...

Step 1 . Using Oracle, create the tables identified in the preferred solution for Assignment 2. Technicians (ZipCode, TechnicianID, FirstName, LastName, Street, City, State, Home

Database manager, Database Manager It is the interface among low-leve...

Database Manager It is the interface among low-level data, queries and application programs. Databases typically need a large amount of storage space. It is kept on disks, as

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