{"id":"W2134227416","doi":"10.1016/s0169-023x(00)00044-6","title":"Selecting and materializing horizontally partitioned warehouse views","year":2001,"lang":"en","type":"article","venue":"Data & Knowledge Engineering","topic":"Advanced Database Systems and Queries","field":"Computer Science","cited_by":22,"is_retracted":false,"has_abstract":false,"ca_institutions":"University of Windsor","funders":"Natural Sciences and Engineering Research Council of Canada","keywords":"Data warehouse; Cube (algebra); Aggregate (composite); Computer science; Table (database); Warehouse; Dimension (graph theory); Data cube; Materialized view; Dimensional modeling; Database; Constraint (computer-aided design); Online analytical processing; Data mining; Information retrieval; Mathematics; View; Geography; Database design; Combinatorics","routes":{"ca_aff":true,"ca_fund":true,"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.001754801,0.001278239,0.001796778,0.00345595,0.001272435,0.006027469,0.002075428,0.001246686,0.007617647],"category_scores_gemma":[0.009104935,0.0016519,0.002117656,0.005021738,0.0008252127,0.005474849,0.00370615,0.001475121,0.001513354],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.0009373035,"about_ca_system_score_gemma":0.001846758,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.003817797,"about_ca_topic_score_gemma":0.007632033,"domain_scores_codex":[0.9979618,0.0002624806,0.0001818242,0.0003196439,0.0009266374,0.0003477612],"domain_scores_gemma":[0.9961197,0.001636741,0.0002374127,0.0008420384,0.0008679302,0.0002962083],"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.002218115,0.0005762768,0.01383857,0.0009454864,0.0004097114,0.001734171,0.002508887,0.0211904,0.1250344,0.01504248,0.03850026,0.7780012],"study_design_scores_gemma":[0.0006141164,0.001547661,0.01766333,0.0005439307,0.001375087,0.002125824,0.01152841,0.5587093,0.2705075,0.06037564,0.07462111,0.0003882441],"study_design_candidate":"simulation_or_modeling","study_design_consensus":null,"genre_codex":"methods","genre_gemma":"methods","genre_scores_codex":[0.312275,0.002089538,0.6432935,0.001190537,0.000335059,0.001189275,0.003348125,0.02242979,0.01384915],"genre_scores_gemma":[0.2688026,0.0008741787,0.7168713,0.0001962243,0.0000997905,0.0002017783,0.006587169,0.002081821,0.004285245],"genre_candidate":"methods","genre_consensus":"methods","teacher_disagreement_score":0.007617647,"threshold_uncertainty_score":0.02548361,"prediction_status":"machine_predicted_unvalidated"},"machine_scores":{"provisional":true,"baseline":true,"maturity_gate_passed":false,"score_opus":0.0577024843604405,"score_gpt":0.2827958738468403,"score_spread":0.2250933894863998,"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."}}