{"id":"W2070325534","doi":"10.4018/jdm.2009062501","title":"A Cost-Based Range Estimation for Mapping Top-k Selection Queries over Relational Databases","year":2009,"lang":"en","type":"article","venue":"Journal of Database Management","topic":"Data Management and Algorithms","field":"Computer Science","cited_by":8,"is_retracted":false,"has_abstract":true,"ca_institutions":"Brock University","funders":"","keywords":"Computer science; Query optimization; Sargable; Relational database; Online aggregation; Range (aeronautics); Database; Search engine indexing; Data mining; View; Query language; Query expansion; Information retrieval; Selection (genetic algorithm); Relational database management system; Range query (database); Query by Example; Web search query; Search engine; Database design; Artificial intelligence","routes":{"ca_aff":true,"ca_fund":false,"ca_venue":false,"about_ca":false,"invisible_to_affiliation_only":false},"retraction":null,"screen":null,"direct_labels":[],"prediction":{"model_version":"metacan-v3-hybrid-931329e0061c","candidate_categories":[],"consensus_categories":[],"category_scores_codex":[0.002237245,0.00085329,0.001426375,0.001895491,0.0005591747,0.001651266,0.00214159,0.001172866,0.001390012],"category_scores_gemma":[0.01522016,0.0005513555,0.0009225409,0.002589,0.0007778091,0.004051632,0.001667971,0.001288902,0.0004363635],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.001163114,"about_ca_system_score_gemma":0.001340638,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.005210686,"about_ca_topic_score_gemma":0.003009134,"domain_scores_codex":[0.9966251,0.001145218,0.0002327479,0.0005056295,0.001292706,0.0001986389],"domain_scores_gemma":[0.9944075,0.003394455,0.000453105,0.0008549374,0.0007750204,0.0001149323],"domain_codex":null,"domain_gemma":null,"domain_candidate":null,"domain_consensus":null,"study_design_codex":"simulation_or_modeling","study_design_gemma":"simulation_or_modeling","study_design_scores_codex":[0.0003276738,0.0002323949,0.003765635,0.000218847,0.00009622802,0.0001192748,0.0002287253,0.6646891,0.0105109,0.02721631,0.003204112,0.2893908],"study_design_scores_gemma":[0.00001054551,0.00004661208,0.0002599364,0.000006691759,0.00001179977,0.0000654354,0.00002520821,0.9919749,0.001855749,0.005252538,0.0004736976,0.00001696169],"study_design_candidate":"simulation_or_modeling","study_design_consensus":"simulation_or_modeling","genre_codex":"methods","genre_gemma":"empirical","genre_scores_codex":[0.009093791,0.0002511583,0.9895622,0.0001155766,0.00001170672,0.00005143523,0.00005119084,0.0004839864,0.0003789367],"genre_scores_gemma":[0.3383992,0.0004296983,0.6596158,0.0001012451,0.00007475273,0.0002112047,0.0003328193,0.0001442893,0.0006909026],"genre_candidate":"empirical","genre_consensus":null,"teacher_disagreement_score":0.005210686,"threshold_uncertainty_score":0.01183182,"prediction_status":"machine_predicted_unvalidated"},"machine_scores":{"provisional":true,"baseline":true,"maturity_gate_passed":false,"score_opus":0.06041991573860454,"score_gpt":0.3075527271262722,"score_spread":0.2471328113876677,"validation_status":"score_only:v0-immature-baseline","note":"Baseline scores from an immature model (maturity gate not passed). Scores rank; they never assert a category."}}