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

Method for improving table processing speed based on dynamic tuning

A table processing and speed technology, applied in the field of improving table processing speed based on dynamic adjustment, can solve problems such as difficult output and data processing troubles, and achieve the effects of ease of use, improved processing speed, and clear data structure

Pending Publication Date: 2022-05-27
首约科技(北京)有限公司
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] At present, a large amount of data of Shouqi Company comes from the aggregation platform. Passengers only need to visit the aggregation platform and enter the address of getting on and off the car to generate request data. Only a very small part of these request data will place an order on the platform, but this part of the data cannot be discarded. Therefore, it is very troublesome to process hundreds of millions of data every day, and the output is also difficult.

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
  • Method for improving table processing speed based on dynamic tuning
  • Method for improving table processing speed based on dynamic tuning
  • Method for improving table processing speed based on dynamic tuning

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0023] This embodiment provides a specific implementation of a method for improving table processing speed based on dynamic adjustment, such as figure 1 shown, including the following steps:

[0024] S1 distinguishes between dynamic price adjustment orders and non-price adjustment orders in the forecast table;

[0025] S2 stores the dynamic price adjustment order information in the dynamic adjustment storage table;

[0026] S3 connects the order number in the dynamic storage table with the order number in the forecast table to obtain the required coefficient.

[0027] Further, in step S1, the price adjustment order and non-price adjustment order are distinguished in the forecast table, including:

[0028] The dynamic_doubly_amount_price field is parsed through the get_json_object function. If the total coefficient of price adjustment is analyzed > 0, a dynamic price adjustment will be generated. If the parsed result is null, no dynamic price adjustment will be performed.

...

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 method for improving table processing speed based on dynamic adjustment. The method comprises the following steps: S1, distinguishing dynamic adjustment price adjustment orders and non-price adjustment orders in a pre-estimation table; s2, storing the dynamic dispatch price adjustment order information in a dynamic dispatch storage table; s3, the order numbers in the pre-estimation table are connected with the order numbers in the dynamic dispatching storage table, and needed coefficients are obtained.The method is suitable for the technical field of online car-hailing, and compared with a previous method that full analysis is carried out on the pre-estimation table with the large magnitude and a new dynamic dispatching storage table is added, only 20% of dynamic dispatching data needs to be reprocessed, analysis on unnecessary analysis fields is reduced, and the efficiency is improved. The processing speed is improved, and compared with the situation that when the dynamic call data is stored in one field of the full-amount pre-estimation table, the storage content of the field is complex and difficult to check, the data structure stored in the newly-built dynamic call storage table is clearer and easy to use.

Description

technical field [0001] The invention belongs to the technical field of online car-hailing, in particular to a method for improving table processing speed based on dynamic adjustment. Background technique [0002] As online car-hailing travel has gradually become people's daily life, the amount of data on the online car-hailing platform is also increasing, and the data must be produced on time every day, so the requirements for data processing are also more stringent. [0003] At present, a large amount of data of Shouqi Company comes from the aggregation platform. Passengers only need to visit the aggregation platform and enter the address of getting on and off the car to generate request data. Only a very small part of these request data will place an order on the platform, but this part of the data cannot be discarded. Therefore, it is very troublesome to process hundreds of millions of data every day, and the output is also difficult. However, with the development of the...

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): G06Q10/06G06Q30/02G06Q50/30
CPCG06Q10/06312G06Q30/0206G06Q50/40
Inventor 杨一帆
Owner 首约科技(北京)有限公司
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