Data Distribution - Part 1

  • Leo Peysakhovich

    Hall of Fame

    Points: 3880

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

  • Phil Factor

    SSCoach

    Points: 19823

    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
    Simple Talk

  • LP-181697

    SSC Eights!

    Points: 966

    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: 281210

    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

    SSCoach

    Points: 19823

    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
    Simple Talk

  • Steve Jones - SSC Editor

    SSC Guru

    Points: 714708

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

  • SQLRNNR

    SSC Guru

    Points: 281210

    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

    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

    Thanks, now it has the sence.

  • LP-181697

    SSC Eights!

    Points: 966

    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.

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

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