{"id":"https://openalex.org/W4399729049","doi":"https://doi.org/10.1109/syscon61195.2024.10553614","title":"PostgreSQL Data Warehouse Implementation and Performance Optimization For Energy Companies","display_name":"PostgreSQL Data Warehouse Implementation and Performance Optimization For Energy Companies","publication_year":2024,"publication_date":"2024-04-15","ids":{"openalex":"https://openalex.org/W4399729049","doi":"https://doi.org/10.1109/syscon61195.2024.10553614"},"language":"en","primary_location":{"id":"doi:10.1109/syscon61195.2024.10553614","is_oa":false,"landing_page_url":"https://doi.org/10.1109/syscon61195.2024.10553614","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2024 IEEE International Systems Conference (SysCon)","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/A5041315004","display_name":"Dakota Joiner","orcid":"https://orcid.org/0000-0002-3094-0015"},"institutions":[{"id":"https://openalex.org/I198387804","display_name":"Okanagan College","ror":"https://ror.org/04k2ezm16","country_code":"CA","type":"education","lineage":["https://openalex.org/I198387804"]}],"countries":["CA"],"is_corresponding":true,"raw_author_name":"Dakota Joiner","raw_affiliation_strings":["Okanagan College,Computer Science,Kelowna,Canada","Computer Science, Okanagan College, Kelowna, Canada"],"affiliations":[{"raw_affiliation_string":"Okanagan College,Computer Science,Kelowna,Canada","institution_ids":["https://openalex.org/I198387804"]},{"raw_affiliation_string":"Computer Science, Okanagan College, Kelowna, Canada","institution_ids":["https://openalex.org/I198387804"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5039595665","display_name":"Mathias Clement","orcid":null},"institutions":[{"id":"https://openalex.org/I198387804","display_name":"Okanagan College","ror":"https://ror.org/04k2ezm16","country_code":"CA","type":"education","lineage":["https://openalex.org/I198387804"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Mathias Clement","raw_affiliation_strings":["Okanagan College,Computer Science,Kelowna,Canada","Computer Science, Okanagan College, Kelowna, Canada"],"affiliations":[{"raw_affiliation_string":"Okanagan College,Computer Science,Kelowna,Canada","institution_ids":["https://openalex.org/I198387804"]},{"raw_affiliation_string":"Computer Science, Okanagan College, Kelowna, Canada","institution_ids":["https://openalex.org/I198387804"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5045252854","display_name":"Keegan Pereira","orcid":null},"institutions":[{"id":"https://openalex.org/I198387804","display_name":"Okanagan College","ror":"https://ror.org/04k2ezm16","country_code":"CA","type":"education","lineage":["https://openalex.org/I198387804"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Keegan Pereira","raw_affiliation_strings":["Okanagan College,Computer Science,Kelowna,Canada","Computer Science, Okanagan College, Kelowna, Canada"],"affiliations":[{"raw_affiliation_string":"Okanagan College,Computer Science,Kelowna,Canada","institution_ids":["https://openalex.org/I198387804"]},{"raw_affiliation_string":"Computer Science, Okanagan College, Kelowna, Canada","institution_ids":["https://openalex.org/I198387804"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5018889144","display_name":"Shek Tom Chan","orcid":null},"institutions":[{"id":"https://openalex.org/I39466443","display_name":"Langara College","ror":"https://ror.org/05qp50e50","country_code":"CA","type":"education","lineage":["https://openalex.org/I39466443"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Shek Tom Chan","raw_affiliation_strings":["Langara College,Mathematics and Statistics,Vancouver,Canada","Mathematics and Statistics, Langara College, Vancouver, Canada"],"affiliations":[{"raw_affiliation_string":"Langara College,Mathematics and Statistics,Vancouver,Canada","institution_ids":["https://openalex.org/I39466443"]},{"raw_affiliation_string":"Mathematics and Statistics, Langara College, Vancouver, Canada","institution_ids":["https://openalex.org/I39466443"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5083484982","display_name":"Youry Khmelevsky","orcid":"https://orcid.org/0000-0002-6837-3490"},"institutions":[{"id":"https://openalex.org/I198387804","display_name":"Okanagan College","ror":"https://ror.org/04k2ezm16","country_code":"CA","type":"education","lineage":["https://openalex.org/I198387804"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Youry Khmelevsky","raw_affiliation_strings":["Okanagan College,Computer Science,Kelowna,Canada","Computer Science, Okanagan College, Kelowna, Canada"],"affiliations":[{"raw_affiliation_string":"Okanagan College,Computer Science,Kelowna,Canada","institution_ids":["https://openalex.org/I198387804"]},{"raw_affiliation_string":"Computer Science, Okanagan College, Kelowna, Canada","institution_ids":["https://openalex.org/I198387804"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5103139210","display_name":"Albert Wong","orcid":"https://orcid.org/0000-0002-0669-4352"},"institutions":[{"id":"https://openalex.org/I39466443","display_name":"Langara College","ror":"https://ror.org/05qp50e50","country_code":"CA","type":"education","lineage":["https://openalex.org/I39466443"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Albert Wong","raw_affiliation_strings":["Langara College,Mathematics and Statistics,Vancouver,Canada","Mathematics and Statistics, Langara College, Vancouver, Canada"],"affiliations":[{"raw_affiliation_string":"Langara College,Mathematics and Statistics,Vancouver,Canada","institution_ids":["https://openalex.org/I39466443"]},{"raw_affiliation_string":"Mathematics and Statistics, Langara College, Vancouver, Canada","institution_ids":["https://openalex.org/I39466443"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5032078853","display_name":"Joe Mahony","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Joe Mahony","raw_affiliation_strings":["Harris SmartWorks,Research and Development,Ottawa,Canada","Research and Development, Harris SmartWorks, Ottawa, Canada"],"affiliations":[{"raw_affiliation_string":"Harris SmartWorks,Research and Development,Ottawa,Canada","institution_ids":[]},{"raw_affiliation_string":"Research and Development, Harris SmartWorks, Ottawa, Canada","institution_ids":[]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5057415804","display_name":"Michael Ferri","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Michael Ferri","raw_affiliation_strings":["Harris SmartWorks,Research and Development,Ottawa,Canada","Research and Development, Harris SmartWorks, Ottawa, Canada"],"affiliations":[{"raw_affiliation_string":"Harris SmartWorks,Research and Development,Ottawa,Canada","institution_ids":[]},{"raw_affiliation_string":"Research and Development, Harris SmartWorks, Ottawa, Canada","institution_ids":[]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":8,"corresponding_author_ids":["https://openalex.org/A5041315004"],"corresponding_institution_ids":["https://openalex.org/I198387804"],"apc_list":null,"apc_paid":null,"fwci":0.8118,"has_fulltext":false,"cited_by_count":1,"citation_normalized_percentile":{"value":0.76007146,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":91,"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/T10101","display_name":"Cloud Computing and Resource Management","score":0.9991000294685364,"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"}},"topics":[{"id":"https://openalex.org/T10101","display_name":"Cloud Computing and Resource Management","score":0.9991000294685364,"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/T10715","display_name":"Distributed and Parallel Computing Systems","score":0.9962000250816345,"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/T12292","display_name":"Graph Theory and Algorithms","score":0.9817000031471252,"subfield":{"id":"https://openalex.org/subfields/1707","display_name":"Computer Vision and Pattern Recognition"},"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.8381103277206421},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.6341453790664673},{"id":"https://openalex.org/keywords/warehouse","display_name":"Warehouse","score":0.5887129306793213},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.49262458086013794},{"id":"https://openalex.org/keywords/energy","display_name":"Energy (signal processing)","score":0.4381709396839142},{"id":"https://openalex.org/keywords/business","display_name":"Business","score":0.2221907675266266}],"concepts":[{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.8381103277206421},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6341453790664673},{"id":"https://openalex.org/C50416739","wikidata":"https://www.wikidata.org/wiki/Q181623","display_name":"Warehouse","level":2,"score":0.5887129306793213},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.49262458086013794},{"id":"https://openalex.org/C186370098","wikidata":"https://www.wikidata.org/wiki/Q442787","display_name":"Energy (signal processing)","level":2,"score":0.4381709396839142},{"id":"https://openalex.org/C144133560","wikidata":"https://www.wikidata.org/wiki/Q4830453","display_name":"Business","level":0,"score":0.2221907675266266},{"id":"https://openalex.org/C105795698","wikidata":"https://www.wikidata.org/wiki/Q12483","display_name":"Statistics","level":1,"score":0.0},{"id":"https://openalex.org/C162853370","wikidata":"https://www.wikidata.org/wiki/Q39809","display_name":"Marketing","level":1,"score":0.0},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/syscon61195.2024.10553614","is_oa":false,"landing_page_url":"https://doi.org/10.1109/syscon61195.2024.10553614","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2024 IEEE International Systems Conference (SysCon)","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"score":0.7799999713897705,"display_name":"Affordable and clean energy","id":"https://metadata.un.org/sdg/7"}],"awards":[],"funders":[{"id":"https://openalex.org/F4320316489","display_name":"Harris","ror":null}],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":30,"referenced_works":["https://openalex.org/W834810655","https://openalex.org/W2000507679","https://openalex.org/W2048805759","https://openalex.org/W2108812780","https://openalex.org/W2345895475","https://openalex.org/W2443188502","https://openalex.org/W2460071091","https://openalex.org/W2548719347","https://openalex.org/W2549448096","https://openalex.org/W2552935709","https://openalex.org/W2617692151","https://openalex.org/W2665090220","https://openalex.org/W2722585093","https://openalex.org/W2749688183","https://openalex.org/W2968961077","https://openalex.org/W3016964022","https://openalex.org/W3142763458","https://openalex.org/W3144645762","https://openalex.org/W3146266057","https://openalex.org/W3165436424","https://openalex.org/W4238645420","https://openalex.org/W4312121203","https://openalex.org/W4399861344","https://openalex.org/W6673195117","https://openalex.org/W6678423775","https://openalex.org/W6722866582","https://openalex.org/W6743501397","https://openalex.org/W6784909568","https://openalex.org/W6795785864","https://openalex.org/W6941451657"],"related_works":["https://openalex.org/W4391375266","https://openalex.org/W2748952813","https://openalex.org/W3135624046","https://openalex.org/W2390279801","https://openalex.org/W4399515993","https://openalex.org/W2358668433","https://openalex.org/W4396701345","https://openalex.org/W2392996360","https://openalex.org/W2389559488","https://openalex.org/W2382329217"],"abstract_inverted_index":{"With":[0],"smart":[1,30],"grids":[2,6,31],"replacing":[3],"traditional":[4],"energy":[5,10,115],"in":[7,29,37,138,178],"recent":[8],"years,":[9],"companies":[11],"are":[12,96],"facing":[13],"a":[14,35,68,88,136],"new":[15],"challenge":[16],"to":[17,34,43,59,143],"efficiently":[18],"manage":[19],"and":[20,125,159,175,182],"analyze":[21],"the":[22,38,46,65,100,151,156,160],"collected":[23],"data.":[24],"The":[25,105],"use":[26],"of":[27,78,102,107,150],"sensors":[28],"has":[32,86],"led":[33],"surge":[36],"data":[39,72,83],"being":[40],"collected.":[41],"Due":[42],"its":[44],"design,":[45],"classic":[47],"relational":[48,53],"Online":[49],"Transaction":[50],"Processing":[51],"(OLTP)":[52],"database":[54],"management":[55],"system":[56,163],"(RDBMS)":[57],"starts":[58],"become":[60,87],"inefficient":[61],"for":[62],"queries":[63],"against":[64],"RDBMS":[66],"beyond":[67],"terabyte":[69],"size.":[70],"For":[71],"extraction":[73],"efficiency":[74],"on":[75,99,120],"large":[76],"volumes":[77],"data,":[79],"OLAP":[80],"along":[81],"with":[82,148],"warehousing":[84],"(DW)":[85],"popular":[89],"solution.":[90],"A":[91],"Business":[92],"Intelligence":[93],"(BI)":[94],"tools":[95],"often":[97],"used":[98],"top":[101],"DWs":[103],"[1].":[104],"adoption":[106],"big-":[108],"data-driven":[109],"technologies":[110],"is":[111,141,164],"still":[112],"lagging":[113],"among":[114],"companies.In":[116],"this":[117],"paper,":[118],"based":[119],"our":[121],"previous":[122],"research":[123,126,167],"projects":[124],"results":[127],"[2]\u2013[5],":[128],"we":[129],"show":[130],"that,":[131],"through":[132],"an":[133,172],"optimization":[134],"process,":[135],"gain":[137],"performance":[139],"that":[140,149],"up":[142],"2800":[144],"times":[145],"faster":[146],"compared":[147],"original":[152],"OLTP":[153],"DBMS":[154],"using":[155],"same":[157,161],"hardware":[158],"operating":[162],"possible.The":[165],"applied":[166],"project":[168],"was":[169,176],"funded":[170],"by":[171],"NSERC":[173],"grant":[174],"conducted":[177],"2020-2023":[179],"at":[180],"Okanagan":[181],"Langara":[183],"Colleges.":[184]},"counts_by_year":[{"year":2025,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}