Even if you have a lot of different tables, the relations between those tables are easy to follow. A lot of customers prefer using because it's pretty easy to follow because each table is holding information about something singular. The data vault model has an additional advantage over both dominant architectures, Klebanov argues: it expects conditions to change, and it's designed to permit rapid and flexible responses to business change. Unlike a star schema design, a data vault architecture normalizes and regularizes data, which makes it suitable for data mining (as well as for other applications that require raw or normalized data) and for real-time loading. According to Klebenov, the data vault architecture addresses several of the primary shortcomings of 3NF - inflexibility and brittleness a protracted development process and a requirement for a custom-built presentation layer to support BI tool access - and co-opts one of the biggest benefits of the star-schema (or dimensional) model: namely, some degree of abstraction from dependency on specific BI tools. The data vault, which was invented and championed by industry luminary Dan Linstedt, is sometimes described as a hybrid of traditional star schema and third-normal-form (3NF) warehouse architectures. In the final stage, the piece of clay you started with has become something else. You show it to your decision maker or your business people, they look at it and see if it does what they need, and you evolve from there. You just build something that makes sense the knowledge that you have today, then you build that data warehouse model and implement it. You don't have to build 100 percent correctly at the beginning. You have this piece of clay and you change it and transform it into something more complex," he comments. "For me, the process of building a data warehouse is continuous morphing. His topic: using WhereScape's data warehouse automation tools to drive an agile data vault development project.Īccording to Klebanov, agile and the data vault are nothing less than a match made in heaven. He recently made a presentation at the World Wide Data Vault Consortium (WWDVC) in St. Raphael Klebanov, a certified data vault modeler and a technical support manager with data warehouse automation specialist WhereScape Inc., thinks so. Is the data vault one of the better kept secrets in business intelligence (BI)? Is the data vault one of the better kept secrets in business intelligence? Agile plus the data vault may be a match made in heaven.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |