Data processing method

A data processing and data technology, applied in the distributed field, can solve the problems of low data processing performance efficiency, low database performance, and inability to accurately locate, etc., to achieve the effect of improving processing performance, improving ability, and avoiding scanning

Active Publication Date: 2014-07-23
ADVANCED NEW TECH CO LTD
View PDF3 Cites 20 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, in the application system of distributed database, the sub-database and sub-table mode is usually adopted, and the first system cannot determine which sub-database and which sub-table the data corresponding to the interaction number returned by the second system exists in (that is, it is not sure whether an item The database table containing the data information of the business data), must scan all the database tables one by one, that is, the database full table scan traversal, to find the database table where a certain data is located, which is inefficient, and it cannot accurately locate the database table where the data is stored, so It has a great impact on system performance, especially database performance, resulting in defects such as reduced data processing performance efficiency, low overall processing performance of application systems, and increased database overhead.
Even if the single database mode is used, its scalability is poor, and the amount of business data is easy to grow to a situation that cannot be supported by a single database table (low database performance)

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 processing method
  • Data processing method
  • Data processing method

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0023] Embodiment 1 provides a data processing method. refer to figure 1 , figure 1 It is a schematic diagram of Embodiment 1 of the solution of this application, that is, the processing of data transferred between systems is improved: the storage of data is organized in the first system, and the obtained and stored data is transferred to the second system responsible for business processing Processing, such as the following steps a to e; the process of returning the data after business processing to the first system to update the stored data, such as the following steps f to i. Positioning data is fast, improving overall system performance.

[0024] a. Obtain one item of data 101 among one or more items of data to be processed, said item of data includes business data 102, for example, the item of data "2012.10.01, Zhang San, 123.45" is obtained, wherein Contains the business data of "123.45".

[0025] b. Generate the interaction number 105 and the number 107 correspondin...

Embodiment 2

[0036] Embodiment 2 provides a data processing method. refer to figure 2 , figure 2 It is a schematic diagram of Embodiment 2 of the present application. Similar to Embodiment 1, the inter-system data processing method is improved to improve the overall system processing performance (see the specific description of Embodiment 1). It further optimizes Example 1.

[0037] a. Obtain one item of data 201 among one or more items of data to be processed, said item of data includes business data 202, for example, acquire the item of data "2012.10.01, Zhang San, 123.45", where Contains the business data of "123.45".

[0038] b. Generate an interaction number 205 and a number 207 corresponding to the interaction number for the item of data according to the predetermined rule 203 . Like Embodiment 1, there can be various predetermined rules. Here, for example, the predetermined rule 203 includes a first predetermined rule 204 and a second predetermined rule 206 , an interaction ...

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 data processing method. The method includes the steps that one of one or more items of data including service data is obtained, wherein the one or more items of data wait for service processing; according to a preset rule, an interaction number and a serial number corresponding to the interaction number are generated for one item of data; a mapping table is established for generating a mapping relation between the interaction number and the serial number; one item of data, the interaction number and the serial number are stored at storage positions in a sub-library and a sub-table in a main database, wherein the sub-library and the sub-table correspond to the one item of data and are indicated by the serial number; the service data of the one item of data and the interaction number are sent to perform service processing. According to the method, a storage seeking mode of a distributed system is improved, the library and table where the data are located can be accurately positioned, all libraries and all tables in the database are prevented from being scanned, the overhead for the database is reduced, and the capacity for processing the data through the system is improved.

Description

technical field [0001] The present application relates to the field of distributed technology, and in particular to a data processing method for interaction between multiple systems in a distributed system. Background technique [0002] When transferring a piece of data between two (or more) systems, usually the first system will generate a fixed-length interaction number according to the requirements of the second system, and store the data in one of the databases of the first system. The sub-database and a sub-table in the sub-database will then send the data including the interaction number to the second system, and the second system will return the interaction number and data to the first system after processing. However, in the application system of distributed database, the sub-database and sub-table mode is usually adopted, and the first system cannot determine which sub-database and which sub-table the data corresponding to the interaction number returned by the seco...

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): G06F17/30
CPCG06F16/2453G06F16/27
Inventor 滕国凯
Owner ADVANCED NEW TECH 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