MOCHA
Authors:
Open Access
- 16 May 2000
- journal article
- Published by Association for Computing Machinery (ACM) in ACM SIGMOD Record
- Vol. 29 (2) , 213-224
Abstract
We present MOCHA, a new self-extensible database middleware system designed to interconnect distributed data sources. MOCHA is designed to scale to large environments and is based on the idea that some of the user-defined functionality in the system should be deployed by the middleware system itself. This is realized by shipping Java code implementing either advanced data types or tailored query operators to remote data sources and have it executed remotely. Optimized query plans push the evaluation of powerful data-reducing operators to the data source sites while executing data-inflating operators near the client's site. The Volume Reduction Factor is a new and more explicit metric introduced in this paper to select the best site to execute query operators and is shown to be more accurate than the standard selectivity factor alone. MOCHA has been implemented in Java and runs on top of Informix and Oracle. We present the architecture of MOCHA, the ideas behind it, and a performance study using scientific data and queries. The results of this study demonstrate that MOCHA provides a more flexible, scalable and efficient framework for distributed query processing compared to those in existing middleware solutions.Keywords
This publication has 8 references indexed in Scilit:
- Scaling heterogeneous databases and the design of Disco2002
- Optimization of queries with user-defined predicatesACM Transactions on Database Systems, 1999
- Secure and portable database extensibility1998
- Performance tradeoffs for client-server query processing1996
- Query evaluation techniques for large databasesACM Computing Surveys, 1993
- The SEQUOIA 2000 storage benchmark1993
- Predicate migration1993
- Access path selection in a relational database management system1979