Database Management System

Only available on StudyMode
  • Download(s) : 81
  • Published : February 16, 2013
Open Document
Text Preview
1. What is Database Management System? 

* is a set of programs that enables you to store, modify, and extract information from a database, it also provides users with tools to add, delete, access, modify, and analyze data stored in one location.

* A database management system (DBMS), sometimes just called a database manager, is a program that lets one or more computer users create and access data in a database. .

*  It is a software system that uses a standard method of cataloging, retrieving, and running queries on data. The DBMS manages incoming data, organizes it, and provides ways for the data to be modified or extracted by users or other programs.

* A DBMS is usually an inherent part of a database product. On PCs, Microsoft Access is a popular example of a single- or small-group user DBMS. Microsoft's SQL Server is an example of a DBMS that serves database requests from multiple (client) users. Other popular DBMSs (these are all RDBMSs, by the way) are IBM's DB2, Oracle's line of database management products, and Sybase's products.

* A collection of programs that enables you to store, modify, and extract information from a database. There are many different types of DBMSs, ranging from small systems that run on personal computers to huge systems that run on mainframes.

2. When do you usually use Database Management System?

* For maintaining the integrity of stored data, running security and users’ access, and recovering information if the system fails. * Used to store, manipulate and retrieve data from database. * For data storage retrieval and update facilities

* A user-accessible catalogue or data dictionary
* To support for shared update
* For backup and recovery services
* For security services
* For integrity services
* For connectivity
* For utilities
tracking img