{"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":"codex-gemma-dda1882f352a","candidate_categories":[],"consensus_categories":[],"category_scores_codex":[0.000319387,0.0001659742,0.0001896493,0.00007897551,0.0001396665,0.0001390368,0.0004817066,0.00003588834,0.000007099898],"category_scores_gemma":[0.0001268684,0.0001636859,0.00001501045,0.0002745225,0.00001262281,0.001729883,0.0008453011,0.00009492777,0.00004238788],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.00002824703,"about_ca_system_score_gemma":0.00002228348,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.0000250779,"about_ca_topic_score_gemma":0.00006582506,"domain_scores_codex":[0.9988936,0.00002508607,0.0002466194,0.0004432851,0.00008971312,0.0003016968],"domain_scores_gemma":[0.9989333,0.00005266454,0.00005034405,0.0008177169,0.00004568981,0.0001002716],"domain_codex":null,"domain_gemma":null,"domain_candidate":null,"domain_consensus":null,"study_design_codex":"design_other","study_design_gemma":"not_applicable","study_design_scores_codex":[0.00004120832,0.0002811063,0.002094593,0.001302093,0.0002338603,0.0004747452,0.007630446,0.0007886342,0.1711292,0.2207682,0.01515642,0.5800995],"study_design_scores_gemma":[0.000277659,0.00003531048,0.0003925654,0.0001740314,0.000008060771,0.0002009812,0.00005343207,0.3635798,0.002296767,0.00002611415,0.6325634,0.0003919412],"study_design_candidate":"not_applicable","study_design_consensus":null,"genre_codex":"methods","genre_gemma":"methods","genre_scores_codex":[0.01188475,0.001327723,0.985107,0.00004787896,0.0007142583,0.0001220729,0.00006895684,0.0004637207,0.000263645],"genre_scores_gemma":[0.2993267,0.0004860096,0.6976799,0.00007425396,0.001254578,0.00007753138,0.0006936949,0.00009605613,0.000311266],"genre_candidate":"methods","genre_consensus":"methods","teacher_disagreement_score":0.6174069,"threshold_uncertainty_score":0.6674917,"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."}}