DATABASE

Add to Favourites
Post to:

Description
A database management system (DBMS) is a collection of programs that enables users to create and maintain a database or contains a set of interrelated data with set of programs to access the data. DBMS provides an environment that is both convenient and efficient to use. The DBMS is hence a general-purpose software system that facilitates the processes of defining, constructing, and manipulating databases for various applications. Defining a database involves specifying the data types, structures, and constraints for the data to be stored in the database. Constructing the database is the process of storing the data itself on some storage medium that is controlled by the DBMS. Manipulating a database includes such functions as querying the database to retrieve specific data, updating the database to reflect changes in the miniworld, and generating reports from the data. Well known DBMSs include • Oracle• IBM DB2<• Microsoft SQL Server• Microsoft Access• PostgreSQL• MySQL• SQLite.Advantages of DBMS?• Redundancy is controlled.• Unauthorised access is restricted.• Providing multiple user interfaces.• Enforcing integrity constraints.• Providing backup and recovery


Type: doc

Discussion

Patel Devang

http://studyoverflow.com/sql-server/

518 days 14 hours 53 minutes ago

Neenu Prasad
Looking to Learn for computer subjects
User
22 Followers

Your Facebook Friends on WizIQ