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

A data laying method and device

A bottom-laying and data-based technology, applied in the field of data processing, can solve problems such as low efficiency and long execution time, and achieve the effect of ensuring efficiency, ensuring bottom-laying efficiency, and avoiding extremely long execution time

Inactive Publication Date: 2018-12-11
BANK OF CHINA
View PDF5 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, this method is inefficient, and there will be a problem of extremely long execution time when faced with large data volume requirements

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 data laying method and device
  • A data laying method and device
  • A data laying method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0046] The following will clearly and completely describe the technical solutions in the embodiments of the present invention with reference to the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are only some, not all, embodiments of the present invention. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts belong to the protection scope of the present invention.

[0047] An embodiment of the present invention provides a method for laying the groundwork for data. The method flow chart of the method is as follows figure 1 shown, including the following steps:

[0048] S10. Obtain the source table and laying conditions, where the laying conditions at least include partition rules and laying parallelism.

[0049] In this embodiment, the source table can be obtained from the source table table name based on the script or di...

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 laying method and device. The method comprises the following steps: obtaining a source table and a laying condition, wherein the laying condition at least comprises a zoning rule and a laying parallelism degree; partitioning the source table according to the partitioning rules to obtain the partition of the source table; selecting the target source table partition tobe paved from the source table partition according to the pavement parallelism degree; using the data of the target source table partition for laying, and judging whether the number of the target source table partitions in the laying state is less than the laying parallelism degree at the same time; if so, returning the method to perform the step of selecting the target source table partition to be paved from the source table partition according to the pavement parallelism degree. The invention realizes the depth implementation of the data laying, ensures the laying efficiency, and reduces oreven avoids the problem of extremely long execution time in the face of the basic requirement of large amount of data.

Description

technical field [0001] The present invention relates to the technical field of data processing, and more specifically, to a data laying method and device. Background technique [0002] The underlying data is a large amount of data stored in the database according to business logic before the performance test, except for the database dictionary table. It has no actual impact on the business logic of the system, but it has a great impact on the performance of the system. [0003] At this stage, in the process of preparing the underlying data, serial processes are often used, such as the loop loop in the storage process to insert the source table data into the target table in a circular manner. However, this method is inefficient, and there will be a problem of extremely long execution time when faced with large data volume requirements. Contents of the invention [0004] In order to solve the above problems, the present invention provides a method and device for laying 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): G06F17/30
Inventor 杜庆
Owner BANK OF CHINA
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