Added locate experiment and results.

simongog · Jan 16, 2013 · bcbc1c8 · bcbc1c8
1 parent 39c9ce6
commit bcbc1c8
Show file tree

Hide file tree

Showing 2 changed files with 328 additions and 0 deletions.
diff --git a/query_performance/query_loc_web-4GB.sh b/query_performance/query_loc_web-4GB.sh
@@ -0,0 +1,48 @@
+#!/bin/bash
+
+bin_dir="../bin"
+output_dir=".."
+pattern_dir="../pattern"
+tmp_dir="../tmp"
+file="../web-4GB"
+file_basename=`basename ${file}`
+
+threshold=4096
+
+pattern_number=1000
+result_file="query_performance_loc_web-4GB.txt"
+repetitions=1
+
+rm -f ${result_file}
+
+os=`uname`
+#if [[ "$os" == 'Darwin' ]]; then
+#	echo "Setup Mac OS for experiments"
+#	./mac_setup.sh
+#fi
+
+#for fac_dens in 0 1 2 4 8 16 32 64 128 256 512 1024; do
+for fac_dens in 0 1 4 16 64 256 1024; do
+	for i in `seq 1 ${repetitions}`; do
+		for pattern_len in 40; do
+			for occ in "8 12" "75 125"; do 
+				if [[ "$os" == 'Darwin' ]]; then
+					purge
+				fi
+					min_occ=${occ% *}
+					max_occ=${occ#* }
+					echo "pattern_len=${pattern_len} min_occ=${min_occ} max_occ=${max_occ}"
+					pattern_file=${pattern_dir}/${file_basename}.${pattern_len}.${pattern_number}.0.${min_occ}.${max_occ}.pattern
+					echo "${pattern_file} "
+					echo "# phase = ${suffix}" >> ${result_file}
+					${bin_dir}/rosa_sd2_delta --input_file=${file} --threshold=${threshold} --output_dir="${output_dir}/" \
+								  --benchmark_loc --benchmark_ext --pattern_file=${pattern_file} --fac_dens=${fac_dens} >> ${result_file}
+				done
+		done
+	done
+done
+
+#if [[ "$os" == 'Darwin' ]]; then
+#	echo "Activate services on Mac OS again"
+#	./mac_teardown.sh
+#fi
diff --git a/query_performance/query_performance_loc_web-4GB.txt b/query_performance/query_performance_loc_web-4GB.txt
@@ -0,0 +1,280 @@
+# phase = 
+# index_suf = rosa_sd
+# repeated_in_memory_search = 0
+# pattern_file_name = ../pattern/web-4GB.40.1000.0.8.12.pattern
+# file_name = ../web-4GB
+# b = 4096
+# fac_dens = 0
+# index_load_rtime = 821.027
+# index_load_utime = 63.957
+# full_queries = 1000
+# cnt4 = 9355
+# cnt5 = 1000
+# rtime_full = 998.04
+# utime_full = 241.484
+# stime_full = 83.464
+# disk_access_per_query = 2
+# gap_disk_access_per_query = 0
+# avg_int_match_depth = 14.044
+# ratio_of_int_matched_queries = 0
+# block_length_per_ext_query = 0
+# phase = 
+# index_suf = rosa_sd
+# repeated_in_memory_search = 0
+# pattern_file_name = ../pattern/web-4GB.40.1000.0.75.125.pattern
+# file_name = ../web-4GB
+# b = 4096
+# fac_dens = 0
+# index_load_rtime = 816.162
+# index_load_utime = 62.879
+# full_queries = 1000
+# cnt4 = 96133
+# cnt5 = 1000
+# rtime_full = 1051.65
+# utime_full = 274.344
+# stime_full = 89.719
+# disk_access_per_query = 1.997
+# gap_disk_access_per_query = 0
+# avg_int_match_depth = 15.355
+# ratio_of_int_matched_queries = 0
+# block_length_per_ext_query = 0
+# phase = 
+# index_suf = rosa_sd
+# repeated_in_memory_search = 0
+# pattern_file_name = ../pattern/web-4GB.40.1000.0.8.12.pattern
+# file_name = ../web-4GB
+# b = 4096
+# fac_dens = 1
+# index_load_rtime = 1814.95
+# index_load_utime = 201.543
+# full_queries = 1000
+# cnt4 = 9355
+# cnt5 = 1000
+# rtime_full = 4647.65
+# utime_full = 1843.04
+# stime_full = 275.212
+# disk_access_per_query = 11.355
+# gap_disk_access_per_query = 0
+# avg_int_match_depth = 14.044
+# ratio_of_int_matched_queries = 0
+# block_length_per_ext_query = 0
+# phase = 
+# index_suf = rosa_sd
+# repeated_in_memory_search = 0
+# pattern_file_name = ../pattern/web-4GB.40.1000.0.75.125.pattern
+# file_name = ../web-4GB
+# b = 4096
+# fac_dens = 1
+# index_load_rtime = 2199.22
+# index_load_utime = 229.451
+# full_queries = 1000
+# cnt4 = 96133
+# cnt5 = 1000
+# rtime_full = 26905
+# utime_full = 11830.2
+# stime_full = 1476.37
+# disk_access_per_query = 98.13
+# gap_disk_access_per_query = 0
+# avg_int_match_depth = 15.355
+# ratio_of_int_matched_queries = 0
+# block_length_per_ext_query = 0
+# phase = 
+# index_suf = rosa_sd
+# repeated_in_memory_search = 0
+# pattern_file_name = ../pattern/web-4GB.40.1000.0.8.12.pattern
+# file_name = ../web-4GB
+# b = 4096
+# fac_dens = 4
+# index_load_rtime = 1205.57
+# index_load_utime = 96.063
+# full_queries = 1000
+# cnt4 = 9355
+# cnt5 = 1000
+# rtime_full = 5113.39
+# utime_full = 2177.79
+# stime_full = 282.606
+# disk_access_per_query = 11.349
+# gap_disk_access_per_query = 0
+# avg_int_match_depth = 14.044
+# ratio_of_int_matched_queries = 0
+# block_length_per_ext_query = 0
+# phase = 
+# index_suf = rosa_sd
+# repeated_in_memory_search = 0
+# pattern_file_name = ../pattern/web-4GB.40.1000.0.75.125.pattern
+# file_name = ../web-4GB
+# b = 4096
+# fac_dens = 4
+# index_load_rtime = 1310.05
+# index_load_utime = 115.004
+# full_queries = 1000
+# cnt4 = 96133
+# cnt5 = 1000
+# rtime_full = 31618.3
+# utime_full = 15480.8
+# stime_full = 1562.35
+# disk_access_per_query = 98.084
+# gap_disk_access_per_query = 0
+# avg_int_match_depth = 15.355
+# ratio_of_int_matched_queries = 0
+# block_length_per_ext_query = 0
+# phase = 
+# index_suf = rosa_sd
+# repeated_in_memory_search = 0
+# pattern_file_name = ../pattern/web-4GB.40.1000.0.8.12.pattern
+# file_name = ../web-4GB
+# b = 4096
+# fac_dens = 16
+# index_load_rtime = 1032.57
+# index_load_utime = 63.218
+# full_queries = 1000
+# cnt4 = 9355
+# cnt5 = 1000
+# rtime_full = 6953.85
+# utime_full = 3552.74
+# stime_full = 320.213
+# disk_access_per_query = 11.302
+# gap_disk_access_per_query = 0
+# avg_int_match_depth = 14.044
+# ratio_of_int_matched_queries = 0
+# block_length_per_ext_query = 0
+# phase = 
+# index_suf = rosa_sd
+# repeated_in_memory_search = 0
+# pattern_file_name = ../pattern/web-4GB.40.1000.0.75.125.pattern
+# file_name = ../web-4GB
+# b = 4096
+# fac_dens = 16
+# index_load_rtime = 857.223
+# index_load_utime = 56.241
+# full_queries = 1000
+# cnt4 = 96133
+# cnt5 = 1000
+# rtime_full = 46816.5
+# utime_full = 28747.5
+# stime_full = 1733.73
+# disk_access_per_query = 97.234
+# gap_disk_access_per_query = 0
+# avg_int_match_depth = 15.355
+# ratio_of_int_matched_queries = 0
+# block_length_per_ext_query = 0
+# phase = 
+# index_suf = rosa_sd
+# repeated_in_memory_search = 0
+# pattern_file_name = ../pattern/web-4GB.40.1000.0.8.12.pattern
+# file_name = ../web-4GB
+# b = 4096
+# fac_dens = 64
+# index_load_rtime = 1392.39
+# index_load_utime = 52.372
+# full_queries = 1000
+# cnt4 = 9355
+# cnt5 = 1000
+# rtime_full = 13058.8
+# utime_full = 9334.31
+# stime_full = 366.642
+# disk_access_per_query = 11.166
+# gap_disk_access_per_query = 0
+# avg_int_match_depth = 14.044
+# ratio_of_int_matched_queries = 0
+# block_length_per_ext_query = 0
+# phase = 
+# index_suf = rosa_sd
+# repeated_in_memory_search = 0
+# pattern_file_name = ../pattern/web-4GB.40.1000.0.75.125.pattern
+# file_name = ../web-4GB
+# b = 4096
+# fac_dens = 64
+# index_load_rtime = 932.621
+# index_load_utime = 55.947
+# full_queries = 1000
+# cnt4 = 96133
+# cnt5 = 1000
+# rtime_full = 101889
+# utime_full = 81964.5
+# stime_full = 2033.54
+# disk_access_per_query = 93.512
+# gap_disk_access_per_query = 0
+# avg_int_match_depth = 15.355
+# ratio_of_int_matched_queries = 0
+# block_length_per_ext_query = 0
+# phase = 
+# index_suf = rosa_sd
+# repeated_in_memory_search = 0
+# pattern_file_name = ../pattern/web-4GB.40.1000.0.8.12.pattern
+# file_name = ../web-4GB
+# b = 4096
+# fac_dens = 256
+# index_load_rtime = 907.513
+# index_load_utime = 51.181
+# full_queries = 1000
+# cnt4 = 9355
+# cnt5 = 1000
+# rtime_full = 34486
+# utime_full = 30470.2
+# stime_full = 470.179
+# disk_access_per_query = 10.903
+# gap_disk_access_per_query = 0
+# avg_int_match_depth = 14.044
+# ratio_of_int_matched_queries = 0
+# block_length_per_ext_query = 0
+# phase = 
+# index_suf = rosa_sd
+# repeated_in_memory_search = 0
+# pattern_file_name = ../pattern/web-4GB.40.1000.0.75.125.pattern
+# file_name = ../web-4GB
+# b = 4096
+# fac_dens = 256
+# index_load_rtime = 862.224
+# index_load_utime = 51.001
+# full_queries = 1000
+# cnt4 = 96133
+# cnt5 = 1000
+# rtime_full = 313781
+# utime_full = 293127
+# stime_full = 2714.74
+# disk_access_per_query = 86.256
+# gap_disk_access_per_query = 0
+# avg_int_match_depth = 15.355
+# ratio_of_int_matched_queries = 0
+# block_length_per_ext_query = 0
+# phase = 
+# index_suf = rosa_sd
+# repeated_in_memory_search = 0
+# pattern_file_name = ../pattern/web-4GB.40.1000.0.8.12.pattern
+# file_name = ../web-4GB
+# b = 4096
+# fac_dens = 1024
+# index_load_rtime = 833.035
+# index_load_utime = 47.845
+# full_queries = 1000
+# cnt4 = 9355
+# cnt5 = 1000
+# rtime_full = 114356
+# utime_full = 110167
+# stime_full = 649.582
+# disk_access_per_query = 10.565
+# gap_disk_access_per_query = 0
+# avg_int_match_depth = 14.044
+# ratio_of_int_matched_queries = 0
+# block_length_per_ext_query = 0
+# phase = 
+# index_suf = rosa_sd
+# repeated_in_memory_search = 0
+# pattern_file_name = ../pattern/web-4GB.40.1000.0.75.125.pattern
+# file_name = ../web-4GB
+# b = 4096
+# fac_dens = 1024
+# index_load_rtime = 862.033
+# index_load_utime = 48.65
+# full_queries = 1000
+# cnt4 = 96133
+# cnt5 = 1000
+# rtime_full = 1.05944e+06
+# utime_full = 1.03882e+06
+# stime_full = 3551.12
+# disk_access_per_query = 78.108
+# gap_disk_access_per_query = 0
+# avg_int_match_depth = 15.355
+# ratio_of_int_matched_queries = 0
+# block_length_per_ext_query = 0