Home Page Icon
Home Page
Table of Contents for
Back Cover
Close
Back Cover
by ITL Education Solutions Limited
Introduction to Database Systems
Cover
Title Page
Contents
Preface
Chapter 1. Database System
1.1 Need of Database System
1.2 Advantages of Database System
1.3 Developments in Database System
1.4 Application Areas of Database System
1.5 Cost and Risk of Database System
1.6 People Who Interact with Databases
1.7 DBMS Architecture and Data Independence
1.8 Database Models
1.9 Database Schema versus Database Instance
1.10 DBMS Languages
1.11 Component Modules of DBMS
1.12 Centralized and Client/Server Database Systems
1.13 Classification of DBMSS
1.14 Database Design Process
Summary
Key Terms
Exercises
Chapter 2. Conceptual Modeling
2.1 Concepts of Entity-Relationship Model
2.2 Entity-Relationship Diagram
2.3 Enhanced E-R Model
2.4 Alternative Notations for E-R Diagrams
2.5 Unified Modeling Language
Summary
Key Terms
Exercises
Chapter 3. The Relational Model
3.1 Relational Model Concepts
3.2 Relational Database Schema
3.3 Relational Database Instance
3.4 Keys
3.5 Data Integrity
3.6 Constraint Violation while Updating Data
3.7 Mapping E-R Model to Relational Model
Summary
Key Terms
Exercises
Chapter 4. Relational Algebra and Calculus
4.1 Relational Algebra
4.2 Relational Calculus
4.3 Expressive Power of Relational Algebra and Relational Calculus
Summary
Key Terms
Exercises
Chapter 5. Structured Query Language
5.1 Basic Features of SQL
5.2 Data Definition
5.3 Data Manipulation Language
5.4 Complex Queries in SQL
5.5 Additional Features of SQL
5.6 Accessing Databases from Applications
Summary
Key Terms
Exercises
Chapter 6. Relational Database Design
6.1 Features of Good Relational Design
6.2 Decomposition
6.3 Functional Dependencies
6.4 Normal Forms
6.5 Insufficiency of Normal Forms
6.6 Comparison of BCNF and 3NF
6.7 Higher Normal Forms
6.8 Denormalization
Summary
Key Terms
Exercises
Chapter 7. Data Storage and Indexing
7.1 Hierarchy of Storage Devices
7.2 Redundant Arrays of Independent Disks
7.3 New Storage Systems
7.4 Accessing Data from Disk
7.5 Placing File Records on Disk Blocks
7.6 Organization of Records in Files
7.7 Indexing
Summary
Key Terms
Exercises
Chapter 8. Query Processing and Optimization
8.1 Query Processing Steps
8.2 External Sort-Merge Algorithm
8.3 Algorithms for Relational Algebra Operations
8.4 Expressions Containing Multiple Operations
8.5 Query Optimization
8.6 Query Optimization in Oracle
Summary
Key Terms
Exercises
Chapter 9. Introduction to Transaction Processing
9.1 Desirable Properties of a Transaction
9.2 States of a Transaction
9.3 Concurrent Execution of Transactions
9.4 Transaction Schedules
9.5 SQL Transaction Statements
Summary
Key Terms
Exercises
Chapter 10. Concurrency Control Techniques
10.1 Locking
10.2 Lock-Based Techniques
10.3 Specialized Locking Techniques
10.4 Performance of Locking
10.5 Timestamp-Based Technique
10.6 Optimistic (or Validation) Technique
10.7 Multiversion Technique
10.8 Dealing with Deadlock
Summary
Key Terms
Exercises
Chapter 11. Database Recovery System
11.1 Types of Failures
11.2 Caching of Disk Pages
11.3 Recovery Related Steps During Normal Execution
11.4 Recovery Techniques
11.5 Recovery for Concurrent Transactions
11.6 ARIES Recovery Algorithm
11.7 Recovery from Catastrophic Failures
Summary
Key Terms
Exercises
Chapter 12. Database Security
12.1 Security Issues
12.2 Role of DBA in Database Security
12.3 Authorization
12.4 Authentication
12.5 Access Control
12.6 Encryption
12.7 Statistical Database
Summary
Key Terms
Exercises
Chapter 13. Database System Architectures
13.1 Overview of Parallel DBMS
13.2 Distributed DBMS
13.3 Client/Server Systems
Summary
Key Terms
Exercises
Chapter 14. Data Warehousing, OLAP, and Data Mining
14.1 Data Warehousing
14.2 Online Analytical Processing (OLAP)
14.3 Data Mining Technology
Summary
Key Terms
Exercises
Chapter 15. Information Retrieval
15.1 Information Retrieval Systems
15.2 Indexing of Text Documents
15.3 Web Search Engines
Summary
Key Terms
Exercises
Chapter 16. Object-Based Databases
16.1 Need for Object-Based Databases
16.2 Object Relational Database Systems
16.3 Object-Oriented Database Management Systems
16.4 OODBMS versus ORDBMS
Summary
Key Terms
Exercises
Chapter 17. XML
17.1 Structured, Semi-Structured, and Unstructured Data
17.2 Overview of XML
17.3 Structure of XML Data
17.4 DTD and XML Schema
17.5 Querying XML Data
17.6 Approaches to Store XML Data
17.7 Uses of XML
Summary
Key Terms
Exercises
Chapter 18. Leading Database Systems
18.1 PostgreSQL
18.2 Oracle
18.3 Microsoft SQL Server
18.4 IBM DB2 Universal Database
Summary
Key Terms
Exercises
Case Study 1. Hospital Management System
Aim
Description
Tables Description
E-R Diagram
Relational Database Schema for Case Study
Implementation in SQL Server
Case Study 2. Railway Reservation
Aim
Description
List of Assumptions
E-R Diagram
Description of Tables and Procedures
Relational Database Schema for Case Study
Appendix A. Microsoft Access as Database Management System
A.1 Components of Access
A.2 Starting Access
A.3 Working with Tables
A.4 Working with Queries
A.5 Working with Forms
A.6 Working with Reports
Appendix B. SQL Extensions for Data Analysis
B.1 Extensions to GROUP BY Clause
B.2 New Analytic Functions
B.3 Top-N Queries
B.4 Windowing in SQL:1999
Appendix C. Abbreviations, Acronyms, and Symbols
Appendix D. E. F. Codd’s Rules
Glossary
Acknowledgements
Copyright
Back Cover
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Prev
Previous Chapter
Copyright
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset