* [#Configure Mulgara 配置] * [#load Load performance] * [#allieload Allie upload] * [#pdbjload PDBJ upload] * [#uniprotload Uniprot upload] * [#ddbjload DDBJ upload] * [#Sparql Sparql query performance] * [#alliequery Allie query ] * [#pdbjquery PDBJ query ] * [#uniprotquery Uniprot query ] * [#ddbjquery DDBJ query ] === Mulgara 配置 === #Configure === Load Performance === #load === Allie upload === #allieload About 89 mins === PDBJ upload === #pdbjload The file includes the characteristics like ABSA_(A2) that can not be dealt with by Mulgara. 2012-01-17 10:10:49,066 WARN [main] itql.TqlSession? - Couldn't execute command org.mulgara.query.QueryException?: Unable to load file:/opt/services/togordf/data/pdbj/XML/10gs-noatom.rdf.gz into rmi://localhost/Pdbj#pdbj: Illegal character in path at index 60: http://pdbj.org/rdf/10GS/pdbx_struct_assembly_prop/1,ABSA_(A^2) === Uniprot upload === #uniprotload === DDBJ upload === #ddbjload 2012-07-06 23:54:59,770 WARN [main] itql.TqlSession - Couldn't execute command org.mulgara.query.QueryException: Unable to load file:/opt/services/togordf/data/ddbj/ddbj_release/ddbjbct3.rdf.gz into rmi://localhost/ddbj#ddbj: Exception on rollback:java.rmi.RemoteException: rollb ack: Unexpected XAException:Cannot send res.rollback:javax.transaction.xa.XAException (error code = -3) --null at org.mulgara.resolver.DatabaseSession.execute(DatabaseSession.java:746) at org.mulgara.resolver.DatabaseSession.setModel(DatabaseSession.java:580) === Sparql query performance === #Sparql === Cell Cycle query === #cellquery ||Query\time(ms) ||time 1 || time 2 || time 3 ||time 4||time 5 || ||case1 ||1299|| 1293|| 1290 ||1297|| 1297|| ||case2 ||27 ||26 ||18 ||17 ||17|| ||case3 ||2211|| 2221|| 2202 ||2207 ||2207|| ||case4 ||10 ||9 ||10 ||9 ||9|| ||case5 ||369 ||332 ||347|| 347|| 347 ||case6 ||2353|| 2319 ||2358 ||2314|| 2314|| ||case7 ||39 ||31|| 34 ||32|| 32|| ||case8 ||59 ||65 ||67 ||54|| 54|| ||case9 ||39 ||33|| 36|| 32|| 32|| ||case10 ||5 ||4 ||5 ||4|| 4|| ||case11 ||14 ||14|| 15|| 14|| 14|| ||case12 ||X||X||X||X||X|| ||case13 ||8 ||9 ||8|| 9|| 9|| ||case14 ||6 ||6 ||6|| 6|| 6|| ||case15 ||X||X||X||X||X|| ||case16 ||X||X|| X|| X|| X|| ||case17 ||X||X|| X|| X|| X|| ||case18 ||X||X|| X|| X|| X|| ||case19 ||34 ||41|| 41 ||39|| 39|| Case 12: "Exception in thread ""main"" org.mulgara.query.QueryException: Query failed: Unknown ConstraintExpression type: class org.mulgara.query.ConstraintFalse known types: [class org.mulgara.resolver.relational.RelationalConstraint, class org.mulgara.query.ConstraintFilter, class org.mulgara.resolver.xsd.IntervalConstraint, class org.mulgara.query.WalkConstraint, class org.mulgara.query.SingleTransitiveConstraint, class org.mulgara.query.ConstraintIn, class org.mulgara.query.ConstraintOptionalJoin, class org.mulgara.query.ConstraintAssignment, class org.mulgara.resolver.lucene.LuceneConstraint, class org.mulgara.query.ConstraintConjunction, class org.mulgara.query.ConstraintDifference, class org.mulgara.query.ConstraintImpl, class org.mulgara.query.ConstraintDisjunction, class org.mulgara.query.TransitiveConstraint, class org.mulgara.query.ConstraintIs]" Case 16,17 &18: Exception in thread "main" org.mulgara.parser.MulgaraParserException: Encountered "count" at line Case 15: Showing 0 results(some unsupported function caused the wrong query result) === Allie query === #alliequery ||Query\time(ms) ||time 1 || time 2 || time 3 ||time 4||time 5 || ||case1 ||375 ||377 ||373 ||376 ||368|| ||case2 ||123 ||123 ||119 ||120 ||128|| ||case3 ||X||X|| X|| X|| X|| ||case4 ||X||X|| X|| X|| X|| ||case5 ||X||X|| X|| X|| X|| As for case3,4&5: Exception in thread "main" org.mulgara.parser.MulgaraParserException: Unable to support arbitrarily complex ORDER BY clause === PDBJ query === #pdbjquery === Uniprot query === #uniprotquery === DDBJ query === #