blog




  • Essay / database management system - 1242

    Differentiate between database management system and information retrieval system by focusing on their functionalities.AnswerDatabase management systemA basic management system Database Management System (DBMS) is the primary software tool of the database management approach as it controls the creation, maintenance and use of the databases of an organization and its end users. A DBMS performs several functions to ensure the integrity and consistency of data in the database. There are ten database management system functions. There are data dictionary management, data storage management, data transformation and presentation, security management, multi-user access control, backup and recovery management, data integrity management, database access languages ​​and application programming interfaces, database communications interfaces and transaction management. The first function of the database management system is a data dictionary. The database management system performs functions for managing database elements and explains how to connect relationships with other data. When the system requires data in a database, it will make it easier to access and search data in the DBMS via SQL. So that users can manage it easily. The data dictionary is used by database administrators and programmers and the data dictionary is often hidden from the user. Data storage is also part of the database management system. The database management system has a main function of data storage. Today, the sophistication of database management system makes it possible to store data in different types, such as videos and images. Users do not need to know how data is stored or manipulated. The database management system has procedures in this process and ensures that the data is stored ...... middle of paper ...... of some data at a single point. the data will always change and there will always be more. Appropriately use diagrams to illustrate the underlying concepts/components of the database management system and information retrieval system. Differentiate between structured and unstructured data. Give examples of each.AnswerStructured data is defined as data that is recorded and classified in the database so that it can be used effectively. This is often the case with selecting the type of detailed data structures that should be used to enable the use of efficient algorithms. A good design data structure allows a variety of critical operations to be performed using as much time and little memory space as possible. Structured data will be represented in discrete form, in the form of columns and rows. it can make database data more organized.