Distributed database systems

Distributed database systems

Distributed Database Systems discusses the recent and emerging technologies in the field of distributed database technology. The material is up-to-date, highly readable, and illustrated with numerous practical examples. The mainstream areas of distributed database technology, such as distributed dat...

Descripción completa

Detalles Bibliográficos
Autor principal: Ray, Chhanda (-)
Formato: Libro electrónico
Idioma:Inglés
Publicado: Delhi : Pearson : Dorling Kindersley (India) c2009.
Edición:[First edition]
Materias:
Distributed databases.
Database management.
Data warehousing.
Ver en Biblioteca Universitat Ramon Llull:https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009819038506719
Tabla de Contenidos:
  • Cover
  • Distributed Database Systems
  • Copyright
  • Contents
  • Preface
  • Overview of Relational1 DBMS
  • Concepts of Relational Databases
  • Integrity Constraints
  • Normalization
  • Functional Dependencies
  • Normal Forms
  • Relational Algebra
  • Selection Operation
  • Projection Operation
  • Union Operation
  • Set Difference Operation
  • Cartesian Product Operation
  • Intersection Operation
  • Join Operation
  • Division Operation
  • Relational Database Management System
  • Chapter Summary
  • Exercises
  • Review of Database Systems
  • Evolution of Distributed Database System
  • Overview of Parallel Processing System
  • Parallel Databases
  • Benefits of Parallel Databases
  • Parallel Database Architectures
  • Parallel Database Design
  • Data Partitioning
  • Chapter Summary
  • Exercises
  • Distributed Database Concepts
  • Fundamentals of Distributed Databases
  • Features of a Distributed DBMS
  • Advantages and Disadvantages of Distributed
  • An Example of Distributed
  • Homogeneous and Heterogeneous Distributed
  • Functions of Distributed
  • Components of a Distributed
  • Date's 12 Objectives for Distributed Database Systems
  • Chapter Summary
  • Exercises
  • Overview of Computer Networking
  • Introduction to Networking
  • Types of Computer Networks
  • Communication Schemes
  • Network Topologies
  • The OSI Model
  • Network Protocols
  • TCP/IP
  • SPX/IPX
  • NetBIOS
  • APPC
  • DEC net
  • Apple Talk
  • WAP
  • The Internet and the World-Wide Web
  • Chapter Summary
  • Exercises
  • Distributed Database Design
  • Distributed Database Design Concepts
  • Alternative Approaches for Distributed Database Design
  • Objectives of Data Distribution
  • Alternative Strategies for Data Allocation
  • Data Fragmentation
  • Benefits of Data Fragmentation
  • Correctness Rules for Data Fragmentation
  • Different Types of Fragmentation
  • The Allocation of Fragments.
  • Measure of Costs and Benefits for Fragment Allocation
  • Transparencies in Distributed Database Design
  • Data Distribution Transparency
  • Transaction Transparency
  • Performance Transparency
  • DBMS Transparency
  • Chapter Summary
  • Exercises
  • Distributed DBMS Architecture
  • Introduction
  • Client/Server System
  • Advantages and Disadvantages of Client/Server System
  • Architecture of Client/Server Distributed Systems
  • Architectural Alternatives for Client/Server Systems
  • Peer-to-Peer Distributed System
  • Reference Architecture of Distributed DBMSs
  • Component Architecture of Distributed DBMSs
  • Distributed Data Independence
  • Multi-Database System
  • Five-Level Schema Architecture of federated MDBS
  • Chapter Summary
  • Exercises
  • Distributed Transaction Management
  • Basic Concepts of Transaction Management
  • ACID Properties of Transactions
  • Objectives of Distributed Transaction Management
  • A Model for Transaction Management in a Distributed System
  • Classification of Transactions
  • Chapter Summary
  • Exercises
  • Distributed Concurrency Control
  • Objectives of Distributed Concurrency Control
  • Concurrency Control Anomalies
  • Distributed Serializability
  • Classification of Concurrency Control Techniques
  • Locking-based Concurrency Control Protocols
  • Centralized 2PL
  • Primary Copy 2PL
  • Distributed 2PL
  • Majority Locking Protocol
  • Biased Protocol
  • Quorum Consensus Protocol
  • Timestamp-Based Concurrency Control Protocols
  • Basic Timestamp Ordering Algorithm
  • Conservative to Algorithm
  • Multi-version to Algorithm
  • Optimistic Concurrency Control Technique
  • Chapter Summary
  • Exercises
  • Distributed Deadlock Management
  • Introduction to Deadlock
  • Distributed Deadlock Prevention
  • Distributed Deadlock Avoidance
  • Distributed Deadlock Detection and Recovery
  • Centralized Deadlock Detection.
  • Hierarchical Deadlock Detection
  • Distributed Deadlock Detection
  • False Deadlocks
  • Chapter Summary
  • Exercises
  • Distributed Recovery Management
  • Introduction to Recovery Management
  • Failures in a Distributed Database System
  • Steps Followed after a Failure
  • Local Recovery Protocols
  • Immediate Modification Technique
  • Shadow Paging
  • Checkpointing and Cold Restart
  • Distributed Recovery Protocols
  • Two-Phase Commit Protocol
  • Three-Phase Commit Protocol
  • Network Partition
  • Pessimistic Protocols
  • Optimistic Protocols
  • Chapter Summary
  • Exercises
  • Distributed Query Processing
  • Concepts of Query Processing
  • Objectives of Distributed Query Processing
  • Phases in Distributed Query Processing
  • Query Decomposition
  • Query Fragmentation
  • Global Query Optimization
  • Join Strategies in Fragmented Relations
  • Simple Join Strategy
  • Semijoin Strategy
  • Global Query Optimization Algorithms
  • Distributed INGRES Algorithm
  • Distributed R* Algorithm
  • SDD-1 Algorithm
  • Chapter Summary
  • Exercises
  • Distributed Database Security and Catalog Management
  • Distributed Database Security
  • View Management
  • View Updatability
  • Views in Distributed DBMS
  • Authorization and Protection
  • Centralized Authorization Control
  • Distributed Authorization Control
  • Semantic Integrity Constraints
  • Global System Catalog
  • Contents of Global System Catalog
  • Catalog Management in Distributed Systems
  • Chapter Summary
  • Exercises
  • Mobile Databases and Object-Oriented DBMS
  • Mobile Databases
  • Mobile DBMS
  • Introduction to Object-Oriented Databases
  • Object-Oriented Database Management Systems
  • Features of OODBMS
  • Benefits of OODBMS
  • Disadvantages of OODBMS
  • Chapter Summary
  • Exercises
  • Distributed Database Systems
  • SDD-1 Distributed Database System
  • General Architecture of SDD-1 Database System.
  • Distributed Concurrency Control in SDD-1
  • Distributed Query Processing in SDD-1
  • Distributed Reliability and Transaction Commitment in SDD-1
  • R* Distributed Database System
  • Architecture of R*
  • Query Processing in R*
  • Transaction Management in R*
  • The Presumed Abort Protocol
  • The Presumed Commit Protocol
  • Chapter Summary
  • Exercises
  • Data Warehousing and Data Mining
  • Concepts of Data Warehousing
  • Benefits of Data warehousing
  • Problems in Data Warehousing
  • Data Warehouses and OLTP Systems
  • Data Warehousing Architecture
  • Operational Data Source
  • Load Manager
  • Query Manager
  • Warehouse Manager
  • Detailed Data
  • Summarized Data
  • Archive/Backup Data
  • Metadata
  • End-User Access Tools
  • Data Warehouse Background Processes
  • Data Warehouse Schema
  • Star Schema
  • Snowflake Schema
  • Fact Constellation Schema
  • Data Marts
  • Online Analytical Processing
  • OLAP Tools
  • Introduction to Data Mining
  • Knowledge Discovery in Database Vs. Data Mining
  • Data Mining Techniques
  • Predictive Modeling
  • Clustering
  • Link Analysis
  • Chapter Summary
  • Exercises
  • Appendix
  • Bibliography
  • Index.

Ejemplares similares