Expect problems and eat them for breakfast.
--Your friends at LectureNotes

Note for Database Management System - DBMS by harika emany

  • Database Management System - DBMS
  • Note
  • Computer Science Engineering
  • B.Tech
  • 11 Topics
  • 4 Offline Downloads
  • Uploaded 9 months ago
Harika H
Harika H
0 User(s)
Download PDFOrder Printed Copy

Share it with your friends

Leave your Comments

Text from page-2

____________________________________D Daattaabbaassee M Maannaaggeem meenntt SSyysstteem mss 1. Define the term data? A collection of known facts can be recorded and which have implicit meaning, is known as Data. Example: Stud_name, Emp_Id, Emp_Photo, Movie_clip, etc. 2. Define the term Database? A Database is a collection of related data, used for specific purpose by one or more groups of users and can be stored in auxiliary storage with minimum redundancy. The Database must be organized and managed so that users can search for, retrieve and update the data as they need. Example: Student [ Stud_id, Stud_name, Course_join, Fee_paid, Date_of_Join ] Employee [ Emp_id, Emp_name, Emp_desig, Emp_sal, Emp_dept ] 3. Define the term DBMS? A DBMS is a collection of programs that enables users to create and maintain Database. The DBMS facilitates the process of defining, constructing and manipulating Databases. 4. Define the term Metadata? The definition of data is known as metadata. It includes the structure of each file, the type and storage format of each data item and various constraints on the data. Example: Employee Emp_id number(2) Primary Key, Emp_name varchar2(20) not null, Emp_desig varchar2(15) not null, Date_join date, Emp_sal number(9,2) check (emp_sal between 1000 and 35000) 5. Explain the characteristics of the Database approach? The main characteristics of the Database approach are: a. Self defining nature of the Database system. b. Insulation between programs and data and data abstraction. c. Support of multiple vies of data. d. Sharing of data and multi user transaction processing. a) Self defining nature of the Database system The fundamental characteristic of the Database approach is defining the metadata, which means that definition of data and its domain. This metadata can be placed in a centralized 2 ********TVSN KLU ECM*********

Text from page-3

____________________________________D Daattaabbaassee M Maannaaggeem meenntt SSyysstteem mss - location called repository or catalog. This repository is used by DBMS software and also by Database users who need information about the Database structure. In traditional file processing, a data definition is a part of the application programs themselves. So these programs are constrained to work with only one specific Database, whose structure is declared in the application programs. 1. The file processing software can access only specific Databases, whereas DBMS software can access number of Databases by extracting Database definitions from the repository. 2. In file processing software, when a request can made by a user, the exact location of that record was known by the application program and then locate that record, whereas in DBMS the DBMS software refers the repository to determine the structure of the Database and then find the record location. b) Insulation between programs and data and data abstraction In traditional file processing system, the structure of data file is included in the programs, so any changes to the structure of a data file may require changing all programming that access that file. But in DBMS, the access program don’t require changes the structure of the file, because the structure of Database or data file is stored in repository which is centralized location to all access programs of the programs. This property is known as program data independence. In object oriented Databases, users can define operations on data as part of the Database definitions. An operation can be in two parts. The interface and implementation. The interface includes the operation name and the data types of its arguments. The implementation (function/method) is specified separately and can be changed without effecting the interface. The user application programs can operate on data by invoking the operations with their arguments rather than how the operations are implemented. This is called program-operation independence. This characteristic that allows both program data independence and program operation independence is called as data abstraction. c) Support multiple views of data A view is a subset of Database or it may contain virtual data that may derive from a base table or Database. A multi user DBMS whose users may have several applications must provide facilitate for defining multiple views on one Database. d) Sharing of data and multi user transaction processing 3 ********TVSN KLU ECM*********

Text from page-4

____________________________________D Daattaabbaassee M Maannaaggeem meenntt SSyysstteem mss A Client/Server or multiuser DBMS must allow multiple users to access the Database at the same time. For this the DBMS must include concurrency control software to ensure that several users trying to update the same data. These updations are maintained by the concurrent control software. Also these types of applications are referred as OLAP applications. 6. Explain the advantages of using DBMS? For good DBMS software, there are several advantages. They are: a) Controlling redundancy. b) Restricting unauthorized access. c) Providing persistent storage for program objects and data structures. d) Permitting interfering and actions using rules. e) Providing multiple user interfaces. f) Representing complex relationships and data. g) Enforcing integrity constraints. h) Providing backup and recovery. a. Controlling redundancy Redundancy means, storing of same data multiple times in multiple files. This leads several problems. 1. If any data item needs to update, it need to update multiple times. 2. Storage space was waster when a system have redundancy. This may creates problem when we use large Databases. 3. Due to redundancy the data consistency was in very high rate. In DBMS, due to we have repository/catalog, the data can be stored at a centralized location, utmost redundancy was eliminated/controlled. When the redundancy was controlled, it will be improved the Database engine’s performance. b. Restricting unauthorized access When we have multiple user environments, typically the Client/Server environment, the users share a Database. In those, some users are fully authorized and some users are partial authorized. Some users may permitted on only retrieving or selection operation, some users may permitted to update and others may permitted both operations. To restrict this type of accessing, the DBMS has given an account name and passwords for each user group. Also the DBMS should provide a security and authorization subsystem. Some users called DBA may only have fully privileged user groups. c. Providing persistent storage for program objects and data structure Databases can be used to provide persistent storage for programs and the data Structures (data members/data objects). For ordinary Databases the DBMS used to store 4 ********TVSN KLU ECM*********

Text from page-5

____________________________________D Daattaabbaassee M Maannaaggeem meenntt SSyysstteem mss ordinary storage, but in object oriented databases, persistent/continuous storage technology is used. d. Permitting interfering and actions using rules Some Database systems, such as Oracle, Sybase, etc., provide capabilities for defining deduction rules for interfacing new information from the stored Database facts. In any situation, if there may exists any critical situation for entering and extracting data, these packages are used procedural languages such as PL/SQL. e. Providing multiple user interface The DBMS provide back end facility to all types of GUI (Graphical User Interface) application such as Visual Basic, VC++, Java, Power Builder, etc. these application are used ODBC or JDBS connections to interact with DBMS. f. Representing complex relationships and data A DBMS package must have capability to represent a numerous verities of relationships from one Database to another. Besides of relationships, also provide proper operations such as selection/retrieving, updating and deleting on data. g. Enforcing integrity constraints Restricting the incoming data using some conditions is known as integrity constraints. These constraints are also used to hold proper data in Database. The DBMS provide a verity of integrity constraints to hold proper data. The Database designers take the responsibility to identify the integrity constraints during the Database design. h. Providing backup and recovery Each DBMS should have contained backup and recovery subsystem. This subsystem is responsibility for recovering data from sudden hardware and software failures. The subsystem could also ensure that the program in resumed from the point at which the Database was interrupted. 7. What are the responsibilities of the DBA and Database designers? Database Administrator In Database environment the primary object is Database and DBMS. Administrating these resources is the responsibility of the DBA. The DBA is responsible for: 1. Authorizing access to the Database. 2. Coordinating and monitoring of Database and DBMS. 3. Acquiring software and hardware resources to the environment as it needed. 4. Maintain an account for problems such as security and poor system response time. 5 ********TVSN KLU ECM*********

Lecture Notes