{"id":"W2102820708","doi":"10.1109/apsec.2003.1254379","title":"Implementing the PostgreSQL query optimizer within the OPT++ framework","year":2004,"lang":"en","type":"article","venue":"","topic":"Advanced Database Systems and Queries","field":"Computer Science","cited_by":2,"is_retracted":false,"has_abstract":true,"ca_institutions":"Concordia University","funders":"","keywords":"Computer science; Query optimization; Sargable; Reuse; Simple (philosophy); Code (set theory); Relational database; Query by Example; Query language; Database; Web search query; Information retrieval; Programming language; 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.005812479,0.0007080974,0.0007011199,0.0004511284,0.0007960231,0.002644751,0.003501002,0.0008896251,0.002594636],"category_scores_gemma":[0.007145725,0.0007471652,0.0010444,0.0009297853,0.001204491,0.003239675,0.002003589,0.001962764,0.001130627],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.001472181,"about_ca_system_score_gemma":0.00291893,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.01203991,"about_ca_topic_score_gemma":0.009551371,"domain_scores_codex":[0.9956274,0.001011676,0.0003086117,0.0006761753,0.001839612,0.0005364911],"domain_scores_gemma":[0.9953026,0.001407866,0.0002899299,0.001856727,0.0009310196,0.0002117926],"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.00314874,0.0009043937,0.01600322,0.001132552,0.0002672556,0.0007401752,0.001955075,0.07919537,0.0929122,0.07659014,0.06258448,0.6645663],"study_design_scores_gemma":[0.000568052,0.0008668539,0.007811964,0.0001312028,0.0001860301,0.00100132,0.000671609,0.671418,0.1565212,0.02467634,0.135858,0.000289408],"study_design_candidate":"simulation_or_modeling","study_design_consensus":null,"genre_codex":"methods","genre_gemma":"empirical","genre_scores_codex":[0.09057716,0.0009345189,0.8209103,0.001100372,0.0001743883,0.0003269173,0.00083265,0.07463358,0.01051015],"genre_scores_gemma":[0.3306656,0.0004387913,0.6554479,0.0007449556,0.00008119924,0.000111412,0.001616552,0.006156549,0.004737037],"genre_candidate":"empirical","genre_consensus":null,"teacher_disagreement_score":0.01203991,"threshold_uncertainty_score":0.03073972,"prediction_status":"machine_predicted_unvalidated"},"machine_scores":{"provisional":true,"baseline":true,"maturity_gate_passed":false,"score_opus":0.01398126065558605,"score_gpt":0.2687328854899083,"score_spread":0.2547516248343222,"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."}}