SQL

Role of #datavault models in #nosql world

For the past 2+ years I’ve been working with Sanjay Pande.  We’ve been addressing the question: what happens to a Data Vault Model when NoSQL is involved as the platform?  In this entry I will address this question at a management level.  If you want to know more about the details, you’ll have to attend this years’ conference: http://wwDVC.com

First, let’s understand how I define NoSQL

NoSQL – in my definition really means: Not Only SQL.  But there is another definition out there which is also valid: Truly “No SQL interface available”.

By No SQL Interface, what we truly mean is: code driven interfaces – with specific access points.  It could be a restful web service, it could be a set of JAVA libraries with entry points, or Javascript, or PHP, Python, or Perl for that matter.  Anyhow, the point is: code-driven.  Setting the “standards of data access” back to the early 1980’s.

I once wrote C++ libraries to access XEROX Documentum servers (one of the first NoSQL data stores??)  It had several basic function calls: (among them were): GET and PUT.  (there were a few others).  The point is, the technology that removes common accessibility standards like SQL (ie: Structured query language), makes it difficult for business users to access the RAW data, let alone the historized data, and even the INFORMATION (if there is any to be had).

Anyhow, most NoSQL systems are adapting or writing some form of SQL hybrid engine on top of their solutions to allow “common language” access to the data sets inside, without writing programmatic code (aside from SQL itself).

Second, the TRUE business problems:

But before we get on to this notion, I’d like to take a minute and say this: what are the business problems we are always trying to solve?

  1. Data Integration – data sets from multiple disparate systems, integrated by some common thread.
  2. Data Historization – the storage of the raw data AS-IT-ARRIVED (for auditability sake), and stamped with at least, one time stamp of arrival.
  3. Information Delivery – how to take DATA and turn it in to INFORMATION from which business (people & sometimes artificial intelligence or statistical algorithms) can make better decisions.

That said, under each one of these major headings – businesses and IT alike are attempting to constantly improve the landscape.  That is to say: tools, storage mechanisms, ingestion rates, management principles, analytics capabilities, and so on.  I would go on to say that there are in fact, two additional business problems that we are attempting to solve today:

  1. Information Historization – this is a critical function of business going forward, and it is different than Data Historization.  The question for you (the reader) here is: “What do you do with the data that the business user has altered, and then wants to share within the enterprise?”
  2. Information Integration – This is different (again) from data integration.  Once the data has been re-aligned, corrected, massaged, altered, and turned in to information – how should it be integrated, where in the organizational hierarchy should it be integrated, and how can it be coalesced for a Master Data View of the enterprise world?

Why is this important?

Well, to be quite frank people offer all kinds of hoopla and hype about NoSQL as well as BIGDATA.   In all honesty the following should apply to all business leaders who have an interest in utilizing these labels:

  • NoSQL is just a categorization for platforms that store data sets.  It is not a system of business intelligence nor is it a data warehouse.
  • Big Data – oh come on, really?  it’s just volumes of data in motion.  Ok, variety is a driver for volume, but let’s face it… Big Data is simply more data in motion (volume and velocity combined).  One without the other is quite simply lots of data at rest, or lots of tiny transactions in flow.

At this time, I want to take a segue to discuss the new buzz word: Internet of Things (IOT)

In reality, data is just data – and the IOT is simply bringing MORE data to us from devices.   To put it quite bluntly IOT is BORING… why? because a) it’s just more devices producing more device logs that can be consumed by what?

Oh wait, that’s the top three problems I mentioned above…  Yes, it’s the same old business problems all over again, only this time, we have to absorb more data…  faster.  I’ll write more about the IOT in upcoming posts.  For now, let’s get back to NoSQL.

Underneath the NoSQL category there are three basic sub-categorizations of data storage and retrieval engines:  a) relational & semi-relational,  b) hybridized (relational & non-relational),  c) completely non-relational.

NOTE: What am I doing in this article?  Hint… turning unstructured data (words and text) into hopefully meaningful information (concepts and organizations of ideas)…

Below the covers of the NoSQL label

Underneath each NoSQL label, are the data storage mechanisms.  Again, each entry / platform in this space can be divided in to the three categories mentioned above.  Let’s explore the Relational NoSQL category for a minute…

