{"id":"https://openalex.org/W2066536651","doi":"https://doi.org/10.1109/icdim.2013.6694037","title":"Data warehouse enhancement manipulating materialized view hierarchy","display_name":"Data warehouse enhancement manipulating materialized view hierarchy","publication_year":2013,"publication_date":"2013-09-01","ids":{"openalex":"https://openalex.org/W2066536651","doi":"https://doi.org/10.1109/icdim.2013.6694037","mag":"2066536651"},"language":"en","primary_location":{"id":"doi:10.1109/icdim.2013.6694037","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icdim.2013.6694037","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Eighth International Conference on Digital Information Management (ICDIM 2013)","raw_type":"proceedings-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/A5084278510","display_name":"Sajid Ullah Khan","orcid":"https://orcid.org/0000-0001-8561-1617"},"institutions":[{"id":"https://openalex.org/I3132053282","display_name":"City University of Science and Information Technology","ror":"https://ror.org/02jsdya97","country_code":"PK","type":"education","lineage":["https://openalex.org/I3132053282"]}],"countries":["PK"],"is_corresponding":true,"raw_author_name":"Sajid Ullah Khan","raw_affiliation_strings":["City University of Science & Information Technology, Peshawar, Pakistan","Rashid Naseem City Univ. of Sci. & Inf. Technol. Peshawar, Peshawar, Pakistan"],"affiliations":[{"raw_affiliation_string":"City University of Science & Information Technology, Peshawar, Pakistan","institution_ids":["https://openalex.org/I3132053282"]},{"raw_affiliation_string":"Rashid Naseem City Univ. of Sci. & Inf. Technol. Peshawar, Peshawar, Pakistan","institution_ids":["https://openalex.org/I3132053282"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":["https://openalex.org/A5084278510"],"corresponding_institution_ids":["https://openalex.org/I3132053282"],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":1,"citation_normalized_percentile":{"value":0.15180211,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":94},"biblio":{"volume":"26","issue":null,"first_page":"369","last_page":"372"},"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.9998999834060669,"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.9998999834060669,"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/T11719","display_name":"Data Quality and Management","score":0.9983000159263611,"subfield":{"id":"https://openalex.org/subfields/1803","display_name":"Management Science and Operations Research"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/materialized-view","display_name":"Materialized view","score":0.9773579835891724},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8085681200027466},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.7110097408294678},{"id":"https://openalex.org/keywords/hierarchy","display_name":"Hierarchy","score":0.6310315728187561},{"id":"https://openalex.org/keywords/process","display_name":"Process (computing)","score":0.5573648810386658},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.4971013367176056},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.4713539481163025},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.3112183213233948},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.10027024149894714},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.09432899951934814}],"concepts":[{"id":"https://openalex.org/C98199447","wikidata":"https://www.wikidata.org/wiki/Q2445044","display_name":"Materialized view","level":4,"score":0.9773579835891724},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8085681200027466},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.7110097408294678},{"id":"https://openalex.org/C31170391","wikidata":"https://www.wikidata.org/wiki/Q188619","display_name":"Hierarchy","level":2,"score":0.6310315728187561},{"id":"https://openalex.org/C98045186","wikidata":"https://www.wikidata.org/wiki/Q205663","display_name":"Process (computing)","level":2,"score":0.5573648810386658},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4971013367176056},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.4713539481163025},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.3112183213233948},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.10027024149894714},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.09432899951934814},{"id":"https://openalex.org/C34447519","wikidata":"https://www.wikidata.org/wiki/Q179522","display_name":"Market economy","level":1,"score":0.0},{"id":"https://openalex.org/C162324750","wikidata":"https://www.wikidata.org/wiki/Q8134","display_name":"Economics","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/icdim.2013.6694037","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icdim.2013.6694037","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Eighth International Conference on Digital Information Management (ICDIM 2013)","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":7,"referenced_works":["https://openalex.org/W1563990524","https://openalex.org/W2038176938","https://openalex.org/W2061751973","https://openalex.org/W2097989803","https://openalex.org/W2152191782","https://openalex.org/W2171492933","https://openalex.org/W2342403919"],"related_works":["https://openalex.org/W2162280381","https://openalex.org/W2185691065","https://openalex.org/W2363712075","https://openalex.org/W2383931363","https://openalex.org/W1908544460","https://openalex.org/W2142569422","https://openalex.org/W2348265434","https://openalex.org/W2087983779","https://openalex.org/W2108498730","https://openalex.org/W1635132392"],"abstract_inverted_index":{"Materialized":[0],"Views":[1],"usually":[2],"used":[3,13],"in":[4],"distributed":[5],"databases":[6],"for":[7,14],"replication":[8],"and":[9,63,125,163],"can":[10,30],"also":[11],"be":[12,32],"well-organized":[15],"delivery":[16,27],"of":[17,25,50,61,93,108,120,128,165],"data":[18,26,130],"to":[19,28,40,106,142,148],"a":[20,56,131,137],"querying":[21],"process.":[22],"The":[23,45,69],"process":[24],"queries":[29,151],"further":[31],"accelerated":[33],"if":[34],"materialized":[35,43,53,57,67,73,80,96,109,123,146,156],"views":[36,49,54,58,74,86,110,124,147],"hierarchy":[37,59],"is":[38,140],"introduced":[39],"the":[41,51,78,91,94,102,118,126,129,154],"existing":[42,52,79],"view.":[44],"newly":[46,64,70,84,121,144],"generated":[47,65,71,85,122,145],"sub":[48,66,72],"forms":[55],"consists":[60],"parents":[62],"views.":[68,81],"are":[75,87],"dependent":[76],"over":[77],"Besides,":[82],"these":[83],"automatically":[88],"created":[89],"upon":[90],"creation":[92,107],"parent":[95,155],"with":[97],"some":[98,113],"restrictions.":[99],"This":[100],"reduces":[101],"user":[103,150],"dependency":[104],"due":[105],"based":[111],"on":[112],"parameters.":[114],"These":[115],"parameters":[116],"include":[117],"number":[119],"type":[127],"view":[132,157],"contain.":[133],"In":[134],"this":[135],"paper,":[136],"stable":[138],"approach":[139],"suggested":[141],"create":[143],"answer":[149],"without":[152],"consulting":[153],"that":[158],"requires":[159],"no":[160],"complex":[161],"calculations":[162],"joining":[164],"multiple":[166],"tables.":[167]},"counts_by_year":[{"year":2024,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}