{"id":"W2950833175","doi":"10.1145/3299869.3319894","title":"Pessimistic Cardinality Estimation","year":2019,"lang":"en","type":"article","venue":"","topic":"Data Management and Algorithms","field":"Computer Science","cited_by":77,"is_retracted":false,"has_abstract":true,"ca_institutions":"","funders":"Alberta Innovates - Technology Futures; National Science Foundation","keywords":"Computer science; Cardinality (data modeling); Benchmark (surveying); Hash function; Tuple; Key (lock); Monotonic function; Parameterized complexity; Partition (number theory); Join (topology); Theoretical computer science; Mathematical optimization; Algorithm; Data mining; Mathematics; Discrete mathematics","routes":{"ca_aff":false,"ca_fund":true,"ca_venue":false,"about_ca":false,"invisible_to_affiliation_only":true},"retraction":null,"screen":null,"direct_labels":[],"prediction":{"model_version":"codex-gemma-dda1882f352a","candidate_categories":["insufficient_payload"],"consensus_categories":[],"category_scores_codex":[0.0001283902,0.00003568337,0.0000441558,0.00002201431,0.00002016423,0.000127444,0.0003581605,0.000008123026,0.0001022278],"category_scores_gemma":[0.000007283291,0.00002923787,0.00001610017,0.0001035952,0.000004235509,0.0005683436,0.0001556363,0.00002050437,0.001090036],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.000008078991,"about_ca_system_score_gemma":0.00000598468,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.0000146218,"about_ca_topic_score_gemma":3.871272e-7,"domain_scores_codex":[0.9995982,0.000009729028,0.00005575748,0.0001443363,0.0001132392,0.0000787133],"domain_scores_gemma":[0.9995903,0.00001393221,0.00001564599,0.0003477292,0.0000129031,0.00001953455],"domain_codex":null,"domain_gemma":null,"domain_candidate":null,"domain_consensus":null,"study_design_codex":"theoretical_or_conceptual","study_design_gemma":"simulation_or_modeling","study_design_scores_codex":[6.572544e-7,0.00002238536,0.002163602,0.00002494123,0.000009972317,0.000003602414,0.0000431792,0.0003856758,0.00003404851,0.7457506,0.009034864,0.2425265],"study_design_scores_gemma":[0.0001083538,0.00001434231,0.01046397,0.000003501538,0.000002278805,8.849186e-7,0.000005795861,0.9720003,0.000101399,0.006940703,0.01027782,0.00008065131],"study_design_candidate":"simulation_or_modeling","study_design_consensus":null,"genre_codex":"methods","genre_gemma":"empirical","genre_scores_codex":[0.002742229,0.00000424417,0.9015237,0.0003528787,0.0002498064,0.00005941701,5.114406e-7,0.0001167136,0.09495047],"genre_scores_gemma":[0.8537722,9.305232e-7,0.1369247,0.0002213878,0.00001875448,0.000002257306,0.000007678317,0.000001699793,0.009050349],"genre_candidate":"methods","genre_consensus":null,"teacher_disagreement_score":0.9716146,"threshold_uncertainty_score":0.9996877,"prediction_status":"machine_predicted_unvalidated"},"machine_scores":{"provisional":true,"baseline":true,"maturity_gate_passed":false,"score_opus":0.007955252744919091,"score_gpt":0.2270172417928118,"score_spread":0.2190619890478927,"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."}}