Conceptually: relational NoSQL basically says – there is a relational method for accessing and changing the data stored underneath.  For instance: HiveQL on top of HDFS and a Key Value physical storage mechanism, is an example of a semi-relational access pattern on top of NoSQL store.

What this means, is: you (the business user) need to KNOW and UNDERSTAND what data is stored.  You need to decide (just like always) what you want to DO with the data that you retrieve, and lastly – you are the data mining engine that turns the data in to Information.  Either by categorizing it, aggregating it, cleansing it (performing business rules on it), filtering it, joining it, enriching it and so on.

It becomes information when a Business User or pre-programmed business rules perform operations on the data, munging it and changing it in to something understandable and usable by business.

Conceptually: Non-Relational NoSQL basically says: there is NO relational paradigm for accessing or representing the data that is stored within it.  For instance, MongoDB “tables” are like a single worksheet in Excel – with thousands of columns, no way to JOIN the data sets together.  Any data that needs to be combined, needs to be flattened and replicated across the storage mechanism.  A “single query” accesses only a “single table” to produce results.

In some of these particular cases, flat & wide are the only way to go.  It’s conceptually similar to a Cobol Copybook defining a single file store with occurs clauses and repeating groups, without any of the conditional logic for overlays and redefines.

Conceptually: Hybrids offer the best of both worlds through libraries, and access points.  This means, the technology or the platform is deciding what to do with the data you pass in.

What does this all mean to Data Vaults?

Well, remember, this is a high level discussion – to find out more about the details, you need to attend the conference: http://wwDVC.com

Anyhow, Data Vault Models are canonically organized.  Which means they adhere to a common set of principles.  The modeling constructs are focused on Business Keys, but more than that – they are focused on creating a hierarchy of business keys – where the hierarchy can constantly change and be adapted to the business needs, without re-engineering the rest of the solution underneath.

In other words, Data Vault Modeling principles are logically based and founded in conceptual constructs.

Ok – too much gibberish.  Data Vault Models are close to the lowest level of a concept model that you could construct based on a set of ideas in your business that are inter-related by business keys (key business terms you use to describe the data in your business uniquely).  For example: customer account, portfolio number, stock ticker symbol, company name, and so on.

Data Vault Models can be leveraged in NoSQL platforms easily, as long as they remain at the logical level.  The physical data model needs to change depending on the physical storage mechanisms housed within the NoSQL environment.  Some NoSQL platforms will actually change the model to accommodate the physical storage mechanisms under the covers.

It means, even if you are putting your Data Vault Models on NoSQL platforms, you should still focus your efforts on understanding the business and therefore understanding the business keys, along with organizing business concepts by hierarchies.

Why Should I as a Business Invest my time in Modeling at all?

Again, Claudia Imhoff will address this issue in her keynote address at http://WWDVC.com

My two cents (to wrap up this article) would be as follows:

  • You can’t understand what you don’t define.  Unstructured data is just that – unstructured and “useless” until you ask a question / mine it, and run correlation on it – resulting in structured result sets. You need to look for patterns!  define the context of what you want to work with.
  • You need to organize the unstructured data / nosql data in to contextual hierarchies in order to understand what it is you have.  You need to attach it to constructs in Business and the Business Processes, so that the “data” can be turned in to information by enriching it with context.

The Data Vault Modeling concepts help you turn data in to information while assisting in the solution to the major problems listed at the top of this article.  I would encourage you to check out the Data Vault 2.0 Principles and best practices, or at least to read more about the Data Vault Modeling constructs by looking at my book: Super Charge Your Data Warehouse (available on Amazon.com, OR here: http://LearnDataVault.com )

Finally, Key-Value stores will change the way physical data is stored, and what your physical model will look like.  Same with Document stores, Graph Databases, Columnar Databases, and BigTable implementations.  Do not discount the value of building a good solid business model based on Data Vault principles and centered around business key integration.

I hope this helps clear the air a bit with regards to Data Vault Modeling & NoSQL.  As always, please feel free to add your thoughts and comments below.

(C) Dan Linstedt, 2015 All Rights Reserved

Tags: , , , , ,

No comments yet.

Leave a Reply

*