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.

Subject Item

n17:this

foaf:made

n2:VirtXMLAODBCExplorerLinkedDataViews

Subject Item

n23:this

sioc:creator_of

n2:VirtXMLAODBCExplorerLinkedDataViews

Subject Item

n20:item

n19:services_of

n2:VirtXMLAODBCExplorerLinkedDataViews

Subject Item

n27:this

sioc:creator_of

n2:VirtXMLAODBCExplorerLinkedDataViews

Subject Item

n6: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

n16:this n17:this

dc:title

VirtXMLAODBCExplorerLinkedDataViews

opl:isDescribedUsing

n22:rdf

sioc:has_creator

n23:this n27:this

sioc:attachment

n4:png n5:png n7:png n8:png n9:png n11:png n30:png n31:png n32:png n33:png n34: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

n6:VOS

n19:has_services

n20:item

atom:title

VirtXMLAODBCExplorerLinkedDataViews

sioc:links_to

n18:CustKey n24:html n25:1961297 n18:CustomerID n26:HTML5 n28:Intensional_definition

atom:source

n6:VOS

atom:author

n17:this

atom:published

2017-06-13T05:44:39Z

atom:updated

2017-06-29T07:42:19Z

sioc:topic

n6:VOS