A streaming transaction processing method and system

A transaction processing and streaming technology, applied in the field of stream transaction processing, can solve the problem of low efficiency, and achieve the effect of lowering the development threshold, saving transaction processing time, and reducing development time.

Active Publication Date: 2019-06-21
BORRUI DATA TECH (BEIJING) CO LTD
View PDF9 Cites 3 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] The biggest problem with this approach is that it is not efficient, especially when the overhead cost of executing the query is small relative to the overhead cost of the query itself (especially including RPC overhead)

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
  • A streaming transaction processing method and system
  • A streaming transaction processing method and system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0041] In order to make the object, technical solution and advantages of the present invention clearer, the present invention will be further described in detail below in conjunction with the accompanying drawings. It should be understood that the specific embodiments described here are only used to explain the present invention, and are not intended to limit the present invention.

[0042] Such as figure 1 As shown, the present invention provides a streaming transaction processing method, wherein each transaction needs to perform a parameterized query on a relational database, and the parameterized query obtains at least one input from each transaction; including the following steps:

[0043] S1. Identify the input of the parameterized query obtained from the transaction;

[0044] S2. Create a parameter table for storing the input of the parameterized query;

[0045] S3. Transforming the parameterized query into an equivalent query including a connection with a parameter ta...

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 streaming transaction processing method and system. The method comprises the following steps: S1, identifying input of parameterized queries obtained from transactions; S2, creating a parameter table used for storing input of parametric query; S3, converting the parameterized query into an equivalent query connected with the parameter table; S4, filling the input of the identified parameterized query into a parameter table; S5, judging whether the parameter table is fully filled or not, and if not, returning to the step S4; If yes, executing a step S6; S6, applying the equivalent query relation database to generate a result set, and inserting an output value of the result set into a corresponding transaction; S7, judging whether the transaction is the last transaction or not, and if yes, finishing transaction processing; And if not, deleting the parameter table, and returning to the step S1. The method and the system have the advantages that the processing efficiency of the streaming transaction is improved, and the processing time is saved.

Description

technical field [0001] The present invention relates to the field of stream transaction processing, in particular to a stream transaction processing method and system. Background technique [0002] In many streaming transaction processing systems, it is necessary to execute queries against traditional relational databases driven by the values ​​in the streaming data. For example, in a typical streaming environment, a stream of records or objects containing various data fields arrives continuously at a transaction processing system. In order to process a typical transaction, it is necessary to execute a regular SQL query on each record in the stream, where the input to the SQL query is taken from selected field values ​​in that record. Also, in many cases the output values ​​from the SQL query will be placed back into fields on that record so that the record can be further processed downstream of the SQL query lookup. For example, a billing processing system might receive a...

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): G06F16/24
Inventor 刘睿民
Owner BORRUI DATA TECH (BEIJING) CO LTD
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