一种应用于金融业务的数据仓库构建方法、装置和电子设备

• Format: Patent
• Language: Chinese
• Published: 27.08.2024
• Subjects: CALCULATING; COMPUTING; COUNTING; DATA PROCESSING SYSTEMS OR METHODS, SPECIALLY ADAPTED FORADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL, SUPERVISORYOR FORECASTING PURPOSES; ELECTRIC DIGITAL DATA PROCESSING; PHYSICS; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE,COMMERCIAL, FINANCIAL, MANAGERIAL, SUPERVISORY OR FORECASTINGPURPOSES, NOT OTHERWISE PROVIDED FOR

本发明提供了应用于金融业务的数据仓库构建方法、装置和电子设备。本发明的数据仓库的构建方法包括：获取来自数据库服务器或数据库服务器集群中的多个源数据表，其中，所述数据库服务器或数据库服务器集群为多个金融业务应用提供数据服务；根据所述多个金融业务应用涉及的业务主题对所述多个源数据表进行归并，生成以业务主题区分的多个归并数据表；为所述各归并数据表提供索引，构建数据仓库。本发明的数据仓库能够快速准确地提供报表，或者可快速访问数据库表中的特定信息，整合分类后的归并数据表使得支持大型表和索引更容易，同时也提高了数据管理和查询性能。 The invention provides a data warehouse construction method and device applied to financial services and electronic equipment. The construction method of the data warehouse comprises the steps that aplurality of source data tables from a database server or a database server cluster are obtained, and the database server or the database server cluster provides data services for a plurality of financial business applications; the plurality of source data tables are merged according to service subjects involved in the plurality of financial service applications to generate a plurality of merged data tables distinguished by the service subjects; and indexes for the merged data tables are provided, and a data warehouse is constructed. The data warehouse can