This HTML5 document contains 96 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/
n21http://vos.openlinksw.com/dataspace/services/wiki/
oplhttp://www.openlinksw.com/schema/attribution#
n4http://vos.openlinksw.com/dataspace/owiki/wiki/VOS/
dchttp://purl.org/dc/elements/1.1/
n11http://vos.openlinksw.com/dataspace/dav#
rdfshttp://www.w3.org/2000/01/rdf-schema#
n20http://rdfs.org/sioc/services#
siocthttp://rdfs.org/sioc/types#
n6http://vos.openlinksw.com/dataspace/person/dav#
n15http://vos.openlinksw.com/wiki/main/VOS/VirtMySQLLinkingObjects/
n2http://vos.openlinksw.com/dataspace/owiki/wiki/
rdfhttp://www.w3.org/1999/02/22-rdf-syntax-ns#
n14http://vos.openlinksw.com/dataspace/owiki#
n18http://vos.openlinksw.com/dataspace/owiki/wiki/VOS/VirtMySQLLinkingObjects/
xsdhhttp://www.w3.org/2001/XMLSchema#
n12http://vos.openlinksw.com/dataspace/%28NULL%29/wiki/VOS/
n9http://vos.openlinksw.com:80/wiki/main/VOS/VirtMySQLLinkingObjects/
n13http://vos.openlinksw.com/dataspace/person/owiki#
siochttp://rdfs.org/sioc/ns#

Statements

