{"id":"W2504311311","doi":"10.4018/978-1-60566-242-8.ch074","title":"Index and Materialized View Selection in Data Warehouses","year":2009,"lang":"en","type":"book-chapter","venue":"IGI Global eBooks","topic":"Data Management and Algorithms","field":"Computer Science","cited_by":2,"is_retracted":false,"has_abstract":true,"ca_institutions":"Université du Québec à Montréal","funders":"","keywords":"Materialized view; Data warehouse; Heuristics; Selection (genetic algorithm); Computer science; Index (typography); Focus (optics); Data mining; State (computer science); Information retrieval; Data science; World Wide Web; View; Artificial intelligence; Algorithm; Database design","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":["metaepi_narrow"],"consensus_categories":[],"category_scores_codex":[0.0001866029,0.0002897283,0.000342955,0.0001057654,0.00005312857,0.0005186424,0.001456917,0.0001610444,0.0000128869],"category_scores_gemma":[0.000006519638,0.0002844532,0.00002831632,0.00003766235,0.0000363928,0.0004417427,0.001367244,0.0001322523,0.00004751432],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.00007613266,"about_ca_system_score_gemma":0.00006180127,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.0001176013,"about_ca_topic_score_gemma":0.0002612856,"domain_scores_codex":[0.9984125,0.00002103285,0.0002981359,0.0007526061,0.0002677213,0.0002479358],"domain_scores_gemma":[0.9989563,0.000008877897,0.0001352348,0.0008083325,0.00002426212,0.0000669518],"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.000008892906,0.000006506002,0.00001170423,0.00003047237,0.00002073245,0.0000479869,0.000009426979,4.64834e-7,0.000002411951,0.7456928,0.00274349,0.2514251],"study_design_scores_gemma":[0.0008798825,0.0000846013,0.000429188,0.0003768279,0.00004164507,0.00005219373,0.000001551525,0.002720981,0.000007836788,0.3643619,0.6303336,0.0007097155],"study_design_candidate":"theoretical_or_conceptual","study_design_consensus":null,"genre_codex":"other","genre_gemma":"other","genre_scores_codex":[0.00003287288,0.0005850743,0.01467973,0.0002042651,0.0005917403,0.0005312222,0.0002218126,0.0003749894,0.9827783],"genre_scores_gemma":[0.09386744,0.001941326,0.1280835,0.01240056,0.003779071,0.0001046713,0.000884526,0.0003830959,0.7585558],"genre_candidate":"other","genre_consensus":"other","teacher_disagreement_score":0.6275901,"threshold_uncertainty_score":0.9999608,"prediction_status":"machine_predicted_unvalidated"},"machine_scores":{"provisional":true,"baseline":true,"maturity_gate_passed":false,"score_opus":0.03430870571903638,"score_gpt":0.2659318365498237,"score_spread":0.2316231308307873,"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."}}