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

Statistical method and device of database

A statistical method and database technology, applied in the field of data processing in financial technology, can solve the problems of single statistical method of in-memory database and inability to meet the needs of business statistics.

Active Publication Date: 2020-01-24
WEBANK (CHINA)
View PDF11 Cites 6 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

The existing in-memory database has a relatively simple statistical method, only counting and accumulation. If you want to realize complex business statistics, you need to perform additional calculation operations, which cannot meet the complex business statistical needs in actual scenarios.

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
  • Statistical method and device of database
  • Statistical method and device of database
  • Statistical method and device of database

Examples

Experimental program
Comparison scheme
Effect test

specific Embodiment 1

[0136] The statistical scenario of the specific embodiment 1 is to count the number of logins of user B, and the statistical request is a counting request, and the specific process includes:

[0137] The counting interface receives the counting request, and the counting request includes the user ID of user B.

[0138] According to the counting request, the counting interface determines that the data structure corresponding to the operation interface of the Redis database is a String (character string), then generates a counting operation instruction corresponding to the String, and the counting operation instruction includes the user ID.

[0139] The counting interface sends counting operation instructions to the operation interface of the Redis database.

[0140] After the Redis database receives the counting operation command, it searches the corresponding Value (value) in the database according to the statistical key (key), that is, the user ID, and automatically increases ...

specific Embodiment 2

[0143] The statistical scenario of the second specific embodiment is to count the accumulated payment amount of user C, and the statistical request is an accumulation request, and the specific process includes:

[0144] The accumulation interface receives the accumulation request, and the accumulation request includes the user ID of user C.

[0145] According to the accumulation request, the accumulation interface determines that the data structure corresponding to the operation interface of the Redis database is a String (character string), and generates an accumulation operation instruction corresponding to the String, and the accumulation operation instruction includes the user ID.

[0146] The accumulation interface sends the accumulation operation instruction to the operation interface of the Redis database.

[0147] After the Redis database receives the accumulation operation command, it searches the corresponding Value in the database, that is, the payment amount, accor...

specific Embodiment 3

[0150] The statistical scenario of the specific embodiment three is how many users have logged in on the statistical device D, and the statistical request is a deduplication counting request. The specific process includes:

[0151] The de-duplication counting interface receives the de-duplication counting request, and the accumulation request includes the device ID of the device D.

[0152] According to the de-duplication counting request, the de-duplication counting interface determines that the data structure corresponding to the operation interface of the Redis database is a Set (collection), and generates a de-duplication counting operation instruction corresponding to the Set, which includes a device ID.

[0153] The deduplication counting interface sends deduplication counting operation instructions to the operation interface of the Redis database.

[0154] After the Redis database receives the deduplication counting operation command, it searches the corresponding Value...

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 relates to the technical field of data processing in fintech, in particular to a statistical method and device of a database, which are used for simplifying a statistical process based on a memory type database and reducing statistical time. The method comprises: a statistical interface receiving a statistical request; generating an operation instruction for an operation interface ofa memory type database according to the statistical request; sending the operation instruction to an operation interface corresponding to the memory type database; receiving an operation response sent by the memory type database; determining a statistical result according to the operation response; feeding back of the statistical results.

Description

technical field [0001] The invention relates to the technical field of data processing in financial technology (Fintech), in particular to a statistical method and device for a database. Background technique [0002] With the continuous development of financial technology, especially Internet technology and finance, more and more technologies (such as distributed, blockchain, artificial intelligence, etc.) Requirements, such as statistical procedures for databases. [0003] An in-memory database is a database that stores data directly in memory. Compared with disk, the data read and write speed of memory is several orders of magnitude higher. Saving data in memory can greatly improve the performance of applications than accessing it from disk. The existing in-memory database has a relatively simple statistical method, only counting and accumulation. If you want to realize complex business statistics, you need to perform additional calculation operations, which cannot meet ...

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): G06F16/25G06F16/2458
CPCG06F16/25G06F16/2462
Inventor 付洋沈剑殷跃
Owner WEBANK (CHINA)
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