Foreword xi Preface xiii Acknowledgments xvii About the Author xix Part One An Object-Oriented View on Persistence 1 Chapter 1 A New Generation of Software 3 1.1 From Data to Information 3 1.2 Improving Software Quality 4 1.3 Databases Everywhere 4 1.4 To Have and to Hold 5 1.5 Concentrating on the Essence 5 1.6 The Importance of Scalability 6 1.7 Application Program Interfaces 7 1.8 The Road to Follow 7 Chapter 2 The Database Community Today 9 2.1 Walking among Dinosaurs 9 2.2 Database Usage 10 23 Database Users 10 2.4 Designing Database Applications 11 2.5 Relational Databases 12 2.6 Client/Server Systems 15 2.7 Distributed Software 18 2.8 Problems with Traditional Systems 19 2.9 4GL: The Solution? 20 2.10 Object-Oriented Databases 21 2.11 Preserving Openness 23 2.12 Summary 24 Chapter 3 An Object-Oriented View on Database Applications 25 3.1 Data-Driven Software Design 25 3.2 Supporting Multiple Applications 28 3.3 Object-Oriented Software Design 29 3.4 The Object Model 30 3.5 Example: Student Administration 31 3.6 Business Models and Supporting Multiple Applications 34 3.7 C++, Java, or Smalltalk: The Ultimate Answer? 35 3.8 Building Reusable Software 38 3.9 Toward Open Client/Server Applications 40 3.10 Object Orientation and Client/Server Design 40 3.11 User Interfaces 40 3.12 Analogy between User Interfaces and Databases 41 3.13 Object-Oriented or Relational? 43 3.14 Persistence from a Different Angle 44 3.15 Persistence and Separation of Concerns 44 3.16 Safety Issues 46 3.17 Summary 46 Part Two An Architecture for Object Persistence 47 Chapter 4 Making Objects Persistent 49 4.1 Introduction 49 4.2 Basic Requirements of a Persistence Framework 50 4.3 Obtaining Scalability 50 4.4 Interfacing with a Relational World: Problems to Conquer 51 4.5 Abstracting the Database 57 4.6 An Architecture for Object Persistence 58 4.7 Summary 60 Chapter 5 Abstracting the Database 61 5.1 A Persistent Container Class 61 5.2 Basic Functionality of PSet 61 5.3 Implementing the Persistence Architecture 63 5.4 Resolving the Impedance Mismatch 65 5.5 Reading and Writing Objects 71 5.6 Direct Instances of PSet 73 5.7 Searching for Objects 75 5.8 Supporting Multiple Technologies 79 5.9 Summary 81 Chapter 6 Encapsuiating Data Access 83 6.1 Deriving from PSet 83 6.2 Example: Class City 87 6.3 Using Class ~i ty 93 6.4 Member Objects 93 6.5 Derived IM Resolvers 94 6.6 Class Extension 99 6.7 Compile-Time Decoupling 100 6.8 Reuse and Migration to Other Technologies 104 6.9 Summary 104 Part Three Implementing Business Models 105 Chapter 7 Designing Business Objects 107 7.1 Developing a Simple Invoicing System 107 7.2 Searching Compound Objects 116 7.3 Object ID versus Primary Key 118 7.4 Developing Generic IM Resolvers 121 7.5 An OID-Based Reference Class 126 7.6 Supporting Existing Database Layouts 130 7.7 Versioning 131 7.8 Stability of Program Code against Schema Changes 134 7.9 Storing Multimedia Objects 135 7.10 Efficiency 139 7.11 Summary 145 Chapter 8 Inheritance of Persistent Objects 147 8.1 Specialization: Using Inheritance for Reuse 147 8.2 Generalization: Using Inheritance for Polymorphism 152 8.3 Using Generalizations as Member Objects 158 8.4 Inheritance in Relational Database Systems 162 8.5 Designing Reusable Software Components 170 8.6 Summary 173 Chapter 9 Associations 175 9.1 Many-to-One Relationships 175 9.2 Attributes versus Associations 176 9.3 Collections: One-to-Many Relationships 178 9.4 Associations and Reuse 186 9.5 Many-to-Many Relationships 188 9.6 A Closer Look at Associations 189 9.7 Associations as Independent Entities 191 9.8 Referential Integrity 197 9.9 Summary 202 Chapter 10 Transaction Management and Concurrency Control 203 10.1 The Transaction 203 10.2 The ACID Test 203 10.3 Transaction Management Exceeds the Database Level 205 10.4 Concurrency Control: Locking 206 10.5 Example: A Transaction Class 211 10.6 Transactions in Relational Database Systems 212 10.7 Using Transactions 214 10.8 Nested Transactions 215 10.9 Distributed Database Systems 217 10.10 Other Levels of Concurrency 219 10.11 Lock Notification through Call-Back Functions 221 10.12 Summary 222 Chapter 11 The Front End 223 11.1 Analogy between User Interfaces and Databases 223 11.2 Separating the User Interface from the Business Model 223 11.3 What to Put Where 229 11.4 Navigating through Persistent Sets 229 11.5 Summary 234 Chapter 12 Case Study: An Electronic Telephone Directory 235 12.1 Project Definition 235 12.2 Comparing Development Approaches 236 12.3 Designing the User Interface 237 12.4 The Database Model 240 12.5 Designing the Business Model 240 12.6 Comparing the Business Model and the Database Model 243 12.7 Implementing the Business Objects 244 12.8 Making Classes Persistent 250 12.9 Impedance Mismatch Examples 257 12.10 Implementing the User Interface 263 12.11 Summary 275 Chapter 13 Toward Open Applications 277 13.1 Third-Party Access to Your Application's Data 278 13.2 Standard Report Generators and Query Tools 278 13.3 Informationbases 281 13.4 Interoperability with Other Applications 282 13.5 Implementing an Informationbase 285 13.6 Architecture for Next-Generation Software 286 13.7 Summary 289 Chapter 14 Conclusion 291 Appendix DBtools-Based Implementation of Scoop 293 PSet 293 DataSet 294 IM_Resolver 294 Resolving Impedance Mismatch 295 Building the Select Statement 296 References 297 Index 301