チェンジセット 46 : BH13SPARQLBuilder/src/org/biohackathon/SPARQLBuilder/OWL/OWLQueryBuilderImpl.java

更新日時:

2014/02/17 16:11:59 (11 年 前)

更新者:

nori

ログメッセージ:

getNextClassで、トリプルの起点となるインスタンス数と終点となるインスタンス数をそれぞれ求められるようにした。

ファイル:

• BH13SPARQLBuilder/src/org/biohackathon/SPARQLBuilder/OWL/OWLQueryBuilderImpl.java (変更) (11 diff)

BH13SPARQLBuilder/src/org/biohackathon/SPARQLBuilder/OWL/OWLQueryBuilderImpl.java

@@ -72 +72 @@
                 }
 */
+
                 System.out.println("CLS");
 
                 String uri = "http://purl.jp/bio/10/lsd/ontology/201209#EnglishEntry";
                 
-                ClassLink[] cls = builder.getNextClass(null, uri, 100, false);
-
+                ClassLink[] cls = null;
+                try{
+                        cls = builder.getNextClass(null, uri, 100, false);
+                }catch(Exception ex) {
+                        ex.printStackTrace();
+                }
+
+                System.out.println("Solutions: ");
                 if (cls != null) {
                         for (ClassLink cl : cls) {
@@ -87 +94 @@
                         }
                 }
+
+                
+                
+                
 /*
+                uri = "http://purl.jp/bio/10/lsd/ontology/201209#EnglishEntry";
+
                 System.out.println("CLS-INS");
-                cls = builder.getNextClassViaInstanceLink(null, clz[0].getClassURI(),
-                                100);
+                cls = null;
+                try{ 
+                        cls = builder.getNextClassViaInstanceLink(null, uri, 100);
+                }catch(Exception ex){
+                        ex.printStackTrace();
+                }
                 if (cls != null) {
                         for (ClassLink cl : cls) {
@@ -96 +113 @@
                         }
                 }
-
+*/
+                /*
                 System.out.println("Instances");
                 Instance[] ins = builder.getInstances(null, "\"A.C. Reed\"@en");
@@ -184 +202 @@
 
                 Query query = QueryFactory.create(queryStr.toString());
-                QueryExecution qexec = QueryExecutionFactory.sparqlService(endpointURI,
-                                query);
+
+                
+                QueryExecution qexec = null;
+                try{
+                        long start = System.currentTimeMillis();
+                        qexec = QueryExecutionFactory.sparqlService(endpointURI,
+                                        query);
+                        long end = System.currentTimeMillis();
+                        System.out.println("EXEC TIME: " + (end-start));
+                }catch(Exception ex){
+                        ex.printStackTrace();
+                        throw ex;
+                }
 
                 ResultSet results = qexec.execSelect();
@@ -327 +356 @@
                 // SELECT
                 if (countLinks) {
-                        queryStr.append("SELECT DISTINCT ?p ?pDirection ?c (COUNT(?s) AS ?numOfLinks) \n");
+                        queryStr.append("SELECT DISTINCT ?p ?pDirection ?c (COUNT(?s) AS ?numOfLinks) (COUNT(DISTINCT(?s)) AS ?numOfLinkedInstances) \n");
                 } else {
                         queryStr.append("SELECT DISTINCT ?p ?pDirection ?c \n");
@@ -390 +419 @@
                 }
 
+                System.out.println("getNextClasses SPARQL Query: ");
                 System.out.println(queryStr.toString());
 
                 Query query = QueryFactory.create(queryStr.toString());
-                QueryExecution qexec = QueryExecutionFactory.sparqlService(endpointURI,
+                QueryExecution qexec = null;
+                try{
+                        qexec = QueryExecutionFactory.sparqlService(endpointURI,
                                 query);
-
-                ResultSet results = qexec.execSelect();
+                }catch(Exception ex){
+                        ex.printStackTrace();
+                        throw ex;
+                }
+                        
+                ResultSet results = null;
+                try{
+                        long start = System.currentTimeMillis();
+                        results = qexec.execSelect();
+                        long end = System.currentTimeMillis();
+                        System.out.println("EXEC TIME: " + (end-start));
+                }catch(Exception ex){
+                        ex.printStackTrace();
+                        throw ex;
+                }
+                        
                 ArrayList<ClassLink> solCLs = new ArrayList<ClassLink>();
                 for (; results.hasNext();) {
@@ -431 +477 @@
                                 }
                                 ClassLink cl = new ClassLink(proURI, clsURI, direction,
-                                                numOfLinks);
+                                                numOfLinks, 0, 0 );
                                 solCLs.add(cl);
                         }
@@ -484 +530 @@
                 }
 
-                // System.out.println(queryStr.toString());
+System.out.println(queryStr.toString());
 
                 Query query = QueryFactory.create(queryStr.toString());
@@ -513 +559 @@
                         // System.out.println(propURI + " " + clsURI + " " + direction);
 
-                        ClassLink cl = new ClassLink(propURI, clsURI, direction, 0);
+                        ClassLink cl = new ClassLink(propURI, clsURI, direction, 0, 0, 0);
                         solCLs.add(cl);
                 }
@@ -714 +760 @@
                         queryStr.append("PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>\n");
 
-                        queryStr.append("SELECT (COUNT(?os) AS ?numOfLinks) \n");
+                        queryStr.append("SELECT (COUNT(?os) AS ?numOfLinks) (COUNT(DISTINCT(?is)) AS ?numOfOriginInstances) (COUNT(DISTINCT(?os)) AS ?numOfLinkedInstances) \n");
                         if (graphURIs != null) {
                                 for (String graphURI : graphURIs) {
@@ -778 +824 @@
                                         classLink.setNumOfLinks(numOfLinks);
                                 }
+                                lit = sol.getLiteral("numOfLinkedInstances");
+                                if (lit != null) {
+                                        int numOfLinkedInstances = lit.getInt();
+                                        classLink.setNumOfLinkedInstances(numOfLinkedInstances);
+                                }
+                                lit = sol.getLiteral("numOfOriginInstances");
+                                if (lit != null) {
+                                        int numOfOriginInstances = lit.getInt();
+                                        classLink.setNumOfOriginInstances(numOfOriginInstances);
+                                }
                         }
                         qexec.close();