Integrated Management of Potential Financial Risks Based on Data Warehouse

Peiyuan Yang; Zuwei Shui; Zhou Chen; Wang Baoming; Han Lei

doi:10.5281/zenodo.10970487

Authors

Peiyuan Yang University of Illinois at Urbana-Champaign
Zuwei Shui Trine University
Zhou Chen Zhejiang University
Wang Baoming University of Illinois at Urbana-Champaign
Han Lei Santa Clara University

DOI:

https://doi.org/10.5281/zenodo.10970487

ARK:

https://n2t.net/ark:/40704/JETBM.v1n2a08

PURL:

https://purl.archive.org/suas/JETBM.v1n2a08

References:

31

Keywords:

Data Warehouse, Financial Risk, Huawei Cloud GaussDB(DWS), Big Data

Abstract

A data warehouse is used to manage an enterprise's vast data sets, providing a storage mechanism to transform data, move data, and present it to end users. This paper introduces the challenges and changes facing the financial industry in the Internet era, and the new needs for data warehouse architecture transformation. The traditional data warehouse architecture has many limitations in the utilization of storage space, computing power and processing of real-time data flow, which is difficult to meet the needs of the rapid development of financial services. Therefore, there is an urgent need for financial institutions to transition from traditional warehouses to cloud-based distributed data warehouses. As a new-generation distributed data warehouse service, Huawei Cloud GaussDB(DWS) has the features of high performance, low cost, and easy expansion, meeting the needs of financial warehouses in the era of big data. The paper also introduces the traditional mode of financial risk management system and the related work of data warehouse, as well as the methodology and concrete implementation cases of financial data warehouse transformation.

Author Biographies

Peiyuan Yang, University of Illinois at Urbana-Champaign

Electrical and Computer Engineering, University of Illinois at Urbana-Champaign, Urbana, IL, USA.

Zuwei Shui, Trine University

Information Studies, Trine University, Phoenix, USA.

Zhou Chen, Zhejiang University

Software Engineering, Zhejiang University, Hangzhou, China.

Wang Baoming, University of Illinois at Urbana-Champaign

Electrical and Computer Engineering, University of Illinois at Urbana-Champaign, Urbana, IL, USA.

Han Lei, Santa Clara University

Computer Science Engineering, Santa Clara University, Santa Clara, USA.

References

Xu, Jinxin, et al. "Predict and Optimize Financial Services Risk Using AI-driven Technology." Academic Journal of Science and Technology 10.1 (2024): 299-304.

Wang, Hongbo, et al. "Intelligent Security Detection and Defense in Operating Systems Based on Deep Learning." International Journal of Computer Science and Information Technology 2.1 (2024): 359-367.

Zeng, Q., Sun, W., Xu, J., Wan, W., & Pan, L. (2024). Machine Learning-Based Medical Imaging Detection and Diagnostic Assistance. International Journal of Computer Science and Information Technology, 2(1), 36-44.

Xu, Z., Gong, Y., Zhou, Y., Bao, Q., & Qian, W. (2024). Enhancing Kubernetes Automated Scheduling with Deep Learning and Reinforcement Techniques for Large-Scale Cloud Computing Optimization. arXiv preprint arXiv:2403.07905.

Zhu, Mengran, et al. "THE APPLICATION OF DEEP LEARNING IN FINANCIAL PAYMENT SECURITY AND THE CHALLENGE OF GENERATING ADVERSARIAL NETWORK MODELS." The 8th International scientific and practical conference “Priority areas of research in the scientific activity of teachers”(February 27–March 01, 2024) Zagreb, Croatia. International Science Group. 2024. 298 p.. 2024.

Gong, Y., Huang, J., Liu, B., Xu, J., Wu, B., & Zhang, Y. (2024). Dynamic Resource Allocation for Virtual Machine Migration Optimization using Machine Learning. arXiv preprint arXiv:2403.13619.

Zhang, Y., Liu, B., Gong, Y., Huang, J., Xu, J., & Wan, W. (2024). Application of Machine Learning Optimization in Cloud Computing Resource Scheduling and Management. arXiv preprint arXiv:2402.17216.Wang, Yong, et al. "Construction and application of artificial intelligence crowdsourcing map based on multi-track GPS data." arXiv preprint arXiv:2402.15796 (2024).

Xu, X., Xu, Z., Ling, Z., Jin, Z., & Du, S. (2024). Comprehensive Implementation of TextCNN for Enhanced Collaboration between Natural Language Processing and System Recommendation. arXiv preprint arXiv:2403.09718.

Wang, Y., Bao, Q., Wang, J., Su, G., & Xu, X. (2024). Cloud Computing for Large-Scale Resource Computation and Storage in Machine Learning. Journal of Theory and Practice of Engineering Science, 4(03).

Xu, J., Jiang, Y., Yuan, B., Li, S., & Song, T. (2023, November). Automated Scoring of Clinical Patient Notes using Advanced NLP and Pseudo Labeling. In 2023 5th International Conference on Artificial Intelligence and Computer Applications (ICAICA) (pp. 384-388). IEEE.

