{"id":"https://openalex.org/W2162033339","doi":"https://doi.org/10.1109/iceei.2011.6021805","title":"Generic data model pattern for data warehouse","display_name":"Generic data model pattern for data warehouse","publication_year":2011,"publication_date":"2011-07-01","ids":{"openalex":"https://openalex.org/W2162033339","doi":"https://doi.org/10.1109/iceei.2011.6021805","mag":"2162033339"},"language":"en","primary_location":{"id":"doi:10.1109/iceei.2011.6021805","is_oa":false,"landing_page_url":"https://doi.org/10.1109/iceei.2011.6021805","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2011 International Conference on Electrical Engineering and Informatics","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/A5050320400","display_name":"Pocut Viqarunnisa","orcid":null},"institutions":[{"id":"https://openalex.org/I134635517","display_name":"Bandung Institute of Technology","ror":"https://ror.org/00apj8t60","country_code":"ID","type":"education","lineage":["https://openalex.org/I134635517"]}],"countries":["ID"],"is_corresponding":true,"raw_author_name":"Pocut Viqarunnisa","raw_affiliation_strings":["Data and Software Engineering Research Group (DSE-RG), Institut Teknologi Bandung (ITB), Bandung, Indonesia"],"affiliations":[{"raw_affiliation_string":"Data and Software Engineering Research Group (DSE-RG), Institut Teknologi Bandung (ITB), Bandung, Indonesia","institution_ids":["https://openalex.org/I134635517"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5062519973","display_name":"Hira Laksmiwati","orcid":null},"institutions":[{"id":"https://openalex.org/I134635517","display_name":"Bandung Institute of Technology","ror":"https://ror.org/00apj8t60","country_code":"ID","type":"education","lineage":["https://openalex.org/I134635517"]}],"countries":["ID"],"is_corresponding":false,"raw_author_name":"Hira Laksmiwati","raw_affiliation_strings":["Data and Software Engineering Research Group (DSE-RG), Institut Teknologi Bandung (ITB), Bandung, Indonesia"],"affiliations":[{"raw_affiliation_string":"Data and Software Engineering Research Group (DSE-RG), Institut Teknologi Bandung (ITB), Bandung, Indonesia","institution_ids":["https://openalex.org/I134635517"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5113848613","display_name":"Fazat Nur Azizah","orcid":null},"institutions":[{"id":"https://openalex.org/I134635517","display_name":"Bandung Institute of Technology","ror":"https://ror.org/00apj8t60","country_code":"ID","type":"education","lineage":["https://openalex.org/I134635517"]}],"countries":["ID"],"is_corresponding":false,"raw_author_name":"Fazat Nur Azizah","raw_affiliation_strings":["Data and Software Engineering Research Group (DSE-RG), Institut Teknologi Bandung (ITB), Bandung, Indonesia"],"affiliations":[{"raw_affiliation_string":"Data and Software Engineering Research Group (DSE-RG), Institut Teknologi Bandung (ITB), Bandung, Indonesia","institution_ids":["https://openalex.org/I134635517"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5050320400"],"corresponding_institution_ids":["https://openalex.org/I134635517"],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":4,"citation_normalized_percentile":{"value":0.20905282,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":95},"biblio":{"volume":null,"issue":null,"first_page":"1","last_page":"8"},"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.9987000226974487,"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.9987000226974487,"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/T12490","display_name":"Software Engineering and Design Patterns","score":0.9944000244140625,"subfield":{"id":"https://openalex.org/subfields/3303","display_name":"Development"},"field":{"id":"https://openalex.org/fields/33","display_name":"Social Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T10538","display_name":"Data Mining Algorithms and Applications","score":0.9858999848365784,"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/data-warehouse","display_name":"Data warehouse","score":0.8488413095474243},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7581818699836731},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.5926330089569092},{"id":"https://openalex.org/keywords/reusability","display_name":"Reusability","score":0.5568225383758545},{"id":"https://openalex.org/keywords/correctness","display_name":"Correctness","score":0.5538771748542786},{"id":"https://openalex.org/keywords/flexibility","display_name":"Flexibility (engineering)","score":0.5044840574264526},{"id":"https://openalex.org/keywords/data-quality","display_name":"Data quality","score":0.48305898904800415},{"id":"https://openalex.org/keywords/dimensional-modeling","display_name":"Dimensional modeling","score":0.48198384046554565},{"id":"https://openalex.org/keywords/dimension","display_name":"Dimension (graph theory)","score":0.48005375266075134},{"id":"https://openalex.org/keywords/data-model","display_name":"Data model (GIS)","score":0.4325202703475952},{"id":"https://openalex.org/keywords/data-modeling","display_name":"Data modeling","score":0.428524374961853},{"id":"https://openalex.org/keywords/data-transformation","display_name":"Data transformation","score":0.42467549443244934},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.36704516410827637},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.1514979600906372},{"id":"https://openalex.org/keywords/statistics","display_name":"Statistics","score":0.14227458834648132},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.12214148044586182},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.1196742057800293},{"id":"https://openalex.org/keywords/metric","display_name":"Metric (unit)","score":0.11321619153022766},{"id":"https://openalex.org/keywords/software","display_name":"Software","score":0.10167565941810608},{"id":"https://openalex.org/keywords/engineering","display_name":"Engineering","score":0.091072678565979},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.08262118697166443}],"concepts":[{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.8488413095474243},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7581818699836731},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.5926330089569092},{"id":"https://openalex.org/C137981799","wikidata":"https://www.wikidata.org/wiki/Q1369184","display_name":"Reusability","level":3,"score":0.5568225383758545},{"id":"https://openalex.org/C55439883","wikidata":"https://www.wikidata.org/wiki/Q360812","display_name":"Correctness","level":2,"score":0.5538771748542786},{"id":"https://openalex.org/C2780598303","wikidata":"https://www.wikidata.org/wiki/Q65921492","display_name":"Flexibility (engineering)","level":2,"score":0.5044840574264526},{"id":"https://openalex.org/C24756922","wikidata":"https://www.wikidata.org/wiki/Q1757694","display_name":"Data quality","level":3,"score":0.48305898904800415},{"id":"https://openalex.org/C143008350","wikidata":"https://www.wikidata.org/wiki/Q3432172","display_name":"Dimensional modeling","level":2,"score":0.48198384046554565},{"id":"https://openalex.org/C33676613","wikidata":"https://www.wikidata.org/wiki/Q13415176","display_name":"Dimension (graph theory)","level":2,"score":0.48005375266075134},{"id":"https://openalex.org/C100463513","wikidata":"https://www.wikidata.org/wiki/Q5227322","display_name":"Data model (GIS)","level":2,"score":0.4325202703475952},{"id":"https://openalex.org/C67186912","wikidata":"https://www.wikidata.org/wiki/Q367664","display_name":"Data modeling","level":2,"score":0.428524374961853},{"id":"https://openalex.org/C150670458","wikidata":"https://www.wikidata.org/wiki/Q4272815","display_name":"Data transformation","level":3,"score":0.42467549443244934},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.36704516410827637},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.1514979600906372},{"id":"https://openalex.org/C105795698","wikidata":"https://www.wikidata.org/wiki/Q12483","display_name":"Statistics","level":1,"score":0.14227458834648132},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.12214148044586182},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.1196742057800293},{"id":"https://openalex.org/C176217482","wikidata":"https://www.wikidata.org/wiki/Q860554","display_name":"Metric (unit)","level":2,"score":0.11321619153022766},{"id":"https://openalex.org/C2777904410","wikidata":"https://www.wikidata.org/wiki/Q7397","display_name":"Software","level":2,"score":0.10167565941810608},{"id":"https://openalex.org/C127413603","wikidata":"https://www.wikidata.org/wiki/Q11023","display_name":"Engineering","level":0,"score":0.091072678565979},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.08262118697166443},{"id":"https://openalex.org/C21547014","wikidata":"https://www.wikidata.org/wiki/Q1423657","display_name":"Operations management","level":1,"score":0.0},{"id":"https://openalex.org/C202444582","wikidata":"https://www.wikidata.org/wiki/Q837863","display_name":"Pure mathematics","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/iceei.2011.6021805","is_oa":false,"landing_page_url":"https://doi.org/10.1109/iceei.2011.6021805","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2011 International Conference on Electrical Engineering and Informatics","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/16","score":0.7599999904632568,"display_name":"Peace, Justice and strong institutions"}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":7,"referenced_works":["https://openalex.org/W58180796","https://openalex.org/W1523197392","https://openalex.org/W1649645444","https://openalex.org/W2074442900","https://openalex.org/W2157475693","https://openalex.org/W2558913672","https://openalex.org/W4240446084"],"related_works":["https://openalex.org/W2369215403","https://openalex.org/W1810998667","https://openalex.org/W2585252724","https://openalex.org/W2003588249","https://openalex.org/W2384973249","https://openalex.org/W2473783532","https://openalex.org/W4211040133","https://openalex.org/W2364425891","https://openalex.org/W2361366861","https://openalex.org/W2181836431"],"abstract_inverted_index":{"Useful":[0],"decision-making":[1],"information":[2,58],"can":[3,93],"be":[4,94],"proceed":[5],"through":[6],"a":[7,34,72,90],"subject-oriented":[8],"data":[9,29,36,43,47,64,74,87,105],"warehouse":[10,30,91],"in":[11,45,164,183],"which":[12,92,177],"it":[13],"will":[14],"store":[15],"an":[16,57],"integrated,":[17],"time-variant,":[18],"and":[19,54,96,110,132,187,213],"non":[20],"volatile":[21],"collected":[22],"data.":[23],"The":[24,138,161],"key":[25],"to":[26,32,70,130,136],"find":[27],"such":[28],"is":[31,66,76],"have":[33],"good":[35,73],"model":[37,65,75,88],"that":[38,146,175,199],"defines":[39],"the":[40,46,50,63,116,121,142,147,154,181],"structure":[41],"of":[42,52,56,85,89,104,118,120],"kept":[44],"warehouse.":[48],"Actually":[49],"quality":[51],"correctness":[53],"completeness":[55],"depends":[59],"on":[60,102,141],"how":[61],"well":[62],"constructed.":[67],"One":[68],"way":[69],"get":[71],"by":[77],"utilizing":[78],"patterns.":[79],"This":[80],"research":[81],"derived":[82],"eighteen":[83],"patterns":[84,122,162,176,198,204],"generic":[86,210],"used":[95,201],"chosen.":[97],"They":[98],"are":[99,125,151,158,178,191,200,203],"created":[100],"based":[101],"analysis":[103],"warehousing":[106],"needs,":[107],"existing":[108],"patterns,":[109],"Kimball's":[111],"case":[112,171],"studies.":[113,172],"To":[114],"measure":[115],"level":[117],"reusability":[119,144],"four":[123],"metrics":[124,128,134,149,156],"defined.":[126],"Two":[127],"related":[129,135,205],"flexibility":[131,148],"two":[133,170],"comprehensibility.":[137],"test":[139,167],"result":[140],"pattern":[143,212],"shows":[145],"score":[150,157],"adequate,":[152],"while":[153],"comprehensibility":[155],"almost":[159,194],"perfect.":[160],"occur":[163],"different":[165],"frequencies":[166],"has":[168],"involving":[169],"It":[173],"concluded":[174],"associated":[179],"with":[180,206],"changes":[182],"dimensions,":[184],"product":[185],"heterogeneity":[186],"multi":[188],"valued":[189],"attributes":[190],"seldom":[192],"or":[193],"never":[195],"used.":[196],"Further":[197],"frequently":[202],"dimension":[207,211],"tables,":[208],"especially":[209],"date":[214],"pattern.":[215]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2024,"cited_by_count":1},{"year":2020,"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"}