{"id":"https://openalex.org/W1503556420","doi":"https://doi.org/10.1109/isitia.2015.7220004","title":"Problems and available solutions on the stage of Extract, Transform, and Loading in near real-time data warehousing (a literature study)","display_name":"Problems and available solutions on the stage of Extract, Transform, and Loading in near real-time data warehousing (a literature study)","publication_year":2015,"publication_date":"2015-05-01","ids":{"openalex":"https://openalex.org/W1503556420","doi":"https://doi.org/10.1109/isitia.2015.7220004","mag":"1503556420"},"language":"en","primary_location":{"id":"doi:10.1109/isitia.2015.7220004","doi":"https://doi.org/10.1109/isitia.2015.7220004","is_oa":false,"landing_page_url":"https://doi.org/10.1109/isitia.2015.7220004","pdf_url":null,"source":{"id":"https://openalex.org/S4306420061","display_name":"International Seminar on Intelligent Technology and Its Applications","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"conference"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2015 International Seminar on Intelligent Technology and Its Applications (ISITIA)","raw_type":"proceedings-article"},"volume":null,"type":"conference-paper","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/A5031169667","display_name":"Ardianto Wibowo","orcid":"https://orcid.org/0000-0002-0257-7239","observed_orcids":["https://orcid.org/0000-0002-0257-7239"]},"institutions":[{"id":"https://openalex.org/I4387153208","display_name":"Caltex Riau Polytechnic","ror":"https://ror.org/00dr09x15","country_code":"ID","type":"education","lineage":["https://openalex.org/I4387153208"]}],"countries":["ID"],"is_corresponding":true,"raw_author_name":"Ardianto Wibowo","raw_affiliation_strings":["Department of Informatics Engineering, Politeknik Caltex Riau, Pekanbaru, Indonesia"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Department of Informatics Engineering, Politeknik Caltex Riau, Pekanbaru, Indonesia","institution_ids":["https://openalex.org/I4387153208"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":["https://openalex.org/A5031169667"],"corresponding_institution_ids":["https://openalex.org/I4387153208"],"apc_list":null,"apc_paid":null,"fwci":2.8261,"has_fulltext":false,"cited_by_count":27,"citation_normalized_percentile":{"value":0.88421053,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":98},"biblio":{"volume":null,"issue":null,"first_page":"345","last_page":"350"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11891","display_name":"Big Data and Business Intelligence","score":0.8910999894142151,"subfield":{"id":"https://openalex.org/subfields/1404","display_name":"Management Information Systems"},"field":{"id":"https://openalex.org/fields/14","display_name":"Business, Management and Accounting"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},"topics":[{"id":"https://openalex.org/T11891","display_name":"Big Data and Business Intelligence","score":0.8910999894142151,"subfield":{"id":"https://openalex.org/subfields/1404","display_name":"Management Information Systems"},"field":{"id":"https://openalex.org/fields/14","display_name":"Business, Management and Accounting"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.09220000356435776,"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/T11719","display_name":"Data Quality and Management","score":0.006899999920278788,"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/etl","display_name":"ETL","score":0.7429999709129333},{"id":"https://openalex.org/keywords/data-latency","display_name":"data latency","score":0.7979999780654907},{"id":"https://openalex.org/keywords/data-extraction","display_name":"data extraction","score":0.7950000166893005},{"id":"https://openalex.org/keywords/data-transformation","display_name":"data transformation","score":0.9990000128746033},{"id":"https://openalex.org/keywords/data-loading","display_name":"data loading","score":0.9950000047683716},{"id":"https://openalex.org/keywords/change-data-capture","display_name":"change data capture","score":0.6940000057220459},{"id":"https://openalex.org/keywords/data-freshness","display_name":"data freshness","score":0.8209999799728394}],"concepts":[{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.9180264472961426},{"id":"https://openalex.org/C2777466982","wikidata":"https://www.wikidata.org/wiki/Q5227287","display_name":"Data extraction","level":3,"score":0.7453237771987915},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7349866032600403},{"id":"https://openalex.org/C82876162","wikidata":"https://www.wikidata.org/wiki/Q17096504","display_name":"Latency (audio)","level":2,"score":0.6055690050125122},{"id":"https://openalex.org/C150670458","wikidata":"https://www.wikidata.org/wiki/Q4272815","display_name":"Data transformation","level":3,"score":0.5508397817611694},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5500662326812744},{"id":"https://openalex.org/C75949130","wikidata":"https://www.wikidata.org/wiki/Q848010","display_name":"Database transaction","level":2,"score":0.5298970341682434},{"id":"https://openalex.org/C143008350","wikidata":"https://www.wikidata.org/wiki/Q3432172","display_name":"Dimensional modeling","level":2,"score":0.4730742871761322},{"id":"https://openalex.org/C2983685735","wikidata":"https://www.wikidata.org/wiki/Q5227355","display_name":"Data source","level":2,"score":0.4610092043876648},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.4482370913028717},{"id":"https://openalex.org/C127722929","wikidata":"https://www.wikidata.org/wiki/Q7833714","display_name":"Transaction data","level":3,"score":0.4261210262775421},{"id":"https://openalex.org/C110593043","wikidata":"https://www.wikidata.org/wiki/Q7300787","display_name":"Real-time data","level":2,"score":0.42523157596588135},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.09442523121833801},{"id":"https://openalex.org/C199539241","wikidata":"https://www.wikidata.org/wiki/Q7748","display_name":"Law","level":1,"score":0.0},{"id":"https://openalex.org/C76155785","wikidata":"https://www.wikidata.org/wiki/Q418","display_name":"Telecommunications","level":1,"score":0.0},{"id":"https://openalex.org/C17744445","wikidata":"https://www.wikidata.org/wiki/Q36442","display_name":"Political science","level":0,"score":0.0},{"id":"https://openalex.org/C2779473830","wikidata":"https://www.wikidata.org/wiki/Q1540899","display_name":"MEDLINE","level":2,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/isitia.2015.7220004","doi":"https://doi.org/10.1109/isitia.2015.7220004","is_oa":false,"landing_page_url":"https://doi.org/10.1109/isitia.2015.7220004","pdf_url":null,"source":{"id":"https://openalex.org/S4306420061","display_name":"International Seminar on Intelligent Technology and Its Applications","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"conference"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2015 International Seminar on Intelligent Technology and Its Applications (ISITIA)","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":12,"referenced_works":["https://openalex.org/W94964754","https://openalex.org/W1530514511","https://openalex.org/W1535597772","https://openalex.org/W2001474264","https://openalex.org/W2002834828","https://openalex.org/W2006761638","https://openalex.org/W2035813616","https://openalex.org/W2129134929","https://openalex.org/W2147097061","https://openalex.org/W2158560981","https://openalex.org/W2184642537","https://openalex.org/W4237421257"],"related_works":["https://openalex.org/W4241319250","https://openalex.org/W197630086","https://openalex.org/W1546663134","https://openalex.org/W2781592841","https://openalex.org/W2147097061","https://openalex.org/W2743179735","https://openalex.org/W3040144332","https://openalex.org/W4390577616","https://openalex.org/W2890864835","https://openalex.org/W2126666814"],"abstract_inverted_index":{"In":[0,93],"the":[1,32,39,45,107,115,124],"traditional":[2,108],"ETL":[3],"(Extract":[4],"Transform":[5],"Loading),":[6],"refreshment":[7],"of":[8,34,36],"data":[9,37,40,54,59,72,82,85,88,98,128,154],"warehouse":[10,41,73],"must":[11],"be":[12,64,91],"done":[13],"in":[14,38,74,84,123],"off":[15],"peak":[16],"hours.":[17],"It":[18,30,70],"means":[19],"that":[20,148],"all":[21,28],"operational":[22,47],"and":[23,117,133,137],"analysis":[24],"stopped":[25],"from":[26,145],"their":[27],"activities.":[29],"cause":[31],"level":[33],"freshness":[35],"is":[42,51,61],"not":[43,104],"indicating":[44],"latest":[46],"transaction.":[48],"This":[49,110],"problem":[50],"called":[52],"by":[53],"latency.":[55],"Near":[56],"real":[57,76,96,126,152],"time":[58,77,97,127,153],"warehousing":[60,99,155],"used":[62],"to":[63,113],"a":[65],"solution":[66],"for":[67],"this":[68],"problem.":[69,156],"update":[71],"near":[75,95,125,151],"manner,":[78],"immediately":[79],"after":[80],"change":[81],"detected":[83],"source.":[86],"Thus,":[87],"latency":[89],"can":[90],"minimized.":[92],"development,":[94],"have":[100],"problems":[101,116,136],"where":[102],"previously":[103],"found":[105],"on":[106,142,150],"ETL.":[109],"paper":[111],"aims":[112],"convey":[114],"available":[118,138],"solutions":[119,139],"at":[120],"each":[121],"stage":[122],"warehousing,":[129],"i.e.":[130],"extraction,":[131],"transformation,":[132],"loading.":[134],"The":[135],"are":[140],"based":[141],"literature":[143],"review":[144],"other":[146],"research":[147],"focusing":[149]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2024,"cited_by_count":3},{"year":2023,"cited_by_count":3},{"year":2022,"cited_by_count":3},{"year":2021,"cited_by_count":5},{"year":2020,"cited_by_count":5},{"year":2019,"cited_by_count":2},{"year":2018,"cited_by_count":1},{"year":2017,"cited_by_count":3},{"year":2016,"cited_by_count":1}],"updated_date":"2026-11-04T10:54:05.112534","created_date":"2016-06-24T00:00:00"}