Xu, Z., Yuan, J., Yu, L., Wang, G., & Zhu, M. (2024). Machine Learning-Based Traffic Flow Prediction and Intelligent Traffic Management. International Journal of Computer Science and Information Technology, 2(1), 18-27.

Wang, Yixu, et al. "Exploring New Frontiers of Deep Learning in Legal Practice: A Case Study of Large Language Models." International Journal of Computer Science and Information Technology 1.1 (2023): 131-138.

Song, B., Xu, Y., & Wu, Y. (2024). ViTCN: Vision Transformer Contrastive Network For Reasoning. arXiv preprint arXiv:2403.09962.

Huang, Zengyi, et al. "Research on Generative Artificial Intelligence for Virtual Financial Robo-Advisor." Academic Journal of Science and Technology 10.1 (2024): 74-80.

Huang, Zengyi, et al. "Application of Machine Learning-Based K-Means Clustering for Financial Fraud Detection." Academic Journal of Science and Technology 10.1 (2024): 33-39.

Che, C., Lin, Q., Zhao, X., Huang, J., & Yu, L. (2023, September). Enhancing Multimodal Understanding with CLIP-Based Image-to-Text Transformation. In Proceedings of the 2023 6th International Conference on Big Data Technologies (pp. 414-418).

Wang, S., Li, N.,Zheng, C., & Wu, Y. (2021). Stochastic joint homecare service and capacity planning with nested decomposition approaches. European Journal of Operational Research, 295(1), 203-222.

Li, X., Zong, Y., Yu, L., Li, L., & Wang, C. (2024, February). OPTIMIZING USER EXPERIENCE DESIGN AND PROJECT MANAGEMENT PRACTICES IN THE CONTEXT OF ARTIFICIAL INTELLIGENCE INNOVATION. In The 8th International scientific and practical conference “Priority areas of research in the scientific activity of teachers”(February 27–March 01, 2024) Zagreb, Croatia. International Science Group. 2024. 298 p. (p. 214).

Du, S., Qian, W., Zhang, Y., Shen, Z., & Zhu, M. (2024, February). IMPROVING SCIENCE QUESTION RANKING WITH MODEL AND RETRIEVAL-AUGMENTED GENERATION. In The 6th International scientific and practical conference “Old and new technologies of learning development in modern conditions”(February 13-16, 2024) Berlin, Germany. International Science Group. 2024. 345 p. (p. 252).

K. Xu, X. Wang, Z. Hu and Z. Zhang, "3D Face Recognition Based on Twin Neural Network Combining Deep Map and Texture," 2019 IEEE 19th International Conference on Communication Technology (ICCT), Xi'an, China, 2019, pp. 1665-1668, doi: 10.1109/ICCT46805.2019.8947113.

Shi, Peng, Yulin Cui, Kangming Xu, Mingmei Zhang, and Lianhong Ding. 2019. "Data Consistency Theory and Case Study for Scientific Big Data" Information 10, no. 4: 137. https://doi.org/10.3390/info10040137.

Zhenghua Hu, Xianmei Wang, Kangming Xu, and Pu Dong. 2020. Real-time Target Tracking Based on PCANet-CSK Algorithm. In Proceedings of the 2019 3rd International Conference on Computer Science and Artificial Intelligence (CSAI '19). Association for Computing Machinery, New York, NY, USA, 343–346. https://doi.org/10.1145/3374587.3374607.

Medication Recommendation System Based on Natural Language Processing for Patient Emotion Analysis. (2024). Academic Journal of Science and Technology, 10(1), 62-68. https://doi.org/10.54097/v160aa61

Li, X., Zheng, H., Chen, J., Zong, Y., & Yu, L. (2024). User Interaction Interface Design and Innovation Based on Artificial Intelligence Technology. Journal of Theory and Practice of Engineering Science, 4(03), 1-8.

Song, T., Li, X., Wang, B., & Han, L. (2024). Research on Intelligent Application Design Based on Artificial Intelligence and Adaptive Interface.

Chen, Jianfeng, et al. "Implementation of an AI-based MRD evaluation and prediction model for multiple myeloma." arXiv preprint arXiv:2403.00842 (2024).

Pan, Linying, et al. "Combine deep learning and artificial intelligence to optimize the application path of digital image processing technology." (2024).

Niu, Hongjie, et al. "Enhancing computer digital signal processing through the utilization of rnn sequence algorithms." International Journal of Computer Science and Information Technology 1.1 (2023): 60-68.

Liu, Beichang, et al. "Machine Learning Model Training and Practice: A Study on Constructing a Novel Drug Detection System." International Journal of Computer Science and Information Technology 1.1 (2023): 139-146.

Wang, Yixu, et al. "Exploring New Frontiers of Deep Learning in Legal Practice: A Case Study of Large Language Models." International Journal of Computer Science and Information Technology 1.1 (2023): 131-138.

Zhou, Yanlin, et al. "A Protein Structure Prediction Approach Leveraging Transformer and CNN Integration." arXiv preprint arXiv:2402.19095 (2024).