Updating Relational Databases through Object-Based Views

The view-object model provides a formal basis for representing and manipulating object-based views on relational databases. In this paper, we present a scheme for handling update operations on view objects. Because a typical view object encompasses multiple relations, a view-object update request must be translated into valid operations on the underlying relational database. Building on an existing approach to update relational views, we introduce algorithms to enumerate all valid translations of the various update operations on view objects. The process of choosing a translator for view-object update occurs at view-object generation time. Once chosen, the translator can handle any update request on the view object. 1 Introduction Many application domains require database techniques for modeling and managing complex objects [6, 12, 16, 21, 24]. At the same time, a major incentive to exploit database management systems is the ability to support sharing of data among applications. In pr..

Use of Relational Storage and a Semantic Model to Generate Objects: The PENGUIN Project

Introduction Relational technology provides a basis for reliable sharing of large bodies of information. Object approaches provide conceptual locality of information to focus users attention. Application systems, similarily, tend to be effective if the data space is well focused and constrained. Future decision-support systems will require the combined use of database and intelligent applications. 2. The PENGUIN project In the penguin project, we demonstrate the hypothesis that relational storage, used to support an object-oriented approach can serve as a unifying framework for developing systems which share information [Wied:86]. Objects offer a consistent framework for users and their applications. Permanently storing information in the form of complex objects, however, can seriously inhibit sharing and flexibility, since an object presents one particular view of the world. A desirable compromise is to exploit existing database technology by d