基于数据仓库技术的小微企业融资增信综合信息系统设计  

Design of Integrated Information System for Small and Micro Enterprises Based on Data Warehouse Technology

作　　者：孟灿 翁巍 庞泰 赵蕾 高玲玲 MENG Can;WENG Wei;PANG Tai;ZHAN Lei;GAO Lingling(Qinghai Provincial Center For Public Credit Information,Qinghai Xining 810001 China)

机构地区：[1]青海省公共信用信息中心,青海西宁810001

出　　处：《长江信息通信》2024年第9期137-139,共3页Changjiang Information & Communications

摘　　要：为解决小微企业融资增信综合信息自异构源的业务数据,系统负担增大的问题,文章提出基于数据仓库技术的小微企业融资增信综合信息系统设计。硬件方面采用AMD EPYC 7002处理器与RAID存储器,软件方面则先设计增信综合信息集成程序,从不同数据源采集融资相关数据并整合到统一数据仓库。再利用数据分区、索引、压缩等技术二次整合数据。测试结果显示,该系统性能更佳,CPU占有率低,能快速响应客户,应用效果较好。该研究为小微企业融资增信业务的信息化提供了有效解决方案。To solve the problem of increased system burden caused by heterogeneous business data sources of financing and credit enhancement comprchensive information for small and micro enterprises,the paper proposes the design of a small and micro enterprise financing and credit cnhancement comprchensive information system based on data warchouse technology.In terms of hardware,AMD EPYC 7o02 processor and RAID memory are used,while in terms of software,a comprehensive information integration program is designed to collect financing related data from different data sources and integrate them into a unified data warchouse.Reuse techniques such as data partitioning,indexing,and compression to integrate data again.The test results show that the system has better performance,lower CPU usage,can quickly respond to customers,and has good application effects.The study provides an effective solution for the informatization of financing and credit cnhancement business for small and micro enterprises.

关 键 词：数据仓库技术 小微企业 融资 增信 综合信息 

分 类 号：P208[天文地球—地图制图学与地理信息工程]