Best way to create a SPARQL endpoint for a DBMS (MySQL database)

Question

I am doing (want to do) some experiments with related open datasets, especially with governments.

I have RDBMS (more precisely, MySQL). I developed it taking into account semantic web ideas, i.e. I have information stored as objects, predicates and classes that define objects. In turn, all objects are related to each other, although object statements are subject → predicate → (where objects are from the table of objects).

I want to be able to request other thrice RDF stores from my application and let the other three stores request my data. Is it possible to "set something" so that it is possible?

I looked at Jena. Using Jena seems to mean that I should use this storage application, not MySQL. The only problem is that I am including a new concept called a category (which, I think, is not part of the semantic web languages). I will use categories to help with the display of information (they have no other meaning), but using Jena seems to mean that I cannot organize the predicates into categories for easier viewing.

I use Java, so it is preferable to use the JAVA API.

It is also possible that I misunderstood the goal of Jena, and maybe it can be useful, but I'm not sure how to do it.

I am sure that in four days this question will seem rather stupid, but at the moment I am somewhat confused about how to proceed.

Answer 1

, " " ", , ?

, , , - - , .

, ( ):

@prefix sch-ont:  <http://education.data.gov.uk/def/school/>.
<http://education.data.gov.uk/id/school/135412>
a sch-ont:School;
sch-ont:establishmentStatus 
    <http://education.data.gov.uk/def/school/EstablishmentStatus_Open>;
sch-ont:MSOA <http://statistics.data.gov.uk/id/msoa/E02000001>;
sch-ont:establishmentName "Guildhall School of Music and Drama";
...

SPARQL, . , , . :

@prefix ankurs-app: <http://ankur.org/example/app/vocab/display#>.
<http://education.data.gov.uk/id/school/135412> 
        ankurs-app:category ankurs-app:wkdCool.

, , , , , . , Jena, SPARQL.

. RDF, Jena, . :)

Jena RDF, D2RQ.

Answer 2

? SPARQL endpoint, SPARQL -api. , SPARQL HTTP.

, (Jena + SDB, Mulgara, Virtuoso, Oracle ..). , , Mulgara db, , , , .

, , RDF , , - .