{"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":"metacan-v3-hybrid-931329e0061c","candidate_categories":[],"consensus_categories":[],"category_scores_codex":[0.002282067,0.001049462,0.001519705,0.001957363,0.0005321634,0.002678176,0.00244828,0.001196582,0.002011932],"category_scores_gemma":[0.01390525,0.0005837209,0.001324279,0.004173945,0.0007025261,0.004961009,0.001325034,0.001654971,0.001027704],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.001988285,"about_ca_system_score_gemma":0.001026646,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.006649615,"about_ca_topic_score_gemma":0.00346103,"domain_scores_codex":[0.996944,0.001036397,0.0002074894,0.0004200283,0.001240243,0.0001518402],"domain_scores_gemma":[0.9941859,0.003900436,0.00043835,0.0007293999,0.0006606477,0.00008521491],"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.00008644256,0.00008345867,0.002175806,0.0002894026,0.00007317852,0.0001070561,0.0001526749,0.7064906,0.003530166,0.05094939,0.004785367,0.2312765],"study_design_scores_gemma":[0.000002585051,0.00001545816,0.0002988038,0.00001120681,0.000010138,0.00008972454,0.00002255482,0.9828926,0.0007801122,0.01470741,0.001155872,0.00001348661],"study_design_candidate":"simulation_or_modeling","study_design_consensus":"simulation_or_modeling","genre_codex":"methods","genre_gemma":"methods","genre_scores_codex":[0.00560319,0.001431529,0.9909116,0.0001973333,0.00002509912,0.00004334027,0.0001205994,0.0004151861,0.001252077],"genre_scores_gemma":[0.3086839,0.0040495,0.6823075,0.0001638391,0.0002163898,0.000286249,0.0008574374,0.0003783242,0.00305701],"genre_candidate":"methods","genre_consensus":"methods","teacher_disagreement_score":0.006649615,"threshold_uncertainty_score":0.01442611,"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."}}