BASICS OF DATABASE MANAGEMENT SYSTEM (DBMS)-YOU MUST KNOW

Welcome friends...lets talk about some technology in which we are going to have knowledge about DBMS i.e. DATABASE MANAGEMENT SYSTEM.

A database is simply an organized collection of DATA . Database management systems are purposely designed software applications that interact with users, other applications, and the database itself to capture and analyse the data . DBMS is a software system designed to allow the definition, creation, querying, update, and administration of databases.Commonly known DBMSs include MySQL, MariaDB, PostgreSQL, SQLite,Microsoft SQL Server, Oracle, SAP, dBASE, FoxPro, IBM DB2, Libre Office Base and File Maker Pro.

Most existing DBMS fall into four main groups :-

Data definition - Defining new data structures for a database, removing data structures from the database, modifying the structure of existing data.

Update - Inserting, modifying, and deleting data.

Retrieval - Obtaining information either for end-user queries and reports or for processing by applications.
Administration - Registering and monitoring users, enforcing data security, monitoring performance, maintaining data integrity, dealing with concurrency control, and recovering information if the system fails.

Administration - Registering and monitoring users, enforcing data security, monitoring performance, maintaining data integrity, dealing with concurrency control, and recovering information if the system fails.

A DBMS is responsible for maintaining the integrity and security of stored data, and for recovering information if the system fails."Database system" refers collectively to the database model, database management system, and database.

Databases are not used only to hold administrative information, but are capable of holding more specified data : for example engineering data or economic models. Examples of database applications include computerized library systems, flight reservation systems, and computerized parts inventory systems.

General-purpose DBMS :- Some general-purpose DBMSs are Adabas, Oracle and DB2.
A common example is an email system: email systems are designed to optimize the handling of email messages, and do not need significant portions of a general-purpose DBMS functionality.

 To easily understand the working of DBMS software lets take an example of university computer file processing system :-

All of the data about applicants, students, courses, and-faculty is stored in a single database. The data is integrated into database. It means that the data items are stored in a compatible format and logical relation among them is also stored. The database contains a description of its own structure so that the DBMS "knows" what data items exist and how they are related to each other. Many users can share the database through the DBMS. The DBMS also provides a user-interface for online queries. The users can access the database directly from terminals, using the query language such as SQL statements.

The most popular database access language is SQL (Structured Query Language). Relational Databases are required to have a database query language. Today most of the RDBMSs use the SQL as database access language.-Ms-Access also uses the SQL to perform different operations on the databases.

Now a days DBMS is the most preferred database system to be used by administrators , developers in IT company.How do you make your career in DBMS??? Leave your feedbacks about this.Your feedbacks will be admired.