Jimmney Crickets! it’s that time again!!! I have to say this is an area near and dear to my heart. Language and semantic expression has always been a part of my research since 1987, yes, you heard me right… 1987 (who would have thunk?) Anyhow, I’m here to talk a bit about UNSTRUCTURED DATA, and more-so, SEMI-STRUCTURED data, in the form of data models, content, relational database structures, and hierarchical (COBOL) structures.
For a long time I had a feature in RapidACE called Model Consolidation. It did what other tools could not do… take 2 to N disparate data models and “MERGE” them together through proprietary algorithms. It was fairly effective. I was not the first, and I won’t be the last, to see that data models are nothing more than ontological expressions of “how we store and understand” our data. In other words, lending context to our data sets and our structures.
Oh yea, what about Unstructured Data? I thought you were going to talk about that…
YEP! It’s all a part of what I have to say… You see, unstructured data really is STRUCTURED at the heart of it – it’s all bits (ones and zeros), so in reality it truly is structured! But, understanding the unstructured data, that is: lending context to it is where the genius comes in. (That would be the human mind most of the time).
In working with Data Structures (COBOL COPYBOOKS) or RELATIONAL TABLE STRUCTURES what we are really doing is lending context (albeit simple context) to what the content within the table/column is supposed to have. These are lables to data that make it understandable and consistently accessible to SQL (standard query language). Which we all know has been formalized mathematically for data access against these structures.
Now, where’s the good part? Take a Data Model and turn it in to an ontology; and you can begin creating magic, especially when you apply business terms to the structures!! Cobol copybooks are hierarchical ontologies, already organized in to parent and child combined relationships. What’s so special about this? You can see it ALL OVER THE WORLD. There has been a ton of work done on this subject, you can leverage it to your hearts content… for free even (if you have enough gumption to figure out how to work the academic products that exist).
Look it up: It’s called ONTOLOGY ALIGNMENT…
Type the term into google, and you begin to see different tools and articles written on the subject of aligning metadata… ie data structures.
What does this all mean? It means: 1) if you can turn your data model into an ontology 2) you can absorb the ontology into one of the fancy tools 3) you can use these fancy tools to “merge” ontologies in a human guided fashion. The end-results? You produce a single consistent merged data model…
Here are some links you might be interested in:
http://www-01.ibm.com/software/data/infosphere/fasttrack/ (cross-walk management, ETL Gen) ($67,000) + EXPENSIVE!!!
http://www.WhereScape.com (ETL Generation + Data Profiling) (don’t know the price)
http://www.BI-Ready.com (ETL Generation, Data Warehouse black-box)
http://www.qosqo.nl/ (opensource Quipu product, Model Engineering + ETL Generation)
http://www.analytixds.com (cross-walk management, ETL generation)
Forgive me if I’ve got this wrong, or missed anything – feel free to comment to correct the post if you see fit.
By the way, just in case you’re thinking of trying this yourself… in your own product… be aware of the following patent application:
I will just say this: there’s power in these concepts, but it’s a matter of getting it right that matters. All of this (data model consolidation included) can be done, from data model structures alone – but profiling the information makes it that much more powerful..