Re: need info: small local copy of large remote database
Date: Tue, 14 Mar 2006 02:30:47 GMT
Message-ID: <rVpRf.5789$dy4.4751_at_news-server.bigpond.net.au>
"falcon" <shahbazc_at_gmail.com> wrote in message
news:1142291721.112444.194530_at_p10g2000cwp.googlegroups.com...
> Hi,
> Could someone please point me to papers or books about how to manage
> links between a large data at a remote location and smaller cache of it
> at a local site.
>
> I need to allow my users to manipulate huge amounts of data on very
> tiny machines. The users can't have all the data available to them
> locally. I also don't want each of their queries to go to the network
> and bring back data. I would like a framework which understands when
> it needs to get data from beyond the local machine.
>
> I will most likely have an sql database on the server and something
> custom built for the local machine. In other words, I'm interested in
> ideas behind how to solve this problem rathern than pointers to
> packages.
>
> (I have started going through vldb.org as well)
Keyword for SQL Server is the function REPLICATION which involves the establishment of publication and subscription protocols between your disparate machines. You'll need to research how this works for you.
-- Pete Brown IT Managers & Engineers Falls Creek Australia www.mountainman.com.au/softwareReceived on Tue Mar 14 2006 - 03:30:47 CET