Skip to main content

Advantage of DBMS and Disadvantage of DBMS

  Advantage of DBMS

  1. Recovery and backup : Data is secure in DBMS , DBMS provides backup for the system which can be stored later. 
  2. Access privilege : DBMS can store data in single or multiple table and provide access controlling ti the users. 
  3. Integrity : In practical Life, there are ma y situations where multiple user update the same data at the same time. DBMS can supports concurrent transactions so that integrity of data is improved. 
  4. Common standards : DBMS follow common standards for all types of data.
  5. Easy to reserve : We can easily retrieve any data from the database.
  6. Easy to insert : We can insert new record or data.
  7. Easy to delete : If we want to delete unwanted data then DBMS provide facility of deletion. 
  8. Security : DBMS provides high level security mechanisms like decryption, password, face and finger detection, voice recognizance.
  9. Cost of development : The initial cost of setting up a database can be large.

 Disadvantage of DBMS

  1. Professionals : For development of maintenance of database we require highly qualified professionals. 
  2. Cost : Cost of hardware and software is very high at initial level. 
  3. Confidentiality, privacy and security : DBMS can be centralized so there is probability of technical, administrate lack of security.
  4. Depend on power : DBMS completely depend in power. When the power is down complete work effected.
  5. Integrity : Multiple users use Database concurrently, technically integrity of data is reduced.





Comments

Post a Comment

Popular posts from this blog

Single partition allocation, Multiple-partition allocation and Fixed Equal-size partitions in operating system-computer world

  Single partition allocation, Multiple-partition allocation and Fixed Equal-size partitions in operating system Single partition allocation In this scheme operating system is residing in law memory and user process are executing in higher memory. Advantages It is simple  It is easy to understand and use Disadvantages User job is limited to the size of available memory. It leads to poor Utilization of processor and memory. Multiple-partition allocation  It is the simplest method for allocating  memory is divided memory into several fixed size partitions. Fixed Equal-size partitions It divides the main memory Into equal number of fixed sized partitions, operating system occupies some fixed portion and remaining portion of main memory is available for user processes. Advantages It supports multi programming. A process whose size is less then or equal to the partitions size can be loaded into any available partition. Disadvantages If a program is big to fit in...
Post a Comment
Read more

Difference between HTML and DHTML-computer world

     Difference between HTML and DHTML  HTML is a markup language, while DHTML is a collection of Technology.  DHTML creates dynamic web page, whereas HTML create static web page.  DHTML allow including small animations and dynamic menus in web pages but HTML is not able to do so.   HTML used events, methods, properties to insulate dynamism in HTML pages.   HTML is used to describe the web page but DHTML is a collection of JavaScript and style sheet in an HTML page. HTML sites will be show upon client side Technologies, while  DHTML site will be fast enough upon client side Technologies as most of entries are checked on browser itself and not waste time rendering to server for mistake.  HTML creates a plain web page without any style and scripts called as HTML. Whereas,  DHTML creates a page with HTML, CSS,DOM And scripts called as DHTML.  HTML cannot any server side code but XHTML may contain server side code.  ...
Post a Comment
Read more

Distributed transaction model-oocomputerworld

  Distributed transaction model Distributed transaction model:- To access the various data items in a distributed system is usually e accomplished through transaction there are two type of transaction that we need to consider The local transaction The Global transaction    The local transaction:- The local transaction are those that access and update data is only one local database.  The global transaction:- global transaction are those that access and update data in several local database in the case of global transaction the task is more complicated since several nodes may be participating in execution the failure of a communication link connecting these nodes may result in erroneous computation.  System structure :- Each node has its oven local transaction manager whose function is to ensure those transaction that execute at that site. The various transaction manager corporate to execute global transaction. To understand how such a manager can be impl...
Post a Comment
Read more