Data Distribution - Part 1

Question

Data Distribution - Part 1

Leo Peysakhovich

Hall of Fame

Points: 3973
More actions
July 24, 2010 at 8:08 pm

#223684

Comments posted to this topic are about the item Data Distribution - Part 1

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

Phil Factor SSC-Insane Points: 20244 More actions · Answer 1

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.

Best wishes,
Phil Factor

LP-181697 SSC Eights! Points: 966 More actions · Answer 2

Phil Factor (7/26/2010)
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.

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.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 3

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.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Phil Factor SSC-Insane Points: 20244 More actions · Answer 4

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.

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.

Best wishes,
Phil Factor

Steve Jones - SSC Editor SSC Guru Points: 736172 More actions · Answer 5

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 6

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

Thanks Steve.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

LP-181697 SSC Eights! Points: 966 More actions · Answer 7

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

LP-181697 SSC Eights! Points: 966 More actions · Answer 8

LP-181697

SSC Eights!

Points: 966

July 26, 2010 at 12:14 pm

#1198365

Thanks, now it has the sence.

LP-181697 SSC Eights! Points: 966 More actions · Answer 9

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

Thanks, Steve.