Unlock instant, AI-driven research and patent intelligence for your innovation.

Mass fund transaction data information analysis method and system

A technology of transaction data and data statistics, applied in the field of data analysis, can solve problems such as low efficiency and irregular processing methods

Pending Publication Date: 2021-03-30
北京宸瑞科技股份有限公司
View PDF5 Cites 1 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] Due to the existence of the above-mentioned problems, based on years of experience in financial data and intelligence analysis, combined with emerging technologies such as databases and big data, the inventor proposed a method for intelligence analysis of massive capital transaction data of hundreds of thousands or more, which not only solved the problem of data volume It also solves the problem of non-standard processing methods and low efficiency, and has been recognized by front-line business personnel in actual use

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
  • Mass fund transaction data information analysis method and system
  • Mass fund transaction data information analysis method and system
  • Mass fund transaction data information analysis method and system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment

[0161] Obtain the fund transaction data stored in multiple Excel files from the anti-money laundering center. Each Excel file has a Sheet page of fund transaction details. There are multiple independent tables in the fund transaction details. Each form records a certain account For the detailed data of capital transactions (indicated by the name of the person or the name of the company), the data structure of each table is the same, and there are blank lines between the tables. The fields of each form are: serial number, transaction time, transaction method, account number of payer, name of payer, ID number of payer, bank of payer, account number of payee, name of payee, ID number of payee, receipt Party bank, currency name, original currency amount, transaction record ID, reporting institution, place of transaction, purpose, classification of foreign-related receipts and payments, name of agent, and certificate number of agent.

[0162] In each Excel file, display all hidden ...

experiment example 1

[0185] The data obtained by the anti-money laundering center is analyzed for the target account, and the data information is shown in Table 10.

[0186] Table 10

[0187] Attributes Data Sources Number of Excel files The amount of data data size value Anti-Money Laundering Center 14 1.15 million 284MB

[0188] Note: The number of tables that record the detailed data of capital transactions of an account corresponds to a data volume.

[0189] The target account analysis is performed using the traditional method of using an Excel table and the analysis method of the present invention, and the comparison of the time used is shown in Table 11.

[0190] Table 11

[0191]

experiment example 2

[0193] During the analysis of a certain case, statistics were carried out according to the method shown in the patent, and compared with the original manual statistics results of business personnel, it was found that the amount involved in the statistics was larger than the amount involved in manual statistics. After further analysis, it was found that the detailed data of capital transactions were retrieved multiple times, and the business personnel only used the data retrieved for the first time in the process of manual statistics, and the data retrieved several times later were omitted. However, with the method of the present invention, all data are aggregated and merged, so there is no missing data, and the amount involved is also larger, which shows that the analysis method shown in the present invention is conducive to the accuracy of target account positioning and reduces the probability of errors and omissions in manual statistics. .

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 mass fund transaction data information analysis method and system. The method is realized through the following steps: performing data acquisition; merging the data; importinginto a database; cleaning the data; performing data statistics; performing analysis, research and judgment. According to the invention, data in a plurality of Excel files are merged and imported intothe database by utilizing the large-capacity characteristic of the database, and cleaning, duplicate removal, statistics, analysis, research and judgment and other work are completed by using SQL statements in the database, so that the limitation that only tens of thousands of data can be processed by the Excel files is broken through, hundreds of thousands of fund transaction data can be processed normatively and efficiently, statistics is carried out to obtain the potential relation between payers and payees, a relatively high application effect is achieved in the fields of financial data overall analysis and police criminal investigation, and the value of the data is improved.

Description

technical field [0001] The invention belongs to the field of data analysis, and relates to the analysis of capital transaction data, in particular to an intelligence analysis method and system for massive capital transaction data, which is suitable for intelligence analysis in the fields of finance, public security, security, and customs anti-smuggling. Background technique [0002] With the development of the economy, there are more and more financial data, and departments such as finance, public security, security, and customs anti-smuggling increasingly need to conduct intelligence analysis on capital transaction data in their work. Intelligence analysis of capital transaction data is a new thing. At present, the analysis method of business personnel is based on manual analysis of spreadsheets such as Excel, which can only analyze a small amount of data of less than tens of thousands each time, and cannot analyze more than hundreds of thousands or more There is a huge amo...

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/04G06F16/215G06F16/2458
CPCG06Q40/04G06F16/215G06F16/2462
Inventor 孙二林王丽薇
Owner 北京宸瑞科技股份有限公司