Wednesday 21 September 2011

Components of DBMS

A database management system (DBMS) consists of several components. Each component plays very important role in the database management system environment. The major components of database management system are:
  • Software
  • Hardware
  • Data
  • Procedures
  • Database Access Language
Software
The main component of a DBMS is the software. It is the set of programs used to handle the database and to control and manage the overall computerized database
  1. DBMS software itself, is the most important software component in the overall system
  2. Operating system including network software being used in network, to share the data of database among multiple users.
  3. Application programs developed in programming languages such as C++, Visual Basic that are used to to access database in database management system. Each program contains statements that request the DBMS to perform operation on database. The operations may include retrieving, updating, deleting data etc . The application program may be conventional or online  workstations or terminals.
Hardware
Hardware consists of a set of physical electronic devices such as computers (together with associated I/O devices like disk drives), storage devices, I/O channels, electromechanical devices that make interface between computers and the real world systems etc, and so on. It is impossible to implement the DBMS without the hardware devices, In a network, a powerful computer with high data processing speed and a storage device with large storage capacity is required as database server.
Data
Data is the most important component of the DBMS. The main purpose of DBMS is to process the data. In DBMS, databases are defined, constructed and then data is stored, updated and retrieved to and from the databases. The database contains both the actual (or operational) data and the metadata (data about data or description about data).
Procedures
Procedures refer to the instructions and rules that help to design the database and to use the DBMS. The users that operate and manage the DBMS require documented procedures on hot use or run the database management system. These may include.
  1. Procedure to install the new DBMS.
  2. To log on to the DBMS.
  3. To use the DBMS or application program.
  4. To make backup copies of database.
  5. To change the structure of database.
  6. To generate the reports of data retrieved from database.
Database Access Language
    The database access language is used to access the data to and from the database. The users use the database access language to enter new data, change the existing data in database and to retrieve required data from databases. The user write a set of appropriate commands in a database access language and submits these to the DBMS. The DBMS translates the user commands and sends it to a specific part of the DBMS called the Database Jet Engine. The database engine generates a set of results according to the commands submitted by user, converts these into a user readable form called an Inquiry Report and then displays them on the screen. The administrators may also use the database access language to create and maintain the databases.
    The most popular database access language is SQL (Structured Query Language). Relational databases are required to have a database query language.
    Users
    The users are the people who manage the databases and perform different operations on the databases in the database system.There are three kinds of people who play different roles in database system
    1. Application Programmers
    2. Database Administrators
    3. End-Users
    Application Programmers
    The people who write application programs in programming languages (such as Visual Basic, Java, or C++) to interact with databases are called Application Programmer.
    Database Administrators 
    A person who is responsible for managing the overall database management system is called database administrator or simply DBA.
    End-Users
    The end-users are the people who interact with database management system to perform different operations on database such as retrieving, updating, inserting, deleting data etc.

    70 comments:

    1. Thanks for helping me in this........

      ReplyDelete
    2. Great write-up, I am regular visitor of one¡¦s web site, maintain up the nice operate, and It’s going to be a regular visitor for a long time.
      Oracle Goldengate

      ReplyDelete
    3. Hi, Nice description about Components of DBMS .Thanks, its really helped me......

      -Aparna
      Theosoft

      ReplyDelete
    4. Thank you Its really helpfull

      ReplyDelete
    5. Hi! I am a digital marketer. The previous seo guy working for my client left a spammy comment at your blog with the username Janice Rafael which links to my client's site.
      Such comments are or might cause serious damage to my client's site with respect to SEO which is why I am request you here by to remove it asap.
      If you don't remove it by 11:59 pm, Pacific Standard Time, 3rd January 2014, we will have use Google's Disavow Tool to get back-link removed and, sorry to say this, but Google may not look too nicely upon you either for not having removed the comment. Thanks in advance for your cooperation.

      ReplyDelete
    6. Thanks a lot for this educative information.

      ReplyDelete
    7. Thanx for helping me in Component of Database Management System

      ReplyDelete
    8. Thanx for helping me ..its very easy..

      ReplyDelete
    9. Thanks a lot it was very helpful

      ReplyDelete
    10. I like your post. It's nice information about Data base management system. Thanks for sharing. Frontaide offers Property Management system. It's a cloud base software.

      ReplyDelete
    11. Thanks ..such easy and good notes...

      ReplyDelete
    12. Thank you so much guys, you are doing a great job!

      ReplyDelete
    13. Nice notes this help me a lot, thanks :)

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

      ReplyDelete
    15. Thanks for sharing the information :)

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

      ReplyDelete
    17. Great you have shared very informative article. This is what i am actually looking for and definitely i will share this my friends and colleagues..
      Enquiry Management System

      ReplyDelete
    18. thanks brother best way of leaning

      ReplyDelete
    19. thanks brother best way of leaning

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

      ReplyDelete
    21. Index64 is the first ever in-memory concurrent key-value sore. There are several advantages of using Index64. Its speed is between two and ten times faster than any competitor. Range queries are as fast as a simple GET request.Lock-free and thread-safe algorithms gives a full availability on data.

      In-memory key-value store

      ReplyDelete
    22. easy to understand.....now i have some idea abt this components

      ReplyDelete
    23. It is easy to understand....
      Tq for ur content

      ReplyDelete
    24. Magicjack Support 1-800-653-4096,
      Customer Support For Magicjack
      COMPLETEPCSOLUTION is one of the best way to resolve
      all problems like magicjack technical support,
      magicjack customer suppport and installation,
      magicjack contact number.

      ReplyDelete
    25. Very informative article.Thank you author for posting this kind of article .



      http://www.wikitechy.com/view-article/explain-the-different-types-of-keys-in-rdbms-with-examples



      Both are really good,
      Cheers,
      Venkat

      ReplyDelete




    26. Thanks for all your information.Website is very nice and informative content.

      Modular Workstations Chennai

      ReplyDelete
    27. Thanks a Lot For Publishing This Its So much help full to me do the My Studys

      ReplyDelete
    28. I'm in a exam hall, it's main question what are DBMS Components and discuss about it... ;-) ThankU very very much...!

      ReplyDelete
    29. I was developing a data base management system and this is the best blog that I have visited with information in data base management system. I have learned a lot from the writers’ point of view and the comments written by forum members and I am grateful to have landed on this blog and found this information. I will be recommending this site to our professional writers who offer Urgent Help to Finish a Project.

      ReplyDelete
    30. Thanks for sharing important information on databases. It has proved me very helpful.
      zylax computers

      ReplyDelete
    31. MANY THANKS ...
      IT'S HELP TO ME ANSWER THE HNDA EXAMINATION ..

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

      ReplyDelete
    33. Thanks sir it really good and very helpful

      ReplyDelete
    34. That seems, by all accounts, to be fantastic anyway i am still not very beyond any doubt that I like it. At any rate will look significantly more into it and choose by and by! camping generators

      ReplyDelete
    35. Thanks for one marvelous posting! I enjoyed reading it; you are a great author.
      nebosh course in chennai

      ReplyDelete
    36. I wish to indicate because of you only to bail me out of this specific trouble. As a consequence of checking through the net and meeting systems that were not beneficial, I thought my life was finished.
      safety course in chennai

      ReplyDelete
    37. I enjoy what you guys are usually up too. This sort of clever work and coverage! Keep up the wonderful works guys I’ve added you guys to my blog roll.
      nebosh course in chennai
      fire and safety course in chennai

      ReplyDelete
    38. If you are looking to best bsc medical imaging technology college in Bangalore, you should visit the below link. Below link will help you to find best bsc medical imaging technology colleges in Bangalore.
      BSc Medical Imaging Technology Colleges In Bangalore

      ReplyDelete
    39. this is very valuable content for all DMS partner

      ReplyDelete