Database Management System

DBMS is the collection of interrelated data and set of procedure to access that data. It has programs to set the storage structure, load the data, accept data requests from programs and user, format the retrieved data according to the given condition, it also hides data that a particular user should not has access to,it also allows the concurrent use of data between the various users without having interface between each other and it also performs backup and recovery procedures automatically.ADVANTAGES OF DBMS:-1 It helps in eliminating redundant data from the table because records with same data items are not possible in a DBMS.2 Data inconsistency can be prevented .3 The data present in different files can be shared and can be collectively used to produce useful information.4 Computer based DBMS provide search capabilities that helps in easy finding a particular record even from a big file.5 It helps in integrating the data.6 Using DBMS standards can be enforced.DISADVANTAGES OF DBMS:-1 Dbms Software Is Very Costly.2 It Requires Hardware Of High Cost.3 It Takes Time To Conversion.

Distributed DBMS

It is the software system that permits the management of the distributed database and makes the distribution transparent to users. A Distributed Database Management System (DDBMS) consists of a single logical database that is split into a number of fragments. Each fragment is stored on one or more computers under the control of a separate DBMS, with the computers connected by a communications network. Each site is capable of independently processing user requests that require access to local data and is also capable of processing data stored on other computers in the network. Users access the distributed database via applications. Applications are classified as those that do not require data from other sites (local Applications) and those that do require data from other sites (global applications). We require a DDBMS to have at least one global application.