DBMS - Database Management System

Databases and Systems to manage them have become significant components of any present day business of any nature. It has a major impact on growing use of computers. These databases help businesses to perform their day-to-day activities in an efficient and effective manner.

Example: Banking; Travel ticket reservation; Library catalog search.

Advances in technology have given raise to new concepts- Like- Multimedia Databases; Data Integration; Big data; GIS; Web Data; Data Warehousing; Data Mining etc.

Data: Known fact that can be recorded and that has implicit meaning.

Examples: Name, Tel_no, city etc.

This data can be stored in a file on a computer.

Database:

Is a collection of related data. It is a collection of logically related data.

A database is designed, built and populated with data for a specific purpose.

What is DBMS

Database Management System or DBMS in short, refers to the technology of storing and retriving users data with utmost efficiency along with safety and security features. DBMS allows its users to create their own databases which are relevant with the nature of work they want. These databases are highly configurable and offers bunch of options.

Database management systems are computer software applications that interact with the user, other applications, and the database itself to capture and analyze data. A general-purpose DBMS is designed to allow the definition, creation, querying, update, and administration of databases. Well-known DBMSs include MySQL, PostgreSQL, Microsoft SQL Server, Oracle, SAP and IBM DB2. A database is not generally portable across different DBMSs, but different DBMS can interoperate by using standards such as SQL and ODBC or JDBC to allow a single application to work with more than one DBMS. Database management systems are often classified according to the database model that they support; the most popular database systems since the 1980s have all supported the relational model as represented by the SQL language.



MORE ABOUT DBMS

     »  DBMS Introduction

     »  ER Model( Entity Relationship Model )

     »  EER Model ( Extended ER modeling )