Thursday, April 25, 2013

DataBaseManagementSystem

For Downloading File use link: http://www.sgdmgdc.com/genxtechno/dbms.pdf

Database System is an integrated collection of related files along with the detail about their


definition, interpretation, manipulation and maintenance. It is a system, which satisfied the data need

for various applications in an organization without unnecessary redundancy. A database system is

based on the data. Also a database system can be run or executed by using software called DBMS

(Database Management System). A database system controls the data from unauthorized access.

A database management system (DBMS) is a system that allows to build and maintain databases, as

well as to utilize their data and retrieve information from it. A DBMS defines the database type that

it supports, as well as its functionality and operational capabilities. A DBMS provides the internal

processes for external applications built on them. The end-users of some such specific application are

usually exposed only to that application and do not directly interact with the DBMS. Thus end-users

enjoy the effects of the underlying DBMS, but its internals are completely invisible to end-users.

Database designers and database administrators interact with the DBMS through dedicated interfaces

to build and maintain the applications' databases, and thus need some more knowledge and

understanding about how DBMSs operate and the DBMSs' external interfaces and tuning parameters.

A DBMS consists of software that operates databases, providing storage, access, security, backup

and other facilities to meet needed requirements. DBMSs can be categorized according to

the database model(s) that they support, such as relational or XML, the type(s) of computer they

support, such as a server cluster or a mobile phone, the query language(s) that access the database,

such as SQL or XQuery, performance trade-offs, such as maximum scale or maximum speed or

others. Some DBMSs cover more than one entry in these categories, e.g., supporting multiple query

languages. Database software typically support the Open Database Connectivity (ODBC) standard

which allows the database to integrate (to some extent) with other databases.

Search This Blog