 Good morning everybody. I am Dr. Sachin R. Gengze, Professor and Head, Department of Electronics Engineering at Vulture Institute of Technology. Welcome to a new class. In today's session, we are going to have a look at database management system. As this topic of database management system is vast, I have divided into two parts. So in today's lecture, we are going to have a look at the first part of database management system or which is popularly called as DBMS. The learning outcome for today's session are at the end of this lecture, student will able to explain advantages of using database and secondly, the student can explain why DBMS system or DBMS software is required. As we know, the modern organization create and store vast amount of data. We already seen the definition of data is as an elementary description of thing, event or activities or transaction and this data is recorded, classified and stored but not necessarily in an organized way. And what what can be stored as a data numericals can be stored as a data, alpha numericals can be stored as a data, alphabets can be stored as a data, images, audios or videos can also be stored as a data. All that is termed as a data. If we look at the difference between the data and the database, we know that the data is simply the description of the thing, event or activities and these are called as the data item. But when I'm storing this data in an organized way so that it will be easy for retrieval of the data or certain information out of that, then it is called as the database. And we have discussed a simple example where the class data can be stored as a table of rows and columns where rows correspond to each row is corresponding to a record of a student and a column each column is corresponding to a particular attribute. And then storing the data in this manner, which is a very basic table by storing this kind of data in a table or form, we can see that it will be easy to retrieve the data or generate an information out of this table. Now what is a database? So once we understand a difference between a data and database, let us go ahead and understand or get into some more some more aspect of the database. What is a database? Database is databases or database is nothing but an optimal way to deal with the database is a logical group of a related file that data is being stored into the table and the table may be stored into the file. And then there can be a logical group of this related file. A database is a collection of data that is organized in a such a way that it can be easily accessed, managed and updated. So it I can read certain out of this data, I can write into this data, I can manage the data, I can combine the data, I can integrate the data, I can change some of the data items that I'm calling as an updation of data. Database is also a collection of schemas, tables, queries, report, views and other object. So that totally makes it as a database. Now what is the advantage of database? Why we instead of storing the data just into a file, why we store it as a database? What is the advantages of the database? The first advantage is that one soft one set of software program, which we are calling as the database management system or DBMS application, provide access to all the data. Although different users want to use the same data, they can use it using a single set of data and a program called as the database management system. There can be certain problems or certain issues related to the related to the data like data redundancy or data isolation, data inconsistency, these problems can be easily solved or can easily be addressed using the DBMS system. Another advantage of using the database and of course, it comes with the database management system DBMS is that data can be shared amongst all application user. As I say, there can be only a single database which can be shared by the number of user using a interface software or database management system. With this DBMS, the security and the data integrity of the database can also be increased. And then when we I'm using the database and database management system, data and the application program which are accessing the data, they become independent of each other. Now when we talk about the database, we talk about the database query. Now database query, there are two types of the database query. One is called as the select query and the other one is called as an action query. A select query is simply a data retrieval or information retrieval query. So whenever this kind of query is passed to the database, output of that is going to be either certain data extracted from the database or certain information extracted from the database. Now an action query is is different than the select query. Please understand in case of select select query, the database is not modified. But in case of action query, the database can be modified because there can be certain operation which modify the data like insertion means that I can add some record to the database, deletion, certain record can be deleted, updated, some of the data can be updated or changed also. So all those all the all these operations like where the data is being modified, then these are called as an action query. So as we can see, there are two types of the operation or two types of the queries that I can do I can I can have on this database. One is called as the select query, which do not change the database, but rather try to extract certain information or data out of the database. And the second one is an action query where the database is being modified. Now languages used to interact with database are called as the query languages of which one of the structured query language or popularly called as an SQL is a well known standard. Now here we can we can you can stop the video for some time and then you can answer what are the two types of the database query and with an example please explain what are the two types of the database queries. I hope you have solved this and yes there are two types of the database query. One is called as the select query and the other one is called as an action query. Let us go ahead. Then when we talk about the database, we also talk about what is called as the database management system. Data in database is managed using database management system, which is an application software. Database are computer programs used to manage the addition of the data, update of the data, deletion of the data as the transaction occurs and support data queries and the reporting. As I say there are two types of the query and action query which changes the data and select query which try to get certain information or data out of the database. So database management systems support both these operations. Mostly there are these DBMS are OLTP system. Now the OLTP stands for online transaction processing system that are designed to manage transaction data which is volatile. Now the volatile here means the data which is continuously changing. So in an organization whenever there are certain transactions going on and these transactions are the are the continuous part of the process of the organization. It is it is they are happening continuously and whenever these transactions are happening the data is being changed and then that kind of thing is called as a or that kind of system is called as an online transaction processing system and it basically deals with the data which is transacting and the data which is volatile and the language supporting and widely used for querying and accessing the database we see that it is called as an SQL. So this is how we can we can we can graphically represent or pictorically can represent about there is a data which is lying into the database and then there is a user. User want to access the data user can have either an action query or a select query and then the user send it to the software. This is a software which is called as the database management system and then the database management system can work on the database and it can either update the database or delete some of the part or add some of the part or some information is being retrieved. There can be multiple user accessing the same database same database and that is also the part of the data and handling that is also a part of the database management system. Now here is an example of how data can be useful data generated by transaction via computer and handheld devices or other devices are stored into the database. We can see that there are number of devices which can initiate the transaction and all that data is being captured or rather the transaction is being captured and the data is being updated over here. Now this database management system DBMS support data queries and report by extracting the data from the database and delivering it to the screen or other output devices. So whether whenever there are certain queries or certain information is being retrieved out of this database then the query can be passed and the graphical output can be processed. So this is a quick you can go through this quickly and find out what are the different database management systems. Many type of the database software are available we know that there is an Oracle or DB2 or SQL server right. So all or my SQL all these are the example of the database management system. Now why there is a need for the database management or the need for the data management is that data management determine the productivity of the manager if you manage the data properly then the productivity increases. Another goal of the data management is to provide infrastructure and tools to transform raw data into the useful information. We have seen that the data can be transformed into information information can be transformed into knowledge and then to in order to get this information out of the database the database management system is also required and properly managed data can increase the revenue and cut expenses also. Now managers where the lower lower managers and upper managers of the organization they require information and data for making certain decision for the organization and that is also provided this information can also be provided by the database management system and lastly the data errors and inconsistency can can can prove catastrophic and these can be avoided using the DBMS system. So with that we come to the end the first part of the database management system and for this the references being used are information technology for management by Turban and Volvino. The second book is information system by Ralph Stair and George Renaud and then I also use the book information technology for management by Turban and Woods. I think that with that we stop here today and we'll continue with the second part in the next lecture. Thank you very much for joining my lecture. Thank you.