Distributed Database Systems / Edition 1
by David Bell
Distributed database systems have now come of age with the announcement of several commercial products (Oracle, Ingres, Multi-Star) which meet the urgent need for integration of heterogeneous collections of data. This book adopts a practical approach, reviewing the fundamentals of database technology and developments in data communications (including standards)
… See more details belowOverview
Distributed database systems have now come of age with the announcement of several commercial products (Oracle, Ingres, Multi-Star) which meet the urgent need for integration of heterogeneous collections of data. This book adopts a practical approach, reviewing the fundamentals of database technology and developments in data communications (including standards) before reviewing the principles of distributed DB systems. It includes case studies of the leading products.
Product Details
- ISBN-13:
- 9780201544008
- Publisher:
- Addison-Wesley
- Publication date:
- 02/26/1992
- Series:
- International Computer Science Series
- Pages:
- 410
- Product dimensions:
- 7.02(w) x 9.48(h) x 1.08(d)
Table of Contents
| Preface | ||
| 1 | Introduction | 1 |
| 1.1 | Introduction | 1 |
| 1.2 | The pressure to distribute data | 2 |
| 1.3 | Heterogeneity and data distribution | 5 |
| 1.4 | Integrating other kinds of information system | 8 |
| 2 | Overview of Databases and Computer Networks | 14 |
| 2.1 | Introduction | 14 |
| 2.2 | Database technology | 14 |
| 2.3 | Computer networks | 37 |
| 2.4 | Distributed databases | 44 |
| 3 | The State of the Art | 63 |
| 3.1 | Introduction | 63 |
| 3.2 | Distributed database products, prototypes and proposals | 64 |
| 3.3 | Two products | 65 |
| 3.4 | Two multidatabase systems | 72 |
| 3.5 | Two research systems | 80 |
| 4 | Data Handling--Distribution and Transformation | 92 |
| 4.1 | Introduction | 92 |
| 4.2 | The data placement and allocation problem | 93 |
| 4.3 | Some examples of data placement and allocation | 94 |
| 4.4 | A semantic approach to the problem | 98 |
| 4.5 | A practical combinatorial optimization approach to the file allocation problem | 100 |
| 4.6 | Integration of heterogeneous database systems | 106 |
| 4.7 | The global data model | 108 |
| 4.8 | Getting a relational schema equivalent to a network schema | 110 |
| 4.9 | Processing relational queries against the network database | 116 |
| 5 | Distributed Query Optimization | 122 |
| 5.1 | Introduction | 122 |
| 5.2 | The importance of query optimization | 124 |
| 5.3 | Equivalence transforms | 130 |
| 5.4 | Generating and selecting access plans in centralized systems | 132 |
| 5.5 | Methods of performing JOINs | 136 |
| 5.6 | Some specific issues for modern query optimization | 148 |
| 6 | Concurrency Control | 164 |
| 6.1 | Introduction | 164 |
| 6.2 | Transactions | 165 |
| 6.3 | Interference between concurrent transactions | 169 |
| 6.4 | Schedules and serialization | 173 |
| 6.5 | Concurrency control techniques | 179 |
| 6.6 | Concurrency in replicated databases | 201 |
| 6.7 | Concurrency control in multidatabases | 204 |
| 6.8 | Application-specific methods and quasi-serializability | 208 |
| 7 | Recovery | 225 |
| 7.1 | Introduction | 225 |
| 7.2 | Causes of failure | 232 |
| 7.3 | Local recovery protocols | 239 |
| 7.4 | Distributed recovery protocols | 247 |
| 7.5 | Recovery in multidatabases | 265 |
| 8 | Integrity and Security | 272 |
| 8.1 | Introduction | 272 |
| 8.2 | Integrity in centralized databases | 273 |
| 8.3 | Integrity issues in distributed databases | 280 |
| 8.4 | Security in centralized DBMSs | 283 |
| 8.5 | Security issues in distributed databases | 292 |
| 9 | Logical Distributed Database Design and Administration | 302 |
| 9.1 | Introduction | 302 |
| 9.2 | Software life cycle | 303 |
| 9.3 | Logical design for distributed databases | 304 |
| 9.4 | Distributed database administration | 315 |
| 9.5 | Meta-data management | 319 |
| 10 | A Case Study--Multidatabases in Health Care Networks | 333 |
| 10.1 | Introduction | 333 |
| 10.2 | The health information network | 336 |
| 10.3 | Some sites and databases in health care networks | 338 |
| 10.4 | The appropriateness of DDB technology for health applications | 351 |
| 10.5 | Queries on the databases | 353 |
| 10.6 | Two specific applications | 356 |
| 10.7 | The technical suitability of this application to DDBS utilization | 358 |
| 11 | Future Developments in Distributed Databases | 363 |
| 11.1 | Introduction | 363 |
| 11.2 | Integrating artificial intelligence and databases | 364 |
| 11.3 | Distributed expert systems | 370 |
| 11.4 | Object-oriented databases | 381 |
| 11.5 | Extended relational systems | 385 |
| 11.6 | Multimedia databases | 386 |
| Glossary/Acronyms | 397 | |
| Author Index | 402 | |
| Subject Index | 406 |
Customer Reviews
Average Review: