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.
    Posted by at

    69 comments:

    1. Unknown18 August 2012 at 06:44

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

      ReplyDelete
    2. Unknown19 December 2012 at 00:16

      thanks alot

      ReplyDelete
    3. Unknown15 January 2013 at 00:17

      pyts!

      ReplyDelete
    4. Unknown15 April 2013 at 20:43

      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
    5. Unknown27 May 2013 at 13:14

      thanks for this

      ReplyDelete
    6. Unknown19 June 2013 at 13:00

      Great! thanks

      ReplyDelete
    7. Unknown26 August 2013 at 00:16

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

      -Aparna
      Theosoft

      ReplyDelete
    8. Unknown30 October 2013 at 06:22

      Thank you Its really helpfull

      ReplyDelete
    9. Unknown22 November 2013 at 01:06

      THANKS FOR YOUR HELP

      ReplyDelete
    10. Le Mystique1 January 2014 at 23:53

      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
    11. Unknown14 August 2014 at 12:56

      Thanks a lot for this educative information.

      ReplyDelete
    12. Hammad Afridi11 October 2014 at 02:12

      Thanx for helping me in Component of Database Management System

      ReplyDelete
    13. Unknown19 October 2014 at 19:10

      Thanx for helping me ..its very easy..

      ReplyDelete
    14. Unknown23 December 2014 at 21:53

      Thanks a lot it was very helpful

      ReplyDelete
    15. Unknown11 January 2015 at 00:20

      Good Points. Thanks

      ReplyDelete
    16. Unknown23 February 2015 at 01:59

      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
    17. Unknown20 May 2015 at 12:08

      good notes thanks

      ReplyDelete
    18. Unknown4 June 2015 at 20:48

      Thanks ..such easy and good notes...

      ReplyDelete
    19. funclip16823 July 2015 at 05:43

      Thanks you so much!

      ReplyDelete
    20. Unknown18 September 2015 at 04:59

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

      ReplyDelete
    21. Malinda Iroshana3 October 2015 at 07:53

      thanx dr.

      ReplyDelete
    22. Unknown31 October 2015 at 08:09

      Nice notes this help me a lot, thanks :)

      ReplyDelete
    23. Unknown8 November 2015 at 23:46

      This comment has been removed by the author.

      ReplyDelete
    24. Unknown8 November 2015 at 23:46

      Thanks for sharing the information :)

      ReplyDelete
    25. Unknown8 November 2015 at 23:47

      This comment has been removed by the author.

      ReplyDelete
    26. Unknown30 November 2015 at 01:23

      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
    27. EDWIN MUKHALISI6 December 2015 at 05:48

      EDWIN MUKHALISI
      Thanks Alot Man

      ReplyDelete
    28. Unknown13 December 2015 at 19:05

      Amazing. Thanks

      ReplyDelete
    29. Unknown19 December 2015 at 21:22

      Thanks it's helpful for me

      ReplyDelete
    30. Saviya Enterprises11 February 2016 at 05:28

      thanks.......

      ReplyDelete
    31. Unknown3 March 2016 at 17:37

      thanks a million times

      ReplyDelete
    32. Unknown7 March 2016 at 09:55

      thanks brother best way of leaning

      ReplyDelete
    33. Unknown7 March 2016 at 09:56

      thanks brother best way of leaning

      ReplyDelete
    34. Unknown10 April 2016 at 00:19

      This comment has been removed by the author.

      ReplyDelete
    35. Unknown10 April 2016 at 00:19

      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
    36. Unknown23 July 2016 at 06:01

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

      ReplyDelete
    37. R Sangavi14 September 2016 at 06:18

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

      ReplyDelete
    38. Unknown19 September 2016 at 10:01

      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
    39. Unknown20 October 2016 at 05:13

      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
    40. Unknown8 November 2016 at 01:41





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

      Modular Workstations Chennai

      ReplyDelete
    41. Unknown23 November 2016 at 01:42

      Thanks so much

      ReplyDelete
    42. Unknown30 November 2016 at 03:13

      really thanx ..

      ReplyDelete
    43. Unknown1 December 2016 at 16:57

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

      ReplyDelete
    44. Unknown21 January 2017 at 02:48

      THANKS BRO

      ReplyDelete
    45. Kasun Rukmaldeniya12 February 2017 at 22:20

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

      ReplyDelete
    46. Unknown1 June 2017 at 02:43

      Thanks god bless you

      ReplyDelete
    47. Unknown12 June 2017 at 02:10

      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
    48. Unknown1 September 2017 at 02:19

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

      ReplyDelete
    49. D&C Accounting and Taxation8 September 2017 at 08:06

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

      ReplyDelete
    50. Redhat Safety20 September 2017 at 23:01

      nebosh course in chennai
      nebosh courses in chennai
      nebosh
      nebosh igc
      nebosh courses in india
      nebosh courses in tamilnadu
      nebosh idip
      nebosh course in chennai
      nebosh in chennai

      ReplyDelete
    51. Anonymous16 October 2017 at 00:30

      This comment has been removed by the author.

      ReplyDelete
    52. rabbit gravy21 November 2017 at 00:13

      Skype 2018
      Skype 2018
      Skype 2018
      Skype 2018
      Skype 2018
      Download Skype 2018

      ReplyDelete
    53. Unknown30 March 2018 at 21:32

      Thanks sir it really good and very helpful

      ReplyDelete
    54. robinjack29 April 2018 at 13:30

      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
    55. nannozi filster28 September 2018 at 20:36

      Thax alot for ur help

      ReplyDelete
    56. Swethagauri1 October 2018 at 02:55

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

      ReplyDelete
    57. sunshineprofe4 October 2018 at 23:40

      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
    58. gowthunan5 October 2018 at 02:32

      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
    59. katetech19 October 2018 at 03:21


      Thank you for your post. This is excellent information. It is amazing and wonderful to visit your site.
      ios app development company kukatpally
      ios app development company kphb
      ios app development company gachibowli
      ios app development company ameerpet
      android app developers in hyderabad

      ReplyDelete
    60. Unknown9 January 2019 at 00:32

      thank u very much for help

      ReplyDelete
    61. Unknown5 February 2019 at 02:32

      thank you much

      ReplyDelete
    62. Naveen2 December 2019 at 23: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
    63. Rajesh Deepak27 February 2020 at 02:00

      The best component details given in this post for computer users.
      What Are The Nine Important Components Of A Computer

      ReplyDelete
    64. Data Tech27 January 2022 at 02:26

      this is very valuable content for all DMS partner

      ReplyDelete

    Subscribe to: Post Comments (Atom)