Subject Item
n6:this
foaf:made
n4:VirtMySQLLinkingObjects
Subject Item
n11:this
sioc:creator_of
n4:VirtMySQLLinkingObjects
Subject Item
n21:item
n20:services_of
n4:VirtMySQLLinkingObjects
Subject Item
n14:this
sioc:creator_of
n4:VirtMySQLLinkingObjects
Subject Item
n2:VOS
sioc:container_of
n4:VirtMySQLLinkingObjects
atom:entry
n4:VirtMySQLLinkingObjects
atom:contains
n4:VirtMySQLLinkingObjects
Subject Item
n4:VirtMySQLLinkingObjects
rdf:type
sioct:Comment atom:Entry
dcterms:created
2017-06-13T05:39:22.303214
dcterms:modified
2017-06-13T05:39:22.303214
rdfs:label
VirtMySQLLinkingObjects
foaf:maker
n13:this n6:this
dc:title
VirtMySQLLinkingObjects
opl:isDescribedUsing
n18:sioc.rdf
sioc:has_creator
n14:this n11:this
sioc:attachment
n9:._VirtLinkMYS5.png.6yyzHD n9:._VirtLinkMYS6.png.SRFZtp n9:._VirtLinkMYS3.png.khJzwq n9:._VirtLinkMYS4.png.XBvzTY n9:._VirtLinkMYS9.png.6WF14i n9:._VirtWebHome.png.19ShPr n9:._VirtLinkMYS7.png.NgW6Uh n9:._VirtLinkMYS8.png.SlIcmf n9:._.DS_Store.okbh58 n9:._VirtConductor.png.Zq0aF7 n9:._VirtLinkMYS10.png.X3kfDD n9:._VirtLinkMYS2.png.949cNY n9:._VirtLinkMYS0.png.2Qczsc n9:._VirtLinkMYS1.png.BqoZ7m n9:._VirtLinkMYS6.png n9:._VirtLinkMYS4.png n9:._VirtLinkMYS5.png n9:._VirtLinkMYS8.png n9:._VirtLinkMYS9.png n9:._VirtLinkMYS7.png n15:VirtWebHome.png n15:.DS_Store n9:._VirtWebHome.png n15:VirtLinkMYS8.png n15:VirtLinkMYS9.png n15:._VirtLinkMYS0.png n15:._VirtLinkMYS1.png n15:._.DS_Store n15:._VirtConductor.png n15:VirtLinkMYS2.png n15:VirtLinkMYS3.png n15:VirtLinkMYS1.png n15:VirtLinkMYS10.png n15:VirtLinkMYS6.png n15:VirtLinkMYS7.png n15:VirtLinkMYS4.png n15:VirtLinkMYS5.png n15:VirtConductor.png n15:VirtLinkMYS0.png n9:._VirtConductor.png n9:._.DS_Store n9:._VirtLinkMYS1.png n9:._VirtLinkMYS10.png n9:._VirtLinkMYS0.png n9:._VirtLinkMYS3.png n9:.DS_Store n9:._VirtLinkMYS2.png n15:._VirtLinkMYS9.png n15:._VirtWebHome.png n15:._VirtLinkMYS3.png n15:._VirtLinkMYS4.png n15:._VirtLinkMYS10.png n15:._VirtLinkMYS2.png n15:._VirtLinkMYS7.png n15:._VirtLinkMYS8.png n15:._VirtLinkMYS5.png n15:._VirtLinkMYS6.png
sioc:content
%VOSWARNING% %META:TOPICPARENT{name="VirtLinkRemoteTables"}% ---+ Linking <nop>MySQL Database Objects into Virtuoso ---++ Steps 1 Start the Virtuoso Web User Interface. %BR%%BR%<img src="%ATTACHURLPATH%/VirtWebHome.png" style="wikiautogen"/>%BR%%BR% 1 Select the *Conductor* link in the left frame and login as the *dba* user. %BR%%BR%<img src="%ATTACHURLPATH%/VirtConductor.png" style="wikiautogen"/>%BR%%BR% 1 Select the *Databases* -> *External Data Source* -> *Data Sources* tab menu items. %BR%%BR%<img src="%ATTACHURLPATH%/VirtLinkMYS0.png" style="wikiautogen"/>%BR%%BR% 1 Select the *Connect* button for the *mysqlma* <nop>MySQL DSN. %BR%%BR%<img src="%ATTACHURLPATH%/VirtLinkMYS1.png" style="wikiautogen"/>%BR%%BR% 1 On succesful connection, select the *Link Objects* button to obtain a list of available tables. %BR%%BR%<img src="%ATTACHURLPATH%/VirtLinkMYS2.png" style="wikiautogen"/>%BR%%BR% 1 Select all the tables that are part of the *mysql* catalog. %BR%%BR%<img src="%ATTACHURLPATH%/VirtLinkMYS3.png" style="wikiautogen"/>%BR%%BR% 1 Ensure a primary key is assigned to all tables that are to be used in the EDM generation phase. %BR%%BR%<img src="%ATTACHURLPATH%/VirtLinkMYS4.png" style="wikiautogen"/>%BR%%BR% 1 Change the Catalog for each table to be *mysql* using the *Set All* button.%BR%%BR% 1 Select the *Link* button to link the selected tables into Virtuoso. %BR%%BR%<img src="%ATTACHURLPATH%/VirtLinkMYS5.png" style="wikiautogen"/>%BR%%BR% 1 On completion of the Link process, the tables will be displayed in the *External Linked Objects* tab. %BR%%BR%<img src="%ATTACHURLPATH%/VirtLinkMYS6.png" style="wikiautogen"/>%BR% 1 The linked tables can be queried by clicking on the hyperlink in the *Local Name* column of the *External Linked Objects* tab above. This loads the Virtuoso *Interactive SQL* interface with the required SQL *Select* for retrieving the remote table data. We shall use the *mysql.mysqlma.artist* table to demonstrate this. %BR%%BR%<img src="%ATTACHURLPATH%/VirtLinkMYS9.png" style="wikiautogen"/>%BR%%BR% 1 Click the *Execute* button to run the query and retrieve the results from the remote table. %BR%%BR%<img src="%ATTACHURLPATH%/VirtLinkMYS10.png" style="wikiautogen"/>%BR%%BR% 1 The tables can also be viewed as part of the Virtuoso *SQL Schema Objects* under the *mysql* catalog name. %BR%%BR%<img src="%ATTACHURLPATH%/VirtLinkMYS7.png" style="wikiautogen"/>%BR% .%BR% .%BR% . %BR%<img src="%ATTACHURLPATH%/VirtLinkMYS8.png" style="wikiautogen"/>%BR%%BR% The link process is now complete enabling the tables to be queried as if part of the Virtuoso Schema. ---++ Related * [[VOSSQL2RDF][Mapping SQL Data to Linked Data Views]] * [[VirtMySQLEntityFrameworkUsage][Using Microsoft Entity Frameworks to Access MySQL Schema Objects with Virtuoso]] CategoryDocumentation CategoryVirtuoso CategoryDotNET CategoryEntityFrameworks CategoryWebSite
sioc:id
4c311948d7ad52fadbdde20bc3fab18e
sioc:link
n4:VirtMySQLLinkingObjects
sioc:has_container
n2:VOS
n20:has_services
n21:item
atom:title
VirtMySQLLinkingObjects
sioc:links_to
n12:VOSSQL2RDF n12:CategoryDotNET n12:CategoryDocumentation n12:CategoryEntityFrameworks n12:CategoryWebSite n12:CategoryVirtuoso n12:VirtMySQLEntityFrameworkUsage
atom:source
n2:VOS
atom:author
n6:this
atom:published
2017-06-13T05:39:22Z
atom:updated
2017-06-13T05:39:22Z
sioc:topic
n2:VOS
Subject Item
n4:VirtLinkRemoteTables
sioc:links_to
n4:VirtMySQLLinkingObjects
Subject Item
n4:VirtMySQLEntityFrameworkUsage
sioc:links_to
n4:VirtMySQLLinkingObjects
Subject Item
n4:VirtMysRDFViewUI
sioc:links_to
n4:VirtMySQLLinkingObjects