{"id":"https://openalex.org/W141003294","doi":null,"title":"Enhancing ETL Performance with Warehouse Builder","display_name":"Enhancing ETL Performance with Warehouse Builder","publication_year":2013,"publication_date":"2013-07-01","ids":{"openalex":"https://openalex.org/W141003294","mag":"141003294"},"language":"en","primary_location":{"id":"pmh:oai:RePEc:aes:dbjour:v:4:y:2013:i:2:p:31-41","doi":null,"is_oa":false,"landing_page_url":"http://dbjournal.ro/archive/12/12_4.pdf","pdf_url":"http://dbjournal.ro/archive/12/12_4.pdf","source":{"id":"https://openalex.org/S4306401271","display_name":"RePEc: Research Papers in Economics","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I77793887","host_organization_name":"Federal Reserve Bank of St. Louis","host_organization_lineage":["https://openalex.org/I77793887"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"article"},"volume":null,"type":"article","is_traditional":true,"indexed_in":["doaj"],"open_access":{"is_oa":true,"oa_status":"diamond","oa_url":"http://dbjournal.ro/archive/12/12_4.pdf","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5033203604","display_name":"Manole Velicanu","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Manole Velicanu","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"last","author":{"id":"https://openalex.org/A5088620258","display_name":"Larisa Copcea","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Larisa Copcea","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":2.183,"has_fulltext":false,"cited_by_count":10,"citation_normalized_percentile":{"value":0.89456153,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":87,"max":97},"biblio":{"volume":"4","issue":"2","first_page":"31","last_page":"41"},"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.9628999829292297,"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.9628999829292297,"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.03310000151395798,"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/T11719","display_name":"Data Quality and Management","score":0.0010000000474974513,"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-design","display_name":"data warehouse design","score":0.6330000162124634},{"id":"https://openalex.org/keywords/data-integration","display_name":"data integration","score":0.6499999761581421}],"concepts":[{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.9177438020706177},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8487492799758911},{"id":"https://openalex.org/C55166926","wikidata":"https://www.wikidata.org/wiki/Q2892946","display_name":"Oracle","level":2,"score":0.8329971432685852},{"id":"https://openalex.org/C50416739","wikidata":"https://www.wikidata.org/wiki/Q181623","display_name":"Warehouse","level":2,"score":0.744413435459137},{"id":"https://openalex.org/C143008350","wikidata":"https://www.wikidata.org/wiki/Q3432172","display_name":"Dimensional modeling","level":2,"score":0.6764452457427979},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.6378154158592224},{"id":"https://openalex.org/C201932085","wikidata":"https://www.wikidata.org/wiki/Q642514","display_name":"Online analytical processing","level":3,"score":0.5505750179290771},{"id":"https://openalex.org/C2777904410","wikidata":"https://www.wikidata.org/wiki/Q7397","display_name":"Software","level":2,"score":0.5237736105918884},{"id":"https://openalex.org/C2987003710","wikidata":"https://www.wikidata.org/wiki/Q185524","display_name":"Oracle database","level":3,"score":0.4601950943470001},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.21569517254829407},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.15918204188346863},{"id":"https://openalex.org/C144133560","wikidata":"https://www.wikidata.org/wiki/Q4830453","display_name":"Business","level":0,"score":0.0},{"id":"https://openalex.org/C162853370","wikidata":"https://www.wikidata.org/wiki/Q39809","display_name":"Marketing","level":1,"score":0.0}],"mesh":[],"locations_count":3,"locations":[{"id":"pmh:oai:RePEc:aes:dbjour:v:4:y:2013:i:2:p:31-41","doi":null,"is_oa":false,"landing_page_url":"http://dbjournal.ro/archive/12/12_4.pdf","pdf_url":"http://dbjournal.ro/archive/12/12_4.pdf","source":{"id":"https://openalex.org/S4306401271","display_name":"RePEc: Research Papers in Economics","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I77793887","host_organization_name":"Federal Reserve Bank of St. Louis","host_organization_lineage":["https://openalex.org/I77793887"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"article"},{"id":"mag:141003294","doi":null,"is_oa":true,"landing_page_url":"http://dbjournal.ro/archive/12/12_4.pdf","pdf_url":null,"source":{"id":"https://openalex.org/S2764408256","display_name":"Database Systems Journal","issn_l":"2069-3230","issn":["2069-3230"],"is_oa":true,"is_in_doaj":true,"is_core":false,"listed_in":["doaj"],"host_organization":"https://openalex.org/P4310314643","host_organization_name":"Bucharest Academy of Economic Studies Publishing House","host_organization_lineage":["https://openalex.org/P4310314643"],"host_organization_lineage_names":["Bucharest Academy of Economic Studies Publishing House"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Database Systems Journal","raw_type":null},{"id":"pmh:oai:doaj.org/article:9a040547f3b74cb9be62064542c2cd1e","doi":null,"is_oa":false,"landing_page_url":"https://doaj.org/article/9a040547f3b74cb9be62064542c2cd1e","pdf_url":null,"source":{"id":"https://openalex.org/S4306401280","display_name":"DOAJ (DOAJ: Directory of Open Access Journals)","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":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Database Systems Journal, Vol IV, Iss 2, Pp 31-41 (2013)","raw_type":"article"}],"best_oa_location":{"id":"mag:141003294","doi":null,"is_oa":true,"landing_page_url":"http://dbjournal.ro/archive/12/12_4.pdf","pdf_url":null,"source":{"id":"https://openalex.org/S2764408256","display_name":"Database Systems Journal","issn_l":"2069-3230","issn":["2069-3230"],"is_oa":true,"is_in_doaj":true,"is_core":false,"listed_in":["doaj"],"host_organization":"https://openalex.org/P4310314643","host_organization_name":"Bucharest Academy of Economic Studies Publishing House","host_organization_lineage":["https://openalex.org/P4310314643"],"host_organization_lineage_names":["Bucharest Academy of Economic Studies Publishing House"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Database Systems Journal","raw_type":null},"sustainable_development_goals":[{"score":0.5378999710083008,"display_name":"Industry, innovation and infrastructure","id":"https://metadata.un.org/sdg/9"}],"study_designs":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":2,"referenced_works":["https://openalex.org/W1545151502","https://openalex.org/W2238567556"],"related_works":["https://openalex.org/W4225713357","https://openalex.org/W4229000965","https://openalex.org/W7135546093","https://openalex.org/W3113323589","https://openalex.org/W2354800742","https://openalex.org/W7135437976","https://openalex.org/W2417896101","https://openalex.org/W4377704429","https://openalex.org/W182840982","https://openalex.org/W4200034645"],"abstract_inverted_index":{"We":[0],"live":[1],"in":[2,6,66,97],"a":[3,7],"dynamic":[4],"world,":[5],"permanent":[8],"move,":[9],"were":[10],"performance":[11,102],"of":[12,20,24,71,80,93,103,116],"information":[13,40],"systems":[14,41],"continually":[15],"increases.":[16],"Thus,":[17],"the":[18,36,58,78,101],"need":[19,37],"being":[21],"informed,":[22],"regardless":[23],"place":[25],"or":[26],"time,":[27],"is":[28,42,83],"very":[29,43],"great":[30],"using":[31,51],"data":[32,59,94,104,121],"warehouses":[33,122],"solutions.":[34],"Therefore,":[35],"for":[38],"efficient":[39],"high.":[44],"The":[45,61],"efficiency":[46],"can":[47,107],"be":[48,108],"achieved":[49],"by":[50],"various":[52],"methods/techniques":[53],"and":[54,113],"technologies":[55],"\"to":[56],"build\"":[57],"warehouse.":[60],"ones,":[62],"we":[63,118],"will":[64,119],"present":[65],"our":[67],"paper,":[68],"are:":[69],"methods":[70],"Enhancing":[72],"ETL":[73,81],"Performance":[74],"with":[75],"Warehouse":[76,125],"Builder:":[77],"purpose":[79],"strategies":[82],"to":[84,99],"create":[85],"an":[86],"integrated,":[87],"complex,":[88],"coherent":[89],"software":[90],"solution;":[91],"techniques":[92],"warehouse":[95,105],"optimization:":[96],"order":[98],"improve":[100],"processing":[106],"applied":[109],"several":[110],"optimization":[111],"techniques;":[112],"\"in":[114],"terms\"":[115],"technology,":[117],"consider:":[120],"(using":[123],"Oracle":[124],"Builder).":[126]},"counts_by_year":[{"year":2021,"cited_by_count":1},{"year":2019,"cited_by_count":1},{"year":2018,"cited_by_count":1},{"year":2017,"cited_by_count":3},{"year":2016,"cited_by_count":3},{"year":2015,"cited_by_count":1}],"updated_date":"2026-11-04T10:54:05.112534","created_date":"2016-06-24T00:00:00"}