Distributed Database Management

ISBN-13: 9780470407455 / Angielski / Twarda / 2010 / 768 str.

Saeed K. Rahimi; Frank S. Haug

Opis

This book addresses issues related to managing data across a distributed database system. It is unique because it covers traditional database theory and current research, explaining the difficulties in providing a unified user interface and global data dictionary. The book gives implementers guidance on hiding discrepancies across systems and creating the illusion of a single repository for users. It also includes three sample frameworks--implemented using J2SE with JMS, J2EE, and Microsoft .Net--that readers can use to learn how to implement a distributed database management system. IT and development groups and computer sciences/software engineering graduates will find this guide invaluable.

Recenzje

"The chapters are clearly written and all the technical details are thoroughly displayed." (Zentralblatt MATH, 2011)

 

Spis treści

Preface.

1 Introduction.

1.1 Database Concepts.

1.2 DBE Architectural Concepts.

1.3 Archetypical DBE Architectures.

1.4 A New Taxonomy.

1.5 An Example DDBE.

1.6 A Reference DDBE Architecture.

1.7 Transaction Management in Distributed Systems.

1.8 Summary.

1.9 Glossary.

References.

References. 

2 Data Distribution Alternatives.

2.1 Design Alternatives.

2.2 Fragmentation.

2.3 Distribution Transparency.

2.4 Impact of Distribution on User Queries.

2.5 A More Complex Example.

2.6 Summary.

2.7 Glossary.

References.

Exercises. 

3 Database Control.

3.1 Authentication.

3.2 Access Rights.

3.3 Semantic Integrity Control.

3.4 Distributed Semantic Integrity Control.

3.5 Cost of Semantic Integrity Enforcement.

3.6 Summary.

3.7 Glossary.

References.

Exercises. 

4 Query Optimization.

4.1 Sample Database.

4.2 Relational Algebra.

4.3 Computing Relational Algebra Operators.

4.4 Query Processing in Centralized Systems.

4.5 Query Processing in Distributed Systems.

4.6 Summary.

4.7 Glossary.

References.

Exercises. 

5 Controlling Concurrency.

5.1 Terminology.

5.2 Multitransaction Processing Systems.

5.3 Centralized DBE Concurrency Control.

5.4 Concurrency Control in Distributed Database Systems.

5.5 Summary.

5.6 Glossary.

References.

Exercises. 

6 Deadlock Handling.

6.1 Deadlock Definition.

6.2 Deadlocks in Centralized Systems.

6.3 Deadlocks in Distributed Systems.

6.4 Summary.

6.5 Glossary.

References.

Exercises. 

7 Replication Control.

7.1 Replication Control Scenarios.

7.2 Replication Control Algorithms.

7.3 Summary.

7.4 Glossary.

References.

Exercises. 

8 Failure and Commit Protocols.

8.1 Terminology.

8.2 Undo/Redo and Database Recovery.

8.3 Transaction States Revisited.

8.4 Database Recovery.

8.5 Other Types of Database Recovery.

8.6 Recovery Based on Redo/Undo Processes.

8.7 The Complete Recovery Algorithm.

8.8 Distributed Commit Protocols.

8.9 Summary.

8.10 Glossary.

References.

Exercises. 

9 DDBE Security (Bradley S. Rubini).

9.1 Cryptography.

9.2 Securing Communications.

9.3 Securing Data.

9.4 Architectural Issues.

9.5 A Typical Deployment.

9.6 Summary.

9.7 Glossary.

References.

Exercises. 

10 Data Modeling Overview.

10.1 Categorizing MLs and DMs.

10.2 The Conceptual Level of the CLP.

10.3 Conceptual Modeling Language Examples.

10.4 Working With Data Models.

10.5 Using Multiple Types of Modeling.

10.6 Summary.

10.7 Glossary.

References.

Exercises. 

11 Logical Data Models.

11.1 The RDM.

11.2 The Network Data Model.

11.3 The Hierarchical Data Model.

11.4 The OODM.

11.5 Summary.

11.6 Glossary.

References.

Exercises. 

12 Traditional DDBE Architectures.

12.1 Applying Our Taxonomy to Traditional DDBE Architectures.

12.2 The MDBS Architecture Classifications.

