Re: Distributed Join

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 In <MAL.95Jun3100013@yavanna> mal@winternet.com (Michael Leo) writes: > > >[tons of talk about semi-join algorithms, coding, and other stuff deleted] > >You could just buy Ingres/Star and use normal everyday SQL, not knowing >which table is on which node. You can do this from ANY tool, not just >call-level or embedded C. You can do this from ANY third party tool >that works against plain old Ingres. Ingres/Star deals with the >"distriby" stuff behind the Ingres front-end. > >Granted the product is not perfect, but its been able to do this for >the last 5 years, at least. > >One has to ask, "Why can't Sybase?" > >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. | >|--------------------------------------------------------------------- ----| >