--Your friends at LectureNotes

Note for Database Management System - DBMS By jayaprakash o v

  • Database Management System - DBMS
  • Note
  • 4 Topics
  • 9 Offline Downloads
  • Uploaded 1 year ago
0 User(s)
Download PDFOrder Printed Copy

Share it with your friends

Leave your Comments

Text from page-3

Database Management System  Concurrent (Simultaneously) access anomalies.    Accessing the data simultaneously results in improper incorrect results. In multi user environment concurrent access is a essential service, need to meet it and DBMS is achieved it properly through. Security problems.   Security is the important for the vital data, since unauthorized accessing of data results in leakage of information. DBMS loaded with good security mechanism with authorization and authentication. View of Data: A major purpose of a database system is to provide users with an abstract view of the data. That is, the system hides certain details of how the data are stored and maintained. Note: Abstraction is hiding the complexity of the system from the end user. The view of data is classified as follows.  Physical level.  The lowest level of abstraction describes how the data are actually stored.  The physical level describes complex low-level data structures in detail.  Logical level.     The next-higher level of abstraction describes what data are stored in the database, and what relationships exist among those data. The logical level thus describes the entire database in terms of a small number of relatively simple structures. The user of the logical level does not need to be aware of this complexity physicallevel structures, this is referred as physical data independence. View level.   This is the highest level of abstraction describes only part of the entire database. The view level of abstraction exists to simplify their interaction with the system. The system may provide many views for the same database. Below diagram shows the different levels of the views. 3 Raghu Gurumurthy, MCA (Site : www.raghug.in, Phone no: 9060130871)

Text from page-4

Database Management System Instances and Schemas    The collection of information stored in the database at a particular moment is called an instance of the database. The overall design of the database is called the database schema. Self description of the database is called schema. The schemas are classified as below.    The physical schema describes the database design at the physical level. The logical schema describes the database design at the logical level. A database may also have several schemas at the view level, sometimes called subschema‟s, that describe different views of the database. Data Models Underlying the structure of a database is the data model. Data models consists of     A collection of conceptual tools for describing data. Data relationships. Data semantics and consistency constraints. A data model provides a way to describe the design of a database at the physical, logical, and view levels. The data models can be classified into four different categories.     Relational Model. Entity-Relationship Model. Object-Based Data Model. Semi structured Data Model. Database Languages   A database system provides a data-definition language to specify the database schema Data-manipulation language to express database queries and updates. Note: The data-definition and data-manipulation languages are not two separate languages, instead they simply form parts of a single database language, such as the widely used SQL language. Data-Manipulation Language (DML) A data-manipulation language (DML) is a language that enables users to access or manipulate data as organized by the appropriate data model. The types of access are: • Retrieval of information stored in the database • Insertion of new information into the database • Deletion of information from the database • Modification of information stored in the database 4 Raghu Gurumurthy, MCA (Site : www.raghug.in, Phone no: 9060130871)

Text from page-5

Database Management System There are basically two types DMLs: • Procedural DMLs require a user to specify what data are needed and how to get those data. • Declarative DMLs (also referred to as nonprocedural DMLs) require a user to specify what data are needed without specifying how to get those data. Ex: SQL query that finds the names of all instructors in the History department select instructor.name from instructor where instructor.dept name = ‟History‟; Query: A query is a statement requesting the retrieval of information from database. Query language: The portion of a DML that involves information retrieval is called a query language. Data-Definition Language (DDL)      We specify a database schema by a set of definitions expressed by a special language called a data-definition language (DDL). The DDL is also used to specify additional properties of the data. Specify the storage structure and access methods used by the database system by a set of statements in a special type of DDL called a data storage and definition language. The statements define the implementation details of the database schemas, which are usually hidden from the users. DDL facilitate data values stored in the database must satisfy certain consistency constraints. Ex: SQL DDL statement defines the department table create table department (dept name char (20), building char (15), budget numeric (12,2)); Type of constraints  Domain Constraints.     A domain of possible values must be associated with every attribute (for example, integer types, character types, date/time types). Declaring an attribute to be of a particular domain acts as a constraint on the values that it can take. Domain constraints are the most elementary form of integrity constraint and they are tested easily by the system.  Referential Constraints.  There are cases where we wish to ensure that a value that appears in one relation for a given set of attributes also appears in a certain set of attributes in another relation. 5 Raghu Gurumurthy, MCA (Site : www.raghug.in, Phone no: 9060130871)

Text from page-6

Database Management System   Assertions.    When a referential-integrity constraint is violated, the normal procedure is to reject the action that caused the violation. An assertion is any condition that the database must always satisfy. Domain constraints and referential-integrity constraints are special forms of assertions. Authorization.  Authorization differentiates among the users as far as the type of access they are permitted on various data values in the database. These differentiations are expressed in terms of authorization, like  Read authorization, which allows reading, but not modification, of data.  Insert authorization, which allows insertion of new data, but not modification of existing data.  Update authorization, which allows modification, but not deletion, of data.  Delete authorization, which allows deletion of data. Note: We may assign the user all, none, or a combination of these types of authorization. Database users and administrators People who work with a database can be categorized as database users or database administrators. There are four different types of database-system users, differentiated by the way they expect to interact with the system, they are as below.  Naive users    Naive users are unsophisticated users who interact with the system by invoking one of the application programs that have been written previously. The typical user interface for naive users is a forms interface, where the user can fill in appropriate fields of the form. Naive users may also simply read reports generated from the database. Ex: A student who uses university portal to see his/her results.  Application programmers   Application programmers are computer professionals who write application programs. Application programmers can choose from many tools to develop user interfaces. Rapid application development (RAD) tools are tools that enable an application programmer to construct forms and reports with minimal programming effort. 6 Raghu Gurumurthy, MCA (Site : www.raghug.in, Phone no: 9060130871)

Lecture Notes