Data vaults with Wherescape

August 27, 2015

View Raphael Klebanov's profile on LinkedIn           learndatavault logo


Data Vaults have been gaining huge attention in recent years all over the world. Invented by Dan Linstedt, Data Vaults is truly an optimal way to build enterprise data warehouses. WhereScape – an industry leading information systems software company – fully supports Data Vault methodology. Read the blog for more about it…

WhereScape Data Vaults


WhereScape New Features and Benefits

July 15, 2015

View Raphael Klebanov's profile on LinkedIn


Many new features are added in every RED and 3D release; it is hard to catch up with fast-paced WhereScape software. This article aims at shedding light on those new features so our customers and prospects have a comprehensible picture as to why they would want to use them.

WhereScape New Features and Benefits

Another Great Event on Data Vault Just Ended

June 5, 2015

View Raphael Klebanov's profile on LinkedIn           learndatavault logo


WWDVC — Stowe, VT May 28–30, 2015

World Wide Data Vault Consortium 2015 has been organized and facilitated – just like in the previous years – by Dan Linstedt, the inventor of the Data Vault Architecture (DV 1.0) and its extension – Data Vault 2.0. This time – in the picturesque Von Trapp Family Lodge; remember “High on a hill was a lonely goatherd/ Lay ee odl lay ee odl lay hee hoo…”

However, this was no time for yodeling; the conference was packed with great presentations, demos, and discussions. Some of the speakers were industry’s leaders and well-known publishers such as Claudia Imhoff, Ph.D. (, Scott W. Ambler (SA+A), Kent Graziano (The Data Warrior ), and others. There were around 60 data vault practitioners – consultants, vendors, and customers – from at least 7 countries. And, of course, Dan Linstedt, like a mountain eagle, was watching and facilitated the event from the height of his expertise and know-how…

This year’s themes were dominated by concept and implementation of Data vault 2.0 – the evolution of the world-renown DV1.0; arguably, 7 out of 10 new EDW’s built in Data Vault “flavor”. Some of the presentations were:

  • Big Data, NoSQL and DV2.0 Modeling
  • Temporal Data Warehouse and Data Vault
  • EDW and Data Marts Virtualization
  • Event-Driven Real-Time EDW in the Cloud
  • Agile Big Data Warehousing with DV2.0
  • …and much more!

I was honored to have the opportunity to present WhereScape Solution for DV 2.0. In this presentation I described what both WhereScape products -3D and RED – have to offer to organizations to build an Information System with Big Data inclusion that is fully compliant with the DV2.0.

“Utilizing WhereScape 3D – DW planning tool – in conjunction with WhereScape RED – DW building tool – [WhereScape] provides a complete agile solution for discovering, profiling, planning, building, deploying, managing and  renovating data warehouses and data marts” — Participant

I appreciate Dan for giving me another opportunity to speak at his conventions. I would like to participate in future WWDVC events and highly recommend all the Data Warehouse and Business intelligence practitioners, Big Data enthusiasts and Data vault lovers to partake in the future WWDVC symposia as well as consider the crème de la crème Data Vault coaching from Dan Linstedt.

Big Data Small Scale

March 3, 2015

View Raphael Klebanov's profile on LinkedIn


A common sentiment of a Big Data has been that it is too big and too costly for small and medium businesses because it requires enormous processing power to crunch all those oodles of data. But it is becoming more clear that this is an outdated perception! Processing power is cheaper and more accessible than any time in the past, granting small and medium-sized enterprises ability to tame Big Data and use it for small operations with limited IT resources and shortage of time and money.

  Blog – Big Data Small Scale

Information Systems Challenges and WhereScape Solution

February 26, 2015

View Raphael Klebanov's profile on LinkedIn


A modern information system serves as an integrated set of components for collecting, storing, and processing data and delivering knowledge. Building an information system – whether it is operational store, data warehouse, or accessing layer et al – has always been a difficult task. WhereScape – as productivity tool – provides a holistic answer for information systems build consisting of Automation Solution, Iterative (Agile) Solution, and Integrated Solution.

IS Challenges WhereScape Solution

Near Real Time Processing

December 28, 2014

View Raphael Klebanov's profile on LinkedIn


A traditional DW architecture should not assume a real time context keeping the system online while updating its data.
However, it is possible, under certain circumstances, to have near real time (NRT) processing in Data warehouse environment. WhereScape RED support NRT processing.

Near Real Time Processing

How to Create RED PIT

March 16, 2013

View Raphael Klebanov's profile on LinkedIn


Point-in-Time (PIT) considers a non-core Data Vault object and is used for one reason only – performance. It is defined by DAn Linstedt as “A structure which sustains integrity of joins across time to all the Satellites that are connected to the Hub [or Link]” 

WhereScape has successfully implemented Point-in-Time structures on customers’ sites.

Best Practices for Building a Warehouse Quickly How to create RED PIT