Data deriving method and device

A data export and database technology, applied in the database field, can solve problems such as time-consuming and inability to complete file export tasks, and achieve the effect of improving export efficiency

Inactive Publication Date: 2018-11-13
CHINA CONSTRUCTION BANK
View PDF5 Cites 8 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Although the existing methods can also achieve data export, but in the case of large export files and complex query statements, there is a shortage of time-consuming, and even the file export task cannot be completed

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 deriving method and device
  • Data deriving method and device
  • Data deriving method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0049] 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. The components of the embodiments of the invention generally described and illustrated in the figures herein may be arranged and designed in a variety of different configurations. Accordingly, the following detailed description of the embodiments of the invention provided in the accompanying drawings is not intended to limit the scope of the claimed invention, but merely represents selected embodiments of the invention. Based on the embodiments of the present invention, all other embodiments obtained by those skilled in the art without making creative efforts belong to the protection scope of the present invention.

[0050] It should be noted that like numerals and let...

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 embodiment of the invention provides a data deriving method and device. The method is applied to a server, and a database is stored in the server; the method comprises the following steps: splitting a query sentence corresponding to a data deriving demand into multiple sub-query sentences; controlling multiple sub-progresses to respectively execute a sub-query sentence in the database in a parallel way, thereby querying the database in parallel; after controlling multiple sub-progresses to obtain the target data corresponding to the executed sub-query sentence, storing the target data in the data file. By splitting the query sentence into multiple sub-query sentences and executing the sub-query sentence in parallel through multiple sub-progresses, the data deriving efficiency can be greatly improved.

Description

technical field [0001] The present invention relates to the technical field of databases, in particular to a data export method and device. Background technique [0002] A huge software system is usually composed of subsystems that implement various functional modules, and each subsystem divides labor and cooperates in line with the design concept of "high cohesion and low coupling". In this cooperation mode, data sharing between systems is particularly important. Among them, data sharing between systems is mainly realized by exporting files from the upstream system and pushing them to the downstream system. [0003] Taking oracle as an example, generally by calling the built-in SPOOL tool to unload data, so as to realize data export. Specifically, the query statement is encapsulated into the SPOOL statement, then the database is connected, and the encapsulated SPOOL statement is executed to obtain the data file. Although the existing method can also realize data export, ...

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 CHINA CONSTRUCTION BANK
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