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 42: Line 42:
 
|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') ))
|[https://issue.d4science.research-infrastructures.eu/ticket/745 #745]
 
 
|33 seconds
 
|33 seconds
 
|35 seconds
 
|35 seconds

Revision as of 12:38, 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 over collections NKUA #621 EMC Completed 100% M11 M11
#Portal User Interface Enhancements NKUA, CNR #136,#839, #865, #828 EMC -> FRMC Delivered 95% M11 R1.5
#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