{"id":"W2383580647","doi":"","title":"A Novel Aggregation Algorithm for Online Analytical Processing Query Evaluation","year":2002,"lang":"en","type":"article","venue":"","topic":"Advanced Database Systems and Queries","field":"Computer Science","cited_by":4,"is_retracted":false,"has_abstract":true,"ca_institutions":"CAE (Canada)","funders":"","keywords":"Computer science; Online analytical processing; Online aggregation; Sorting; Sorting algorithm; sort; Key (lock); Query optimization; Aggregate (composite); Data mining; Schema (genetic algorithms); Algorithm; Join (topology); Table (database); SQL; Data warehouse; Theoretical computer science; Information retrieval; Database; Query by Example; 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.0002812496,0.0000813128,0.0001003187,0.00006166488,0.0001045115,0.00005322696,0.0001207565,0.00003201812,0.00002556709],"category_scores_gemma":[0.00009558263,0.00006663858,0.0000344765,0.0002322351,0.00001965028,0.0009675564,0.00004380208,0.0000389285,0.000008981263],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.00004534236,"about_ca_system_score_gemma":0.00003474948,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.0000154431,"about_ca_topic_score_gemma":0.00002220303,"domain_scores_codex":[0.9990935,0.00001537501,0.0001985349,0.000265909,0.0002744858,0.0001522494],"domain_scores_gemma":[0.9993446,0.00004539244,0.00007481639,0.0002242604,0.0002645457,0.00004634587],"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":[5.443119e-7,0.0000666141,0.000003020423,0.00001055026,0.000003290069,3.022168e-7,0.00007363791,0.0001075068,0.0001607758,0.02049283,0.0003351546,0.9787458],"study_design_scores_gemma":[0.0003613126,0.00003266362,0.00006850778,0.00002945696,0.000006910555,0.00001248994,0.00003021577,0.9863802,0.0002344671,0.0003305858,0.01241501,0.00009817195],"study_design_candidate":"simulation_or_modeling","study_design_consensus":null,"genre_codex":"methods","genre_gemma":"methods","genre_scores_codex":[0.0002606387,0.0001831745,0.9981737,0.0004157395,0.0001122925,0.000293823,0.00002260095,0.0001062795,0.000431788],"genre_scores_gemma":[0.007949064,0.000004553048,0.9909363,0.0001822647,0.0001523793,0.00004802347,0.00004286008,0.000005808906,0.000678777],"genre_candidate":"methods","genre_consensus":"methods","teacher_disagreement_score":0.9862727,"threshold_uncertainty_score":0.2717443,"prediction_status":"machine_predicted_unvalidated"},"machine_scores":{"provisional":true,"baseline":true,"maturity_gate_passed":false,"score_opus":0.07987215920354403,"score_gpt":0.3293050287235504,"score_spread":0.2494328695200064,"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."}}