An introduction to database systems: vol. I (4th ed.)
An introduction to database systems: vol. I (4th ed.)
Computer
SIGMOD '86 Proceedings of the 1986 ACM SIGMOD international conference on Management of data
Development of an object-oriented DBMS
OOPLSA '86 Conference proceedings on Object-oriented programming systems, languages and applications
Benchmarking simple database operations
SIGMOD '87 Proceedings of the 1987 ACM SIGMOD international conference on Management of data
Teaching object-oriented programming with the KEE system
OOPSLA '87 Conference proceedings on Object-oriented programming systems, languages and applications
Composite object support in an object-oriented database system
OOPSLA '87 Conference proceedings on Object-oriented programming systems, languages and applications
Principles of database and knowledge-base systems, Vol. I
Principles of database and knowledge-base systems, Vol. I
The design and implementation of O2
Lecture notes in computer science on Advances in object-oriented database systems
ZEITGEIST: Database support for object-oriented programming
Lecture notes in computer science on Advances in object-oriented database systems
Integrating an object-oriented programming system with a database system
OOPSLA '88 Conference proceedings on Object-oriented programming systems, languages and applications
ODE (Object Database and Environment): the language and the data model
SIGMOD '89 Proceedings of the 1989 ACM SIGMOD international conference on Management of data
Object identity as a query language primitive
SIGMOD '89 Proceedings of the 1989 ACM SIGMOD international conference on Management of data
Special report: the 1988 Object-oriented database workshop
ACM SIGMOD Record
Complex objects for relational databases
Computer-Aided Design
An object-oriented relational database
Communications of the ACM
Efficiency in instantiating objects from relational databases through views
Efficiency in instantiating objects from relational databases through views
Object-oriented database systems
Proceedings of the seventh ACM SIGACT-SIGMOD-SIGART symposium on Principles of database systems
A semantics for complex objects and approximate queries
Proceedings of the seventh ACM SIGACT-SIGMOD-SIGART symposium on Principles of database systems
Extending the database relational model to capture more meaning
ACM Transactions on Database Systems (TODS)
A relational model of data for large shared data banks
Communications of the ACM
Data Models
On extending the functions of a relational database system
SIGMOD '82 Proceedings of the 1982 ACM SIGMOD international conference on Management of data
Non first normal form relations to represent hierarchically organized data
PODS '84 Proceedings of the 3rd ACM SIGACT-SIGMOD symposium on Principles of database systems
Complex and Composite Objects in CAD/CAM Databases
Proceedings of the Fifth International Conference on Data Engineering
Design Overview of the NAIL! System
Proceedings of the Third International Conference on Logic Programming
LDL: A Logic-Based Data Language
VLDB '86 Proceedings of the 12th International Conference on Very Large Data Bases
PCLOS: A Flexible Implementation of CLOS Persistence
ECOOP '88 Proceedings of the European Conference on Object-Oriented Programming
Hypergraph based reorderings of outer join queries with complex predicates
SIGMOD '95 Proceedings of the 1995 ACM SIGMOD international conference on Management of data
Outerjoin simplification and reordering for query optimization
ACM Transactions on Database Systems (TODS)
View maintenance and change notification for application program views
SAC '98 Proceedings of the 1998 ACM symposium on Applied Computing
View Management Support in Advanced Knowledge Base Servers
Journal of Intelligent Information Systems
Research Frontiers in Object Technology
Information Systems Frontiers
Efficiently instantiating view-objects from remote relational databases
The VLDB Journal — The International Journal on Very Large Data Bases
Context-Based Prefetch for Implementing Objects on Relations
VLDB '99 Proceedings of the 25th International Conference on Very Large Data Bases
A Practical Approach to Access Heterogeneous and Distributed Databases
CAiSE '99 Proceedings of the 11th International Conference on Advanced Information Systems Engineering
Context-based prefetch – an optimization for implementing objects on relations
The VLDB Journal — The International Journal on Very Large Data Bases
Computing full disjunction using COJO
Information Technology and Management
CBMS'03 Proceedings of the 16th IEEE conference on Computer-based medical systems
Hi-index | 0.00 |
One of the approaches for integrating object-oriented programs with databases is to instantiate objects from relational databases by evaluating view queries. In that approach, it is often necessary to evaluate some joins of the query by left outer joins to prevent information loss caused by the tuples discarded by inner joins. It is also necessary to filter some relations with selection conditions to prevent the retrieval of unwanted nulls. The system should automatically prescribe joins as inner or left outer joins and generate the filters, rather than letting them be specified manually for every view definition. We develop such a mechanism in this paper. We first develop a rigorous system model to facilitate the mapping between an object-oriented model and the relational model. The system model provides a well-defined context for developing a simple mechanism. The mechanism requires only one piece of information from users: null options on an object attribute. The semantics of these options are mapped to non-null constraints on the query result. Then the system prescribes joins and generates filters accordingly. We also address reducing the number of left outer joins and the filters so that the query can be processed more efficiently.