VirtTipsAndTricksGuideTrblLinkedDataViews Troubleshooting Linked Data Views generated from a Relational Database Troubleshooting Linked Data Views generated from a Relational Database What? Virtuoso provides powerful options for generating 5-Star Linked Data from ODBC and JDBC accessible RDBMS based data sources. It provides you with the ability to produce transient and materialized Linked Data views using its native Metaschema Language or the W3C's R2RML. Why? Being able to diagnose problems associated with Linked Data views generation is vital for sustainable usage of this powerful Virtuoso feature. How? The following steps guide you through the process of generating Linked Data Views and isolating problems that might arise during the process: Pick an example script building your view, in this case we use one that builds Linked Data Views from the DB2 hosted data. It might happen that while running the script you receive output errors such as: 22023 The quad storage "http://www.openlinksw.com/schemas/virtrdf#DefaultQuadStorage" is edited by other client, started 2011-12-19 16:20:48 The error above means that a manipulation was started at 2011-12-19 16:20:48, but it never completed. The default remedy is to use Virtuoso's DB.DBA.RDF_AUDIT_METADATA() function, as follows: SQL> DB.DBA.RDF_AUDIT_METADATA(1, '*'); The resulting output should contain no errors. Some demo links from the created Linked Data Views: Instance Data Named Graph http://demo.openlinksw.com/DB2HUGH# Metadata Data (VoID) http://demo.openlinksw.com/DB2HUGH/stat# Ontology Data Named Graph http://demo.openlinksw.com/schemas/DB2HUGH/ Quad Maps http://demo.openlinksw.com/schemas/DB2HUGH/qm-cl_sched http://demo.openlinksw.com/schemas/DB2HUGH/qm-department http://demo.openlinksw.com/schemas/DB2HUGH/qm-employee http://demo.openlinksw.com/schemas/DB2HUGH/qm-emp_act http://demo.openlinksw.com/schemas/DB2HUGH/qm-emp_photo http://demo.openlinksw.com/schemas/DB2HUGH/qm-emp_resume http://demo.openlinksw.com/schemas/DB2HUGH/qm-in_tray http://demo.openlinksw.com/schemas/DB2HUGH/qm-org http://demo.openlinksw.com/schemas/DB2HUGH/qm-project http://demo.openlinksw.com/schemas/DB2HUGH/qm-sales http://demo.openlinksw.com/schemas/DB2HUGH/qm-staff http://demo.openlinksw.com/schemas/DB2HUGH/qm-VoidStatistics Sample URIs http://demo.openlinksw.com/DB2HUGH/department/DEPTNO/A00#this http://demo.openlinksw.com/DB2HUGH/employee/EMPNO/000010#this http://demo.openlinksw.com/DB2HUGH/emp_act/EMPNO/000010/PROJNO/MA2100/ACTNO/10#this http://demo.openlinksw.com/DB2HUGH/emp_photo/EMPNO/000130/PHOTO_FORMAT/bitmap#this http://demo.openlinksw.com/DB2HUGH/emp_resume/EMPNO/000130/RESUME_FORMAT/ascii#this http://demo.openlinksw.com/DB2HUGH/org/DEPTNUMB/10/MANAGER/160#this http://demo.openlinksw.com/DB2HUGH/project/PROJNO/AD3100#this http://demo.openlinksw.com/DB2HUGH/sales/SALES_DATE/1995-12-31T05:00:00Z/SALES_PERSON/LUCCHESSI/REGION/Ontario-South/SALES/1#this http://demo.openlinksw.com/DB2HUGH/staff/ID/10#this http://demo.openlinksw.com/DB2HUGH/stat# Related Virtuoso Tips and Tricks Collection "Generate RDB2RDF triggers" and "Enable Data Syncs with Physical Quad Store" Linked Data Views options Generate Transient and/or Persistent Linked Data Views atop ODBC or JDBC accessible Relational Data Sources Using OWL based inference to exploit the power of Linked Vocabularies Import Linked Data using the Briefcase "Create" feature Simple Linked Data Deployment using Virtuoso's HTTP Re-write Rules Reification alternatives usage for Linked Data publishing Virtuoso Linked Data Deployment In 3 Simple Steps Expose Linked Data View URIs associated with "References" on a given Table Manage Linked (Open) Data