Interoperable Database Systems (DS-5) (eBook)

Front Cover 1
Interoperable Database Systems (DS-5) 4
Copyright Page 5
Table of Contents 8
Preface 6
Chapter 1. The promise of distributed computing and the challenges of legacy information systems1 16
Abstract 16
1. WORLD-WIDE COMPUTING 16
2. THE CHALLENGE OF LEGACY INFORMATION SYSTEMS 34
3. KILLER APPLICATIONS FOR WORLD-WIDE COMPUTING 43
ACKNOWLEDGMENTS 45
REFERENCES 45
APPENDIX: A PERSONAL STATEMENT COMPUTER SCIENCE AND CONCERN FOR OUR PLANET 46
Chapter 2. An Object-Oriented Integration Framework for Building Heterogeneous Database Systems 48
Abstract 48
1 Introduction and Overview 48
2 Overview of the Integration Process in ZOOIFI 51
3 The Object-Oriented Data Model of ZOOIFI 52
4 The Integration Framework Approach 58
5 Conclusion and Future Work 66
6 References 67
Chapter 3. Large Multidatabases: Issues and Directions 70
Abstract 70
1. Large Scale Databases 70
2. Overview of Current Research 73
3. Directions 75
4. Discussion 77
5. Conclusion 79
6. References 80
Chapter 4. Translating Relational Schema With Constraints Into OODB Schema 84
Abstract 84
1 Introduction 84
2 Background 85
3 Object class as a cluster of relations 87
4 Identifier Dependency and Complex Object 90
5 ISA Hierarchy 92
6 Object Identifier Generation 95
7 Inter-Object Relationships 96
8 Conclusion and Perspectives 98
References 99
Chapter 5. Translation of Extended Entity-Relationship Database Model into Object-Oriented Database Model 102
Abstract 102
1. INTRODUCTION 102
2. EXTENDED ENTITY-RELATIONSHIP MODEL VERSUS OBJECT ORIENTED MODEL 104
3. EXTENDED ENTITY-RELATIONSHIP MODEL 105
4. OBJECT-ORIENTED DATABASE MODEL 107
5. TRANSLATION 109
6. SUMMARY 113
Acknowledgement 114
REFERENCES 114
Chapter 6. Interoperability between Database Models 116
Abstract 116
1 INTRODUCTION 116
2 THE CANONICAL DATA MODEL ERC++ 119
3 AN OVER VIEW OF THE O2 DATA MODEL 123
4 INTEROPERABILITY BETWEEN CANONICAL AND LOCAL DATA MODELS 123
5 CONCLUSION 131
Acknowledgements 131
References 131
Chapter 7. O*SQL: A Language for Object Oriented Multidatabase Interoperability 134
Abstract 134
1. INTRODUCTION 134
2. BASIC IDEAS IN Q*SQL 135
3. Q*SQL STATEMENTS 142
4. CONCLUSION 151
Acknowledgments 151
References 151
Chapter 8. Coordination of Data and Knowledge Base Systems under Distributed Environment 154
Abstract 154
1. Introduction 155
2. Hierarchies for Databases 159
3. Knowledge Module Hierarchy 161
4. Context Module Hierarchy 163
5. A Context Module Example for Data and Knowledge Cooperation 164
6. Remarks and Comparisons with Related Notions 167
Acknowledgements 168
7. References 168
Chapter 9. Knowledge based integration of heterogeneous databases 170
Abstract 170
1. INTRODUCTION 170
2. RELATED WORK 172
3. TERMINOLOGICAL KNOWLEDGE 174
4. MEANING OF SCHEMA CONSTITUENTS 176
5. RESEMBLANCE AND INTEGRATION 185
6. CONCLUSION 188
References 189
Chapter 10. Representation and Translation of Queries in Heterogeneous Databases with Schematic Discrepancies 192
Abstract 192
1 Introduction 192
2 Global View Formats and Languages 194
3 Representation 197
4 Styles 201
5 A Problem with Interpreting Fixed Queries 202
6 Concluding Remarks 203
References 203
Appendix 204
Chapter 11. Overcoming Schematic Discrepancies in Interoperable Databases 206
Abstract 206
1. INTRODUCTION 206
2. WHAT'S THE PROBLEM? SCHEMATIC DISCREPANCIES 207
3. SCHEMA TRANSFORMATIONS IN THE RELATIONAL MODEL 208
4. SCHEMA TRANSFORMATIONS IN AN OBJECT-ORIENTED MODEL 214
5. DISCUSSION 218
6. CONCLUSIONS 219
References 219
Chapter 12. Canonical Security Modeling for Federated Databases 222
Abstract 222
1. Introduction 222
2. Analysis of Access Control Models 224
3. A Framework for Federated Database Security 227
4. Security Model Integration 230
5. Conclusion, Future Work 235
Acknowledgement 236
References 236
Chapter 13. Achieving Incremental Consistency among Autonomous Replicated Databases 238
Abstract 238
1 Introduction 239
2 Model of Replicated Database and its Behavior 240
3 Transaction execution 244
4 Reconciliation algorithms 245
5 Applicability scenarios 249
6 Further research issues and conclusion 250
References 250
Chapter 14. A Mechanism and Experimental System for Function-Based Sharing in Federated Databases 254
Abstract 254
1 Introduction 254
2 Function-Based Sharing 256
3 Experimental Prototype Implementation 261
4 Conclusions and Future Directions 266
References 267
Chapter 15. Cooperation between Autonomous Operation Services and Object Database Systems in a Heterogeneous Environment 270
Abstract 270
1. INTRODUCTION 270
2. COOPERATION BETWEEN APPLICATIONS AND DBMS 272
3. Case Studies and Prototypes 278
4. COST ANALYSIS AND PERFORMANCE-MEASUREMENTS 282
5. Extended Service Model 288
6. Conclusion and Further Work 291
Acknowledgements 292
References 292
Chapter 16. So Far (Schematically) yet So Near (Semantically) 298
Abstract 298
1 Introduction 298
2 Semantic Similarities between Objects 300
3 Semantic Proximity and Uncertainty Modeling 308
4 Domain Incompatibility Problem 312
5 Entity Definition Incompatibility Problem 315
6 Data Value Incompatibility Problem 318
7 Abstraction Level Incompatibility Problem 321
8 Schematic Discrepancies Problem 322
9 Conclusion 325
Acknowledgements 325
References 325
Chapter 17. Object identification in multidatabase systems 328
Abstract 328
1 INTRODUCTION 328
2 PREMISES 329
3 IMPORTING OBJECTS: PRODUCER TYPES 334
4 INTEGRATION 335
5 EXTENSIONS 340
6 CONCLUSIONS 344
7 REFERENCES 344
Chapter 18. Managing Interdependences among Objects in Federated Databases 346
Abstract 346
1. INTRODUCTION 346
2. ODF: A N OBJECTIFIED DATABASE FEDERATION 347
3. DATA INTERDEPENDENCES: TYPES A N D IMPLICATIONS 349
4. SUPPORTING INTERDEPENDECEES WITH OBJECT ORIENTATION 355
5. CONCLUSIONS AND FUTURE RESEARCH 360
References 361
The INTERNATIONAL FEDERATION FOR INFORMATION PROCESSING 364
IFIP's MISSION STATEMENT 366
IFIP TRANSACTIONS 367