{"id":"https://openalex.org/W4410887323","doi":"https://doi.org/10.1109/syscon64521.2025.11014823","title":"Algorithmic Trading Machine Learning Modelling and Forecasting Subsystems Integration and Data Transformation Process Automation for a Data Warehouse","display_name":"Algorithmic Trading Machine Learning Modelling and Forecasting Subsystems Integration and Data Transformation Process Automation for a Data Warehouse","publication_year":2025,"publication_date":"2025-04-07","ids":{"openalex":"https://openalex.org/W4410887323","doi":"https://doi.org/10.1109/syscon64521.2025.11014823"},"language":"en","primary_location":{"id":"doi:10.1109/syscon64521.2025.11014823","is_oa":false,"landing_page_url":"https://doi.org/10.1109/syscon64521.2025.11014823","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2025 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/A5093557703","display_name":"Ajitesh Parihar","orcid":"https://orcid.org/0009-0001-3162-1470"},"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":"Ajitesh Parihar","raw_affiliation_strings":["Computer Science, Okanagan College,Kelowna,Canada"],"affiliations":[{"raw_affiliation_string":"Computer Science, Okanagan College,Kelowna,Canada","institution_ids":["https://openalex.org/I198387804"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5115021201","display_name":"Dolcy Sareen","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":"Dolcy Sareen","raw_affiliation_strings":["Computer Science, Okanagan College,Kelowna,Canada"],"affiliations":[{"raw_affiliation_string":"Computer Science, Okanagan College,Kelowna,Canada","institution_ids":["https://openalex.org/I198387804"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5117770551","display_name":"Dylan Huitema","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":"Dylan Huitema","raw_affiliation_strings":["Computer Science, Okanagan College,Kelowna,Canada"],"affiliations":[{"raw_affiliation_string":"Computer Science, Okanagan College,Kelowna,Canada","institution_ids":["https://openalex.org/I198387804"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5105699771","display_name":"Kristina Cormier","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":"Kristina Cormier","raw_affiliation_strings":["Computer Science, Okanagan College,Kelowna,Canada"],"affiliations":[{"raw_affiliation_string":"Computer Science, Okanagan College,Kelowna,Canada","institution_ids":["https://openalex.org/I198387804"]}]},{"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":["Computer Science, Okanagan College,Kelowna,Canada"],"affiliations":[{"raw_affiliation_string":"Computer Science, Okanagan College,Kelowna,Canada","institution_ids":["https://openalex.org/I198387804"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5006607311","display_name":"Ga\u00e9tan Hains","orcid":"https://orcid.org/0000-0002-1687-8091"},"institutions":[{"id":"https://openalex.org/I2800365227","display_name":"Paris-Est Sup","ror":"https://ror.org/0268ecp52","country_code":"FR","type":"education","lineage":["https://openalex.org/I2800365227"]}],"countries":["FR"],"is_corresponding":false,"raw_author_name":"Ga\u00e9tan Hains","raw_affiliation_strings":["LACL, Université Paris-Est,Créteil,France"],"affiliations":[{"raw_affiliation_string":"LACL, Université Paris-Est,Créteil,France","institution_ids":["https://openalex.org/I2800365227"]}]},{"author_position":"last","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":["Mathematics and Statistics, Langara College,Vancouver,Canada"],"affiliations":[{"raw_affiliation_string":"Mathematics and Statistics, Langara College,Vancouver,Canada","institution_ids":["https://openalex.org/I39466443"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":7,"corresponding_author_ids":["https://openalex.org/A5093557703"],"corresponding_institution_ids":["https://openalex.org/I198387804"],"apc_list":null,"apc_paid":null,"fwci":4.9801,"has_fulltext":false,"cited_by_count":2,"citation_normalized_percentile":{"value":0.94797279,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":95,"max":96},"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/T11891","display_name":"Big Data and Business Intelligence","score":0.9815999865531921,"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.9815999865531921,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/automation","display_name":"Automation","score":0.7758516073226929},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.7601020932197571},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7358453869819641},{"id":"https://openalex.org/keywords/process","display_name":"Process (computing)","score":0.6296342611312866},{"id":"https://openalex.org/keywords/transformation","display_name":"Transformation (genetics)","score":0.6044392585754395},{"id":"https://openalex.org/keywords/data-transformation","display_name":"Data transformation","score":0.5804219245910645},{"id":"https://openalex.org/keywords/data-modeling","display_name":"Data modeling","score":0.5561307668685913},{"id":"https://openalex.org/keywords/data-integration","display_name":"Data integration","score":0.4816419184207916},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.3792106807231903},{"id":"https://openalex.org/keywords/industrial-engineering","display_name":"Industrial engineering","score":0.37495386600494385},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.3507288098335266},{"id":"https://openalex.org/keywords/engineering","display_name":"Engineering","score":0.15111181139945984},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.12621253728866577}],"concepts":[{"id":"https://openalex.org/C115901376","wikidata":"https://www.wikidata.org/wiki/Q184199","display_name":"Automation","level":2,"score":0.7758516073226929},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.7601020932197571},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7358453869819641},{"id":"https://openalex.org/C98045186","wikidata":"https://www.wikidata.org/wiki/Q205663","display_name":"Process (computing)","level":2,"score":0.6296342611312866},{"id":"https://openalex.org/C204241405","wikidata":"https://www.wikidata.org/wiki/Q461499","display_name":"Transformation (genetics)","level":3,"score":0.6044392585754395},{"id":"https://openalex.org/C150670458","wikidata":"https://www.wikidata.org/wiki/Q4272815","display_name":"Data transformation","level":3,"score":0.5804219245910645},{"id":"https://openalex.org/C67186912","wikidata":"https://www.wikidata.org/wiki/Q367664","display_name":"Data modeling","level":2,"score":0.5561307668685913},{"id":"https://openalex.org/C72634772","wikidata":"https://www.wikidata.org/wiki/Q386824","display_name":"Data integration","level":2,"score":0.4816419184207916},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.3792106807231903},{"id":"https://openalex.org/C13736549","wikidata":"https://www.wikidata.org/wiki/Q4489420","display_name":"Industrial engineering","level":1,"score":0.37495386600494385},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.3507288098335266},{"id":"https://openalex.org/C127413603","wikidata":"https://www.wikidata.org/wiki/Q11023","display_name":"Engineering","level":0,"score":0.15111181139945984},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.12621253728866577},{"id":"https://openalex.org/C78519656","wikidata":"https://www.wikidata.org/wiki/Q101333","display_name":"Mechanical engineering","level":1,"score":0.0},{"id":"https://openalex.org/C104317684","wikidata":"https://www.wikidata.org/wiki/Q7187","display_name":"Gene","level":2,"score":0.0},{"id":"https://openalex.org/C55493867","wikidata":"https://www.wikidata.org/wiki/Q7094","display_name":"Biochemistry","level":1,"score":0.0},{"id":"https://openalex.org/C185592680","wikidata":"https://www.wikidata.org/wiki/Q2329","display_name":"Chemistry","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/syscon64521.2025.11014823","is_oa":false,"landing_page_url":"https://doi.org/10.1109/syscon64521.2025.11014823","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2025 IEEE International systems Conference (SysCon)","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":24,"referenced_works":["https://openalex.org/W2914888512","https://openalex.org/W2919119516","https://openalex.org/W2945921409","https://openalex.org/W2951120644","https://openalex.org/W3091291078","https://openalex.org/W3123473877","https://openalex.org/W3126577088","https://openalex.org/W3130929068","https://openalex.org/W3158146252","https://openalex.org/W4220891756","https://openalex.org/W4224312691","https://openalex.org/W4226377870","https://openalex.org/W4280583546","https://openalex.org/W4312096242","https://openalex.org/W4316591919","https://openalex.org/W4378191509","https://openalex.org/W4382644382","https://openalex.org/W4383749405","https://openalex.org/W4386161583","https://openalex.org/W4389566759","https://openalex.org/W4391792097","https://openalex.org/W4392921067","https://openalex.org/W4399452789","https://openalex.org/W4410887488"],"related_works":["https://openalex.org/W2384379346","https://openalex.org/W2348093825","https://openalex.org/W2390710026","https://openalex.org/W2364425891","https://openalex.org/W2347601812","https://openalex.org/W3022239989","https://openalex.org/W2369660510","https://openalex.org/W3015205082","https://openalex.org/W1505247071","https://openalex.org/W2284149529"],"abstract_inverted_index":{"A":[0],"DW":[1],"is":[2],"needed":[3],"to":[4,56,69],"efficiently":[5],"and":[6,15,27,32,42,65],"continuously":[7],"prepare":[8],"data":[9,13,66],"for":[10,37,53,63],"practical":[11],"real-time":[12],"analysis":[14],"forecasting":[16],"with":[17],"machine":[18],"learning":[19],"(ML)":[20],"algorithms.":[21],"This":[22],"paper":[23],"discusses":[24],"extraction,":[25],"transformation,":[26],"loading":[28],"process":[29],"(ETL)":[30],"automation":[31],"the":[33,57],"critical":[34,71],"subsystems":[35],"integration":[36],"algorithmic":[38],"trading":[39],"ML":[40],"modelling":[41],"stock":[43],"market":[44],"forecasting.":[45],"Additionally,":[46],"we":[47],"discuss":[48],"a":[49],"new":[50],"API":[51],"designed":[52],"direct":[54],"access":[55],"DW.":[58],"It":[59],"opens":[60],"vast":[61],"opportunities":[62],"performance":[64],"processing":[67],"time":[68],"become":[70],"nonfunctional":[72],"requirements.":[73]},"counts_by_year":[{"year":2025,"cited_by_count":2}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}