Creating a triple store query using SQL - how to find all triples that have a common predicate and o

Posted by Ankur on Stack Overflow See other posts from Stack Overflow or by Ankur
Published on 2010-04-21T02:36:31Z Indexed on 2010/04/21 2:43 UTC
Read the original article Hit count: 285

Filed under:

rdf

|

triples

|

semantic-web

|

sql

I have a database that acts like a triple store, except that it is just a simple MySQL database.

I want to select all triples that have a common predicate and object. Info about RDF and triples

I can't seem to work out the SQL.

If I had just a single predicate and object to match I would do:

select TRIPLE from TRIPLES where PREDICATE="predicateName" and OBJECT="objectName"

But if I have a list (HashMap) of many pairs of (predicateName,objectName) I am not sure what I need to do.

Please let me know if I need to provide more info, I am not sure that I have made this quite clear, but I am wary of providing too much info and confusing the issue.

© Stack Overflow or respective owner

Related posts about rdf

RDF correct approach to subClassOf

as seen on Stack Overflow - Search for 'Stack Overflow'
I am learning RDF. What's the difference between this two approaches: a) <?xml version="1.0" encoding="UTF-8"?> <rdf:RDF xmlns:rdfs="http://www.w3.org/2000/01/rdf-schema#" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:tur="http://www.blah.com/turismo#"> <rdf:Description… >>> More
Parse RDF XML file to get all rdf:about values

as seen on Stack Overflow - Search for 'Stack Overflow'
I am using php's simple xml and xpath to parse an rdf xml file and am struggling to get a list of all the rdf:about values. Any advice? >>> More
Extracting URIs from RDF web page in Java using Jena Library

as seen on Stack Overflow - Search for 'Stack Overflow'
I have written following code for extratcting URIs from a web page with content type application/rdf-xml for Linked Data application. public static void test(String url) { try { Model read = ModelFactory.createDefaultModel().read(url); System.out.println("to go"); … >>> More
How to access members of an rdf list with rdflib (or plain sparql)

as seen on Stack Overflow - Search for 'Stack Overflow'
What is the best way to access the members of an rdf list? I'm using rdflib (python) but an answer given in plain SPARQL is also ok (this type of answer can be used through rdfextras, a rdflib helper library). I'm trying to access the authors of a particular journal article in rdf produced by Zotero… >>> More
Reading multiple instances of a tag or element using XSLT

as seen on Stack Overflow - Search for 'Stack Overflow'
My RDF xml file is something like this.. <rdf:RDF> <rdf:Description rdf:about="........"> <j.0:property rdf:resource="....."/> <j.0:property rdf:resource=....."/> <j.0:property rdf:resource="........"/> </rdf:Description> </rdf:RDF> Now… >>> More

Related posts about triples

Creating a triple store query using SQL - how to find all triples that have a common predicate and o

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a database that acts like a triple store, except that it is just a simple MySQL database. I want to select all triples that have a common predicate and object. Info about RDF and triples I can't seem to work out the SQL. If I had just a single predicate and object to match I would do: select… >>> More
Solving Naked Triples in Sudoku

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello, I wished I paid more attention to the math classes back in Uni. :) How do I implement this math formula for naked triples? Naked Triples Take three cells C = {c1, c2, c3} that share a unit U. Take three numbers N = {n1, n2, n3}. If each cell in C has as its candidates ci ? N then we can… >>> More
How to select a subset of results from a select statement

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a table that stores RDF triples: triples(triple_id, sub_id, pre_id, obj_id) The method (I need to write) will receive an array of numbers which correspond to pre_id values. I want to select all sub_id values that have a corresponding pre_id for all the pre_ids in the array that is passed… >>> More
How can one extract rdf:about or rdf:ID properties from triples using SPARQL?

as seen on Stack Overflow - Search for 'Stack Overflow'
It seemed a trivial matter at the beginning but so far I have not managed to get the unique identifier for a given resource using SPARQL. What I mean is given, e.g., rdf:Description rdf:about="http://..." and then some properties identifying this resource, what I want to do is to first find this very… >>> More
How can one extra rdf:about or rdf:ID properties from triples using SPARKQL?

as seen on Stack Overflow - Search for 'Stack Overflow'
It seemed a trivial matter at the beginning but so far I had not managed to get unique identifier for a given resource using SPARKQL. What I mean is given and then some properties identifiying this resource in perfect world I want to first know how to retrieve an individual triple given some uri… >>> More