Re: ORACLE,INGRES,SYBASE in a DDBS
From: Alastair Newson <anewson_at_cix.compulink.co.uk>
Date: Mon, 23 May 1994 08:44:37 GMT
Message-ID: <Cq8yyD.1Ju_at_cix.compulink.co.uk>
Date: Mon, 23 May 1994 08:44:37 GMT
Message-ID: <Cq8yyD.1Ju_at_cix.compulink.co.uk>
Hi Torho,
At the server end you could use the Oracle transparent gateways. This can give transparent access to the other databases through a single server. I'm sure performance is somthing to look out for when data is being moved around like that. I don't know if the exist, but I expect Sysbase and Ingres have similar gateway products.
There has been a trend for combining data within client applications. This works fine for small datasets. However, 100,000 rows from one databse and 20,000 from another to give a result set of 300 is not good news, for either the network or the client. (Especially if the client is a PC with a small hard disk and < 64MB ram!)
Alastair Received on Mon May 23 1994 - 10:44:37 CEST