ADVANCED DATABASE MANAGEMENT SYSTEM THIS BOOK COVERS:
Introduction to DBMS t Advanced SQL Concepts t Advanced Transaction Processing and Recovery t Data Security t t Implementation of Storage and Indexing t Distributed Databases t Object Databases t Introduction to Data Warehousing t Introduction to Dimensional Modeling t Introduction to ETL Process t Introduction to OLAP
here has been a rapid growth and development in the field of relational database management systems. This book provides an in-depth analysis of advanced database areas as well as the basics of database management systems. It explores the different SQL concepts, starting from the very basic DDL and DML statements to constraints and views. The theme of this book is the potential of various database management systems. The book combines advanced techniques with practical advice and many new ideas, methods, and examples for database management students, system specialists, and programmers. It provides a wealth of technical information on database methods and an encyclopedic coverage of advanced techniques. This book is a valuable source of information for academics, practitioners, and post and under graduate students with a good overview of the basic notions, methods, and techniques as well as important issues and trends across the broad spectrum of data management. SALIENT FEATURES: u Provides simple, clear, and concise language, which makes the book an easy and enjoyable read u Follows a code-centric approach and provides code snippets wherever applicable u Provides well-structured text and illustrative block diagrams and figures wherever required u Includes chapter objectives and advance organizer at the beginning of each chapter to describe what the reader
would learn in the chapter u Includes a comprehensive and detailed coverage of each topic to meet the requirements of the target audience,
including postgraduates,undergraduates, and professionals u Provides various scenario-based questions as labs with solutions
ISBN: 9789351194552 | Price: 399/- | Pages: 352 | Authors: Rini Chakrabarti, Shilbhadra Dasgupta, Subhash K. Shinde, KLSI
TABLE OF CONTENTS: Chapter 1: Introduction to DBMS: Introduction | Data versus Information | Record | The File System | The Evolution of Database | Defining a Database | Entities and Relationships | Data Models | Database Design | Types of Databases | Transaction Management | Introduction to SQL Chapter 2: Advanced SQL: Introduction | Constraints | SQL CREATE INDEX | SQL Functions | The GROUP BY Statement | The HAVING Clause | SQL Special Functions | SQL Alias | SQL Join | Sub-Queries | Recursive Queries | Data Control Language | Views and Assertion Chapter 3: Advanced Transaction Processing and Recovery: Introduction | Defining a Transaction in DBMS | Defining a Concurrent Transaction in DBMS | Serializability and Recoverability | Enhanced Lock-Based and TimestampBased Protocols | Multiple Granularity | Multi-Version Schemes Chapter 4: Data Security: Introduction | Introduction to Data Security Issues | Discretionary Access Control | Mandatory Access Control | Role-Based Access Control | SQL Injection | Statistical Databases | Introduction to Flow Control Chapter 5: Storage and Indexing: Introduction | Basics of Database Storage | Operations on Files | Hashing Techniques | File Indexing | Types of Single-Level Ordered Indexes | Multi-Level Indexes | Dynamic Multi-Level Indexes | Indexing on Multiple Keys Chapter 6: Distributed Databases: Introduction | Differences between Centralized DBMS and Distributed DBMS | Functionality of DDBMS | Advantages and Disadvantages of DDBMS | Centralized versus NonCentralized Databases | Homogeneous and Heterogeneous DDBMS and Their Comparison
Chapter 7: Object Database: Introduction | Overview of the Object-Oriented Database | Limitations of Relational Database | Need for Complex Data Type | Collection Types and Structured Types | Data Definition | Object Identity and Reference Types | Persistent Programming Languages Chapter 8: Introduction to Data Warehousing: Introduction | The Need for Data Warehousing | Data Warehousing: An Information Environment | Increased Demand for Strategic Information | Inability of Past Decision Support System Chapter 9: Introduction to Dimensional Modeling: Introduction | Data Warehouse Modeling vs. Operational Database Modeling | Dimensional Model vs. the ER Model | Features of a Good Dimensional Model | Introducing the Fact Table | Introducing the Dimension Table | The Factless Face Table | The Star Schema | Snowflake Schema | Updates to Dimension Tables | Slowly Changing Dimensions | Large Dimension Tables | Rapidly Changing or Large Slowly Changing Dimensions | Junk Dimensions Chapter 10: ETL Process: Introduction | Overview of the ETL Process | Need for the ETL Process | Data Extraction | Identification of Data Source | Extraction Methods in Data Warehouse | Change Data Capture | Transportation in Data Warehouses | Transformation | Staging | Loading | Fact Tables | Dimension Tables | Cleaning | Tools for ETL | Chapter 11: Online Analytical Processing (OLAP): Introduction | Introduction to OLAP | Need for OLAP | OLAP Models | OLTP Vs OLAP | Multidimentional Analysis or Data Cube | On-Line Analytical Processing (OLAP)
WILEY INDIA PVT. LTD. DREAMTECH PRESS 4435-36/7, Ansari Road, Daryaganj 19-A, Ansari Road, Daryaganj New Delhi-110 002, INDIA New Delhi-110 002, INDIA Tel: +91-11-4363 0000, Fax: +91-11-2327 5895 Tel: +91-11-2324 3463-73, Fax: +91-11-2324 3078 Email: [email protected] Email: [email protected] Website: www.wileyindia.com Website: www.dreamtechpress.com Regional Offices: Bangalore: Tel: +91-80-2313 2383, Fax: +91-80-2312 4319, Email: [email protected] Mumbai: Tel: +91-22-2788 9263, 2788 9272, Telefax: +91-22-2788 9263, Email: [email protected] /dtechpress
Exclusively Distributed by:
