Difference between revisions of "Search Performance Evalutation"

From Gcube Wiki
Jump to: navigation, search
(Query Response Times Sum-up Table)
(Query Response Times Sum-up Table)
Line 25: Line 25:
 
|6 seconds
 
|6 seconds
 
|-
 
|-
|Search  for the word <font color="green">"Atlantic"</font>, inside the <font color="green">abstract</font>, in <font color="green">EM Advanced Along - Track Scanning Radiometer (AATSR) Data Set Products</font> collection and the word <font color="green">european</font>, <font color="green">anywhere</font>, in <font color="green">EM Advanced Along - Track Scanning Radiometer (AATSR) Data Set: Monthly Products</font> collection, in <font color="green">ISO19115</font> schema and <font color="green">english</font> language. <font color="fuchsia">Sort</font> the results by <font color="green">title</font>.
+
|Search  for the word <font color="green">"Atlantic"</font>, inside the <font color="green">abstract</font>, in <font color="green">EM Advanced Along - Track Scanning Radiometer (AATSR) Data Set Products</font> collection and the word <font color="green">"european"</font>, <font color="green">anywhere</font>, in <font color="green">EM Advanced Along - Track Scanning Radiometer (AATSR) Data Set: Monthly Products</font> collection, in <font color="green">ISO19115</font> schema and <font color="green">english</font> language. <font color="fuchsia">Sort</font> the results by <font color="green">title</font>.
 
|sort 'ASC' by '//*[local-name()=\'title\']' on (retrievemetadata as 'ISO19115' in 'ENGLISH' on (merge on (fieldedsearch by 'abstract' contains 'Atlantic' in 'ENGLISH' on 'f8fea990-00c5-11de-8e55-ae4f02e984c5' as 'ISO19115') and (fulltextsearch by 'european'  in 'ENGLISH' on '0057b970-1ed5-11de-8141-e3edd323bdf8') ))
 
|sort 'ASC' by '//*[local-name()=\'title\']' on (retrievemetadata as 'ISO19115' in 'ENGLISH' on (merge on (fieldedsearch by 'abstract' contains 'Atlantic' in 'ENGLISH' on 'f8fea990-00c5-11de-8e55-ae4f02e984c5' as 'ISO19115') and (fulltextsearch by 'european'  in 'ENGLISH' on '0057b970-1ed5-11de-8141-e3edd323bdf8') ))
 
|Never (SocketTimeOut Exception)
 
|Never (SocketTimeOut Exception)
 
|
 
|
 
|-
 
|-
|Search  for the word <font color="green">"Atlantic"</font>, inside the <font color="green">abstract</font>, in <font color="green">EM Advanced Along - Track Scanning Radiometer (AATSR) Data Set Products</font> collection and the word <font color="green">european</font>, <font color="green">anywhere</font>, in <font color="green">EM Advanced Along - Track Scanning Radiometer (AATSR) Data Set: Monthly Products</font> collection, in <font color="green">ISO19115</font> schema and <font color="green">english</font> language.
+
|Search  for the word <font color="green">"Atlantic"</font>, inside the <font color="green">abstract</font>, in <font color="green">EM Advanced Along - Track Scanning Radiometer (AATSR) Data Set Products</font> collection and the word <font color="green">"european"</font>, <font color="green">anywhere</font>, in <font color="green">EM Advanced Along - Track Scanning Radiometer (AATSR) Data Set: Monthly Products</font> collection, in <font color="green">ISO19115</font> schema and <font color="green">english</font> language.
 
|retrievemetadata as 'ISO19115' in 'ENGLISH' on (merge on (fieldedsearch by 'abstract' contains 'Atlantic' in 'ENGLISH' on 'f8fea990-00c5-11de-8e55-ae4f02e984c5' as 'ISO19115') and (fulltextsearch by 'european'  in 'ENGLISH' on '0057b970-1ed5-11de-8141-e3edd323bdf8') )
 
|retrievemetadata as 'ISO19115' in 'ENGLISH' on (merge on (fieldedsearch by 'abstract' contains 'Atlantic' in 'ENGLISH' on 'f8fea990-00c5-11de-8e55-ae4f02e984c5' as 'ISO19115') and (fulltextsearch by 'european'  in 'ENGLISH' on '0057b970-1ed5-11de-8141-e3edd323bdf8') )
 
|11 seconds
 
|11 seconds
Line 40: Line 40:
 
|8 seconds
 
|8 seconds
 
|-
 
|-
|Search  for the word <font color="green">"satellite"</font>, inside the <font color="green">title</font>, and the word <font color="green">europe</font>, inside the <font color="green">description</font>, in <font color="green">EM ESA Earth Images</font> collection, in <font color="green">es</font> schema and <font color="green">english</font> language. <font color="fuchsia">Sort</font> the results by <font color="green"> title</font>.
+
|Search  for the word <font color="green">"satellite"</font>, inside the <font color="green">title</font>, and the word <font color="green">"europe"</font>, inside the <font color="green">description</font>, in <font color="green">EM ESA Earth Images</font> collection, in <font color="green">es</font> schema and <font color="green">english</font> language. <font color="fuchsia">Sort</font> the results by <font color="green"> title</font>.
 
|sort 'ASC' by '//*[local-name()=\'title\']' on (retrievemetadata as 'es' in 'ENGLISH' on (merge on (fieldedsearch by 'title' contains 'satellite' in 'ENGLISH' on '778b3e50-f2a6-11dd-8d14-904a5718339a' as 'es') and (fieldedsearch by 'description' contains 'europe' in 'ENGLISH' on '778b3e50-f2a6-11dd-8d14-904a5718339a' as 'es') ))
 
|sort 'ASC' by '//*[local-name()=\'title\']' on (retrievemetadata as 'es' in 'ENGLISH' on (merge on (fieldedsearch by 'title' contains 'satellite' in 'ENGLISH' on '778b3e50-f2a6-11dd-8d14-904a5718339a' as 'es') and (fieldedsearch by 'description' contains 'europe' in 'ENGLISH' on '778b3e50-f2a6-11dd-8d14-904a5718339a' as 'es') ))
 
|33 seconds
 
|33 seconds
 
|35 seconds
 
|35 seconds
 
|-
 
|-
|Search  for the word <font color="green">"satellite"</font>, inside the <font color="green">title</font>, and the word <font color="green">europe</font>, inside the <font color="green">description</font>, in <font color="green">EM ESA Earth Images</font> collection, in <font color="green">es</font> schema and <font color="green">english</font> language.  
+
|Search  for the word <font color="green">"satellite"</font>, inside the <font color="green">title</font>, and the word <font color="green">"europe"</font>, inside the <font color="green">description</font>, in <font color="green">EM ESA Earth Images</font> collection, in <font color="green">es</font> schema and <font color="green">english</font> language.  
 
|retrievemetadata as 'es' in 'ENGLISH' on (merge on (fieldedsearch by 'title' contains 'satellite' in 'ENGLISH' on '778b3e50-f2a6-11dd-8d14-904a5718339a' as 'es') and (fieldedsearch by 'description' contains 'europe' in 'ENGLISH' on '778b3e50-f2a6-11dd-8d14-904a5718339a' as 'es') )
 
|retrievemetadata as 'es' in 'ENGLISH' on (merge on (fieldedsearch by 'title' contains 'satellite' in 'ENGLISH' on '778b3e50-f2a6-11dd-8d14-904a5718339a' as 'es') and (fieldedsearch by 'description' contains 'europe' in 'ENGLISH' on '778b3e50-f2a6-11dd-8d14-904a5718339a' as 'es') )
 
|5 seconds
 
|5 seconds
Line 51: Line 51:
 
|-
 
|-
 
|-
 
|-
Search  for the word <font color="green">"Antarctica"</font>, inside the <font color="green">description</font>, and the word <font color="green">map</font>, inside the <font color="green">description</font>, in <font color="green">EM ESA Earth Images</font> collection, in <font color="green">es</font> schema and <font color="green">english</font> language.  
+
|Search  for the word <font color="green">"Antarctica"</font>, inside the <font color="green">description</font>, and the word <font color="green">"map"</font>, inside the <font color="green">description</font>, in <font color="green">EM ESA Earth Images</font> collection, in <font color="green">es</font> schema and <font color="green">english</font> language.  
 
|retrievemetadata as 'es' in 'ENGLISH' on (join inner by 'DocID' on (fieldedsearch by 'description' contains 'Antarctica' in 'ENGLISH' on '778b3e50-f2a6-11dd-8d14-904a5718339a' as 'es') and (fieldedsearch by 'description' contains 'map' in 'ENGLISH' on '778b3e50-f2a6-11dd-8d14-904a5718339a' as 'es') )
 
|retrievemetadata as 'es' in 'ENGLISH' on (join inner by 'DocID' on (fieldedsearch by 'description' contains 'Antarctica' in 'ENGLISH' on '778b3e50-f2a6-11dd-8d14-904a5718339a' as 'es') and (fieldedsearch by 'description' contains 'map' in 'ENGLISH' on '778b3e50-f2a6-11dd-8d14-904a5718339a' as 'es') )
 
|5 seconds
 
|5 seconds

Revision as of 12:48, 5 November 2009

Introduction

In this section a number of varied queries submitted in the production infrastructure, along with the response times of the gCube system are recorded. The target is to evaluate the performance of the search functionality provided by D4science services.

Query Response Times Sum-up Table

Query Explanation (Physical Language) Query Submitted to SearchMaster (SearchMaster Syntax) Time Until Search Responds Rime Until First Result is Retrieved
Search for the word "earth", anywhere, in EM ESA Earth Images collection, in eiDB schema and english language. retrievemetadata as 'eiDB' in 'ENGLISH' on (fulltextsearch by 'earth' in 'ENGLISH' on '94d02c10-f2eb-11dd-a6f4-add312924299') 3 seconds 4 seconds
Search for the word "europe", inside the title, in EM ESA Earth Images collection, in eiDB schema and english language. retrievemetadata as 'eiDB' in 'ENGLISH' on (fieldedsearch by 'title' contains 'europe' in 'ENGLISH' on '778b3e50-f2a6-11dd-8d14-904a5718339a' as 'eiDB' 2 seconds 3 seconds
Search for the word "Atlantic", inside the abstract, in EM Advanced Along - Track Scanning Radiometer (AATSR) Data Set Products collection, in ISO19115 schema and english language. retrievemetadata as 'ISO19115' in 'ENGLISH' on (fieldedsearch by 'abstract' contains 'Atlantic' in 'ENGLISH' on 'f8fea990-00c5-11de-8e55-ae4f02e984c5' as 'ISO19115') 3 seconds 6 seconds
Search for the word "Atlantic", inside the abstract, in EM Advanced Along - Track Scanning Radiometer (AATSR) Data Set Products collection and the word "european", anywhere, in EM Advanced Along - Track Scanning Radiometer (AATSR) Data Set: Monthly Products collection, in ISO19115 schema and english language. Sort the results by title. sort 'ASC' by '//*[local-name()=\'title\']' on (retrievemetadata as 'ISO19115' in 'ENGLISH' on (merge on (fieldedsearch by 'abstract' contains 'Atlantic' in 'ENGLISH' on 'f8fea990-00c5-11de-8e55-ae4f02e984c5' as 'ISO19115') and (fulltextsearch by 'european' in 'ENGLISH' on '0057b970-1ed5-11de-8141-e3edd323bdf8') )) Never (SocketTimeOut Exception)
Search for the word "Atlantic", inside the abstract, in EM Advanced Along - Track Scanning Radiometer (AATSR) Data Set Products collection and the word "european", anywhere, in EM Advanced Along - Track Scanning Radiometer (AATSR) Data Set: Monthly Products collection, in ISO19115 schema and english language. retrievemetadata as 'ISO19115' in 'ENGLISH' on (merge on (fieldedsearch by 'abstract' contains 'Atlantic' in 'ENGLISH' on 'f8fea990-00c5-11de-8e55-ae4f02e984c5' as 'ISO19115') and (fulltextsearch by 'european' in 'ENGLISH' on '0057b970-1ed5-11de-8141-e3edd323bdf8') ) 11 seconds 14 seconds
Search for the word "initiative", inside the abstract, in all the collections of AATSR Products group, in ISO19115 schema and english language. merge on (retrievemetadata as 'ISO19115' in 'ENGLISH' on (fieldedsearch by 'abstract' contains 'initiative' in 'ENGLISH' on 'f8fea990-00c5-11de-8e55-ae4f02e984c5' as 'ISO19115')) and (retrievemetadata as 'ISO19115' in 'ENGLISH' on (fieldedsearch by 'abstract' contains 'initiative' in 'ENGLISH' on 'f519f550-00c5-11de-8e55-ae4f02e984c5' as 'ISO19115')) and (retrievemetadata as 'ISO19115' in 'ENGLISH' on (fieldedsearch by 'abstract' contains 'initiative' in 'ENGLISH' on '0bfd7c60-00c6-11de-8e55-ae4f02e984c5' as 'ISO19115')) and (retrievemetadata as 'ISO19115' in 'ENGLISH' on (fieldedsearch by 'abstract' contains 'initiative' in 'ENGLISH' on '1030ece0-00c6-11de-8e55-ae4f02e984c5' as 'ISO19115')) 7 seconds 8 seconds
Search for the word "satellite", inside the title, and the word "europe", inside the description, in EM ESA Earth Images collection, in es schema and english language. Sort the results by title. sort 'ASC' by '//*[local-name()=\'title\']' on (retrievemetadata as 'es' in 'ENGLISH' on (merge on (fieldedsearch by 'title' contains 'satellite' in 'ENGLISH' on '778b3e50-f2a6-11dd-8d14-904a5718339a' as 'es') and (fieldedsearch by 'description' contains 'europe' in 'ENGLISH' on '778b3e50-f2a6-11dd-8d14-904a5718339a' as 'es') )) 33 seconds 35 seconds
Search for the word "satellite", inside the title, and the word "europe", inside the description, in EM ESA Earth Images collection, in es schema and english language. retrievemetadata as 'es' in 'ENGLISH' on (merge on (fieldedsearch by 'title' contains 'satellite' in 'ENGLISH' on '778b3e50-f2a6-11dd-8d14-904a5718339a' as 'es') and (fieldedsearch by 'description' contains 'europe' in 'ENGLISH' on '778b3e50-f2a6-11dd-8d14-904a5718339a' as 'es') ) 5 seconds 26 seconds
Search for the word "Antarctica", inside the description, and the word "map", inside the description, in EM ESA Earth Images collection, in es schema and english language. retrievemetadata as 'es' in 'ENGLISH' on (join inner by 'DocID' on (fieldedsearch by 'description' contains 'Antarctica' in 'ENGLISH' on '778b3e50-f2a6-11dd-8d14-904a5718339a' as 'es') and (fieldedsearch by 'description' contains 'map' in 'ENGLISH' on '778b3e50-f2a6-11dd-8d14-904a5718339a' as 'es') ) 5 seconds 28 seconds
#Personal Information Spaces CNR #140, EMC Delivered 70% M23 R1.5
#Reports / Live Documents CNR #144, #145 EMC,FRMC Delivered 95% M23 M23 - R1.4