[Sedna-reports] [time-testing] Time of test execution, Sat Jul 30 04:48:50 RDT 2011
Sedna is a native full-featured XML database management system.
Brought to you by:
mozinsur,
shcheklein
From: <tim...@na...> - 2011-07-30 00:49:36
|
<?xml version="1.0" encoding="UTF-8"?> <body> <script type="text/javascript" src="http://modis.ispras.ru/tooltip/wz_tooltip.js"> 0 </script> <p> <h1> Execution time of queries </h1> </p> <h2> <a name="implementations"/> Implementations: </h2> <table cellpadding="6"> <tr> <td> <h3> Native XML Database Sedna </h3> <table cellpadding="6"> <tr> <td valign="top"> Organization: </td> <td valign="top"> Sedna Team, ISP RAS </td> <td valign="top"> <a href="http://modis.ispras.ru"> http://modis.ispras.ru </a> </td> </tr> <tr> <td valign="top"> Implementation: </td> <td valign="top"> Native XML Database Sedna </td> <td valign="top"> <a href="http://modis.ispras.ru/sedna"> http://modis.ispras.ru/sedna </a> </td> </tr> <tr> <td valign="top"> Build: </td> <td valign="top"> sedna-3.4.368-bin-win-x64.tar.gz </td> </tr> <tr> <td valign="top"> Machine: </td> <td valign="top"> Windows Server 2008 R2 x64 (Intel E8400, 8GB) </td> </tr> </table> </td> </tr> </table> <p> <h3> Date: 2011-07-30-04-00 </h3> </p> <table frame="box" rules="all" border="1" bordercolor="black" bgcolor="lightcyan" cellpadding="6"> <colgroup align="left"/> <colgroup align="center" span="1"/> <colgroup align="center" span="1"/> <colgroup align="center" span="1"/> <colgroup align="center" span="1"/> <thead> <tr bgcolor="paleturquoise"> <th ROWSPAN="2"> Test Name </th> <th ROWSPAN="2"> Last Execution Time </th> <th valign="top" COLSPAN="2"> Average Execution Time </th> <th valign="top" COLSPAN="2"> Minimal Execution Time </th> </tr> <tr bgcolor="paleturquoise"> <th valign="top"> Time </th> <th valign="top"> Num of runs </th> <th valign="top"> Time </th> <th valign="top"> Date Of Min Time </th> </tr> </thead> <tbody> <tr> <td align="center"> 01_00_load.xquery </td> <td align="center"> 0.20 </td> <td align="center"> 0.20197736 </td> <td align="center"> 354 </td> <td align="center"> 0.14 </td> <td align="center"> 2011-07-13-04-00 </td> </tr> <tr> <td align="center"> 01_01_indexes.xquery </td> <td align="center"> 0.14 </td> <td align="center"> 0.13087575 </td> <td align="center"> 354 </td> <td align="center"> 0.09 </td> <td align="center"> 2011-07-12-04-00 </td> </tr> <tr> <td align="center"> 01_02_indexes_sort.xquery </td> <td align="center"> 0.09 </td> <td align="center"> 0.08915253 </td> <td align="center"> 354 </td> <td align="center"> 0.06 </td> <td align="center"> 2011-07-24-04-00 </td> </tr> <tr> <td align="center"> 01_03_species.xquery </td> <td align="center"> 0.15 </td> <td align="center"> 0.1550565 </td> <td align="center"> 354 </td> <td align="center"> 0.14 </td> <td align="center"> 2011-07-27-04-00 </td> </tr> <tr bgcolor="violet"> <td align="center"> 01_04_speciesw.xquery </td> <td align="center"> <strong> 0.23 </strong> </td> <td align="center"> 0.15014115 </td> <td align="center"> 354 </td> <td align="center"> 0.12 </td> <td align="center"> 2011-06-20-04-00 </td> </tr> <tr> <td align="center"> 01_05_speciesw_b.xquery </td> <td align="center"> 0.10 </td> <td align="center"> 0.102994345 </td> <td align="center"> 354 </td> <td align="center"> 0.09 </td> <td align="center"> 2011-07-29-04-00 </td> </tr> <tr> <td align="center"> _load.xquery </td> <td align="center"> 17.34 </td> <td align="center"> 18.448868 </td> <td align="center"> 354 </td> <td align="center"> 16.09 </td> <td align="center"> 2011-05-31-04-00 </td> </tr> <tr> <td align="center"> create_index.xquery </td> <td align="center"> 0.26 </td> <td align="center"> 0.34384164 </td> <td align="center"> 354 </td> <td align="center"> 0.23 </td> <td align="center"> 2011-07-10-04-00 </td> </tr> <tr> <td align="center"> simple1.xquery </td> <td align="center"> 0.06 </td> <td align="center"> 0.079406776 </td> <td align="center"> 354 </td> <td align="center"> 0.04 </td> <td align="center"> 2011-07-28-04-00 </td> </tr> <tr> <td align="center"> <a onmouseover="Tip('Return the name of the person with ID \'person0\'', WIDTH, 300, SHADOW, true, FADEIN, 400, FADEOUT, 400)"> xm01.xquery </a> </td> <td align="center"> 0.10 </td> <td align="center"> 0.15302257 </td> <td align="center"> 354 </td> <td align="center"> 0.09 </td> <td align="center"> 2011-07-27-04-00 </td> </tr> <tr bgcolor="skyblue"> <td align="center"> <a onmouseover="Tip('Return the initial increases of all open auctions', WIDTH, 200, SHADOW, true, FADEIN, 400, FADEOUT, 400)"> xm02.xquery </a> </td> <td align="center"> <strong> 0.63 </strong> </td> <td align="center"> 0.71813995 </td> <td align="center"> 354 </td> <td align="center"> 0.63 </td> <td align="center"> 2011-07-30-04-00 </td> </tr> <tr> <td align="center"> <a onmouseover="Tip('Return the IDs of all open auctions whose current increase is at least twice as high as the initial increase', WIDTH, 300, SHADOW, true, FADEIN, 400, FADEOUT, 400)"> xm03.xquery </a> </td> <td align="center"> 0.39 </td> <td align="center"> 0.38898304 </td> <td align="center"> 354 </td> <td align="center"> 0.35 </td> <td align="center"> 2011-06-25-04-00 </td> </tr> <tr> <td align="center"> <a onmouseover="Tip('ist the reserves of those open auctions where a certain person issued a bid before another person', WIDTH, 300, SHADOW, true, FADEIN, 400, FADEOUT, 400)"> xm04.xquery </a> </td> <td align="center"> 0.34 </td> <td align="center"> 0.41053656 </td> <td align="center"> 354 </td> <td align="center"> 0.31 </td> <td align="center"> 2011-07-27-04-00 </td> </tr> <tr> <td align="center"> <a onmouseover="Tip('How many sold items cost more than 40?', WIDTH, 200, SHADOW, true, FADEIN, 400, FADEOUT, 400)"> xm05.xquery </a> </td> <td align="center"> 0.09 </td> <td align="center"> 0.08694923 </td> <td align="center"> 354 </td> <td align="center"> 0.06 </td> <td align="center"> 2011-07-27-04-00 </td> </tr> <tr bgcolor="skyblue"> <td align="center"> <a onmouseover="Tip('How many items are listed on all continents?', WIDTH, 300, SHADOW, true, FADEIN, 400, FADEOUT, 400)"> xm06.xquery </a> </td> <td align="center"> <strong> 0.04 </strong> </td> <td align="center"> 0.12694918 </td> <td align="center"> 354 </td> <td align="center"> 0.04 </td> <td align="center"> 2011-07-30-04-00 </td> </tr> <tr> <td align="center"> <a onmouseover="Tip('How many pieces of prose are in our database?', WIDTH, 300, SHADOW, true, FADEIN, 400, FADEOUT, 400)"> xm07.xquery </a> </td> <td align="center"> 0.09 </td> <td align="center"> 0.13079092 </td> <td align="center"> 354 </td> <td align="center"> 0.06 </td> <td align="center"> 2011-07-21-04-00 </td> </tr> <tr> <td align="center"> <a onmouseover="Tip('List the names of persons and the number of items they bought. (joins person, closed_auction)', WIDTH, 300, SHADOW, true, FADEIN, 400, FADEOUT, 400)"> xm08.xquery </a> </td> <td align="center"> 605.03 </td> <td align="center"> 718.38617 </td> <td align="center"> 354 </td> <td align="center"> 563.55 </td> <td align="center"> 2011-07-27-04-00 </td> </tr> <tr> <td align="center"> xm08_ind.xquery </td> <td align="center"> 6.16 </td> <td align="center"> 6.052771 </td> <td align="center"> 354 </td> <td align="center"> 5.92 </td> <td align="center"> 2010-10-17-04-00 </td> </tr> <tr> <td align="center"> <a onmouseover="Tip('List the names of persons and the names of the items they bought in Europe. (joins person, closed_auction, item)', WIDTH, 300, SHADOW, true, FADEIN, 400, FADEOUT, 400)"> xm09.xquery </a> </td> <td align="center"> 778.61 </td> <td align="center"> 944.1225 </td> <td align="center"> 354 </td> <td align="center"> 733.73 </td> <td align="center"> 2011-07-20-04-00 </td> </tr> <tr> <td align="center"> xm09_ind.xquery </td> <td align="center"> 7.76 </td> <td align="center"> 7.6434155 </td> <td align="center"> 354 </td> <td align="center"> 7.47 </td> <td align="center"> 2010-08-05-04-00 </td> </tr> <tr> <td align="center"> <a onmouseover="Tip('List all persons according to their interest; use French markup in the result', WIDTH, 300, SHADOW, true, FADEIN, 400, FADEOUT, 400)"> xm10.xquery </a> </td> <td align="center"> 75.00 </td> <td align="center"> 81.11509 </td> <td align="center"> 354 </td> <td align="center"> 70.98 </td> <td align="center"> 2011-07-20-04-00 </td> </tr> <tr> <td align="center"> <a onmouseover="Tip('For each person, list the number of items currently on sale whose price does not exceed 0.02% of the person\'s income', WIDTH, 300, SHADOW, true, FADEIN, 400, FADEOUT, 400)"> xm11.xquery </a> </td> <td align="center"> 1103.68 </td> <td align="center"> 1069.2587 </td> <td align="center"> 354 </td> <td align="center"> 1008.02 </td> <td align="center"> 2010-10-10-04-00 </td> </tr> <tr> <td align="center"> <a onmouseover="Tip('For each richer-than-average person, list the number of items currently on sale whose price does not exceed 0.02% of the person\'s income', WIDTH, 300, SHADOW, true, FADEIN, 400, FADEOUT, 400)"> xm12.xquery </a> </td> <td align="center"> 241.98 </td> <td align="center"> 248.50894 </td> <td align="center"> 354 </td> <td align="center"> 224.81 </td> <td align="center"> 2011-07-27-04-00 </td> </tr> <tr bgcolor="skyblue"> <td align="center"> <a onmouseover="Tip('List the names of items registered in Australia along with their descriptions', WIDTH, 300, SHADOW, true, FADEIN, 400, FADEOUT, 400)"> xm13.xquery </a> </td> <td align="center"> <strong> 0.29 </strong> </td> <td align="center"> 0.33533886 </td> <td align="center"> 354 </td> <td align="center"> 0.29 </td> <td align="center"> 2011-07-30-04-00 </td> </tr> <tr> <td align="center"> <a onmouseover="Tip('Return the names of all items whose description contains the word gold', WIDTH, 300, SHADOW, true, FADEIN, 400, FADEOUT, 400)"> xm14.xquery </a> </td> <td align="center"> 9.15 </td> <td align="center"> 8.949175 </td> <td align="center"> 354 </td> <td align="center"> 7.28 </td> <td align="center"> 2010-07-21-04-00 </td> </tr> <tr> <td align="center"> <a onmouseover="Tip('Print the keywords in emphasis in annotations of closed auctions', WIDTH, 300, SHADOW, true, FADEIN, 400, FADEOUT, 400)"> xm15.xquery </a> </td> <td align="center"> 0.07 </td> <td align="center"> 0.07720342 </td> <td align="center"> 354 </td> <td align="center"> 0.04 </td> <td align="center"> 2011-07-27-04-00 </td> </tr> <tr> <td align="center"> <a onmouseover="Tip('Return the IDs of those auctions that have one or more keywords in emphasis. (cf. Q15)', WIDTH, 300, SHADOW, true, FADEIN, 400, FADEOUT, 400)"> xm16.xquery </a> </td> <td align="center"> 0.10 </td> <td align="center"> 0.14533895 </td> <td align="center"> 354 </td> <td align="center"> 0.07 </td> <td align="center"> 2011-06-28-04-00 </td> </tr> <tr> <td align="center"> <a onmouseover="Tip('Which persons don\'t have a homepage?', WIDTH, 200, SHADOW, true, FADEIN, 400, FADEOUT, 400)"> xm17.xquery </a> </td> <td align="center"> 0.70 </td> <td align="center"> 0.74033904 </td> <td align="center"> 354 </td> <td align="center"> 0.68 </td> <td align="center"> 2010-10-30-04-00 </td> </tr> <tr> <td align="center"> <a onmouseover="Tip('Convert the currency of the reserve of all open auctions to another currency', WIDTH, 300, SHADOW, true, FADEIN, 400, FADEOUT, 400)"> xm18.xquery </a> </td> <td align="center"> 0.06 </td> <td align="center"> 0.053898305 </td> <td align="center"> 354 </td> <td align="center"> 0.03 </td> <td align="center"> 2011-06-28-04-00 </td> </tr> <tr> <td align="center"> <a onmouseover="Tip('Give an alphabetically ordered list of all items along with their location', WIDTH, 300, SHADOW, true, FADEIN, 400, FADEOUT, 400)"> xm19.xquery </a> </td> <td align="center"> 1.34 </td> <td align="center"> 1.3871479 </td> <td align="center"> 354 </td> <td align="center"> 1.24 </td> <td align="center"> 2010-10-11-04-00 </td> </tr> <tr bgcolor="skyblue"> <td align="center"> <a onmouseover="Tip('Group customers by their income and output the cardinality of each group', WIDTH, 300, SHADOW, true, FADEIN, 400, FADEOUT, 400)"> xm20.xquery </a> </td> <td align="center"> <strong> 0.21 </strong> </td> <td align="center"> 0.28675148 </td> <td align="center"> 354 </td> <td align="center"> 0.21 </td> <td align="center"> 2011-07-30-04-00 </td> </tr> <tr> <td align="center"> simple1.xquery </td> <td align="center"> 0.06 </td> <td align="center"> 0.079406776 </td> <td align="center"> 354 </td> <td align="center"> 0.04 </td> <td align="center"> 2011-07-28-04-00 </td> </tr> <tr> <td align="center"> <a onmouseover="Tip('Sedna restart and database creation.', WIDTH, 300, SHADOW, true, FADEIN, 400, FADEOUT, 400)"> 01_createdb.sh </a> </td> <td align="center"> 4.05 </td> <td align="center"> 3.4024005 </td> <td align="center"> 354 </td> <td align="center"> 2.69 </td> <td align="center"> 2010-08-06-04-00 </td> </tr> <tr bgcolor="skyblue"> <td align="center"> <a onmouseover="Tip('Loading of 100000 documents 460 bytes-160 Kb each (emails) into a single collection. Each document is loaded in a separate transaction.', WIDTH, 300, SHADOW, true, FADEIN, 400, FADEOUT, 400)"> 02_load_collection.sh </a> </td> <td align="center"> <strong> 22.02 </strong> </td> <td align="center"> 936.006 </td> <td align="center"> 354 </td> <td align="center"> 22.02 </td> <td align="center"> 2011-07-30-04-00 </td> </tr> <tr bgcolor="skyblue"> <td align="center"> <a onmouseover="Tip('Collection with 100000 documents is dropped.', WIDTH, 300, SHADOW, true, FADEIN, 400, FADEOUT, 400)"> 03_drop_collection.sh </a> </td> <td align="center"> <strong> 1.17 </strong> </td> <td align="center"> 42.042274 </td> <td align="center"> 354 </td> <td align="center"> 1.17 </td> <td align="center"> 2011-07-30-04-00 </td> </tr> <tr bgcolor="skyblue"> <td align="center"> <a onmouseover="Tip('Loading of 100000 documents 460 bytes-160 Kb each (emails) into a single collection. All documents are loaded in one common transaction.', WIDTH, 300, SHADOW, true, FADEIN, 400, FADEOUT, 400)"> 04_load_collection_single_trans.sh </a> </td> <td align="center"> <strong> 1.13 </strong> </td> <td align="center"> 247.69678 </td> <td align="center"> 354 </td> <td align="center"> 1.13 </td> <td align="center"> 2011-07-30-04-00 </td> </tr> <tr bgcolor="skyblue"> <td align="center"> <a onmouseover="Tip('Collection of 100000 documents is queried.', WIDTH, 300, SHADOW, true, FADEIN, 400, FADEOUT, 400)"> 05_query_collection.sh </a> </td> <td align="center"> <strong> 1.13 </strong> </td> <td align="center"> 10.944596 </td> <td align="center"> 354 </td> <td align="center"> 1.13 </td> <td align="center"> 2011-07-30-04-00 </td> </tr> <tr bgcolor="skyblue"> <td align="center"> <a onmouseover="Tip('Collection of 100000 documents is queried. There are two sessions: in one session update (rename) of document in collection is executed, in other session - document is queried in READ_ONLY session. Each query is executed in a READ_ONLY session.', WIDTH, 300, SHADOW, true, FADEIN, 400, FADEOUT, 400)"> 06_query_collection2.sh </a> </td> <td align="center"> <strong> 1.13 </strong> </td> <td align="center"> 41.04575 </td> <td align="center"> 354 </td> <td align="center"> 1.13 </td> <td align="center"> 2011-07-30-04-00 </td> </tr> <tr> <td align="center"> <a onmouseover="Tip('Sedna restart and database creation.', WIDTH, 300, SHADOW, true, FADEIN, 400, FADEOUT, 400)"> 07_createdb.sh </a> </td> <td align="center"> 2.27 </td> <td align="center"> 4.066073 </td> <td align="center"> 354 </td> <td align="center"> 2.24 </td> <td align="center"> 2011-07-29-04-00 </td> </tr> <tr bgcolor="skyblue"> <td align="center"> <a onmouseover="Tip('Loading of 500-Mb XMark file as a stand-alone document.', WIDTH, 300, SHADOW, true, FADEIN, 400, FADEOUT, 400)"> 08_load_xmark500.sh </a> </td> <td align="center"> <strong> 0.10 </strong> </td> <td align="center"> 100.09259 </td> <td align="center"> 354 </td> <td align="center"> 0.10 </td> <td align="center"> 2011-07-30-04-00 </td> </tr> <tr> <td align="center"> <a onmouseover="Tip('Sedna restart and database is created with small buffers (size of buffers = 25 Mb).', WIDTH, 300, SHADOW, true, FADEIN, 400, FADEOUT, 400)"> 09_create_small_bufs.sh </a> </td> <td align="center"> 2.32 </td> <td align="center"> 8.237536 </td> <td align="center"> 354 </td> <td align="center"> 2.30 </td> <td align="center"> 2011-07-29-04-00 </td> </tr> <tr> <td align="center"> <a onmouseover="Tip('Loading of 100-Mb XMark file as a stand-alone document into a database with small buffers (25 Mb).', WIDTH, 300, SHADOW, true, FADEIN, 400, FADEOUT, 400)"> 10_load_xmark100.sh </a> </td> <td align="center"> 0.20 </td> <td align="center"> 18.234411 </td> <td align="center"> 354 </td> <td align="center"> 0.10 </td> <td align="center"> 2011-07-29-04-00 </td> </tr> <tr bgcolor="skyblue"> <td align="center"> <a onmouseover="Tip('Heavy update is performed on a document: rename of a root element. This test demonstrates performance while intensive page swapping.', WIDTH, 300, SHADOW, true, FADEIN, 400, FADEOUT, 400)"> 11_heavy_update.sh </a> </td> <td align="center"> <strong> 0.10 </strong> </td> <td align="center"> 43.46359 </td> <td align="center"> 354 </td> <td align="center"> 0.10 </td> <td align="center"> 2011-07-30-04-00 </td> </tr> <tr bgcolor="skyblue"> <td align="center"> 12_createdb.sh </td> <td align="center"> <strong> 2.49 </strong> </td> <td align="center"> 86.223045 </td> <td align="center"> 354 </td> <td align="center"> 2.49 </td> <td align="center"> 2011-07-30-04-00 </td> </tr> <tr bgcolor="skyblue"> <td align="center"> <a onmouseover="Tip('Database is stopped and started', WIDTH, 300, SHADOW, true, FADEIN, 400, FADEOUT, 400)"> 13_restartdb.sh </a> </td> <td align="center"> <strong> 0.12 </strong> </td> <td align="center"> 29.464539 </td> <td align="center"> 354 </td> <td align="center"> 0.12 </td> <td align="center"> 2011-07-30-04-00 </td> </tr> <tr bgcolor="skyblue"> <td align="center"> <a onmouseover="Tip('Opens Readonly transaction and retrieves the updated document (thus indirect pointers to the previous version is used while retrieval)', WIDTH, 300, SHADOW, true, FADEIN, 400, FADEOUT, 400)"> 14_transaction1.sh </a> </td> <td align="center"> <strong> 0.10 </strong> </td> <td align="center"> 2.4227974 </td> <td align="center"> 354 </td> <td align="center"> 0.10 </td> <td align="center"> 2011-07-30-04-00 </td> </tr> <tr bgcolor="skyblue"> <td align="center"> <a onmouseover="Tip('Database is stopped and started', WIDTH, 300, SHADOW, true, FADEIN, 400, FADEOUT, 400)"> 15_restartdb.sh </a> </td> <td align="center"> <strong> 0.12 </strong> </td> <td align="center"> 0.8284751 </td> <td align="center"> 354 </td> <td align="center"> 0.12 </td> <td align="center"> 2011-07-30-04-00 </td> </tr> <tr> <td align="center"> <a onmouseover="Tip('Opens Update-transaction and retrieves the udpated document (the last version is used - no indirection', WIDTH, 300, SHADOW, true, FADEIN, 400, FADEOUT, 400)"> 16_transaction2.sh </a> </td> <td align="center"> 0.14 </td> <td align="center"> 2.3470352 </td> <td align="center"> 354 </td> <td align="center"> 0.12 </td> <td align="center"> 2011-07-29-04-00 </td> </tr> <tr bgcolor="skyblue"> <td align="center"> <a onmouseover="Tip('Stops Sedna and deletes the database.', WIDTH, 300, SHADOW, true, FADEIN, 400, FADEOUT, 400)"> 17_stop.sh </a> </td> <td align="center"> <strong> 0.14 </strong> </td> <td align="center"> 0.75694925 </td> <td align="center"> 354 </td> <td align="center"> 0.14 </td> <td align="center"> 2011-07-30-04-00 </td> </tr> </tbody> </table> <p align="right"> Generated: <a href="http://modis.ispras.ru"> Sedna Team </a> </p> </body> |