Re: Distributed Join
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. 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. 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 In <MAL.95Jun13082128@yavanna> mal@winternet.com (Michael Leo) writes: >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. | >|--------------------------------------------------------------------- ----| >