Using synonyms

----LNX_Wed_May_14_2003_18:25:24_V3.33-- Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello, = I'm looking for general advice regarding the use of synonyms to get information from databases residing on other IDS instances (or even servers)? Is it a good idea to get data (user information, location informationetc.= ) for different applications from one central database using table synonyms= ? Does anyone use this approach? Or did anyone try and discard this solutio= n? = Regards, Andreas Kutsche ------------------------------------------------ SPAR Oesterreichische Warenhandels-AG Hauptzentrale Europastra=DFe 3 A-5015 Salzburg = Telefon : +43 662 4470 24423 E-Mail : Andreas.KUTSCHE@spar.at Internet: http://www.spar.at ------------------------------------------------ = ----LNX_Wed_May_14_2003_18:25:24_V3.33----

We use synonyms where data has been segregated into different databases depending on function. This can give some flexibility over where data is stored. We only notice performace issues when the database is on a different server. Colin Bull c.bull@videonetworks.com > -----Original Message----- > From: forum.subscriber@iiug.org [mailto:forum.subscriber@iiug.org]On > Behalf Of Andreas.KUT.... > Sent: 14 May 2003 17:28 > To: ids@iiug.org > Subject: Using synonyms [1142] > > > ----LNX_Wed_May_14_2003_18:25:24_V3.33-- > Content-Type: text/plain; charset="iso-8859-1" > Content-Transfer-Encoding: quoted-printable > > Hello, > = > > I'm looking for general advice regarding the use of synonyms to > get information from databases residing on other IDS instances (or > even servers)? > Is it a good idea to get data (user information, location > informationetc.= > ) > for different applications from one central database using > table synonyms= > ? > Does anyone use this approach? Or did anyone try and discard > this solutio= > n? > = > > Regards, > Andreas Kutsche > > ------------------------------------------------ > SPAR Oesterreichische Warenhandels-AG > Hauptzentrale > Europastra=DFe 3 > A-5015 Salzburg > = > > Telefon : +43 662 4470 24423 > E-Mail : Andreas.KUTSCHE@spar.at > Internet: http://www.spar.at > ------------------------------------------------ > > = > > > ----LNX_Wed_May_14_2003_18:25:24_V3.33---- >