Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Data treatment method and system oriented to settlement for account

A data processing and data technology, which is applied in the field of data processing, can solve the problems of query database index failure and stuckness, etc., and achieve the effects of avoiding multiple queries, saving hardware costs, and improving the efficiency of account settlement

Inactive Publication Date: 2017-12-19
深圳市爱贝信息技术有限公司
View PDF8 Cites 3 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0009] Assuming that the transaction details have a data volume of 1000W, it needs to be queried and stored three times, and the query details are summarized several times. The performance of such a settlement process can be imagined. In addition, when a certain amount of data is reached, it will cause time conditions to query the database. The index fails and the full table is scanned, resulting in a stuck situation. If it is fast in a quasi-production environment, it will take more than ten hours to run out of the settlement data

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
  • Data treatment method and system oriented to settlement for account
  • Data treatment method and system oriented to settlement for account
  • Data treatment method and system oriented to settlement for account

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0043] Embodiments of the technical solutions of the present invention will be described in detail below in conjunction with the accompanying drawings. The following examples are only used to illustrate the technical solution of the present invention more clearly, so they are only examples, and should not be used to limit the protection scope of the present invention.

[0044] It should be noted that, unless otherwise specified, the technical terms or scientific terms used in this application shall have the usual meanings understood by those skilled in the art to which the present invention belongs.

[0045] In the first aspect, an account settlement-oriented data processing method provided by an embodiment of the present invention combines image 3 , the method includes:

[0046] Step S1, pulling transaction detail data.

[0047] Step S2, fill in the transaction detail data according to different dimension tables, such as filling in the corresponding merchant name, channel ...

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 belongs to the technical field of data treatment, and provides a data treatment method and system oriented to settlement for account. The method includes the steps of pulling transaction detail data, filling the transaction detail data according to different dimension tables to form a data wide-table, calculating the data wide-table according to different account time to obtain an account data table oriented to different themes, and collecting data with business sense from the data wide-table or the account data table. By means of the method and system, data of different accounts can be accurately calculated, the accounts can be rapidly closed, and hardware cost is reduced.

Description

technical field [0001] The invention relates to the technical field of data processing, in particular to a data processing method and system for account period settlement. Background technique [0002] At present, with the rise of new transaction models such as Internet+, Alipay, and WeChat, the company's business transaction volume has increased sharply, and the traditional relational database has highlighted its weaknesses in storage and computing. Quasi-production environments sometimes fail to run out of settlement data. [0003] The amount of data processing is large, and the requirements for hardware devices, such as server computing power, memory, disk IO, and single point of failure, are getting higher and higher. Enterprises need to use high hardware costs to support processing and storage of tens of millions of data volumes. At the same time, overseas travel is booming, and merchants hope to support the same services at home and abroad, and have put forward require...

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
IPC IPC(8): G06F17/30G06Q40/00
CPCG06F16/254G06F16/215G06F16/283G06Q40/12
Inventor 丘越崑
Owner 深圳市爱贝信息技术有限公司
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com