SQLServerCentral / Discuss Content Posted by Leo Peysakhovich / Article Discussions / Article Discussions by Author / Data Distribution - Part 1 / Latest Posts

RE: Data Distribution - Part 1

LP-181697 — Mon, 26 Jul 2010 12:16:02 GMT

[quote][b]Steve Jones - Editor (7/26/2010)[/b][hr]I'm not sure what happened, but I have added back the last code snippet and final para.[/quote]Thanks, Steve.

RE: Data Distribution - Part 1

LP-181697 — Mon, 26 Jul 2010 12:14:54 GMT

Thanks, now it has the sence.

RE: Data Distribution - Part 1

LP-181697 — Mon, 26 Jul 2010 12:13:34 GMT

If text will not be edited with missed part, then I will add the missing part in comment tomorrow.

RE: Data Distribution - Part 1

SQLRNNR — Mon, 26 Jul 2010 12:11:04 GMT

[quote][b]Steve Jones - Editor (7/26/2010)[/b][hr]I'm not sure what happened, but I have added back the last code snippet and final para.[/quote]Thanks Steve.

RE: Data Distribution - Part 1

Steve Jones - SSC Editor — Mon, 26 Jul 2010 12:07:06 GMT

I'm not sure what happened, but I have added back the last code snippet and final para.

RE: Data Distribution - Part 1

Phil Factor — Mon, 26 Jul 2010 11:27:43 GMT

[quote]Unfortunately, the last part of the article is missed and this is created misunderstanding. Even for me is difficult to understand myself. I did sent email to the publisher but has no response. You are right. For the small data warehouses (up to 10G) it is one of the ways to replace data and make very short period of data inavalability.[/quote]Ah, I understand now. It will be interesting to see the second part then. It is an interesting topic and great to see what is involved with providing a working solution for this sort of warehousing. Thanks for the article.

RE: Data Distribution - Part 1

SQLRNNR — Mon, 26 Jul 2010 10:38:27 GMT

Thanks for the time taken to write this article.I too would have liked to see something more verbose in the explanations. More detail would also be good.

RE: Data Distribution - Part 1

LP-181697 — Mon, 26 Jul 2010 08:33:17 GMT

[quote][b]Phil Factor (7/26/2010)[/b][hr]I'm not clear to me whether you are suggesting that this approach (restore followed by a rename) is a good way of updating the data marts from the hub. If so, then it would need some more explanation, as I'm still wondering whether you are suggesting it over more elegant solutions just because of huge volumes of data to be transferred. Apologies if I've misunderstood.[/quote]Unfortunately, the last part of the article is missed and this is created misunderstanding. Even for me is difficult to understand myself. I did sent email to the publisher but has no response. You are right. For the small data warehouses (up to 10G) it is one of the ways to replace data and make very short period of data inavalability. We preparing data in separate data warehouse, loading it to every server from HUB and then switching within 1 second or even less. We have 3-4 data warehouses and doing this for at least 2 years during low nightly traffic. Our data warehouses supporting many applications. What we got with this process 1. data updated on all servers practically at the same time. 2. Data availability 24*7 3. Ability load and verify data first before it get used 4. Data integrity at any time - there is no time when data inconsistent because of load process.

RE: Data Distribution - Part 1

Phil Factor — Mon, 26 Jul 2010 08:13:41 GMT

I'm not clear to me whether you are suggesting that this approach (restore followed by a rename) is a good way of updating the data marts from the hub. If so, then it would need some more explanation, as I'm still wondering whether you are suggesting it over more elegant solutions just because of huge volumes of data to be transferred. Apologies if I've misunderstood.

Data Distribution - Part 1

Leo Peysakhovich — Sat, 24 Jul 2010 20:08:10 GMT

Comments posted to this topic are about the item [B]Data Distribution - Part 1[/B]