This HTML5 document contains 46 embedded RDF statements represented using HTML+Microdata notation.

The embedded RDF content will be recognized by any processor of HTML5 Microdata.

Namespace Prefixes

PrefixIRI
dctermshttp://purl.org/dc/terms/
atomhttp://atomowl.org/ontologies/atomrdf#
foafhttp://xmlns.com/foaf/0.1/
n15http://vos.openlinksw.com/dataspace/services/wiki/
oplhttp://www.openlinksw.com/schema/attribution#
n2http://vos.openlinksw.com/dataspace/owiki/wiki/VOS/
dchttp://purl.org/dc/elements/1.1/
n18http://vos.openlinksw.com/dataspace/dav#
n17http://vos.openlinksw.com/dataspace/owiki/wiki/VOS/VirtXMLAODBCExplorerLinkedDataViews/
rdfshttp://www.w3.org/2000/01/rdf-schema#
n14http://rdfs.org/sioc/services#
n12http://vos.openlinksw.com/dataspace/person/dav#
n19http://demo.openlinksw.com/XMLAexplorer/
siocthttp://rdfs.org/sioc/types#
n5http://vos.openlinksw.com/dataspace/owiki/wiki/
rdfhttp://www.w3.org/1999/02/22-rdf-syntax-ns#
n20http://queue.acm.org/
n22http://vos.openlinksw.com/dataspace/owiki#
n23http://en.wikipedia.org/wiki/
n21http://wikis.openlinksw.com/dataspace/owiki/wiki/UdaWikiWeb/InstallConfigXMLAHTML5Bridge#
xsdhhttp://www.w3.org/2001/XMLSchema#
n13http://vos.openlinksw.com/dataspace/%28NULL%29/wiki/VOS/
n11http://vos.openlinksw.com/dataspace/person/owiki#
siochttp://rdfs.org/sioc/ns#
n4http://vos.openlinksw.com/wiki/main/VOS/VirtXMLAODBCExplorerLinkedDataViews/

Statements

Subject Item
n12:this
foaf:made
n2:VirtXMLAODBCExplorerLinkedDataViews
Subject Item
n18:this
sioc:creator_of
n2:VirtXMLAODBCExplorerLinkedDataViews
Subject Item
n15:item
n14:services_of
n2:VirtXMLAODBCExplorerLinkedDataViews
Subject Item
n22:this
sioc:creator_of
n2:VirtXMLAODBCExplorerLinkedDataViews
Subject Item
n5:VOS
sioc:container_of
n2:VirtXMLAODBCExplorerLinkedDataViews
atom:entry
n2:VirtXMLAODBCExplorerLinkedDataViews
atom:contains
n2:VirtXMLAODBCExplorerLinkedDataViews
Subject Item
n2:VirtXMLAODBCExplorerLinkedDataViews
rdf:type
sioct:Comment atom:Entry
dcterms:created
2017-06-13T05:44:39.570762
dcterms:modified
2017-06-29T07:42:19.101559
rdfs:label
VirtXMLAODBCExplorerLinkedDataViews
foaf:maker
n11:this n12:this
dc:title
VirtXMLAODBCExplorerLinkedDataViews
opl:isDescribedUsing
n17:sioc.rdf
sioc:has_creator
n18:this n22:this
sioc:attachment
n4:ld5.png n4:ld2.png n4:ld3.png n4:ld10.png n4:ld11.png n4:ld1.png n4:ld8.png n4:ld9.png n4:ld6.png n4:ld7.png n4:ld4.png
sioc:content
%META:TOPICPARENT{name="VirtTipsAndTricksGuide"}% ---+Exposing Linked Data View URIs associated with "SQL References" on a given Table using a simple function %TOC% ---++What? A function that exposes Linked Data View URIs associated with "SQL References" on a given Table. Note, "SQL References" expose local columns that are part of Foreign Keys associated with other tables. Thus, given two tables 'Orders' and 'Customers' where the 'Orders' table has a foreign key "CustKey" comprised of the 'CustomerID' field in the 'Customer' table, the following data dictionary objects would exist in a typical RDBMS schema: * 'Orders' table -- foreign key "CustKey" comprised of the column 'CustomerID' * 'Customers' table -- a reference that identifies the foreign key "CustKey" its'CustomerID' component and the table ('Orders' in this case) on which the foreign key was created. Foreign Keys and References are mirrors that provide powerful mechanisms for referential integrity and smart data navigation. ---++Why? Linked Data Views over SQL data provides a powerful mechanism for exercising the virtues of Intensional database definition and data access. Basically, this means that rather that being confined to a representation of data where identifiers such as Primary and Foreign Keys are part of the data (as Extensions) you can explore the use of Identifiers in a manner distinct from actual records. The net effect of this is that each record becomes explicit proposition (or claim) associated with an Identifier that's verifiable via the host DBMS in course of query execution and fulfillment. The <code>links_dump</code> function enables you to quickly establish a bridge that connects the Intensional and Extensional aspects of the Virtuoso (hybrid model) DBMS: <verbatim> CREATE PROCEDURE links_dump (in tb varchar) { declare res, tb_name any; result_names (res); tb_name := sprintf ('"%S"."%S"."%S"', name_part (tb, 0), name_part (tb, 1), name_part (tb, 2)); FOR SELECT "o" FROM ( SPARQL SELECT DISTINCT ?o WHERE { ?s virtrdf:qmTableName ?:tb_name ; virtrdf:qmPredicateRange-rvrFixedValue ?ref . ?ref <http://www.w3.org/2000/01/rdf-schema#domain> ?o . } ) x DO result ("o"); end_result (); } ; </verbatim> ---++How? Bearing in mind that a SQL scheme Reference is the inverse of a Foreign Key i.e., given a qualified 'Table Name' you can use References information from a data dictionary (schema) to determine where the fields of said 'Table' are the Referents in Foreign Keys created by other Tables. ---+++Sample Scenario ---++++Prerequisites Make sure the [[http://wikis.openlinksw.com/dataspace/owiki/wiki/UdaWikiWeb/InstallConfigXMLAHTML5Bridge#Install%20the%20HTML5][HTML5 WebDB-to-XMLA Bridge Extension]] is installed. ---++++Basic Steps 1 Go to http://demo.openlinksw.com/XMLAexplorer/XMLAexplorer.html %BR%%BR%<img src="%ATTACHURLPATH%/ld1.png" />%BR%%BR% 1 Enter user "vdb" and password "vdb": %BR%%BR%<img src="%ATTACHURLPATH%/ld2.png" />%BR%%BR% 1 Click "Connect": %BR%%BR%<img src="%ATTACHURLPATH%/ld3.png" />%BR%%BR% %BR%%BR%<img src="%ATTACHURLPATH%/ld4.png" />%BR%%BR% 1 Expand for ex. the "Demo" Catalog: %BR%%BR%<img src="%ATTACHURLPATH%/ld5.png" />%BR%%BR% 1 Double click on a table, for ex. "Customers": 1 Should be presented the "Structure" tab showing the table's catalog name, schema, name, columns, etc. %BR%%BR%<img src="%ATTACHURLPATH%/ld6.png" />%BR%%BR% 1 Go to "Primary Keys" tab to view the list of the "Customer" table primary keys: %BR%%BR%<img src="%ATTACHURLPATH%/ld7.png" />%BR%%BR% 1 Go to "Foreign Keys" tab to view the list of the "Customer" table foreign keys: %BR%%BR%<img src="%ATTACHURLPATH%/ld8.png" />%BR%%BR% 1 Using the function <code>links_dump"</code> we are locating TBox URIs derived from the selected table that are used in one of more Linked Data Views (Quad Maps). The list of these URIs is presented in the "<b>References</b>" tab: %BR%%BR%<img src="%ATTACHURLPATH%/ld9.png" />%BR%%BR% 1 For executing queries one can use the "Execute SQL" tab, which in our example shows default query selecting all columns from the table <code>"Demo"."demo"."Customers"</code>: %BR%%BR%<img src="%ATTACHURLPATH%/ld10.png" />%BR%%BR% %BR%%BR%<img src="%ATTACHURLPATH%/ld11.png" />%BR%%BR% ---++Related * [[VirtTipsAndTricksGuide][Virtuoso Tips and Tricks Collection]] * [[http://queue.acm.org/detail.cfm?id=1961297][A co-Relational Model of Data for Large Shared Data Banks]] * [[http://en.wikipedia.org/wiki/Intensional_definition][Intensional Definition]]
sioc:id
500885d2aedabc7a81e58670fa9223de
sioc:link
n2:VirtXMLAODBCExplorerLinkedDataViews
sioc:has_container
n5:VOS
n14:has_services
n15:item
atom:title
VirtXMLAODBCExplorerLinkedDataViews
sioc:links_to
n13:CustKey n19:XMLAexplorer.html n20:detail.cfm?id=1961297 n13:CustomerID n21:Install%20the%20HTML5 n23:Intensional_definition
atom:source
n5:VOS
atom:author
n12:this
atom:published
2017-06-13T05:44:39Z
atom:updated
2017-06-29T07:42:19Z
sioc:topic
n5:VOS