Wednesday 21 September 2011

Advantages of DBMS

The database management system has a number of advantages as compared to traditional computer file-based processing approach. The DBA must keep in mind these benefits or capabilities during databases and monitoring the DBMS.
The Main advantages of DBMS are described below.

  • Controlling Data Redundancy 
In non-database systems each application program has its own private files. In this case, the duplicated copies of the same data is created in many places. In DBMS, all data of an organization is integrated into a single database file. The data is recorded in only one place in the database and it is not duplicated.

  • Sharing of Data
In DBMS, data can be shared by authorized users of the organization. The database administrator manages the data and gives rights to users to access the data. Many users can be authorized to access the same piece of information simultaneously. The remote users can also share same data. Similarly, the data of same database can be shared between different application programs.

  • Data Consistency 
By controlling the data redundancy, the data consistency is obtained. If a data item appears only once, any update to its value has to be performed only once and the updated value is immediately available to all users. If the DBMS has controlled redundancy, the database system enforces consistency.

  • Integration of Data
In Database management system, data in database is stored in tables. A single database contains multiple tables and relationships can be created between tables (or associated data entities). This makes easy to retrieve and update data.
  • Integration Constraints
Integrity constraints or consistency rules can be applied to database so that the correct data can be entered into database. The constraints may be applied to data item within a single record or the may be applied to relationships between records.
  • Data Security
Form is very important object of DBMS. You can create forms very easily and quickly in DBMS. Once a form is created, it can be used many times and it can be modified very easily. The created forms are also saved along with database and behave like a software component. A form provides very easy way (user-friendly) to enter data into database, edit data and display data from database. The non-technical users can also perform various operations on database through forms without going into technical details of a fatabase.
  • Report Writers
Most of the DBMSs provide the report writer tools used to create reports. The users can create very easily and quickly. Once a report is created, it can be used may times and it can be modified very easily. The created reports are also saved along with database and behave like a software component.
  • Control Over Concurrency 
In a computer file-based system, if two users are allowed to access data simultaneously, it is possible that they will interfere with each other. For example, if both users attempt to perform update operation on the same record, then one may overwrite the values recorded by the other. Most database management systems have sub-systems to control the concurrency so that transactions are always recorded with accuracy.
  • Backup and Recovery Procedures 
In a computer file-based system, the user creates the backup of data regularly to protect the valuable data from damage due to failures to the computer system or application program. It is very time consuming method, if amount of data is large. Most of the DBMSs provide the 'backup and recovery' sub-systems that automatically create the backup of data and restore data if required.
  • Data Independence 
The separation of data structure of database from the application program that uses the data is called data independence. In DBMS, you can easily change the structure of database without modifying the application program.

62 comments:

  1. nice info..chec this for full engineering notes of computer science engineering..http://dbmsenotes.blogspot.in/

    ReplyDelete
  2. Thank you for providing information about DBMS. It Will help me in solving professional knowledge.

    ReplyDelete
  3. Thanks for sharing information about Advantages of Data base management system. Frontaide offers Online Hotel management software. It's a web-based software.

    ReplyDelete
  4. Thanks a lot bro...these are awesome for DBMS.
    What is DBMS

    ReplyDelete
  5. Database is playing very important role in any field, we can say that its a backbone. Actually we are working on canvas learning management system means our qualified and experienced technician team has changed and included additional features to the already existing Canvas layout. If you need such type of help from us email us at: info@cryptextechnologies.com

    ReplyDelete
  6. no it is good

    ReplyDelete
  7. thanku it will help me alot & nice information😊😊

    ReplyDelete
  8. thanku it will help me alot & nice information😊😊

    ReplyDelete
  9. thanku it will help me alot & nice information😊😊

    ReplyDelete
  10. thans for sharing dbms related information.....thankful it will helpful me lottttt...........

    ReplyDelete
  11. Thanks its very simple o understand

    ReplyDelete
  12. This comment has been removed by the author.

    ReplyDelete
  13. DBMS like oracle has an huge effect on Database industries.
    Thanks for sharing all this wonderful article.
    Learn More About DBMS

    ReplyDelete
  14. It's a awesome answer. I like this answer

    ReplyDelete
  15. Great stuff. check also zealwriters.com

    ReplyDelete
  16. This comment has been removed by the author.

    ReplyDelete
  17. world cup match schedule check kre
    www.tubeless12.blogspot.com

    ReplyDelete
  18. Hello how can i get more involved in this field dears

    ReplyDelete
  19. Easily understandable points...
    Thank you.

    ReplyDelete
  20. Good one simple and straight

    ReplyDelete
  21. Nice topic and useful explanation!
    Thanks

    ReplyDelete
  22. Yeah its very easy to understand am in chennai pachaiyappas clg student help full to others frds

    ReplyDelete
  23. I truly admire you for the way you impart such beneficial and important guidance here, keeping the content short, yet gainful. Much thanks for this worthwhile information. Keep blogging. Professional Web design services are provided by W3BMINDS- Website development company in Lucknow.
    Website Design Agency | Website design company in Lucknow

    ReplyDelete
  24. First time visit your blog got very helpful information thanks for post.
    click here

    ReplyDelete
  25. McAfee Customer Service is known worldwide for the services that it provides to solve the queries of its customers. 

    ReplyDelete
  26. Symantec Customer Service  is known worldwide for the services that it provides to solve the queries of its customers.

    ReplyDelete
  27. This comment has been removed by the author.

    ReplyDelete
  28. This comment has been removed by the author.

    ReplyDelete
  29. Coupon2deal, one of the most reliable interfaces that offer various deals and discount coupons.
    Vistaprint Coupons
    Ace Hardware Coupon
    Dollar General Coupons

    ReplyDelete
  30. Adtech careers I think this is an informative post and it is very useful and knowledgeable. therefore, I would like to thank you for the efforts you have made in writing this article.

    ReplyDelete
  31. You have written a nice post. I was searching for this and thanks a lot I came to your blog, this helped me a lot, you given a comprehensive detail of the topic
    Happy Birthday Images

    ReplyDelete
  32. After reading this intriguing post I find it necessary to commend you for your creativity. You did a great job. Keep it up. Check out this: Verjaarsdag Wense Vroulik

    ReplyDelete
  33. I’m impressed, I have to say. Hardly ever do I encounter a blog that’s both educative and entertaining. Your idea is outstanding; the problem is that not sufficient people speak intelligently about...wish a friend good evening message

    ReplyDelete
  34. This is one of the finest blog regarding Benefits Data Management Services, which will be very much effective for us in the future. Thanks for sharing such great information. Keep it up.

    ReplyDelete