SQL Reference Material.pdf - What is DBMS Database Logical collection of data with some inherent meaning A database management system(DBMS is a software

SQL Reference Material.pdf - What is DBMS Database Logical...

This preview shows page 1 - 3 out of 9 pages.

What is DBMS? Database - Logical collection of data with some inherent meaning. A database management system (DBMS) is a software package designed to define, manipulate, retrieve and manage data in a database. A DBMS generally manipulates the data itself, the data format, field names, record structure and file structure. It also defines rules to validate and manipulate this data. A DBMS relieves users of framing programs for data maintenance. Fourth-generation query languages, such as SQL, are used along with the DBMS package to interact with a database. Some other DBMS examples include: MySQL SQL Server Oracle dBASE FoxPro Types of DBMS: Following are the different types of DBMS: Hierarchical DBMS: This type of database management system showcases a style of predecessor-successor type of relationship. You can consider it to be similar to a tree, where the nodes of the tree represent records and the branches of the tree represent fields. Relational DBMS (RDBMS): This type of Database management system, has a structure which allows the users to identify and access data in relation to another piece of data in the database. In this type of DBMS, the data is stored in the form of tables. Network DBMS: This type of database management system supports many to many relations where multiple user records can be linked. Object-oriented DBMS: This type of database management system uses small individual software called objects. Here, each object contains a piece of data and the instructions for the actions to be done with the data.
Image of page 1
Advantages of DBMS: It offers a variety of methods to store and retrieve various formats of data using the query language. It can be easily maintained because of its nature of a centralized database system. Facilitates multiple applications using the same data with less development and maintenance time. Provides data security and integrity with minimal data duplicity and redundancy. It allows seamless integration into the application programming languages like Java and Python to enable the users to connect a database with any application or website. Has automatic backup and recovery systems to create an automatic backup of data. Authorizes users who can view, share and access data. Disadvantages of DBMS: Databases Management Systems are often complex systems. Few of the DBMS available in the market are licensed. So, you have to pay to use that DBMS in your organization. Most leading companies store their data in a single database. Hence, if that database is damaged due to any reason, the complete data would be lost. DBMS that you wish to use might not be compatible with an organization’s operational requirements.
Image of page 2
Image of page 3

You've reached the end of your free preview.

Want to read all 9 pages?

  • Summer '19
  • Priri
  • Database management system

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

Stuck? We have tutors online 24/7 who can help you get unstuck.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes