{"id":"https://openalex.org/W2020010531","doi":"https://doi.org/10.2498/cit.1002046","title":"An ETL Metadata Model for Data Warehousing","display_name":"An ETL Metadata Model for Data Warehousing","publication_year":2012,"publication_date":"2012-01-01","ids":{"openalex":"https://openalex.org/W2020010531","doi":"https://doi.org/10.2498/cit.1002046","mag":"2020010531"},"language":"en","primary_location":{"id":"doi:10.2498/cit.1002046","is_oa":true,"landing_page_url":"https://doi.org/10.2498/cit.1002046","pdf_url":"http://cit.fer.hr/index.php/CIT/article/download/2046/1532","source":{"id":"https://openalex.org/S98565333","display_name":"Journal of Computing and Information Technology","issn_l":"1330-1136","issn":["1330-1136","1846-3908"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310314807","host_organization_name":"Faculty of Electrical Engineering and Computing, University of Zagreb","host_organization_lineage":["https://openalex.org/P4310314807"],"host_organization_lineage_names":["Faculty of Electrical Engineering and Computing, University of Zagreb"],"type":"journal"},"license":"cc-by-nd","license_id":"https://openalex.org/licenses/cc-by-nd","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of Computing and Information Technology","raw_type":"journal-article"},"type":"article","indexed_in":["crossref","doaj"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"http://cit.fer.hr/index.php/CIT/article/download/2046/1532","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5108100245","display_name":"Nayem Rahman","orcid":null},"institutions":[{"id":"https://openalex.org/I4210158342","display_name":"Intel (United Kingdom)","ror":"https://ror.org/058cxws58","country_code":"GB","type":"company","lineage":["https://openalex.org/I1343180700","https://openalex.org/I4210158342"]}],"countries":["GB"],"is_corresponding":true,"raw_author_name":"Nayem Rahman","raw_affiliation_strings":["Intel Corporation"],"affiliations":[{"raw_affiliation_string":"Intel Corporation","institution_ids":["https://openalex.org/I4210158342"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5071099771","display_name":"Jessica Marz","orcid":null},"institutions":[{"id":"https://openalex.org/I1343180700","display_name":"Intel (United States)","ror":"https://ror.org/01ek73717","country_code":"US","type":"company","lineage":["https://openalex.org/I1343180700"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Jessica Marz","raw_affiliation_strings":["Intel Corporation, USA","Intel Corp., USA#TAB#"],"affiliations":[{"raw_affiliation_string":"Intel Corporation, USA","institution_ids":["https://openalex.org/I1343180700"]},{"raw_affiliation_string":"Intel Corp., USA#TAB#","institution_ids":["https://openalex.org/I1343180700"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5003899908","display_name":"Shameem Akhter","orcid":null},"institutions":[{"id":"https://openalex.org/I95781656","display_name":"Western Oregon University","ror":"https://ror.org/002xn4752","country_code":"US","type":"education","lineage":["https://openalex.org/I95781656"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Shameem Akhter","raw_affiliation_strings":["Western Oregon University, USA","Western Oregon University, USA,"],"affiliations":[{"raw_affiliation_string":"Western Oregon University, USA","institution_ids":["https://openalex.org/I95781656"]},{"raw_affiliation_string":"Western Oregon University, USA,","institution_ids":["https://openalex.org/I95781656"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5108100245"],"corresponding_institution_ids":["https://openalex.org/I4210158342"],"apc_list":{"value":450,"currency":"EUR","value_usd":485},"apc_paid":{"value":450,"currency":"EUR","value_usd":485},"fwci":3.7253,"has_fulltext":true,"cited_by_count":24,"citation_normalized_percentile":{"value":0.93405915,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":89,"max":97},"biblio":{"volume":"20","issue":"2","first_page":null,"last_page":null},"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.9997000098228455,"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.9997000098228455,"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.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"}},{"id":"https://openalex.org/T11719","display_name":"Data Quality and Management","score":0.9951000213623047,"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/metadata","display_name":"Metadata","score":0.9477359056472778},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8548194169998169},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.7999424934387207},{"id":"https://openalex.org/keywords/metadata-repository","display_name":"Metadata repository","score":0.6923887729644775},{"id":"https://openalex.org/keywords/meta-data-services","display_name":"Meta Data Services","score":0.690069317817688},{"id":"https://openalex.org/keywords/metadata-modeling","display_name":"Metadata modeling","score":0.6454495191574097},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.628241240978241},{"id":"https://openalex.org/keywords/data-element","display_name":"Data element","score":0.5751494765281677},{"id":"https://openalex.org/keywords/metadata-management","display_name":"Metadata management","score":0.5696883201599121},{"id":"https://openalex.org/keywords/timestamp","display_name":"Timestamp","score":0.5402623414993286},{"id":"https://openalex.org/keywords/data-quality","display_name":"Data quality","score":0.41116952896118164},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.29234743118286133},{"id":"https://openalex.org/keywords/service","display_name":"Service (business)","score":0.07082012295722961}],"concepts":[{"id":"https://openalex.org/C93518851","wikidata":"https://www.wikidata.org/wiki/Q180160","display_name":"Metadata","level":2,"score":0.9477359056472778},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8548194169998169},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.7999424934387207},{"id":"https://openalex.org/C153048206","wikidata":"https://www.wikidata.org/wiki/Q3454922","display_name":"Metadata repository","level":3,"score":0.6923887729644775},{"id":"https://openalex.org/C136976847","wikidata":"https://www.wikidata.org/wiki/Q6822297","display_name":"Meta Data Services","level":4,"score":0.690069317817688},{"id":"https://openalex.org/C110326360","wikidata":"https://www.wikidata.org/wiki/Q17149476","display_name":"Metadata modeling","level":4,"score":0.6454495191574097},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.628241240978241},{"id":"https://openalex.org/C30872290","wikidata":"https://www.wikidata.org/wiki/Q1172389","display_name":"Data element","level":3,"score":0.5751494765281677},{"id":"https://openalex.org/C2779489174","wikidata":"https://www.wikidata.org/wiki/Q6822246","display_name":"Metadata management","level":3,"score":0.5696883201599121},{"id":"https://openalex.org/C113954288","wikidata":"https://www.wikidata.org/wiki/Q186885","display_name":"Timestamp","level":2,"score":0.5402623414993286},{"id":"https://openalex.org/C24756922","wikidata":"https://www.wikidata.org/wiki/Q1757694","display_name":"Data quality","level":3,"score":0.41116952896118164},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.29234743118286133},{"id":"https://openalex.org/C2780378061","wikidata":"https://www.wikidata.org/wiki/Q25351891","display_name":"Service (business)","level":2,"score":0.07082012295722961},{"id":"https://openalex.org/C136264566","wikidata":"https://www.wikidata.org/wiki/Q159810","display_name":"Economy","level":1,"score":0.0},{"id":"https://openalex.org/C38652104","wikidata":"https://www.wikidata.org/wiki/Q3510521","display_name":"Computer security","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":2,"locations":[{"id":"doi:10.2498/cit.1002046","is_oa":true,"landing_page_url":"https://doi.org/10.2498/cit.1002046","pdf_url":"http://cit.fer.hr/index.php/CIT/article/download/2046/1532","source":{"id":"https://openalex.org/S98565333","display_name":"Journal of Computing and Information Technology","issn_l":"1330-1136","issn":["1330-1136","1846-3908"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310314807","host_organization_name":"Faculty of Electrical Engineering and Computing, University of Zagreb","host_organization_lineage":["https://openalex.org/P4310314807"],"host_organization_lineage_names":["Faculty of Electrical Engineering and Computing, University of Zagreb"],"type":"journal"},"license":"cc-by-nd","license_id":"https://openalex.org/licenses/cc-by-nd","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of Computing and Information Technology","raw_type":"journal-article"},{"id":"pmh:oai:hrcak.srce.hr:85081","is_oa":true,"landing_page_url":"http://hrcak.srce.hr/85081","pdf_url":null,"source":{"id":"https://openalex.org/S4306400071","display_name":"University of Zagreb University Computing Centre (SRCE)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I181343428","host_organization_name":"University of Zagreb","host_organization_lineage":["https://openalex.org/I181343428"],"host_organization_lineage_names":[],"type":"repository"},"license":"other-oa","license_id":"https://openalex.org/licenses/other-oa","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Journal of computing and information technology","raw_type":"text"}],"best_oa_location":{"id":"doi:10.2498/cit.1002046","is_oa":true,"landing_page_url":"https://doi.org/10.2498/cit.1002046","pdf_url":"http://cit.fer.hr/index.php/CIT/article/download/2046/1532","source":{"id":"https://openalex.org/S98565333","display_name":"Journal of Computing and Information Technology","issn_l":"1330-1136","issn":["1330-1136","1846-3908"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310314807","host_organization_name":"Faculty of Electrical Engineering and Computing, University of Zagreb","host_organization_lineage":["https://openalex.org/P4310314807"],"host_organization_lineage_names":["Faculty of Electrical Engineering and Computing, University of Zagreb"],"type":"journal"},"license":"cc-by-nd","license_id":"https://openalex.org/licenses/cc-by-nd","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of Computing and Information Technology","raw_type":"journal-article"},"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":true,"grobid_xml":true},"content_urls":{"pdf":"https://content.openalex.org/works/W2020010531.pdf","grobid_xml":"https://content.openalex.org/works/W2020010531.grobid-xml"},"referenced_works_count":49,"referenced_works":["https://openalex.org/W84515857","https://openalex.org/W188779069","https://openalex.org/W332208005","https://openalex.org/W606199560","https://openalex.org/W1502921605","https://openalex.org/W1801132961","https://openalex.org/W1970205746","https://openalex.org/W1981031417","https://openalex.org/W1983385867","https://openalex.org/W1989762853","https://openalex.org/W1990429972","https://openalex.org/W1990694685","https://openalex.org/W1995999642","https://openalex.org/W2006761638","https://openalex.org/W2008120802","https://openalex.org/W2021184893","https://openalex.org/W2023284394","https://openalex.org/W2025296527","https://openalex.org/W2053287658","https://openalex.org/W2065661212","https://openalex.org/W2071058905","https://openalex.org/W2072764742","https://openalex.org/W2073824505","https://openalex.org/W2106105778","https://openalex.org/W2108971776","https://openalex.org/W2113448659","https://openalex.org/W2115708987","https://openalex.org/W2119565958","https://openalex.org/W2133569817","https://openalex.org/W2143180374","https://openalex.org/W2143759802","https://openalex.org/W2148003754","https://openalex.org/W2149877754","https://openalex.org/W2153164398","https://openalex.org/W2158447492","https://openalex.org/W2164086463","https://openalex.org/W2914420586","https://openalex.org/W2934882144","https://openalex.org/W3025278216","https://openalex.org/W4241498663","https://openalex.org/W4247387026","https://openalex.org/W4248563344","https://openalex.org/W4300564821","https://openalex.org/W6646151245","https://openalex.org/W6647982551","https://openalex.org/W6649511929","https://openalex.org/W6655559027","https://openalex.org/W6681436898","https://openalex.org/W6681918522"],"related_works":["https://openalex.org/W3084772717","https://openalex.org/W2907247951","https://openalex.org/W2374379029","https://openalex.org/W2380261968","https://openalex.org/W2376038160","https://openalex.org/W3199469221","https://openalex.org/W1512114296","https://openalex.org/W2018424284","https://openalex.org/W2389784781","https://openalex.org/W2537325806"],"abstract_inverted_index":{"Metadata":[0],"is":[1,31],"essential":[2],"for":[3,75,121],"understanding":[4],"information":[5],"stored":[6],"in":[7],"data":[8,19,21,38,53,58,77],"warehouses.":[9],"It":[10],"helps":[11],"increase":[12],"levels":[13],"of":[14,18,36,42,69,95,108],"adoption":[15,68],"and":[16,25,88,92,112],"usage":[17],"warehouse":[20,59,78],"by":[22],"knowledge":[23],"workers":[24],"decision":[26],"makers.":[27],"A":[28,55],"metadata":[29,44,73,101],"model":[30,45,74,102],"important":[32],"to":[33,48],"the":[34,40,52,76,122],"implementation":[35,60],"a":[37,43,106,114],"warehouse,":[39],"lack":[41],"can":[46],"lead":[47],"quality":[49],"concerns":[50],"about":[51],"warehouse.":[54],"highly":[56],"successful":[57],"depends":[61],"on":[62],"consistent":[63],"metadata.":[64],"This":[65],"article":[66],"proposes":[67],"an":[70],"ETL":[71,100,109],"(extracttransform-load)":[72],"that":[79],"makes":[80],"subject":[81],"area":[82],"refreshes":[83],"metadata-driven,":[84],"loads":[85],"observation":[86],"timestamps":[87],"other":[89],"useful":[90],"parameters,":[91],"minimizes":[93],"consumption":[94],"database":[96],"systems":[97],"resources.":[98],"The":[99],"provides":[103],"developers":[104],"with":[105],"set":[107],"development":[110],"tools":[111],"delivers":[113],"user-friendly":[115],"batch":[116],"cycle":[117],"refresh":[118],"monitoring":[119],"tool":[120],"production":[123],"support":[124],"team.":[125]},"counts_by_year":[{"year":2024,"cited_by_count":3},{"year":2023,"cited_by_count":1},{"year":2022,"cited_by_count":1},{"year":2021,"cited_by_count":1},{"year":2019,"cited_by_count":1},{"year":2018,"cited_by_count":3},{"year":2017,"cited_by_count":1},{"year":2016,"cited_by_count":3},{"year":2015,"cited_by_count":3},{"year":2014,"cited_by_count":3},{"year":2013,"cited_by_count":3},{"year":2012,"cited_by_count":1}],"updated_date":"2026-04-05T17:49:38.594831","created_date":"2025-10-10T00:00:00"}