Introduction to database systems

Format:

Book

Author/Creator:

Limited, ITL, author.

ITL Education Solutions, Corporate Author.

Contributor:

ITL Education Solutions.

Language:

English

Physical Description:

1 online resource (xi, 580 p.) : ill.

Edition:

1st edition

Place of Publication:

[Place of publication not identified] Dorling Kindersley India 2008

Language Note:

English

System Details:

text file

Summary:

The book deals with implementation, design and application of DBMS and complicated topics such as relational algebra and calculus, and normalization are explained in a very simple manner.

Contents:

Cover

Introduction to Database Systems

Copyright

Contents

Preface

Database System

Need of Database System

Advantages of Database System

Developments in Database System

Application Areas of Database System

Cost and Risk of Database System

People Who Interact with Databases

DBMS Architecture and Data Independence

Database Models

Database Schema versus Database Instance

DBMS Languages

Component Modules of DBMS

Centralized and Client/Server Database Systems

Classification of DBMSs

Database Design Process

Summary

Key Terms

Exercises

Conceptual Modeling

Concepts of Entity-Relationship Model

Entity-Relationship Diagram

Enhanced E-R Model

Alternative Notations for E-R Diagrams

Unified Modeling Language

The Relational Model

Relational Model Concepts

Relational Database Schema

Relational Database Instance

Keys

Data Integrity

Constraint Violation while Updating Data

Mapping E-R Model to Relational Model

Relational Algebra and Calculus

Relational Algebra

Relational Calculus

Expressive Power of Relational Algebra and Relational Calculus

Structured Query Language

Basic Features of SQL

Data Definition

Data Manipulation Language

Complex Queries in SQL

Additional Features of SQL

Accessing Databases from Applications

Relational Database Design

Features of Good Relational Design

Decomposition

Functional Dependencies

Normal Forms

Insufficiency of Normal Forms

Comparison of BCNF and 3NF

Higher Normal Forms

Denormalization

Data Storage and Indexing

Hierarchy of Storage Devices.

Redundant Arrays of Independent Disks

New Storage Systems

Accessing Data from Disk

Placing File Records on Disk Blocks

Organization of Records in Files

Indexing

Queryp Rocessing and Optimization

Query Processing Steps

External Sort-Merge Algorithm

Algorithms for Relational Algebra Operations

Expressions Containing Multiple Operations

Query Optimization

Query Optimization in Oracle

Introduction to Transaction Processing

Desirable Properties of a Transaction

States of a Transaction

Concurrent Execution of Transactions

Transaction Schedules

SQL Transaction Statements

Concurrency Control Tenchniques

Locking

Lock-Based Techniques

Specialized Locking Techniques

Performance of Locking

Timestamp-Based Technique

Optimistic Technique

Multiversion Technique

Dealing with Deadlock

Database Recovery System

Types of Failures

Caching of Disk Pages

Recovery Related Steps During Normal Execution

Recovery Techniques

Recovery for Concurrent Transactions

ARIES Recovery Algorithm

Recovery from Catastrophic Failures

Database Security

Security Issues

Role of DBA in Database Security

Authorization

Authentication

Access Control

Encryption

Statistical Database

Databasesy Stem Architectures

Overview of Parallel DBMS

Distributed DBMS

Client/Server Systems

Data Warehousing, Olap, and Data Mining

Data Warehousing

Online Analytical Processing

Data Mining Technology

Information Retrieval

Information Retrieval Systems.

Indexing of Text Documents

Web Search Engines

Object-Based Databases

Need for Object-Based Databases

Object Relational Database Systems

Object-Oriented Database Management Systems

OODBMS versus ORDBMS

XML

Structured, Semi-Structured, and Unstructured Data

Overview of XML

Structure of XML Data

DTD and XML Schema

Querying XML Data

Approaches to Store XML Data

Uses of XML

Leading Database Systems

Postgre SQL

Oracle

Microsoft SQL Server

IBM DB2 Universal Database

Hospital Management System

Aim

Description

Tables Description

E-R Diagram

Relational Database Schema for Case Study

Implementation in SQL Server

Railway Reservation

List of Assumptions

Description of Tables and Procedures

Microsoft Access as Database Management System

Components of Access

Starting Access

Working with Tables

Working with Queries

Working with Forms

Working with Reports

SQL Extensions for Data Analysis

Extensions to GROUP bY Clause

New Analytic Functions

Top-N Queries

Windowing in SQL:1999

Abbreviations, Acronyms, and Symbols

E. F. Codd's Rules

Glossary

Index.

Notes:

Bibliographic Level Mode of Issuance: Monograph

Includes index.

Description based on publisher supplied metadata and other sources.

ISBN:

9786612652592

9781282652590

1282652591

9788131743195

8131743195

OCLC:

732019174