{"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":"codex-gemma-dda1882f352a","candidate_categories":[],"consensus_categories":[],"category_scores_codex":[0.0009590597,0.0001494917,0.0001770883,0.0004839782,0.0001657836,0.000212641,0.0005013634,0.0000175662,0.00003123932],"category_scores_gemma":[0.00007107535,0.0001375818,0.00009664978,0.0004453883,0.00001648322,0.003097886,0.0001412632,0.0001054946,0.000008096839],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.0000978521,"about_ca_system_score_gemma":0.00003839574,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.000005300699,"about_ca_topic_score_gemma":0.000002709406,"domain_scores_codex":[0.9984711,0.00004521332,0.0004811246,0.0002533848,0.0005250914,0.0002241183],"domain_scores_gemma":[0.998912,0.00008890934,0.0004270902,0.0003674969,0.0001310355,0.00007344157],"domain_codex":null,"domain_gemma":null,"domain_candidate":null,"domain_consensus":null,"study_design_codex":"design_other","study_design_gemma":"simulation_or_modeling","study_design_scores_codex":[0.0002342333,0.0004176042,0.001098669,0.0003279845,0.0002581545,0.0001295525,0.00015179,0.008734339,0.0002771352,0.3860814,0.1522654,0.4500237],"study_design_scores_gemma":[0.003191942,0.0003081179,0.01400786,0.0003330225,0.0001266823,0.00002042259,0.00007354818,0.6683127,0.0004084601,0.001892373,0.3109667,0.0003581622],"study_design_candidate":"simulation_or_modeling","study_design_consensus":null,"genre_codex":"methods","genre_gemma":"methods","genre_scores_codex":[0.000780697,0.00007459629,0.9956378,0.002150506,0.0003629302,0.0004896688,0.0000834869,0.00005103144,0.000369336],"genre_scores_gemma":[0.01352947,0.0000502834,0.9843936,0.001132033,0.000208791,0.00002348965,0.0003861754,0.000008384331,0.0002677701],"genre_candidate":"methods","genre_consensus":"methods","teacher_disagreement_score":0.6595784,"threshold_uncertainty_score":0.5610423,"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."}}