Re: Distributed Join

In article <3ruiln$1gf@ixnews5.ix.netcom.com> fcasas@ix.netcom.com (Francisco Casas) writes: > >Hi Michael, > >First let me apologize for the 'Ingres who?' message. But when you >throw down the gauntlet of 'why can't Sybase do this?' it RUBBED me the >wrong way! I hope you are not an ex-Ingres employee or an existing >Ingres customer. If you are, my condulences. Both Oracle and Sybase >have very attractive swith over offers :-) If you are a consultant >then I have a question for you: 'Why are you recommending products from >a company whose engineering team was severely raided by Oracle, Sybase >and Informix?' Oracle parked moving vans in from of the Ingres head >quarter buildings and, dare I say, we did something similar. The >Ingres database group had less than 5 engineers by the time it was all >over. I'm not sure if I'd brag about all this too much. Doesn't give me a big reason to do business with you. Why does it rub you the wrong way? If you are clearly truthful in your advertisment, you shouldn't be so threatened. BTW, I am not an RTI/Ingres/ASK/CA employee. Former or otherwise. I have never received any sort of compensation from them. Period. > >You say 'Prove me wrong.' Ok, I'll give it a shot piece by piece. >You are asking me to explain the following: > > 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 > >In addition you ask that I explain the architecture of the product. I >will answer your requests. > >In return I ask that you explain the same for Ingres' product. Come to >think of it, I really don't want to spend a lot of time comparing my >product to that of a company whose engineering has been desimated by >its competitors, unless you answer your own questions in this forum. >You will find that answering the questions you posed accurately takes a >good 3-4 hours of typing. So the ball is in your court. If you have all the Ingres engineers at your shop, why don't YOU explain it. If OMNI is so simple to set up, why does it take 3-4 hours of typing to explain it? Geez. I could write a quarter of a novel in that time. The ball has been in your court since you posted your blatant advertisment. > >But as a token of goodwill I will offer you a bird's eye view of the >product and it's architecture. The Sybase OmniSQL Gateway (I'll refer >to it as Omni from here on) is written on top of another Sybase product >called Open Server. Open Server has several features built in such as >a multi-threaded kernel and blah, blah, blah. Omni has it's own >repository and database optimizer. It can interoperate with the Omni >Access Modules (DB2, Oracle...), MDI gateways (IMS, Adabas...) and of >course the Sybase SQL Server. I can give you a list of all the access >modules and gatways if you'd like. Omni DOES NOT require a Sybase SQL >Server to work. In other words Omni can do distributed queries between >DB2 and Informix transaparently without requiring a SQL Server >(remember it has it's own optimizer, repository and connectivity >services). Omni also provides the abiliy to perform transparent >two-phase commits across heterogenous database environments. Omni also >allows customers to write stored procedures for any of the databases it >can access (Oracle,Informix,etc.), including those that do not support >stored procedures such as DB2, IMS, Adabas, etc. So much for the >bird's eye view of the product's architecture. > >In order for me to answer what it takes to set up the product, I'd like >to know which parts of the overview above you want to use. Which >databases do you want to access? Do you want to write stored >procedures against Oracle, DB2, IMS. Do you need transaparent >two-phase commit? > >Just make sure that you can answer what you can ask. > >Francisco > Nice advertisement. Got the same thing from the marketing brochures. You've proven your ability to type in stuff from flyers. Grow up. This "pot-shotting" Ingres was old news last YEAR. I'm not sure if you really even understand the terms you typed in above. Bait not taken. I will no longer reply to this thread. 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. | |--------------------------------------------------------------------------|