• Home
  • Contact Us
  • Guest Blogging
  • Privacy Policy
  • Computer Support
    •  

    Difference between DBMS and RDBMS

    Learn the difference between DBMS and RDBMS:
    The data contained the database may be used by application programmers and/or end users (users who use the data for getting information by querying the database or those who are using the application programs to get required information). Different application programmers and different users will have different views (the virtual portion of the database that is used ofr particular purpose or information). Which must be derived from a common overall data structure.

    internal structure of a database.

    Usually, in file processing system, records are stored permenently in various files. A number of application programs are written to extract records from, add records to and update records in the files. This style of file processing may lead to some drawbacks such as data redundancy (duplication of data), data inconsistency, non-sharable of data, non-standardized data, insecure data, incorrect data, invalid data etc. To overcome all these problems the software called database management system (DBMS) is used, which provides a centralized control of the data. The overall DBMS consists of databases, database languages, and the users.

    What is DBMS?
    A database managemant system (DBMS) contains a set of programs which helps users to construct and maintain a database. The DBMS is hence a common-purpose software system that helps the process of defining, creating and manipulating databases for different purposes. Defining a database includes opting of the data types, structures and constraints for the data to be saved in the database. Constructing the databsae is the process of storing the data itself on some storage devices which is controlled by the DBMS. Manipulating a database contains such functions as querying the database to grab required data, updating the database and building reports from the data.

    What is RDBMS?
    A database system is divided into small modules that to manage with each of the responsibilities of the entire system. Some of the functions of the database system may be done by the computer’s OS itself.

    This entry was posted on Tuesday, May 17th, 2011 at 5:43 pm and is filed under Programming. You can follow any responses to this entry through the RSS 2.0 feed. Both comments and pings are currently closed.