Banking business data processing and querying method and device

A banking business and business data technology, applied in the field of data processing, can solve the problems of capacity limitation, processing efficiency and query efficiency reduction, etc.

Pending Publication Date: 2020-05-15
CHINA CONSTRUCTION BANK
View PDF4 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] Most of the existing reporting systems use relational databases such as oracle. If the data size reaches TB or more, the processing efficiency and query efficiency will be seriously reduced. For traditional relational databases, only partial storage or sub-database and sub-table methods can be used. to address capacity constraints

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Banking business data processing and querying method and device
  • Banking business data processing and querying method and device
  • Banking business data processing and querying method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0047] The following will clearly and completely describe the technical solutions in the embodiments of the present invention with reference to the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are only some, not all, embodiments of the present invention. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts belong to the protection scope of the present invention.

[0048] The invention provides a banking business data processing method, such as figure 1 As shown, the processing method includes:

[0049] Step S101, loading the banking business source data stored in the big data node server into the HIVE database;

[0050] Step S102, preprocessing the banking business source data in the HIVE database according to the preset business data dimension;

[0051] Step S103, storing the preprocessed banking business source data...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

Abstract

The invention provides a banking business data processing and querying method and device. The method comprises the following steps: loading banking business source data stored in a big data node server to an HIVE database; preprocessing the banking business source data in the HIVE database according to a preset business data dimension; and storing the preprocessed banking business source data in an HBASE database. According to the method, processing and query of mass data are supported based on a big data technology, the problems of data capacity storage and dimension query efficiency are solved, and the requirements of historical data analysis and rapid dimension display can be effectively met.

Description

technical field [0001] The invention relates to data processing technology, in particular to a bank business data processing and query method and device. Background technique [0002] According to the needs of the financial industry, it is necessary to provide queries on various dimensions of related transactions to support the development of marketing activities and assessments of business departments. [0003] Most of the existing reporting systems use relational databases such as oracle. If the data size reaches TB or more, the processing efficiency and query efficiency will be seriously reduced. For traditional relational databases, only partial storage or sub-database and sub-table methods can be used. to address capacity constraints. Contents of the invention [0004] In order to meet the bank's requirements for historical data analysis and fast display in different dimensions, and to realize massive data processing and query, an embodiment of the present invention ...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
Patent Type & Authority Applications(China)
IPC IPC(8): G06Q40/02G06Q40/04
CPCG06Q40/02G06Q40/04
Inventor 张世宜李杨
Owner CHINA CONSTRUCTION BANK
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap