{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,11,1]],"date-time":"2025-11-01T09:35:53Z","timestamp":1761989753978,"version":"3.37.3"},"reference-count":32,"publisher":"IEEE","license":[{"start":{"date-parts":[[2024,4,15]],"date-time":"2024-04-15T00:00:00Z","timestamp":1713139200000},"content-version":"stm-asf","delay-in-days":0,"URL":"https:\/\/doi.org\/10.15223\/policy-029"},{"start":{"date-parts":[[2024,4,15]],"date-time":"2024-04-15T00:00:00Z","timestamp":1713139200000},"content-version":"stm-asf","delay-in-days":0,"URL":"https:\/\/doi.org\/10.15223\/policy-037"}],"funder":[{"DOI":"10.13039\/100016279","name":"Harris","doi-asserted-by":"publisher","id":[{"id":"10.13039\/100016279","id-type":"DOI","asserted-by":"publisher"}]}],"content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":[],"published-print":{"date-parts":[[2024,4,15]]},"DOI":"10.1109\/syscon61195.2024.10553614","type":"proceedings-article","created":{"date-parts":[[2024,6,17]],"date-time":"2024-06-17T17:55:15Z","timestamp":1718646915000},"page":"1-8","source":"Crossref","is-referenced-by-count":1,"title":["PostgreSQL Data Warehouse Implementation and Performance Optimization For Energy Companies"],"prefix":"10.1109","author":[{"given":"Dakota","family":"Joiner","sequence":"first","affiliation":[{"name":"Okanagan College,Computer Science,Kelowna,Canada"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Mathias","family":"Clement","sequence":"additional","affiliation":[{"name":"Okanagan College,Computer Science,Kelowna,Canada"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Keegan","family":"Pereira","sequence":"additional","affiliation":[{"name":"Okanagan College,Computer Science,Kelowna,Canada"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Shek Tom","family":"Chan","sequence":"additional","affiliation":[{"name":"Langara College,Mathematics and Statistics,Vancouver,Canada"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Youry","family":"Khmelevsky","sequence":"additional","affiliation":[{"name":"Okanagan College,Computer Science,Kelowna,Canada"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Albert","family":"Wong","sequence":"additional","affiliation":[{"name":"Langara College,Mathematics and Statistics,Vancouver,Canada"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Joe","family":"Mahony","sequence":"additional","affiliation":[{"name":"Harris SmartWorks,Research and Development,Ottawa,Canada"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Michael","family":"Ferri","sequence":"additional","affiliation":[{"name":"Harris SmartWorks,Research and Development,Ottawa,Canada"}],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"263","reference":[{"volume-title":"The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling","year":"2013","author":"Kimball","key":"ref1"},{"article-title":"Parallel Programming Applied Research Projects for Teaching Parallel Programming to Beginner Students","year":"2021","author":"Khmelevsky","key":"ref2"},{"key":"ref3","article-title":"Machine Learning Prediction of Gamers Private Networks","volume-title":"CoRR","volume":"abs\/2012.06480","author":"Mazur","year":"2020"},{"key":"ref4","doi-asserted-by":"publisher","DOI":"10.1109\/RASSE54974.2022.9989603"},{"key":"ref5","doi-asserted-by":"publisher","DOI":"10.1007\/978-3-030-63089-8_7"},{"key":"ref6","first-page":"3","article-title":"Information Security and Data Protection in Computer Science Education","volume-title":"12th Western Canadian Conference Education on Computing Education (WCCCE-2007)","author":"Khmelevsky"},{"key":"ref7","first-page":"3","article-title":"Information Security and Data Protection in Computer Science Education","volume-title":"12th Western Canadian Conference Education on Computing Education (WCCCE-2007)","author":"Khmelevsky"},{"key":"ref8","doi-asserted-by":"publisher","DOI":"10.5488\/CMP.11.4.761"},{"issue":"250","key":"ref9","first-page":"60","article-title":"SW Development Projects in Academia","volume-title":"WCCCE 2009 - Proceedings of the 14th Western Canadian Conference on Computing Education","volume":"1","author":"Khmelevsky"},{"key":"ref10","first-page":"65","article-title":"Okanagan College and Vancouver Island University educational joint projects results","volume-title":"Proceedings of the 14th Western Canadian Conference on Computing Education - WCCCE 09","author":"Khmelevsky"},{"key":"ref11","doi-asserted-by":"publisher","DOI":"10.1145\/1989622.1989638"},{"key":"ref12","doi-asserted-by":"publisher","DOI":"10.1145\/1989622.1989637"},{"key":"ref13","first-page":"8","article-title":"Strategies for teaching mobile application development","volume-title":"18th Western Canadian Conference on Computing Education","volume":"18","author":"Khmelevsky"},{"article-title":"Hybrid Cloud Computing Infrastructure in Academia","volume-title":"WC- CCE 2015 - the 20th Western Canadian Conference on Computing Education, At May 8-9, 2015","author":"Khmelevsky","key":"ref14"},{"key":"ref15","doi-asserted-by":"publisher","DOI":"10.1109\/CCECE.2016.7726819"},{"key":"ref16","doi-asserted-by":"publisher","DOI":"10.1109\/ICCCF.2016.7740436"},{"key":"ref17","doi-asserted-by":"publisher","DOI":"10.1145\/2910925.2910949"},{"key":"ref18","doi-asserted-by":"publisher","DOI":"10.1109\/ICCCF.2016.7740432"},{"key":"ref19","doi-asserted-by":"publisher","DOI":"10.1109\/SYSCON.2016.7490577"},{"key":"ref20","doi-asserted-by":"publisher","DOI":"10.1145\/3085585.3088491"},{"key":"ref21","doi-asserted-by":"publisher","DOI":"10.1109\/CCECE.2017.7946694"},{"key":"ref22","doi-asserted-by":"publisher","DOI":"10.1109\/SYSCON.2017.7934779"},{"key":"ref23","article-title":"OLAP vs. OLTP: Whats the Difference?","volume-title":"IBM Blog","author":"Sinha","year":"2021"},{"key":"ref24","doi-asserted-by":"publisher","DOI":"10.1088\/1742-6596\/1477\/3\/032013"},{"issue":"9","key":"ref25","first-page":"2865","article-title":"Data Warehousing, Data Mining, OLAP and OLTP Technologies are essential elements to support decision-making process in industries","volume":"2","author":"Reddy","year":"2010","journal-title":"International Journal on Computer Science and Engineering"},{"key":"ref26","first-page":"481","volume-title":"Comparing Oracle and PostgreSQL, Performance and Optimization","author":"Martins","year":"2021"},{"key":"ref27","doi-asserted-by":"publisher","DOI":"10.1109\/WETICE.2019.00022"},{"key":"ref28","first-page":"232","article-title":"Query Performance Optimization in XML Data Warehouses","volume-title":"E-Strategies for Resource Management Systems","author":"Mahboubi","year":"2017"},{"key":"ref29","first-page":"7","article-title":"Improving Query Performance in Data Warehouses","volume-title":"Seattle","author":"Rosenberg","year":"2006"},{"key":"ref30","first-page":"1169","volume-title":"Dynamic query scheduling in parallel data warehouses","author":"M\u00e4rtens","year":"2003"},{"key":"ref31","first-page":"232","article-title":"Efficient data access and performance improvement model for virtual data warehouse","author":"Khan","year":"2017"},{"journal-title":"Documentation PostgreSQL 10.20","first-page":"445","year":"2022","key":"ref32"}],"event":{"name":"2024 IEEE International Systems Conference (SysCon)","start":{"date-parts":[[2024,4,15]]},"location":"Montreal, QC, Canada","end":{"date-parts":[[2024,4,18]]}},"container-title":["2024 IEEE International Systems Conference (SysCon)"],"original-title":[],"link":[{"URL":"http:\/\/xplorestaging.ieee.org\/ielx8\/10553374\/10553399\/10553614.pdf?arnumber=10553614","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2024,6,25]],"date-time":"2024-06-25T19:13:30Z","timestamp":1719342810000},"score":1,"resource":{"primary":{"URL":"https:\/\/ieeexplore.ieee.org\/document\/10553614\/"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2024,4,15]]},"references-count":32,"URL":"https:\/\/doi.org\/10.1109\/syscon61195.2024.10553614","relation":{},"subject":[],"published":{"date-parts":[[2024,4,15]]}}}