Supercharge Your Innovation With Domain-Expert AI Agents!

Sub-table data processing method and device

A technology for data processing and table division, applied in the computer field, can solve the problem of low ability and efficiency in processing sub-table data, and achieve the effect of reducing data processing pressure, improving performance, and avoiding the problem of redundant cycles.

Pending Publication Date: 2020-03-06
BEIJING JINGDONG SHANGKE INFORMATION TECH CO LTD +1
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] In view of this, the embodiment of the present invention provides a method and device for sub-table data processing, which can solve the problem of aggregating all processing results due to the need to cycle through all data tables to obtain the processing results in each data table. The ability and efficiency of processing sub-table data caused by the problem

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
  • Sub-table data processing method and device
  • Sub-table data processing method and device
  • Sub-table data processing method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0026] Exemplary embodiments of the present invention are described below in conjunction with the accompanying drawings, which include various details of the embodiments of the present invention to facilitate understanding, and they should be regarded as exemplary only. Accordingly, those of ordinary skill in the art will recognize that various changes and modifications of the embodiments described herein can be made without departing from the scope and spirit of the invention. Also, descriptions of well-known functions and constructions are omitted in the following description for clarity and conciseness.

[0027] figure 1 is a schematic diagram of the basic flow of the method for processing sub-table data according to an embodiment of the present invention. Such as figure 1 As shown, the embodiment of the present invention provides a method for sub-table data processing, including:

[0028] Step S101. Obtain the data to be processed and the instruction of dynamic structur...

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 sub-table data processing method and device, and relates to the technical field of computers. A specific embodiment of the method comprises the steps of obtaining to-be-processed data and an instruction of a dynamic structured query language; judging whether the to-be-processed data carries a primary key or not; if so, determining a data table corresponding to the to-be-processed data according to a data table number in the primary key; and in the data table, processing the to-be-processed data according to the instruction of the dynamic structured query language. According to the embodiment, the technical means of directly and correctly positioning the data table according to the primary key is adopted. All data tables needing to be operated do not need to be circulated, the problem of circulation redundancy caused by the complexity of database composition is effectively avoided, the efficiency of processing the sub-table data is improved, then the pressure of processing the data in the database is reduced, and the performance of the database is improved.

Description

technical field [0001] The invention relates to the field of computer technology, in particular to a method and device for processing sub-table data. Background technique [0002] Table splitting can refer to storing data originally stored in one table in blocks into multiple data tables, and table splitting data can refer to data stored in each data table after table splitting. For the processing of sub-table data, in the prior art, since the data table storing the data to be processed cannot be directly located, the data records corresponding to all tables can only be queried globally, that is, processing operations such as query, modification, and deletion all need to be cycled. For all the data tables, the processing results in each data table are obtained, and then all the processing results are aggregated. [0003] In the process of implementing the present invention, the inventors have found at least the following problems in the prior art: the performance and effici...

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/22G06F16/242G06F16/2455
Inventor 叶强董旭
Owner BEIJING JINGDONG SHANGKE INFORMATION TECH CO LTD
Features
  • R&D
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More