{"id":"W2493539536","doi":"10.4018/978-1-60960-521-6.ch012","title":"Cost Modeling and Range Estimation for Top-k Retrieval in Relational Databases","year":2011,"lang":"en","type":"book-chapter","venue":"IGI Global eBooks","topic":"Data Management and Algorithms","field":"Computer Science","cited_by":0,"is_retracted":false,"has_abstract":true,"ca_institutions":"Brock University","funders":"","keywords":"Computer science; Query optimization; Information retrieval; Relational database; Data mining; Range (aeronautics); Search engine indexing; Database; Sargable; Range query (database); Online aggregation; View; Query expansion; Relational database management system; Database design; Web search query; Search engine","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.0002278855,0.0001986884,0.0001992007,0.00009610986,0.0000677031,0.0001126414,0.0003604661,0.00009781036,0.000005805026],"category_scores_gemma":[0.00002920155,0.0002074616,0.00004722981,0.00002031088,0.00003083998,0.0004467976,0.000365884,0.0001086521,0.00001773466],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.00007218703,"about_ca_system_score_gemma":0.00005434397,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.00005268752,"about_ca_topic_score_gemma":0.00004124335,"domain_scores_codex":[0.9988454,0.000007626929,0.0002712423,0.0004634966,0.0002291139,0.0001831117],"domain_scores_gemma":[0.9993564,0.00003872063,0.0001098497,0.000382899,0.00005443431,0.00005772359],"domain_codex":null,"domain_gemma":null,"domain_candidate":null,"domain_consensus":null,"study_design_codex":"theoretical_or_conceptual","study_design_gemma":"theoretical_or_conceptual","study_design_scores_codex":[0.00002229114,0.000004023685,0.00001082401,0.00002693272,0.00001225259,0.000008140233,0.00002666895,0.00009977536,1.752209e-7,0.9702674,0.0003467191,0.02917476],"study_design_scores_gemma":[0.0005407416,0.00003208607,0.00002576627,0.0001706363,0.00002509076,0.000006482926,0.000001544506,0.4774671,0.00000214244,0.5123885,0.009067244,0.0002725899],"study_design_candidate":"theoretical_or_conceptual","study_design_consensus":"theoretical_or_conceptual","genre_codex":"methods","genre_gemma":"methods","genre_scores_codex":[0.00001902315,0.000148703,0.6902611,0.00003986866,0.0002082979,0.0004635566,0.0002818162,0.00005648379,0.3085212],"genre_scores_gemma":[0.04122663,0.00008709417,0.8820638,0.001036114,0.0007415829,0.0001130763,0.0008945561,0.00009849855,0.07373863],"genre_candidate":"methods","genre_consensus":"methods","teacher_disagreement_score":0.4773673,"threshold_uncertainty_score":0.8460039,"prediction_status":"machine_predicted_unvalidated"},"machine_scores":{"provisional":true,"baseline":true,"maturity_gate_passed":false,"score_opus":0.09564848466483881,"score_gpt":0.2883735946860542,"score_spread":0.1927251100212154,"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."}}