12.3 Approaches for Developing A DDBE.

12.4 Deployment of DDBE Software.

12.5 Integration Challenges.

12.6 Schema Integration Example.

12.7 Example of Existing Commercial DDBEs.

12.8 The Experiment.

12.9 Summary.

12.10 Glossary.

References.

Exercises. 

13 New DDBE Architectures.

13.1 Cooperative DBEs.

13.2 Peer–to–Peer DDBEs.

13.3 Comparing COOP and P2P.

13.4 Summary.

13.5 Glossary.

References.

Exercises. 

14 DDBE Platform Requirements.

14.1 DDBE Architectural Vocabulary.

14.2 Fundamental Platform Requirements.

14.3 Distributed Process Platform Requirements.

14.4 Distributed Data Platform Requirements.

14.5 Preview of the DDBE Platforms Used in Chapters 15–9.

14.6 Summary.

14.7 Glossary.

References.

Exercises. 

15 The JMS Starter Kit.

15.1 Java Message Service Overview.

15.2 JMS Provider Implementation Alternatives.

15.3 JMS Starter Kit (JMS–SKIT) Framework Overview.

15.4 Using the JMS–SKIT Framework.

15.5 Summary.

15.6 Glossary.

References.

Exercises. 

16 The J2EE Platform.

16.1 Java 2 Enterprise Edition (J2EE) Overview.

16.2 J2EE Support for Distributed Process Platform Requirements.

16.3 J2EE Support for Distributed Data Platform Requirements.

16.4 J2EE Platform Implementation Alternatives.

16.5 Summary.

16.6 Glossary.

References.

Exercises. 

17 The J2EE Starter Kit.

17.1 Java 2 Enterprise Edition Starter Kit (J2EE–SKIT) Overview.

17.2 J2EE–SKIT Design Overview.

17.3 Summary.

17.4 Glossary.

References.

Exercises. 

18 The Microsoft .NET Platform.

18.1 Platform Overview.

18.2 Support for Distributed Process Platform Requirements.

18.3 Distributed Data Platform Requirements.

18.4 Summary.

18.5 Glossary.

References.

Exercises. 

19 The DNET Starter Kit.

19.1 DNET–SKIT Overview.

19.2 DNET–SKIT Design Overview.

19.3 Summary.

19.4 Glossary.

Reference.

Exercises. 

Index.

O autorze

Saeed K. Rahimi, PhD, is an associate professor with the Graduate Program in Software at the University of St. Thomas. He is also a cofounder of DWSoft Corporation and InfoSpan, two companies specializing in metadata  management for data warehousing. He had been a database design and implementation consultant, providing services to the industry and the federal government for over thirty years. He has spoken in many national and international conferences and has published many scientific articles. Dr. Rahimi holds a BS in electrical engineering and a PhD, both in computer science, from the University of Minnesota.

Frank S. Haug is an adjunct professor with the Graduate Programs in Software at the University of St. Thomas, where he has taught graduate courses in software development, distributed database management systems, and data warehousing. He has over twenty–five years of experience in academia and industry, working in areas including software development, database design and implementation, and network administration to implement projects across many technology platforms, DDBMS, and programming languages. Mr. Haug had a BA in mathematics and quantitative methods and computer science, and an MS in software engineering, both from the University of St. Thomas.

Blurb

Unique coverage of traditional database theory and current research for building easier–to–mange distributed database systems

A distributed database management system (DDBMS) is a layer of software, implemented on top of existing database management systems, allowing users transparent access to information dispersed across a network. This book addresses the architectural and platform issues on the design and development of a DDBMS, guiding readers in building their own systems in real–world environments.

Distributed Database Management Systems is divided into three units. The first provides a theoretical foundation for understanding the internal processing of the DDBMS available to address these issues. The second unit presents the state of the practice, examining the architectural alternatives that practitioners will likely encounter in the real world and the exploring the general requirements for any platform capable of implementing a DDBMS architectural alternative including those yet to be invented. The final unit focuses on distributed database implementation, examining three platforms suitable for the development of a real DDBMS system the Java Message Service (JMS), the Java 2 Enterprise Edition (J2EE), and the Microsoft .NET Framework. For each, a starter kit is provided (containing a detailed overview and an extensible framework) and discussed in detail.