Re: Distributed Join

In article <3rjfvi$ebg@ixnews3.ix.netcom.com> fcasas@ix.netcom.com (Francisco Casas) writes: > >Ingres who? Why limit yourself to Ingres when most large companies run >their business on at least 5 different databases. Those databases >generally include DB2, Oracle, Sybase, some flat files and hierarchical >databases. Sybase's OmniSQL Gateway let's you access most of these >databases transparently in a heterogenous environment. > >Did I also mention that we can do perform transparent two-phase commit >to in a heterogenous DBMS environment. > >Oh, what about writing stored procedures for ALL accessible data >sources, including those that don't support stored procedures like DB2, >and Adabas. > >Francisco > Francisco, I've spoken with some people that use OmniSQL Gateway at a large firm on the East Coast. This is NOT a trivial product to use. Why don't you explain the "architecture" of this product. Explain 1. Steps needed to set it up 2. Storage required on the OmniSQL Gateway host 3. Client tools necessary to use it 4. The distributed join optimizations, or lack thereof I think your post is mostly an add. I think your product is very expensive and requires massive DBA work upfront. Prove me wrong. I *sincerely* want you to. Cheers, |--------------------------------------------------------------------------| | Michael Leo | The Ingres FAQ is at ftp.adc.com, /pub/ingres. | | York & Associates, Inc.| Also check out /pub/ingres/utilities/NAIUA for | | Minneapolis, MN, USA | the NAIUA Tool Kit. Lastly, access all this via| | (612) 831-0077 (voice) | WWW at http://www.adc.com/ingres/ing-top.html. | | mal@winternet.com | All constructive suggestions/criticism welcome. | |--------------------------------------------------------------------------|