Script data extraction method and device, computer equipment and storage medium

A data extraction and data technology, applied in the field of power grid, can solve problems such as low data extraction efficiency, affecting data quality, and data extraction results, so as to avoid data quality problems, reduce difficulty, and improve data extraction efficiency.

Active Publication Date: 2020-09-04
GUANGXI POWER GRID CORP +1
View PDF7 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] The above data extraction methods rely on manual data extraction, which not only consumes a lot of manpower and time, but if there is a lack of table or a wrong name of the table, it will lead to errors in the data

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
  • Script data extraction method and device, computer equipment and storage medium
  • Script data extraction method and device, computer equipment and storage medium
  • Script data extraction method and device, computer equipment and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Example Embodiment

[0052] In order to make the purpose, technical solutions, and advantages of this application clearer, the following further describes this application in detail with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described here are only used to explain the application, and not used to limit the application.

[0053] The script data extraction method provided in this application can be applied to figure 1 In the application environment shown. Wherein, the terminal 102 communicates with the server 104 through the network. The database on the server 104 stores the data of the marketing domain development project of the power grid industry, including a large amount of SQL (Structured Query Language, structured query language) script data. By operating on the terminal 102, the user sends a script data extraction request to the server 104. The server 104 responds to the request, obtains the script data, extracts the regula...

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 relates to a script data extraction method and device, computer equipment and a storage medium. The method comprises the following steps of obtaining script data, extracting regular expression rule logic corresponding to the script data; generating a regular expression based on regular expression rule logic, extracting bottom data and an output result field of the script data according to the regular expression, and outputting the extracted bottom data and the output result field to a data set corresponding to a preset filename matching model according to the preset filename matching model. By the adoption of the method, only regular expression rule logic needs to be obtained, specific extension of the regular expression can be constructed to obtain successful matching, and bottom layer data and output result fields contained in script data are rapidly found out from a large amount of script data. A large amount of manpower is saved for searching data, the data quality problem caused by missing of manual searching is greatly avoided, the data extraction efficiency is improved, and the auditing work difficulty is reduced.

Description

technical field [0001] The present application relates to the technical field of power grids, in particular to a script data extraction method, device, computer equipment and storage medium. Background technique [0002] With the development of information technology, electronic business flow, capital flow and information flow have gradually become the mainstream of data audit work, and massive data audit needs the support of information technology and big data. Among them, the marketing domain audit model involves a large number of source tables and model output data sets, and there are huge workload challenges in the matching, extraction and integration of related tables and data sets. There are too many scripts involved in the marketing domain of the power grid industry, and the correlation between scripts is also relatively complicated, which also contains multiple pseudo-tables. [0003] At present, the traditional marketing domain audit model source table and result i...

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): G06Q10/06G06F16/2455G06F16/2458G06Q50/06
CPCG06Q10/06393G06Q50/06G06F16/2462G06F16/24564Y04S10/50
Inventor 唐毓广唐文彬蓝文涛周钰书秦铖赵永国刘森黎晚晴郭洁
Owner GUANGXI POWER GRID CORP
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