CONCEPT OF DBMS

Karishma soni ritika dubey priya pandey

1. 2016-2017 NASRULLAGANJ Name – Karishma soni , Ritika Dubey , Priya Pandey Topic – Concept of DBMS Class – B.sc. Vth sem ( cs ) Submited to Submited By Mr. C.L.Malviya & Karishma Soni , Ritika Dubey , Priya Paney M.r . Sanjay shinde RAI SAHEB BHANWAR SINGH COLLEGE

2. Data – data , also known as  primary data , is  data  (e.g., numbers, instrument readings, figures, etc.) collected from a source. If a scientist sets up a computerized  thermometer  which records the temperature of a chemical mixture in a test tube every minute, the list of temperature readings for every minute, as printed out on a spreadsheet or viewed on a computer screen is "raw data". Raw data has not been subjected to processing, "cleaning" by researchers to remove  outliers , obvious instrument reading errors or data entry errors, or any analysis (e.g., determining  central tendency  aspects such as the  average  or  median  result . Information – A  database management system  ( DBMS ) is a computer software application that interacts 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.

3. Data base – , sls data dk xzqi gksrk gS tksa fofHkUu yksxks } kjk ;wt esa ykus ds fy , Design fd;k x;k gSA " Database Software" redirects here. For the computer program, D atabase management system  ( DBMS ) MsVk dks fdlh Hkh Particulari Place dj esust djus okyk flLVe gSA is a  computer software  application that interacts 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 , MongoDB ,  Microsoft SQL Server ,  Oracle ,  Sybase ,  SAP HANA , 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 . [ disputed  –  discuss ]  Sometimes a DBMS is loosely referred to as a 'database'.

4. Data Base Management System :- Data dks fdlh Hkh Particulare place ij Manage djus okyk flLVe gSA Components of DBMS A database management system (DBMS) consists of several components. Each component plays very important role in the database management system environment. The major components of database management system are: Software Hardware Data Users Software The main component of a DBMS is the software. It is the set of programs used to handle the database and to control and manage the overall computerized database DBMS software itself, is the most important software component in the overall system Operating system including network software being used in network, to share the data of database among multiple users. Application programs developed in programming languages such as C++, Visual Basic that are used to to access database in database management system. Each program contains statements that request the DBMS to perform operation on database. The operations may include retrieving, updating, deleting data etc . The application program may be conventional or online  workstations or terminals.

5. Advantages of DBMS The database management system has a number of advantages as compared to traditional computer file-based processing approach. The DBA must keep in mind these benefits or capabilities during databases and monitoring the DBMS. The Main advantages of DBMS are described below. Controlling Data Redundancy  In non-database systems each application program has its own private files. In this case, the duplicated copies of the same data is created in many places. In DBMS, all data of an organization is integrated into a single database file. The data is recorded in only one place in the database and it is not duplicated. Sharing of Data In DBMS, data can be shared by authorized users of the organization. The database administrator manages the data and gives rights to users to access the data. Many users can be authorized to access the same piece of information simultaneously. The remote users can also share same data. Similarly, the data of same database can be shared between different application programs.

6. Data Consistency  By controlling the data redundancy, the data consistency is obtained. If a data item appears only once, any update to its value has to be performed only once and the updated value is immediately available to all users. If the DBMS has controlled redundancy, the database system enforces consistency. Disadvatage of DBMS 1. Costly 2. Maintinense 3. Sharing Data

7. Thanku