{"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":"codex-gemma-dda1882f352a","candidate_categories":[],"consensus_categories":[],"category_scores_codex":[0.0007912666,0.0001351332,0.0001123452,0.0000219202,0.0007089077,0.0001766177,0.0008411213,0.00003559771,0.00003399028],"category_scores_gemma":[0.0001007955,0.00006010595,0.00006295402,0.0002875642,0.00009002848,0.0005789586,0.0007324268,0.0002324896,0.00006414932],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.00002638073,"about_ca_system_score_gemma":0.00007854485,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.0004132438,"about_ca_topic_score_gemma":0.0001664652,"domain_scores_codex":[0.9987422,0.00006336169,0.000270798,0.0002783789,0.0002709538,0.0003743412],"domain_scores_gemma":[0.9985139,0.0002009749,0.0001249702,0.001059617,0.00005437118,0.00004611078],"domain_codex":null,"domain_gemma":null,"domain_candidate":null,"domain_consensus":null,"study_design_codex":"theoretical_or_conceptual","study_design_gemma":"not_applicable","study_design_scores_codex":[0.000001733577,0.000007741419,0.00005582809,0.000002696855,0.00001174749,0.000005634572,0.001154463,0.002646706,0.00005435504,0.9943693,0.000366517,0.001323249],"study_design_scores_gemma":[0.001921337,0.0002880128,0.001973368,0.0005183721,0.0000469166,0.0005284612,0.01422767,0.02499479,0.02210528,0.3098146,0.6217759,0.001805244],"study_design_candidate":"theoretical_or_conceptual","study_design_consensus":null,"genre_codex":"methods","genre_gemma":"methods","genre_scores_codex":[0.002390962,0.0002049744,0.9846554,0.008626308,0.0004677557,0.0002286252,0.000004921388,0.0001493707,0.003271722],"genre_scores_gemma":[0.2126085,0.00001199703,0.782782,0.003790306,0.000214849,0.00004118387,0.000002883756,0.00001272033,0.0005355916],"genre_candidate":"methods","genre_consensus":"methods","teacher_disagreement_score":0.6845547,"threshold_uncertainty_score":0.5452417,"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."}}