Deceptively Simple Conceptual Data Virtualization

 Deceptively Simple Conceptual Data Virtualization
<http://kidehen.blogspot.com/2014/12/deceptively-simple-conceptual-data.html>
Using the combined prowess of Linked Open Data, RDF, and Ontologies
(Semantically Rich Data Dictionary), we can now virtualize disparate SQL
RDMS Data Sources, conceptually. Add Virtuoso to the mix, and this goal is
achieve without compromising performance, scalability, and security.
 What is Conceptual Data Virtualization of SQL RDBMS Data?
Construction of explicit conceptual entity relationship based views over a
variety of ODBC accessible SQL RDBMS based Data Sources. These views take
the form of *subject->predicate->object* or *entity->attribute-value* based
relational property graphs, rather than relational tables.
 Why is it Important?
The Volume, Velocity, and Variety of Data continue to pose agility
challenges to enterprises and individuals alike. Circa., 2014, we are
still grappling with SQL RDBMS siloed data from prior investments in a
variety of SQL RDBMS backed applications and services. Net effect, we
remain unable to virtualize conceptually, using open standards, in a manner
that scales.
 Ideally, SQL RDBMS Table based Relations should be able to co-exist with
semantically-rich RDF based Relations (Property/Predicate graphs) en route
to addressing
the need for conceptually integrated data access, integration, and
management.
 How Do I Use It?
Using the R2RML <http://www.w3.org/TR/r2rml/> declarative language for
mapping SQL RDBMS Relations (represented as Tables) to RDF based Linked
Data Relations (represented as Predicate/Property Graphs), as implemented
in Virtuoso (which includes an HTML based R2RML generation Wizard), you can
automatically construct the following (fully materialized or transient
form) from existing SQL RDBMS Database Schemas:

   - Ontology of Class and Property/Predicate definitions from each ODBC
   accessible Table
   - Instances of Classes defined in the generated Ontology
   - Instances of Relations defined in the generated Ontology (represented
   using a variety of RDF subject, predicate, object notations).

 What follows is a collection of links to live demo instances of Virtuoso
that showcase the following:

   - SQL RDBMS Virtual Database Functionality atop ODBC accessible Data
   Sources -- Oracle, SQL Server, DB2, Sybase, Informix, Ingres, Progress
   etc., databased attached to Virtuoso
   - RDF based Conceptual Views over ODBC accessible Data Sources --
   dynamically generated Ontologies from the Data Dictionaries of each of the
   attached SQL RDBMS Tables.

 Each generated Ontology provides powerful "context lenses" that enable
powerful exploration of the data stored in each SQL RDBMS. Here are some
live examples (note: *authenticate as user "vdb" and password "vdb" when
challenged for credentials*):

   - http://demo.openlinksw.com/c/HDDR3Y -- Ontology generated from Data
   Dictionary of an Oracle HR Demo Database
   - http://demo.openlinksw.com/c/GVE4C2 -- Ontology generated from Data
   Dictionary of an Microsoft SQL Server Northwind Demo Database
   - http://demo.openlinksw.com/c/GJYXNW -- Ontology generated from Data
   Dictionary of a Sybase Pubs Demo Database
   - http://demo.openlinksw.com/c/HKN4M2 -- Ontology generated from Data
   Dictionary of an Informix Stores Demo Database
   - http://demo.openlinksw.com/c/F6ESUE -- Ontology generated from Data
   Dictionary of a Progress iSports Demo Database
   - http://demo.openlinksw.com/c/GW7JKN -- Ontology generated from Data
   Dictionary of an IBM DB2 Demo Database
   - http://demo.openlinksw.com/c/HR2JT2 -- Ontology generated from Data
   Dictionary of an Ingres Books Demo Database



http://kidehen.blogspot.ca/2014/12/deceptively-simple-conceptual-data.html