Data Base Management System (DBMS)?

1753 Words8 Pages

Data Base Management System

What is data?
Know facts that can be recorded and have an implicit meaning.

What is a database?
The database is a collection of real data sets.
A database is a centralized and structured set of data stored on a computer system.

What is a database management system (DBMS)?
The DBMS is a computerized software that can be working as an interface between user and database to maintain the database.

The purpose of the DBMS.

All kinds of data can be stored in database. (Annual Attendance, Subject marks)
Easy to access necessaries data in any time.
We can reduce the data duplication and redundancy.
We can add data into database easy.
It is a safe mode to storing data.
There are minimum spaces to data lost. (Illegal …show more content…

Because of its proved performance disadvantages. Relational databases could not match the performance in the network databases and hierarchical databases. Then IBM research abled to find a solution. They constructed a efficient relational database system. It was the system R. The system R are provided by Astrahan et al. (1976) and Chamberlin et al. (1981). The full version of system R anlage led to IBMs first relational database product SQL/DS. The Ingres system was released developed by university of California at Berkeley at the same time. IBM DB2, Oracle, Ingres and DEC Rdb played the major roles of efficient declarative queries. Relational databases had become competitive with network and hierarchical database systems in the early 1980s. Relational databases finally replaced network and hierarchical database. The 1980s also saw much research on parallel and distributed databases, as well as initial work on object oriented databases.

Early 1990s
The SQL language designed for decision support applications. The mainstay of SQL queries were processing transaction applications in 1980s. In this databases re-emerged decision support and querying. Parallel database products introduced by many database vendors in this time period. To add object relational support to their databases also began by database …show more content…

The new database technology would be the XQuery as a result of the XML. And also XML is broadly used for the exchange, likewise for storing complex data types. But the relational databases get the core majority of the large scale databases applications. The growth in “autonomic-computing/auto-admin” techniques for minimizing system administration efforts have also witnessed by us in this time. The significant growth of this time period is inventing the open-source database systems in substance PostgreSQL and MySQL. The recent part of the group ten has seen amplification in specialized database for data analysis, in significant column-stores, which in force store each column of a table as a separate array, and highly parallel database system designed for analysis of huge data set. This database systems handle very large databases based the world wide web like Amazon, Google, yahoo, EBay, Facebook, Microsoft and twitter etc. This databases can handle concurrent users’ activities. Can analysis of streaming data, network monitoring data. Data-mining mechanism are now broadly deployed. For example web based product recommendation systems and displaying advertisements on web

Open Document