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

Deadlock in operating system-computer world

  Deadlock in operating system-computer world Deadlock :  In a multi-programming environment, many process may complete for a minute number of resources. A process make a request for a resource and if the resource is not available at that time, the process enter In a waiting state. A waiting state process is never again-able to change state because the resource it has requested is held by other waiting process. This situation is called deadlock. So we can say that a process is said to be deadlock when it is waiting for an event or resources which will never occurs.   so we can say that in this situation none of the process gets executed  since the resource it needs, is held by some other process which is also waits for some other resource to be released.  Let's assume that there are three process P1, P2, p3 and three different resources R1, R2 and R3. R1 is assigned to p1, R2 is assigned to P2 and R3 is assigned to P3.   After somet...
9 comments
Read more

What is sound card, video card, TV tuner card and network adapter card-computer world

 What is sound card, video card, TV tuner card and network adapter card Sound card :  Sound card is also known as audio card, sound sound board or audio output device. Sound card is a expansion card that provide the input and output of audio signals to and from a computer under control of computer programs. It is an expansion card for producing sound on computer that can be heard by speakers and headphones.  Uses of sound card :  Sound card is used for for providing the audio component  for multimedia application such as video auditing , audio auditing .It is also used in the field of education.  Video card :  It is an expansion card that connect to a computer motherboard. Video card is also known as video adapter or video controller. It is used to create a picture on display. TV tuner card : A  TV tuner card is like a television tuner that allow single to be received by a computer. TV tuner c...
2 comments
Read more

What is computer and its characteristics-computer world

  What is computer and its characteristics  Computer  :  Computer is an electronic data processing device, which accept and store data input, process the data and generates the output in a required format. computer is made up of integrated  parts (input, control, ALU, storage and output unit) All the part work together to process data so, we can say that a computer is a programmable electronic device accept row data as input and process it with  set of instruction to produce the result as output. Meaning of computer The word "computer" comes from the word "compute" which means to "calculate". The word computer is derived from the Latin word compute which means to calculate. Characteristics of computer Automatic : It is a automatic machine work by itself without human instruction. Speed :  A computer is a very fast devices. It can perform in a few second, the amount of work that a human being can do in an entire year.  Accuracy : In addition t...
1 comment
Read more