{"id":"https://openalex.org/W1550106653","doi":"https://doi.org/10.1109/mipro.2015.7160496","title":"Delta view generation for incremental loading of large dimensions in a data warehouse","display_name":"Delta view generation for incremental loading of large dimensions in a data warehouse","publication_year":2015,"publication_date":"2015-05-01","ids":{"openalex":"https://openalex.org/W1550106653","doi":"https://doi.org/10.1109/mipro.2015.7160496","mag":"1550106653"},"language":"en","primary_location":{"id":"doi:10.1109/mipro.2015.7160496","is_oa":false,"landing_page_url":"https://doi.org/10.1109/mipro.2015.7160496","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2015 38th International Convention on Information and Communication Technology, Electronics and Microelectronics (MIPRO)","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/A5067736091","display_name":"Igor Mekterovi\u0107","orcid":"https://orcid.org/0000-0002-9813-1935"},"institutions":[{"id":"https://openalex.org/I181343428","display_name":"University of Zagreb","ror":"https://ror.org/00mv6sv71","country_code":"HR","type":"education","lineage":["https://openalex.org/I181343428"]}],"countries":["HR"],"is_corresponding":true,"raw_author_name":"Igor Mekterovic","raw_affiliation_strings":["Faculty of Electrical Engineering and Computing, University of Zagreb, Zagreb, Croatia","University of Zagreb, Faculty of Electrical Engineering and Computing, Croatia#TAB#"],"affiliations":[{"raw_affiliation_string":"Faculty of Electrical Engineering and Computing, University of Zagreb, Zagreb, Croatia","institution_ids":["https://openalex.org/I181343428"]},{"raw_affiliation_string":"University of Zagreb, Faculty of Electrical Engineering and Computing, Croatia#TAB#","institution_ids":["https://openalex.org/I181343428"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5051434230","display_name":"Ljiljana Brki\u0107","orcid":"https://orcid.org/0000-0002-6345-8735"},"institutions":[{"id":"https://openalex.org/I181343428","display_name":"University of Zagreb","ror":"https://ror.org/00mv6sv71","country_code":"HR","type":"education","lineage":["https://openalex.org/I181343428"]}],"countries":["HR"],"is_corresponding":false,"raw_author_name":"Ljiljana Brkic","raw_affiliation_strings":["Faculty of Electrical Engineering and Computing, University of Zagreb, Zagreb, Croatia","University of Zagreb, Faculty of Electrical Engineering and Computing, Croatia#TAB#"],"affiliations":[{"raw_affiliation_string":"Faculty of Electrical Engineering and Computing, University of Zagreb, Zagreb, Croatia","institution_ids":["https://openalex.org/I181343428"]},{"raw_affiliation_string":"University of Zagreb, Faculty of Electrical Engineering and Computing, Croatia#TAB#","institution_ids":["https://openalex.org/I181343428"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5067736091"],"corresponding_institution_ids":["https://openalex.org/I181343428"],"apc_list":null,"apc_paid":null,"fwci":0.6656,"has_fulltext":false,"cited_by_count":5,"citation_normalized_percentile":{"value":0.72459256,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":96},"biblio":{"volume":"3","issue":null,"first_page":"1417","last_page":"1422"},"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/T10538","display_name":"Data Mining Algorithms and Applications","score":0.9983000159263611,"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"}},{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9976999759674072,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/table","display_name":"Table (database)","score":0.7478692531585693},{"id":"https://openalex.org/keywords/dimension","display_name":"Dimension (graph theory)","score":0.7397075295448303},{"id":"https://openalex.org/keywords/cardinality","display_name":"Cardinality (data modeling)","score":0.6679426431655884},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.6664323210716248},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.6066750288009644},{"id":"https://openalex.org/keywords/set","display_name":"Set (abstract data type)","score":0.537975013256073},{"id":"https://openalex.org/keywords/process","display_name":"Process (computing)","score":0.5237779021263123},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.3627813756465912},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.32643184065818787},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.21728724241256714},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.1243453323841095},{"id":"https://openalex.org/keywords/combinatorics","display_name":"Combinatorics","score":0.09803131222724915}],"concepts":[{"id":"https://openalex.org/C45235069","wikidata":"https://www.wikidata.org/wiki/Q278425","display_name":"Table (database)","level":2,"score":0.7478692531585693},{"id":"https://openalex.org/C33676613","wikidata":"https://www.wikidata.org/wiki/Q13415176","display_name":"Dimension (graph theory)","level":2,"score":0.7397075295448303},{"id":"https://openalex.org/C87117476","wikidata":"https://www.wikidata.org/wiki/Q362383","display_name":"Cardinality (data modeling)","level":2,"score":0.6679426431655884},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6664323210716248},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.6066750288009644},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.537975013256073},{"id":"https://openalex.org/C98045186","wikidata":"https://www.wikidata.org/wiki/Q205663","display_name":"Process (computing)","level":2,"score":0.5237779021263123},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.3627813756465912},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.32643184065818787},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.21728724241256714},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.1243453323841095},{"id":"https://openalex.org/C114614502","wikidata":"https://www.wikidata.org/wiki/Q76592","display_name":"Combinatorics","level":1,"score":0.09803131222724915}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/mipro.2015.7160496","is_oa":false,"landing_page_url":"https://doi.org/10.1109/mipro.2015.7160496","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2015 38th International Convention on Information and Communication Technology, Electronics and Microelectronics (MIPRO)","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"display_name":"Industry, innovation and infrastructure","id":"https://metadata.un.org/sdg/9","score":0.41999998688697815}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":12,"referenced_works":["https://openalex.org/W1893018","https://openalex.org/W105408422","https://openalex.org/W1600445262","https://openalex.org/W1762755661","https://openalex.org/W2035813616","https://openalex.org/W2074713486","https://openalex.org/W2113450657","https://openalex.org/W2113941456","https://openalex.org/W2141739881","https://openalex.org/W2143180374","https://openalex.org/W2342403919","https://openalex.org/W2401332709"],"related_works":["https://openalex.org/W2002177687","https://openalex.org/W2058438338","https://openalex.org/W2019471580","https://openalex.org/W2941284322","https://openalex.org/W4224920876","https://openalex.org/W2168299207","https://openalex.org/W2373884155","https://openalex.org/W4200307027","https://openalex.org/W2585354854","https://openalex.org/W2026059297"],"abstract_inverted_index":{"Incremental":[0],"load":[1,127],"is":[2,112],"the":[3,13,17,32,60,117,125,149,194],"preferred":[4],"approach":[5,181],"in":[6,26,43,130,182,193],"efficient":[7],"ETL":[8,61],"processes.":[9],"Fact":[10],"tables":[11,37,103,137,163],"are":[12,24,38,104],"ones":[14],"who":[15],"benefit":[16],"most":[18],"from":[19],"this":[20,142,180],"approach,":[21],"since":[22],"they":[23,72],"large":[25],"terms":[27],"of":[28,34,134,168,197],"row":[29,93],"count.":[30],"For":[31],"sake":[33],"simplicity,":[35],"dimension":[36,91,102,158],"often":[39],"ignored":[40],"and":[41,63,110,132,164,187],"populated":[42],"a":[44,56,78,157,166,183,190],"full":[45],"reload":[46],"manner.":[47],"However,":[48],"big":[49,198],"dimensions":[50],"(e.g.":[51,170],"Client)":[52],"can":[53],"also":[54,65],"have":[55,73,178,188],"significant":[57,191],"impact":[58],"on":[59,106],"process":[62],"should":[64,121,173],"be":[66,122,139,174],"considered":[67,123],"for":[68,124,148,156],"incremental":[69,126],"load.":[70],"Although":[71],"much":[74,85],"smaller":[75],"cardinality":[76],"than":[77,94],"typical":[79],"fact":[80,98],"table,":[81],"it":[82,111],"usually":[83],"takes":[84],"more":[86],"resources":[87],"to":[88,95,115],"calculate":[89,96],"one":[90,97],"table":[92,99],"row.":[100],"Large":[101],"based":[105],"multiple":[107],"source":[108,136,162],"tables,":[109],"not":[113],"trivial":[114],"determine":[116],"changed":[118],"records":[119],"that":[120,172],"because":[128],"changes":[129],"any":[131],"all":[133,160],"underlying":[135],"must":[138],"considered.":[140],"In":[141],"paper,":[143],"we":[144],"present":[145],"an":[146],"algorithm":[147],"dimension's":[150],"delta":[151],"view":[152,155],"generation.":[153],"Delta":[154],"encompasses":[159],"its":[161],"produces":[165],"set":[167],"keys":[169],"ClientIds)":[171],"incrementally":[175],"processed.":[176],"We":[177],"employed":[179],"real":[184],"world":[185],"project":[186],"noticed":[189],"reduction":[192],"loading":[195],"time":[196],"dimensions.":[199]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2020,"cited_by_count":2},{"year":2018,"cited_by_count":1},{"year":2017,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}