Method and device for extracting data

A technology for extracting data and configuring tables, which is applied in the computer field and can solve problems such as low data extraction efficiency, long data extraction cycle, and inability to meet individualized data requirements

Pending Publication Date: 2019-08-09
BEIJING JINGDONG SHANGKE INFORMATION TECH CO LTD +1
View PDF6 Cites 1 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] In the process of realizing the present invention, the inventor found that there are at least the following problems in the prior art: the first solution generally can only meet the common data requirements, but can...

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 and device for extracting data
  • Method and device for extracting data
  • Method and device for extracting data

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0037] 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.

[0038] It should be noted that, in the case of no conflict, the embodiments of the present invention and the features in the embodiments can be combined with each other.

[0039] Before introducing the embodiments of the present invention in detail, some technical terms involved in the embodiments of the present invention will be described first.

[0040] SQL: Structured ...

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 and device for extracting data in the technical field of computers. The method comprises the following steps: receiving a number extraction request input by a user; querying a splicing configuration table according to the number extraction request to obtain corresponding splicing configuration information; and generating an SQL statement according to the number extraction request and the corresponding splicing configuration information so as to extract data according to the SQL statement. Through the above steps, the SQL statement can be automatically generated, then data is extracted in a self-service mode, the personalized data requirement can be met, the number extraction efficiency can be improved, and the number extraction period can be shortened.

Description

technical field [0001] The invention relates to the field of computer technology, in particular to a method and device for extracting data. Background technique [0002] In the era of big data production, data has become an indispensable part of enterprise production and operation. In order to better measure work output or find problems in operation, digital measurement of relevant indicators has become an indispensable part of business operations. As the division of labor in enterprises becomes more and more detailed and specialized, not all personnel in all positions have the skills to independently obtain the required data from the database. [0003] In order to meet the data needs of all personnel, there are the following two solutions in the prior art: first, data display through data visualization reports; second, enterprises carry out data extraction by recruiting a certain number of data extractors. [0004] In the process of realizing the present invention, the in...

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/2452G06F16/242
CPCG06F16/24522G06F16/2448
Inventor 许慧
Owner BEIJING JINGDONG SHANGKE INFORMATION 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