{"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":"metacan-v3-hybrid-931329e0061c","candidate_categories":[],"consensus_categories":[],"category_scores_codex":[0.001645373,0.0008282278,0.001521289,0.001612799,0.0007625406,0.004485652,0.002500117,0.0008950231,0.003710659],"category_scores_gemma":[0.004054161,0.0009471673,0.001033971,0.005989299,0.0009935522,0.005371582,0.00203336,0.001288905,0.001796032],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.001065964,"about_ca_system_score_gemma":0.0008656865,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.0009376166,"about_ca_topic_score_gemma":0.0009262325,"domain_scores_codex":[0.9984391,0.000368351,0.0001373381,0.0002977294,0.0006466035,0.0001107592],"domain_scores_gemma":[0.9984018,0.0007329049,0.0001383125,0.0004395063,0.0002119816,0.00007546781],"domain_codex":null,"domain_gemma":null,"domain_candidate":null,"domain_consensus":null,"study_design_codex":"design_other","study_design_gemma":"theoretical_or_conceptual","study_design_scores_codex":[0.0006089719,0.0002865291,0.002028843,0.001066969,0.0001270017,0.0004261335,0.0004573032,0.09524955,0.01581925,0.2129586,0.03111989,0.6398509],"study_design_scores_gemma":[0.0001286404,0.0003702903,0.001363135,0.0002395223,0.0001847944,0.001197292,0.0003127397,0.4921274,0.01954041,0.3895722,0.09485517,0.0001084038],"study_design_candidate":"theoretical_or_conceptual","study_design_consensus":null,"genre_codex":"methods","genre_gemma":"methods","genre_scores_codex":[0.02028331,0.0106936,0.9525513,0.0005979317,0.0001446846,0.0001635095,0.0007364919,0.001819329,0.01300979],"genre_scores_gemma":[0.1762471,0.007793824,0.8049084,0.0002429651,0.0002433184,0.0002042783,0.002084452,0.0005037439,0.007771902],"genre_candidate":"methods","genre_consensus":"methods","teacher_disagreement_score":0.004485652,"threshold_uncertainty_score":0.01241338,"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."}}