Monday, 19 September 2011

DATABASE MANAGEMENT SYSTEM (DBMS)













Typically database management system is considered as a computerized record keeping system. However, DBMS is a collection of programs, which are used to define, create and maintain database. Basically, database management system is a general-purpose software package whose overall purpose is to maintain information and to make that information available on demand. You can also develop a special purpose DBMS software (in Visual Basic, C++ etc.) to create and maintain database.
There are many functions of general-purpose DBMS software but the main functions are:
  • Defining the Structure of Database: which involves defining tables and their relationships, fields and their data types and constraints for data to be stored in the database.
  • Populating the Database: which involves to store data into database.
  • Manipulating the Database: which involves to retrieves specific data, update data, insert data, and to generate reports.
Now consider the example of university computer file-based processing system is converted  to database management system, applicants, students, courses, and faculty is stored in a single file called database. The data is integrated into database. It means that the data items are stored in a compatible format and logical connection among them is also stored. The database contains a description of its own structure so that the database management system "knows" what data item exist and how they are related to each other. Many users can share the database through the database management system. The Database Management system also provides a user-interface for online queries. The users can access the database directly from terminals, using query language such as Structured Query Language statements.

7 comments:

  1. Since I got a net connection, I invest all my time online. One of my primary passions is looking for appropriate internet sites like this one you've got here. I consider that the info you've provided here is just fantastic. Also I own a blog page but I cover stuff like knuckle lift and other related items. Regardless, thank you for discussing this blog post. Had a wonderful time!
    Oracle Goldengate

    ReplyDelete
  2. Hi, My client's previous SEO consultant left a spammy comment with the alias Clara Snyder at your blog which links to my client's site. This is causing us serious trouble with respect to SEO and the comment does not look good on your blog either.
    We apologize for the inconvenience and we request you to remove that comment as well as this current one that I am making within 48 hours. If you don't do so, I will have to use Google's disavow tool to get the spammy comment along with the website 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
  3. Nice Blog. It's great information about Data base Management System. Thanks For sharing the post. FrontAide is a cloud-based Property Management Software that is feature-rich and scalable to the needs of varied property types like Hotels, Bed & Breakfasts, Homestays, Holiday Lettings and more…

    ReplyDelete
  4. Thank you for your post. This is excellent information. It is amazing and wonderful to visit your site.
    mobile app training institutes

    ReplyDelete
  5. Latest Technology Information The website Provide Database Management System includes, Besides Theoretical Portion, Complete Articles on SQL and MS Access so that the readers may get a practical knowledge of databases.


    https://itused.net/

    ReplyDelete