MOCHA: A Self-Extensible Database Middleware System for Distributed Data Sources

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 advanceddata 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 shownto be more accuratethan the standardselectivity factor alone. MOCHA has been implemented in Javaand runs on top of Informix and Oracle. We present the architecture of MOCHA, the ideas behind it, and a performance st...

• Type: Conference
• Year: 2000
• Where: SIGMOD
• Authors: Manuel Rodriguez-Martinez, Nick Roussopoulos
• Keywords: Data Source, Database, Middleware, Query Operators, SIGMOD 2000