RE: Need your idea on setting up Distributed database

This is not a trivial problem. With 245 locations you need some serious thought about distributed transactions, IPC (inter process communication) and more.

George.

> -----Original Message-----
> From: "Balasubramanian M" <sbala_at_hclinsys.com>
> [mailto:sbala_at_hclinsys.com]
> Sent: Friday, May 26, 2000 1:56 PM
> To: smtp_at_inl001@servers["Multiple recipients of list ORACLE-L"
> <ORACLE-L_at_fatcity.com>]
> Subject: Need your idea on setting up Distributed database
>
>
> Dear all,
>
> I have to plan a strategy for setting up the database. Let me
> explain the scenario of operation.
>
> Local databases are available in 245 locations and there will
> be one centralized database.
> Whenever there is a transaction occuring at each location it
> should be posted to both the local database and the
> centralized database. We are using oracle8i database.
>
> How i can post the database transaction to local database
> after commit as well as centralized database ?
> This should happen in online.
>
> How many dblinks a centralized oracle8i database server can
> support ? In this case from each location
> i need to have a database link to the centralized database server.
>
> What database feature i can use to update the data in both
> local and centralized database ?
>
> I request every one to share every ones thoughts and tips and
> steps with me.
>
>
> Awaiting the response.
>
> Regards,
> Balasubramanian .M
> Bangalore.
>
>
> --
> Author: Balasubramanian M
> INET: sbala_at_hclinsys.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Fri May 26 2000 - 08:58:43 CDT