SourceForge DV Models created

Hi Folks,  I just created a source-forge project under BSD license, for Open-Data-Vault-Models.  They have to approve it, but here is the project name, and the SVN link to post new code.  There are 3 forums there as well (DEVELOPERS, HELP, and Open Discussion).

The SVN link is:

svn co https://open-data-vault.svn.sourceforge.net/svnroot/open-data-vault open-data-vault

The Project name is:

Open-Data-Vault-Models

I will be uploading AdventureWorks data models, along with NDC (National Drug Code) Data Vault Models, and if I can find it, I’ll also upload a web-log Data Vault model that I created a couple years ago.  In the future, I hope we can contribute Metrics, and Metadata data models, along with Industry vertical Data Models.  If you have experience in a specific industry vertical, PLEASE feel free to contribute.

Regarding the “Shared” data Modeling tool…

I think it should be an open-source Data Modeling tool, I’m open to ideas, but I’ve also found this one:

http://www.sqlpower.ca/page/architect

Which seems to be pretty powerful – post your comments, thoughts, questions, and tool suggestions at the bottom of this blog entry.

Cheers,

Dan Linstedt

Tags: , ,

4 Responses to “SourceForge DV Models created”

  1. Roland Bouman 2011/05/21 at 6:29 am #

    Hi Dan,

    great idea! I hope this will make it easier for newbies (like me) to learn about and understand the data vault architecture.

    As for the modeling tool: I’m using it myself for some time now and it has served me well. It’s a bit hard to find the actual download but it’s here:

    http://www.sqlpower.ca/page/architect_download_os

    (registration required but otherwise GPL and free of charge)

    kind regards,

    Roland

  2. Alex Meadows 2011/05/22 at 9:29 am #

    It’s exciting to see some open source templates coming out – hopefully we’ll soon have a vast library of examples to help kick start data vault projects.

    Power Architect is one of the few (if only?) database agnostic modeling tools out there. It also provides an interface to convert the architect schema using xslt templates. That’s handy because you can basically create any kind of output from the same schema, provided the template is already created.

  3. dlinstedt 2011/05/22 at 4:26 pm #

    @Alex, @Ronald,

    I’ve put downloads up in the FILES section, but I’m not sure they are in the right place? I don’t think they can be retrieved from the code section in SVN… I’ll have to check.

    Anyhow, I’d love help in building “stubs” at a minimum, generic models that can serve as a base.

    REMEMBER: One of the most powerful components of the Data Vault architecture is the LINK table, we can ALWAYS link these models together (as customization) later, if desired.

    Cheers,
    Dan L

  4. Jos van Dongen 2011/05/30 at 5:09 pm #

    Hey Dan,

    great initiative! I noticed over the past years that the SQLPower guys made it harder and harder to find their stuff, and now they even require you to register… Fortunately, it IS still GPL software which can be downloaded directly from http://code.google.com/p/power-architect/ (without registration ;-))

    best, Jos

Leave a Reply

*