-
Essay / Database Management and Recovery System - 1417
Question 1. Differentiate between database management system and information recovery system by focusing on their features. Database management system (also known as DBMS) is a set of applications that allows the user to create, modify, update, store and retrieve data from database files. data. Using the DBMS, data in a database can be added, deleted, modified, sorted and searched. DBMSs are typically used to manage a large company's employee information, customer information, and stock information. There are advantages and disadvantages to using DBMS. The advantages of a DBMS are that the same information can be available to any user, minimizing redundancy can reduce the cost of storing information on other devices, the accuracy of using the DBMS due to its up-to-date and easily accessible data. The downside of DBMS is that implementing this system can be expensive and time-consuming, even in terms of training. When we mentioned the features of DBMS, it has four main components. The four components are data, hardware, software and user. Data are simple, raw, unorganized facts that must be processed to make sense. Hardware is a physical component of the computer system and also called peripheral. Software is an application inside the computer. Finally, the user is the one who clearly understands what it means to use the system on a daily basis. There are a number of functions that a typical DBMS supports. • Data Definition Language also known as DDL – for defining a database. The DBMS must allow users to create database definitions. • Data manipulation language called DML – to insert, update, delete and query data in the database. • Concurrency control which allows shared access to the database, with multip.... .. middle of paper ......t, then the result will be fast.Works Cited1. Joey F. George et.al. 2004 Analysis and design of 2d object-oriented systems ed. Pearson International Edition: page 1442. Raghu Ramakrishnan & Johannes Gehrke 2003 3d Database Management System ed. McGraw-Hill Higher Education: p. 9.3. Patricia Ward and George Dafoulas 2006 Thomson Database Management Systems: pages 4 and 54. Ralph M. Stair and George W. Reynolds 2006 Principles of Information Systems, A Managerial Approach, 7th ed. Thomson: p. 5 and 75. Ramez Elmasri and Shamkant B. Navethe 1989 Fundamentals of Database Systems 6th ed. Pearson: pg10006. http://www.personal.psu.edu/glh10/ist110/topic/topic07/topic07_05.html7. http://smithaprahlad.blogspot.com/2006/05/distinguih-between-irs-and-dbms.html?m=18. http://www.ask.com/question/what-is-different-between-data-and-information9. http://en.m.wikipedia.org/wiki/Unstructured_data