Topic > database management system - 1242

Differentiate between database management system and information retrieval system by focusing on their functionality.AnswerDatabase Management SystemA database management system (DBMS) is the primary software tool of the database management approach because it controls the creation, maintenance, and use of an organization's databases and its end users. There are several functions that a DBMS performs to ensure the integrity and consistency of the data in the database. There are ten functions of database management system. Data dictionary management, data storage management, data transformation and presentation, security management, multi-user access control, backup and recovery management, data integrity management are available , database access languages ​​and application programming interfaces, database communication interfaces, and transaction management. The first function of the database management system is the data dictionary. The database management system performed functions of managing items in the database and how to link relationships with other data. When the system requires data in a database it will facilitate the DBMS via SQL to access and search the data. 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 one of the database management systems. The database management system has a primary function such as data storage. Today, the sophistication of database management system can store data in various types such as videos and images. Users don't 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… in the middle of the paper… of certain data in one place. the data will always change and more and more will come. Make appropriate use of diagrams to illustrate the underlying concepts/components of the database management system and information retrieval system. Distinguish between structured and unstructured data. Provide examples for each. Answer Structured data refers to data that is recorded and stored in the database for efficient use. This is often the case with selecting the type of detailed data structures to use to enable the use of efficient algorithms. A good design data structure allows you to perform a variety of critical operations using as little time and memory space as possible. structured data will be represented in discrete form or in column and row form. this can make the data in the database more organized.