{"id":"https://openalex.org/W2014634045","doi":"https://doi.org/10.4018/jdwm.2006040101","title":"A Hybrid Approach for Data Warehouse View Selection","display_name":"A Hybrid Approach for Data Warehouse View Selection","publication_year":2006,"publication_date":"2006-04-01","ids":{"openalex":"https://openalex.org/W2014634045","doi":"https://doi.org/10.4018/jdwm.2006040101","mag":"2014634045"},"language":"en","primary_location":{"id":"doi:10.4018/jdwm.2006040101","is_oa":false,"landing_page_url":"https://doi.org/10.4018/jdwm.2006040101","pdf_url":null,"source":{"id":"https://openalex.org/S53932126","display_name":"International Journal of Data Warehousing and Mining","issn_l":"1548-3924","issn":["1548-3924","1548-3932"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320424","host_organization_name":"IGI Global","host_organization_lineage":["https://openalex.org/P4310320424"],"host_organization_lineage_names":["IGI Global"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"International Journal of Data Warehousing and Mining","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5102775051","display_name":"Biren Shah","orcid":"https://orcid.org/0000-0001-5520-0497"},"institutions":[{"id":"https://openalex.org/I79516672","display_name":"University of Louisiana at Lafayette","ror":"https://ror.org/01x8rc503","country_code":"US","type":"education","lineage":["https://openalex.org/I2799628689","https://openalex.org/I79516672"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Biren Shah","raw_affiliation_strings":["University of Louisiana at Lafayette, USA","University of Louisiana at Lafayette, USA,"],"affiliations":[{"raw_affiliation_string":"University of Louisiana at Lafayette, USA","institution_ids":["https://openalex.org/I79516672"]},{"raw_affiliation_string":"University of Louisiana at Lafayette, USA,","institution_ids":["https://openalex.org/I79516672"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5011046422","display_name":"K. K. Ramachandran","orcid":null},"institutions":[{"id":"https://openalex.org/I79516672","display_name":"University of Louisiana at Lafayette","ror":"https://ror.org/01x8rc503","country_code":"US","type":"education","lineage":["https://openalex.org/I2799628689","https://openalex.org/I79516672"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Karthik Ramachandran","raw_affiliation_strings":["University of Louisiana at Lafayette, USA","University of Louisiana at Lafayette, USA,"],"affiliations":[{"raw_affiliation_string":"University of Louisiana at Lafayette, USA","institution_ids":["https://openalex.org/I79516672"]},{"raw_affiliation_string":"University of Louisiana at Lafayette, USA,","institution_ids":["https://openalex.org/I79516672"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5023699325","display_name":"Vijay V. Raghavan","orcid":"https://orcid.org/0000-0001-7224-7828"},"institutions":[{"id":"https://openalex.org/I79516672","display_name":"University of Louisiana at Lafayette","ror":"https://ror.org/01x8rc503","country_code":"US","type":"education","lineage":["https://openalex.org/I2799628689","https://openalex.org/I79516672"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Vijay Raghavan","raw_affiliation_strings":["University of Louisiana at Lafayette, USA","University of Louisiana at Lafayette, USA,"],"affiliations":[{"raw_affiliation_string":"University of Louisiana at Lafayette, USA","institution_ids":["https://openalex.org/I79516672"]},{"raw_affiliation_string":"University of Louisiana at Lafayette, USA,","institution_ids":["https://openalex.org/I79516672"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5102775051"],"corresponding_institution_ids":["https://openalex.org/I79516672"],"apc_list":null,"apc_paid":null,"fwci":1.5769,"has_fulltext":false,"cited_by_count":52,"citation_normalized_percentile":{"value":0.84738884,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":99},"biblio":{"volume":"2","issue":"2","first_page":"1","last_page":"37"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9995999932289124,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9995999932289124,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9994000196456909,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10538","display_name":"Data Mining Algorithms and Applications","score":0.9968000054359436,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/materialized-view","display_name":"Materialized view","score":0.8983950018882751},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8822677135467529},{"id":"https://openalex.org/keywords/selection","display_name":"Selection (genetic algorithm)","score":0.6224420666694641},{"id":"https://openalex.org/keywords/set","display_name":"Set (abstract data type)","score":0.5958409905433655},{"id":"https://openalex.org/keywords/partition","display_name":"Partition (number theory)","score":0.5765529274940491},{"id":"https://openalex.org/keywords/heuristic","display_name":"Heuristic","score":0.5731269121170044},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.5424280166625977},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.46414461731910706},{"id":"https://openalex.org/keywords/on-the-fly","display_name":"On the fly","score":0.44126150012016296},{"id":"https://openalex.org/keywords/point","display_name":"Point (geometry)","score":0.4268903434276581},{"id":"https://openalex.org/keywords/greedy-algorithm","display_name":"Greedy algorithm","score":0.41247284412384033},{"id":"https://openalex.org/keywords/machine-learning","display_name":"Machine learning","score":0.20394650101661682},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.17431950569152832},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.173098623752594},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.15800681710243225},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.09921267628669739},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.09301063418388367}],"concepts":[{"id":"https://openalex.org/C98199447","wikidata":"https://www.wikidata.org/wiki/Q2445044","display_name":"Materialized view","level":4,"score":0.8983950018882751},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8822677135467529},{"id":"https://openalex.org/C81917197","wikidata":"https://www.wikidata.org/wiki/Q628760","display_name":"Selection (genetic algorithm)","level":2,"score":0.6224420666694641},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.5958409905433655},{"id":"https://openalex.org/C42812","wikidata":"https://www.wikidata.org/wiki/Q1082910","display_name":"Partition (number theory)","level":2,"score":0.5765529274940491},{"id":"https://openalex.org/C173801870","wikidata":"https://www.wikidata.org/wiki/Q201413","display_name":"Heuristic","level":2,"score":0.5731269121170044},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.5424280166625977},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.46414461731910706},{"id":"https://openalex.org/C2781020372","wikidata":"https://www.wikidata.org/wiki/Q533093","display_name":"On the fly","level":2,"score":0.44126150012016296},{"id":"https://openalex.org/C28719098","wikidata":"https://www.wikidata.org/wiki/Q44946","display_name":"Point (geometry)","level":2,"score":0.4268903434276581},{"id":"https://openalex.org/C51823790","wikidata":"https://www.wikidata.org/wiki/Q504353","display_name":"Greedy algorithm","level":2,"score":0.41247284412384033},{"id":"https://openalex.org/C119857082","wikidata":"https://www.wikidata.org/wiki/Q2539","display_name":"Machine learning","level":1,"score":0.20394650101661682},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.17431950569152832},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.173098623752594},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.15800681710243225},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.09921267628669739},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.09301063418388367},{"id":"https://openalex.org/C114614502","wikidata":"https://www.wikidata.org/wiki/Q76592","display_name":"Combinatorics","level":1,"score":0.0},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.0},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.0},{"id":"https://openalex.org/C2524010","wikidata":"https://www.wikidata.org/wiki/Q8087","display_name":"Geometry","level":1,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.4018/jdwm.2006040101","is_oa":false,"landing_page_url":"https://doi.org/10.4018/jdwm.2006040101","pdf_url":null,"source":{"id":"https://openalex.org/S53932126","display_name":"International Journal of Data Warehousing and Mining","issn_l":"1548-3924","issn":["1548-3924","1548-3932"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320424","host_organization_name":"IGI Global","host_organization_lineage":["https://openalex.org/P4310320424"],"host_organization_lineage_names":["IGI Global"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"International Journal of Data Warehousing and Mining","raw_type":"journal-article"},{"id":"pmh:oai:RePEc:igg:jdwm00:v:2:y:2006:i:2:p:1-37","is_oa":false,"landing_page_url":"https://services.igi-global.com/resolvedoi/resolve.aspx?doi=10.4018/jdwm.2006040101","pdf_url":null,"source":{"id":"https://openalex.org/S4306401271","display_name":"RePEc: Research Papers in Economics","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I77793887","host_organization_name":"Federal Reserve Bank of St. Louis","host_organization_lineage":["https://openalex.org/I77793887"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"article"}],"best_oa_location":null,"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/9","score":0.49000000953674316,"display_name":"Industry, innovation and infrastructure"}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":44,"referenced_works":["https://openalex.org/W1893018","https://openalex.org/W38346608","https://openalex.org/W62665833","https://openalex.org/W149223582","https://openalex.org/W1509663381","https://openalex.org/W1514949376","https://openalex.org/W1522055873","https://openalex.org/W1538267625","https://openalex.org/W1551562200","https://openalex.org/W1565838812","https://openalex.org/W1582833014","https://openalex.org/W1601435884","https://openalex.org/W1635132392","https://openalex.org/W1908466746","https://openalex.org/W1946262574","https://openalex.org/W1975337935","https://openalex.org/W1981031417","https://openalex.org/W2008365755","https://openalex.org/W2017782374","https://openalex.org/W2020393234","https://openalex.org/W2028145673","https://openalex.org/W2039396857","https://openalex.org/W2044240774","https://openalex.org/W2048104165","https://openalex.org/W2054170837","https://openalex.org/W2061751973","https://openalex.org/W2074713486","https://openalex.org/W2088205980","https://openalex.org/W2103201239","https://openalex.org/W2109464129","https://openalex.org/W2113888164","https://openalex.org/W2114712170","https://openalex.org/W2120621050","https://openalex.org/W2122902664","https://openalex.org/W2128322880","https://openalex.org/W2131576956","https://openalex.org/W2132681112","https://openalex.org/W2142183404","https://openalex.org/W2143401113","https://openalex.org/W2150950420","https://openalex.org/W2152272665","https://openalex.org/W2155166680","https://openalex.org/W2163620558","https://openalex.org/W4285719527"],"related_works":["https://openalex.org/W2792920932","https://openalex.org/W2317637552","https://openalex.org/W2751504412","https://openalex.org/W2371393768","https://openalex.org/W1523517289","https://openalex.org/W2288602726","https://openalex.org/W2950842566","https://openalex.org/W2301096354","https://openalex.org/W1541435301","https://openalex.org/W2014634045"],"abstract_inverted_index":{"Materialized":[0],"view":[1,190,226,236],"selection":[2,18,42,94],"is":[3,100,203,230],"one":[4],"of":[5,19,43,54,71,80,95,105,161,169,179,183],"the":[6,30,39,60,67,72,76,81,93,103,121,136,145,153,157,164,176,180,199,208],"crucial":[7],"decisions":[8],"in":[9,175,186,205],"designing":[10],"a":[11,51,63,89,109,172,223],"data":[12,31],"warehouse":[13],"for":[14,48,62,92,118,207],"optimal":[15,234],"efficiency.":[16],"Static":[17],"views":[20,24,44,107,116,133,149,170,184],"may":[21],"materialize":[22],"certain":[23,188],"that":[25,65,115,194,218,229],"are":[26,124,150],"not":[27],"beneficial":[28],"as":[29],"and":[32,75,111,185],"usage":[33],"trends":[34],"change":[35],"over":[36,126],"time.":[37],"On":[38],"contrary,":[40],"dynamic":[41,82,112,137,181,225],"works":[45],"better":[46],"only":[47],"queries":[49],"demanding":[50],"high":[52],"degree":[53],"aggregation.":[55],"These":[56],"facts":[57],"point":[58],"to":[59,101,211,232],"need":[61],"technique":[64],"combines":[66],"improved":[68],"response":[69],"time":[70],"static":[73,110,122,167,235],"approach":[74,91,220],"automated":[77],"tuning":[78],"capability":[79],"approach.":[83],"In":[84],"this":[85],"article,":[86],"we":[87],"propose":[88],"hybrid":[90],"materialized":[96],"views.":[97],"The":[98],"idea":[99],"partition":[102],"collection":[104],"all":[106],"into":[108],"set":[113,123,138,168,182],"such":[114],"selected":[117,134,151],"materialization":[119],"from":[120,135],"persistent":[125],"multiple":[127],"query":[128,158],"(and":[129],"maintenance)":[130],"windows,":[131],"whereas":[132,163],"can":[139],"be":[140],"queried":[141],"and/or":[142],"replaced":[143],"on":[144,152,156],"fly.":[146],"Highly":[147],"aggregated":[148],"fly":[154],"based":[155],"access":[159],"patterns":[160],"users,":[162],"more":[165],"detailed":[166,189],"plays":[171],"significant":[173],"role":[174],"efficient":[177],"maintenance":[178],"answering":[187],"queries.":[191],"We":[192],"prove":[193],"our":[195,219],"proposed":[196],"strategy":[197],"satisfies":[198],"monotonicity":[200],"requirements,":[201],"which":[202],"essential":[204],"order":[206],"greedy":[209],"heuristic":[210],"deliver":[212],"competitive":[213],"solutions.":[214],"Experimental":[215],"results":[216],"show":[217],"outperforms":[221],"Dynamat,":[222],"well-known":[224],"management":[227],"system":[228],"known":[231],"outperform":[233],"selection.":[237]},"counts_by_year":[{"year":2024,"cited_by_count":4},{"year":2020,"cited_by_count":2},{"year":2019,"cited_by_count":2},{"year":2018,"cited_by_count":1},{"year":2017,"cited_by_count":2},{"year":2016,"cited_by_count":3},{"year":2015,"cited_by_count":4},{"year":2014,"cited_by_count":4},{"year":2013,"cited_by_count":5},{"year":2012,"cited_by_count":8}],"updated_date":"2026-04-05T17:49:38.594831","created_date":"2025-10-10T00:00:00"}