Hit this exam harder than you have ever done before.
--Your friends at LectureNotes

Note for Database Management System - DBMS by Thanmayee Tumuluri

  • Database Management System - DBMS
  • Note
  • Computer Science Engineering
  • B.Tech
  • 2 Offline Downloads
  • Uploaded 1 year ago
0 User(s)
Download PDFOrder Printed Copy

Share it with your friends

Leave your Comments

Text from page-1

UNIT-I What is Data? Data is nothing but facts and statistics stored or free flowing over a network, generally it's raw and unprocessed. For example: When you visit any website, they might store you IP address, that is data, in return they might add a cookie in your browser, marking you that you visited the website, that is data, your name, it's data, your age, it's data. Data becomes information when it is processed, turning it into something meaningful. Like, based on the cookie data saved on user's browser, if a website can analyse that generally men of age 20-25 visit us more, that is information, derived from the data collected. What is a Database? A Database is a collection of related data organised in a way that data can be easily accessed, managed and updated. Database can be software based or hardware based, with one sole purpose, storing data. During early computer days, data was collected and stored on tapes, which were mostly writeonly, which means once data is stored on it, it can never be read again. They were slow and bulky, and soon computer scientists realised that they needed a better solution to this problem. What is DBMS? A DBMS is a software that allows creation, definition and manipulation of database, allowing users to store, process and analyse data easily. DBMS provides us with an interface or a tool, to perform various operations like creating database, storing data in it, updating data, creating tables in the database and a lot more. DBMS also provides protection and security to the databases. It also maintains data consistency in case of multiple users. Here are some examples of popular DBMS used these days:  MySql  Oracle  SQL Server  IBM DB2  PostgreSQL 1 Prepared by AKBAR SHAIK, MIC COLLEGE

Text from page-2

 Amazon SimpleDB (cloud based) etc. ARCHIETECTURE OF DBMS The database management system can be divided into five major components, they are: 1. Hardware 2. Software 3. Data 4. Users 5. Database Access Language Let's have a simple diagram to see how they all fit together to form a database management system. 2 Prepared by AKBAR SHAIK, MIC COLLEGE

Text from page-3

DBMS Components: Hardware When we say Hardware, we mean computer, hard disks, I/O channels for data, and any other physical component involved before any data is successfully stored into the memory. When we run Oracle or MySQL on our personal computer, then our computer's Hard Disk, our Keyboard using which we type in all the commands, our computer's RAM, ROM all become a part of the DBMS hardware. DBMS Components: Software This is the main component, as this is the program which controls everything. The DBMS software is more like a wrapper around the physical database, which provides us with an easy-to-use interface to store, access and update data. The DBMS software is capable of understanding the Database Access Language and intrepret it into actual database commands to execute them on the DB. DBMS Components: Data Data is that resource, for which DBMS was designed. The motive behind the creation of DBMS was to store and utilise data. In a typical Database, the user saved Data is present and meta data is stored. Metadata is data about the data. This is information stored by the DBMS to better understand the data stored in it. For example: When I store my Name in a database, the DBMS will store when the name was stored in the database, what is the size of the name, is it stored as related data to some other data, or is it independent, all this information is metadata. DBMS Components: Procedures Procedures refer to general instructions to use a database management system. This includes procedures to setup and install a DBMS, To login and logout of DBMS software, to manage databases, to take backups, generating reports etc. 3 Prepared by AKBAR SHAIK, MIC COLLEGE

Text from page-4

DBMS Components: Database Access Language Database Access Language is a simple language designed to write commands to access, insert, update and delete data stored in any database. A user can write commands in the Database Access Language and submit it to the DBMS for execution, which is then translated and executed by the DBMS. User can create new databases, tables, insert data, fetch stored data, update data and delete the data using the access language. Users  Database Administrators: Database Administrator or DBA is the one who manages the complete database management system. DBA takes care of the security of the DBMS, it's availability, managing the license keys, managing user accounts and access etc.  Application Programmer or Software Developer: This user group is involved in developing and desiging the parts of DBMS.  End User: These days all the modern applications, web or mobile, store user data. How do you think they do it? Yes, applications are programmed in such a way that they collect user data and store the data on DBMS systems running on their server. End users are the one who store, retrieve, update and delete data. Characteristics of Database Management System A database management system has following characteristics: 1. Data stored into Tables: Data is never directly stored into the database. Data is stored into tables, created inside the database. DBMS also allows to have relationships between 4 Prepared by AKBAR SHAIK, MIC COLLEGE

Lecture Notes