Advanced Database Management System 72n3v

ADVANCED DATABASE MANAGEMENT SYSTEM THIS BOOK COVERS:

` 399/-

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

T

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 | 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 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)

ABOUT THE AUTHORS: Rini Chakrabarti is an IT engineer, currently working in the consultancy department of a software company. She obtained the B.Tech degree in Computer Science & Engineering from University of Calcutta, India and ranked 5th in the whole university in the year 2009. Prior to that, she did Bachelor of Science in Physics (Hons), and ranked 10th in the entire University. Her areas of interest include recent trends and developments in the fields of database management systems, .NET architecture and programming in ASP.NET, ADO.NET, C# and VB.NET. She also keeps track of the recent developments in the field of wireless and sensor networking. Shilbhadra Dasgupta is a software engineer by profession. He is a first class Honours Graduate in Physics from University of Calcutta. He did his post graduation from University of Calcutta in Computer Science & Engineering in 2009. His areas of research and interest include basic networking, database management systems, data warehousing, network simulations, multiplexing, demultiplexing, advancement in the fields of mobile ad-hoc network (MANET), wireless and sensor networks, cellular network, 3G, 4G, security in ad-hoc Networks and QoS in mobile networks. He is also co-authoring a book, “Mobile Ad-hoc Network & Wireless Communications” along with Dr. Nabendu Chaki, Head of the Department of Computer Science & Engineering, University of Calcutta and Mr. S. Banerjee, software engineer, IXIA Technologies. Subhash K. Shinde is a Professor at Lokmanya Tilak College of Engineering, Navi Mumbai. He received B. E. (Computer Engineering) in 1999 and M. E. (Information Technology) in 2004 from university of Mumbai, India. He completed his Ph.D. (Computer Engineering) in October -2012 from Swami Ramanand Teertha Marathwada University, India. Currently, he is working in the field of Programming; Web Mining; Frequent Pattern Discovery; and Integration of domain knowledge, such as ontologies in the mining process and benefits of patterns in web personalized recommendations for e-business. He has published more than 20 research papers in the international journals and conferences. The proficient teams at Kogent Learning Solutions Inc. and Dreamtech Press have seized the market of engineering textbooks, bringing excellent content in engineering and technical education to the fore. The teams at Kogent Learning Solutions, Inc. and Dreamtech Press are committed to providing excellence in quality of content by judiciously analyzing the needs of its readers and ensuring dedication of its authors and editors in catering to these needs. Published by:

/dtechpress

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] /dtechpress

/dreamtechpress

Exclusively Distributed by:

/company/dreamtech-press