Join processing in database systems with large main memories
ACM Transactions on Database Systems (TODS)
Computer
Query processing in main memory database management systems
SIGMOD '86 Proceedings of the 1986 ACM SIGMOD international conference on Management of data
Panel: The effect of large main memory on database systems
SIGMOD '86 Proceedings of the 1986 ACM SIGMOD international conference on Management of data
ACM Transactions on Database Systems (TODS)
OOPLSA '86 Conference proceedings on Object-oriented programming systems, languages and applications
Office-by-example: an integrated office system and database manager
ACM Transactions on Information Systems (TOIS)
Extended algebra and calculus for nested relational databases
ACM Transactions on Database Systems (TODS)
Object identity as a query language primitive
SIGMOD '89 Proceedings of the 1989 ACM SIGMOD international conference on Management of data
Optimization of large join queries
Optimization of large join queries
Query optimization in a memory-resident domain relational calculus database system
ACM Transactions on Database Systems (TODS)
Complex objects for relational databases
Computer-Aided Design
Updating relational databases through object-based views
SIGMOD '91 Proceedings of the 1991 ACM SIGMOD international conference on Management of data
Efficiency in instantiating objects from relational databases through views
Efficiency in instantiating objects from relational databases through views
The art of computer programming, volume 3: (2nd ed.) sorting and searching
The art of computer programming, volume 3: (2nd ed.) sorting and searching
Implications of certain assumptions in database performance evauation
ACM Transactions on Database Systems (TODS)
ACM Computing Surveys (CSUR)
A relational model of data for large shared data banks
Communications of the ACM
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
Implementation techniques for main memory database systems
SIGMOD '84 Proceedings of the 1984 ACM SIGMOD international conference on Management of data
Outer Joins and Filters for Instantiating Objects from Relational Databases Through Views
IEEE Transactions on Knowledge and Data Engineering
Performance of Complex Queries in Main Memory Database Systems
Proceedings of the Third International Conference on Data Engineering
Complex and Composite Objects in CAD/CAM Databases
Proceedings of the Fifth International Conference on Data Engineering
A Study of Index Structures for Main Memory Database Management Systems
VLDB '86 Proceedings of the 12th International Conference on Very Large Data Bases
Performance Evaluation of Main Memory Database Systems
Performance Evaluation of Main Memory Database Systems
View objects for relational databases
View objects for relational databases
Context-Based Prefetch for Implementing Objects on Relations
VLDB '99 Proceedings of the 25th International Conference on Very Large Data Bases
Context-based prefetch – an optimization for implementing objects on relations
The VLDB Journal — The International Journal on Very Large Data Bases
| Hi-index | 0.00 |
View-objects are complex objects that are instantiated by delivering a query to a database and converting the query result into a nested structure. In relational databases, query results are conventionally retrieved as a single flat relation, which contains duplicate subtuples in its composite tuples. These duplicate subtuples increase the amount of data to be handled and thus degrade performance. In this article, we describe two new methods that retrieve a query result in structures other than a single flat relation. One method retrieves a set of relation fragments, and the other retrieves a single-nested relation. We first describe their algorithms and cost models, and then present the cost comparison results in a client-server architecture with a relational main memory database residing on a server.