Data acquisition method and device

A data acquisition and data technology, applied in the Internet field, can solve problems such as inability to reuse and increase the difficulty of system maintenance, and achieve the effect of easy maintenance and reduction of code fragments.

Active Publication Date: 2017-05-10
BEIJING GRIDSUM TECH CO LTD
View PDF4 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] In the process of obtaining the data in the CSV file mentioned above, the inventor found that for different businesses, a relatively fixed business logic for data acquisition and format conversion needs to be constructed, and the process of data acquisition cannot be reused, so it will be formed in the system. Many code fragments increase the difficulty of system maintenance

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

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0025] Exemplary embodiments of the present disclosure will be described in more detail below with reference to the accompanying drawings. Although exemplary embodiments of the present disclosure are shown in the drawings, it should be understood that the present disclosure may be embodied in various forms and should not be limited by the embodiments set forth herein. Rather, these embodiments are provided for more thorough understanding of the present disclosure and to fully convey the scope of the present disclosure to those skilled in the art.

[0026] In order to solve the problem in the prior art that the process of obtaining data in the CSV file cannot be reused, the embodiment of the present invention provides a data query method, such as figure 1 As shown, the method includes:

[0027] 101. Receive metadata information corresponding to a business requirement, where the metadata information includes attribute names, column identifiers, and format types corresponding to...

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 data acquisition method and device, relates to the technical field of internet, and aims at solving the problem that the process of acquiring data in CSV files is not reusable in the prior art. The method comprises the following steps of: receiving metadata information corresponding to a business requirement, wherein the metadata information comprises an attribute name, a row identifier and a format type corresponding to different pieces of attribute information, and the row identifier is an identifier of a row in a Comma-separated values CSV file; establishing a mapping table according to the metadata information, wherein the mapping table records a corresponding relationship among the attribute name, the row identifier and the format type; extracting data corresponding to the row identifier from the CSV file according to the mapping table; converting the extracted data into a format type corresponding to the row identifier according to the mapping table; and binding the format-converted data with the attribute name corresponding to the row identifier. The data acquisition method and device are suitable for being applied to the process of extracting the data in the CSV file.

Description

technical field [0001] The present invention relates to the technical field of the Internet, in particular to a data acquisition method and device. Background technique [0002] When users need to exchange information, it may be necessary to import a database program that stores data in a proprietary format into a spreadsheet with an entirely different database format. Usually, the program that stores the database in a private format is first exported to the "Comma-Separated Values ​​(CSV)" format. The CSV format is a common and relatively simple method that is widely used to transfer table data between programs. file format. Then import the file in CSV format into a spreadsheet with a completely different database format. [0003] When importing a CSV format file into a new spreadsheet, it is necessary to obtain data from the CSV file. The existing process of obtaining data in the CSV file is: read each row of data in the CSV file; create according to the specific busines...

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): G06F17/30
CPCG06F16/258
Inventor 商平锋
Owner BEIJING GRIDSUM 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