Analysis of database management and information retrieval systems

1735 Words4 Pages

1) Differentiate between database management system and information retrieval system by focusing on their functionalities. (Up to one page)
[30% marks]

Database management system is also known as DBMS. DBMS is a software system that uses a standard method of cataloging, retrieving and running queries of data and to control access to it. DBMS usually manages incoming data, organize the data and provides ways for the data to be altered or extracted by users or other programs. Some of the example for DBMS includes MySQL, PostgreSQL, Microsoft Access, SQL server and Oracle.

Above is the diagram of how DBMS and operating system works, to access the database controlled by the host operating system. DBMS accepts request for data from the application program and then informs the operating system to transfer the required data. The file manager keeps track of the location of the data and whiles the system buffers are the temporary location for storing and manipulating the data. Reading and writing of the data is performed at System buffers.

As for the functions of DBMS, it is a query processing (SQL) and optimization, query optimization determines the optimum strategy for a query execution. Then, security control, DBMS have includes a prevent of unauthorized access to the database. Data Integrity in DBMS includes the facility for enforcing integrity constraints whenever a change is made to the data to ensure that the database is consistent and no error. Lastly, the functionality of DBMS is recovery, the DBMS must take steps to ensure that if the database fails, it will remain at a consistent state which that the data will not be lost. Other than that, DBMS also have data independency function, which this function pro...

... middle of paper ...

...se with little or no form or structure fixed. Unstructured data is including e-mails, reports, contracts, and other communications. A person who performs activities in an unstructured communication system has wide latitude to structure the message in any desired shape. Rules unstructured system is a little complicated and less.

Illustrator about non-Structured Data and Structured Data

Example of Non-Structured Data
Non-Structured data is raw and unorganized and organizations keep everything. Ideally, all this information will be made in the form of structured data; however, this would be expensive and time consuming. Also, not all types of unstructured data can easily be converted into a structural model
List of types of unstructured data:
• Emails
• Word Processing Files
• PDF files
• Spreadsheets
• Digital Images
• Video
• Audio
• Social Media Posts

Open Document