Financial data storage method and device based on HBase and storage medium

A financial data and storage system technology, applied in finance, data processing applications, structured data retrieval, etc., can solve the problems of inability to achieve reasonable storage of massive financial data, high-frequency query and fast calculation, etc., and achieve the effect of not being easily lost

Inactive Publication Date: 2019-05-31
成都有据量化科技有限公司
View PDF3 Cites 7 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] Embodiments of the present disclosure provide an HBase-based financial data storage method, device, and storage medium to at least solve the existing problems in the prior art due to the storage

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
  • Financial data storage method and device based on HBase and storage medium
  • Financial data storage method and device based on HBase and storage medium
  • Financial data storage method and device based on HBase and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0021] According to this embodiment, a method embodiment of an HBase-based financial data storage method is provided. It should be noted that the steps shown in the flow chart of the accompanying drawings can be executed in a computer system such as a set of computer-executable instructions , and, although a logical order is shown in the flowcharts, in some cases the steps shown or described may be performed in an order different from that shown or described herein.

[0022] The method embodiment provided in this embodiment can be executed in a mobile terminal, a computer terminal or a similar computing device. figure 1 It shows a hardware structural block diagram of a computer terminal (or mobile device) for realizing the HBase-based financial data storage method. Such as figure 1 As shown, the computer terminal 10 (or mobile device 10) may include one or more (shown by 102a, 102b, ..., 102n in the figure) processor 102 (the processor 102 may include but not limited to a mic...

Embodiment 2

[0066] Figure 6 The HBase-based financial data storage device 600 according to this embodiment is shown, and the device 600 corresponds to the method according to the first aspect of Embodiment 1. refer to Figure 6 As shown, the device 600 includes: a calling module 610, used to call a financial data file; a first generating module 620, used to generate row keys according to the parameter values ​​of multiple attributes included in the financial data file, wherein multiple The attributes include at least any one of the following: stock code, stock type, transaction date and transaction time; and an import module 630, configured to import the financial data in the financial data file into the HBase storage system according to the row key.

[0067] Optionally, the first generating module 620 includes: a first determining submodule, configured to determine the serial number of the trading day, where the serial number of the trading day is used to indicate the order in which th...

Embodiment 3

[0077] Figure 7 The HBase-based financial data storage device 700 according to this embodiment is shown, and the device 700 corresponds to the method according to the first aspect of Embodiment 1. refer to Figure 7 As shown, the device 700 includes: a processor 710; and a memory 720, connected to the processor 710, used to provide the processor 710 with instructions for processing the following processing steps: call the financial data file; The parameter value of attribute, generate row key, wherein multiple attributes include at least any one of following: stock code, stock type, transaction date and transaction time; And according to row key, the financial data in the financial data file is imported into HBase storage system .

[0078] Optionally, according to the parameter values ​​of multiple attributes included in the financial data file, the operation of generating the row key includes: determining the serial number of the transaction date, wherein the serial number...

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 discloses a financial data storage method and device based on HBase and a storage medium. The method comprises the following steps: calling a financial data file; generating a row key according to parameter values of a plurality of attributes included in the financial data file, the plurality of attributes including at least one of the following items: stock code, stock type, transaction date and transaction time; and importing financial data in the financial data file into an HBase storage system according to the row key. According to the method and the device, a large amount oftransaction data in the financial field are stored in the HBase storage system, so that the technical effects of reasonable storage of the financial data and rapid query and calculation of services are realized. Furthermore, the technical problem that in the prior art, due to the fact that financial data are stored in a relational database, a local disk or a data warehouse, reasonable storage, high-frequency query and rapid calculation of mass financial data cannot be achieved is solved.

Description

technical field [0001] The present application relates to the field of financial data storage, in particular to an HBase-based financial data storage method, device and storage medium. Background technique [0002] Financial data, involving stocks, options, futures in the financial field, and data records from the opening to the closing of each trading day, the data records are at the millisecond level, resulting in a relatively large historical base and daily increment of such data, such a massive amount of historical data And daily incremental data poses a huge challenge to the fast query and analysis of storage devices and services. At present, financial data is stored and processed mainly by relational database or directly stored on local disk. The storage and query calculation efficiency of this kind of storage method is low, and it cannot serve the quantitative analysis and trading business in the financial field with the characteristics of high frequency, real time, ...

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/27G06Q40/04
Inventor 胡荣德李亮亮张昱曹良城
Owner 成都有据量化科技有限公司
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