Star schemas are great for generalized data warehouse schemes, but what if you want to warehouse financial data and preserve the account relationships betweend GL, AP, AR, INVENTORY and the like? Does the star schema have to be abandoned in this case? Can it be adapted?
I

    Requires Free Membership to View

    Login

have seen warehouses do this kind of thing, so yes, it can be done. You have to decide how you will be using the data in the warehouse; you have to rethink the relations, since a data warehouse is not just a bigger version of your OLTP system. I suggest looking at a few books on data warehouse design and theory before undertaking this conversion.
 

This was first published in September 2004

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.
    Back to top