Functions Of Database Management System

Functions Of entropybase Management musical arrangementBefore we start with database management system we should know what is selective in figureation. A info is a piece of information, and entropybase is the allurement of entropy that is set in an orderly way. And managing this entropybase is know as Database Management dodge in short database management system. The person who manages, creates, controls and maintain this database management system is known as Database Administrator (DBA). new(prenominal) important term to remember is information. Any data which has been converted to a subroutineful and understandable form is called information.There atomic number 18 some differences between data and information.DataInformationAny raw figure or fact is data.For example 6 is a data.A processed form of data is known as information.For example weight = 6 kg is dataData does not help in making decisions.With right information we can situate decision.Functions of Database M anagement establishmentData typeing The organized definition of data storage is known as data modeling.Processing Query This a appliance of manipulating the dataConcurrency Control To ensure the accuracy and simultaneous approach of the database by multiple users.Security of Information Security of the database is very important.Crash Recovery Data recovery after the system crashes.Types of Database usersDatabase Administrator (DBA) The database administrator is the person who who maintains radiation patterns and creates the database.Database Designer A database designer is a person who plans or designs the database. dismiss User The ace who uses the database, it whitethorn be that he/she exactly views the database or it whitethorn be that he/she makes the data entries. Make queries, etcThere may be different grammatical cases of last user, for exampleSophisticated these atomic number 18 the users who has a good familiarity in database and can make queries, with SQL man ipulate data with DML (Data Manipulating Language)Specialized who makes application programs that interacts with the databaseNative only interacts with the database via some sophisticated programsApplication Programmers A person who makes applications which interacts with the database using programming language like C++ , Java, etc. He may create a computer software which gives a easygoing to use interface to input data into a confused database, so that even the clerks of the office can input data or search for some data from the companies database without knowing Oracle, MySQL or other DBMS softwareDatabase mannikinDatabase Model is the building or the format of the data it may be fleshly or conceptual. Database Model is also known as database schema.Conceptual Model Conceptual Model helps to overview the organizational schema kinda than the database schema.Physical Model Physical Model is the database design which means that this model describes the data storage, data struc ture, etc. basically we lead off to know about the physical media of the data storage and the mode of access of that data from this model.Frame Memory Model This type of model is generally used for large manufacturing database application. Modifying the characteristic of the complex database easy and accurately.Unifying Model in the Unifying Model the Entity-Relation concept has been extended to introduce a new form of diagrammatic representation other than class diagrams.Object Oriented Model A Object Oriented Model is a data model in which the real life data or entities are organized. Generally Object Oriented Data Model or OODM consists of the following concepts, they are as followsObject and object identifierAttributes and methods menageClass hierarchy and inheritanceRecord Based Model The Record Based Model helps us to specify the overall logical structure of the database. In this type of data bases the numbers of types of data are decided. And each of the record type or dat a type has a fixed number of fields with fixed field length. There are three types of record based data model they areHierarchical Model In a Hierarchical Model the data is organized in a form of tree like structure. In this kind of structure the parent child relationship can easily be shown. A very famous use of this kind of database is the Windows Registry developed by Microsoft.320px-Hierarchical_Model.jpgNet run Model This is a type of database model where it is easy to represent objects and relationship. Its to a greater extent easier to define m some(prenominal) to many relation in this model rather than in the hierarchical model. A well known effectuation of Network Model is RDM Server.320px-Network_Model.jpgRelational Model The relational model was developed by E.F Codd. The right(a)ties of a relational database model are as followsThe columns of table are all homogenous i.e. they are of the resembling kind.Every item should have simple value.All the relationship of tupl es must be distinct.The key value should be used to order the tuples within a relationship.Columns are named distinctly and their ordering is not so important.280px-Relational_Model_2.jpgManual Database.A Manual Database is a record unplowed by a human without the use of any computers or electronic devices. This obviously has many problems likeSearching It is very difficult to find a particular result from a manual database if the size of it of the database is huge.Updating Updating a new entry is also problematic as we have to manually find the old record, scratch it, or erase it then make the new entry.Backing up Suppose there is a database of 10,000 pages making a manual rest of this database, i.e. a handwritten copy of it will be difficult to make.Sorting It is virtually unacceptable to sort the data say name calling of customers by alphabetic order, etc on a manual database.As we see that making a manual database of a large amount of data becomes impossible to manage so now we use computerized data.Traditional commove Processing SystemOne of the earliest forms of computerizing data storage is the filing cabinet processing system. Creating, sorting, organizing and accessing the content of the file is known as data file Processing System.Characteristics of File Processing System.Each file is different from each other.This is a collection of files, or screen out data.Each of the file is called a flat file.Every file contains processed information of a specific function such as one file may be for accounting other file may be of contacts.Files are created by the help of program which are written in C, C++ or COBOL.Drawbacks of the File Processing System.There are many drawbacks of File Processing System.Separated DataDuplicated DataData DependencyData rigidityProblems in representing the data to user.File format problems.Database A database is a organized form of data. This organization is very important because when the size of data increases it bec omes difficult to use or control the data.Database Management System A DBMS or Database Management System is a collection of data and programs which help us to access and modify those data. The collection of data is called database. The main purpose of DBMS is to efficiently store and control the database.Advantages of DBMSControl Redundancy With the help of DBMS data redundancy can be controlled. In the File Processing System there used to be data redundancy, which means that the same data stored more than once.Integrity Maintaining Integrity means that the data stored in the database is accurate and precise. This is very much important as incorrect data can not be stored into the database so some integrity constraints are enabled on the database, to check the accuracy of the database.Avoiding inconsistency Consider there are two data storage sites of data and some changes are made in one site but those changes are not reflected on the other site for some reasons then it gives pas s over to data inconsistency. To avoid this data redundancy should be removed if data redundancy is checked it will also remove data inconsistency.Data manduction Suppose a same data is required by two databases then that data can be shared from a centralized database.Maintaining standards As we know that DBMS is a centralized system so it can be standardized effectively. A company database can be standardized in Department Level, National Level, International Level, etc.Preventing unauthorized access Lots of security can be enabled to prevent the unauthorized access of the data. Passwords and encryptions are enabled in database to provide better security to companys data.Backup and recovery of data Data loss can happen at any routine due to number of reasons so it is very much important to create backup so that the data can be recovered if there is any accidental loss of data.Disadvantages of DBMSComplexity The functionality of DBMS is a very complex process. The database designe r, database administrator, developer and the end user should have a clear understanding of the DBMS working and functionality to make it work in a correct way. If they fail to do it DBMS will not work in a proper way.Size As time passes the size or the volume of data increases which makes the size of database larger. Moving, copying and editing this large amount of data take a considerable time and system resource. Sometimes upgrading RAM or Disk Space becomes necessary to run the DBMS properlyPerformance DBMS software tends to run slower than the typical File Processing System.Cost Cost of implementing the DBMS is high. Sometimes the DBMS software for the specific environment is high, or the upgradeing of graveware to run it becomes costly or when converting from an older system to DBMS the process of conversion of the data costs a lot.Failure rate higher As it is a centralized system I it fals every operation comes to a halt.Difference between File Management System and Database Management SystemFile Management SystemDatabase Management SystemFile management Systems are relatively small in size and volumeDatabase Management Systems are relatively larger in size.They are cheaper to implementMuch costlier to implementIt deals with few filesIt deals with a large number of files.The structure of this system is very simpleThe structure is very much complex in nature.There are many redundant data.Redundant data is very much reduced.Data inconsistency takes business office in File Management SystemData inconsistency is checked in the DBMSIn File Management System data is isolated.In DBMS data can be shared.There is no security.It is secured.Very simple and primitive form of backup and recovery.Highly sophisticated and complex form of backup and recovery.Mainly single user.Most of the time its multiuser.Less preliminary designVast preliminary designPurpose of DBMSDatabase Management System is very useful and is used in many sectors. Some the areas where it is us ed is given below.Railway for making the railway enquiry and reservation system to work properly there is a needed of implementing DBMS as all the data has to be stored in a centralized location and the data is then used by every railway stations throughout the country.Banking As now a days there are many branches of a savings bank there has to be a DBMS to track and record the transactions of every customers. This will have not been possible if File Management System were used.Schools/Colleges and Universities To store the records of students like their name, roll number, address, contact number, marks obtained, etc a DBMS is used so that the database can be updated easily.Business and Offices To store the companys sales, profit , etc and its record of employees a sophisticated DBMS is used.Instances and SchemasThe database changes from time to time, the information which is stored in the database at a particular time is known as Instance. A Schema is a overall design of the data base .QUESTIONSWhat do you mean by DBMS?A DBMS or Database Management System is a collection of data and programs which help us to access and modify those data. The collection of data is called database. The main purpose of DBMS is to efficiently store and control the database.How does DBMS differs from MS Excel?What are the differences between data and information?What is the difference between Conceptual Model and Physical Model?Conceptual Model Conceptual Model helps to overview the organizational schema rather than the database schema.Physical Model Physical Model is the database design which means that this model describes the data storage, data structure, etc. basically we get to know about the physical media of the data storage and the mode of access of that data from this model.What are the difference between Traditional File Management System and Database Management System?Traditional File Management SystemDatabase Management SystemFile management Systems are relatively sma ll in size and volumeDatabase Management Systems are comparatively larger in size.They are cheaper to implementMuch costlier to implementIt deals with few filesIt deals with a large number of files.The structure of this system is very simpleThe structure is very much complex in nature.There are many redundant data.Redundant data is very much reduced.Data inconsistency takes place in File Management SystemData inconsistency is checked in the DBMSIn File Management System data is isolated.In DBMS data can be shared.There is no security.It is secured.Very simple and primitive form of backup and recovery.Highly sophisticated and complex form of backup and recovery.Mainly single user.Most of the time its multiuser.Less preliminary designVast preliminary designWhat do you mean by Data Duplicity?Data Duplicity means repetition of the same data more than once in the same database. Data Duplicity causes lot of problems likeIt is waste of time and money.It leads to loss of data integrity.It t akes up additional storage and increases the size of the database which effects the search time.What do you mean by Data Dependency?In a File Processing System the specific physical format of file and record were hard coded on the application programs. So a change in database format required the codes to be updated.What is data isolation?Data Isolation means a data which is isolated form other databases that means when data can not be shared. It is not possible to share data in a File Processing System so the data remains in a isolated condition.Write down the necessary steps to secure a data into a database.What do you mean by redundant data?Data Redundancy means duplication of data. A same data may be present more than onces leading to data inconsistency.Write down the applications of Database Management System.There are many applications of Database Management System , some of them are explained belowRailway for making the railway enquiry and reservation system to work properly t here is a needed of implementing DBMS as all the data has to be stored in a centralized location and the data is then used by every railway stations throughout the country.Banking As now a days there are many branches of a bank there has to be a DBMS to track and record the transactions of every customers. This will have not been possible if File Management System were used.Schools/Colleges and Universities To store the records of students like their name, roll number, address, contact number, marks obtained, etc a DBMS is used so that the database can be updated easily.Business and Offices To store the companys sales, profit , etc and its record of employees a sophisticated DBMS is used.Who are the End Users? How many types of End Users are there in DBMS?End User The one who uses the database, it may be that he/she only views the database or it may be that he/she makes the data entries. Make queries, etcThere may be different types of end user, for example Sophisticated these are t he users who has a good knowledge in database and can make queries, with SQL manipulate data with DML (Data Manipulating Language)Specialized who makes application programs that interacts with the databaseNative only interacts with the database via some sophisticated programs