Re: Distributed Join

Posted in 1995

Borden Armstrong, United Airlines — 7 Jun 95 13:03:49 -0400 — source: Informix-list mailing list archive (1991-1998)

In article <james.lawrence.45.0012036C@EPAMAIL.EPA.GOV>, james.lawrence@EPAMAIL.EPA.GOV writes: > However anyone considering this for production systems should be aware > that nobody is optimizing distributed joins yet. Unfortunately this > means that there is no value in making it transparent, since it wouldn't > perform worth a shit. Not entirely true. Examine Digital's DBIntegrator. And since DBI can front-end both Sybase & Oracle7 (as well as DB2, Oracle Rdb and a number of other databases) it is possible to perform optimised distributed joins across database platforms, not just across databases. Disclaimer: I do not work for Digital, but I did beta-test the product. Borden Armstrong United Airlines - SFOKI Sr. Staff Analyst - Database Design San Francisco International Airport Armstrong@Eisner.Decus.Org San Francisco, CA 94128 [Disclaimer: All opinions herein are my own and not those of my employer. All advice herein is worth exactly what you paid for it.]