Table splitting and data extracting method based on logic tree

A technology of data extraction and logic tree, applied in other database retrieval, other database index, other database query, etc., can solve the problems of lack of organization management, poor efficiency, complex and changeable table structure and semantics, etc., to achieve clear logical relationship, The effect of efficient search

Active Publication Date: 2019-09-27
CETC BIGDATA RES INST CO LTD
View PDF2 Cites 3 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

At present, the structure and semantics of the table are complex and changeable, lack of effective organization and management, and the entry and reading basically rely on manual processing
Especially in the process of managing a large number of tables from different organizations, it is necessary to redefine the format of the tables before summarizing and querying. As the amount of data increases, the efficiency is extremely poor

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
  • Table splitting and data extracting method based on logic tree
  • Table splitting and data extracting method based on logic tree
  • Table splitting and data extracting method based on logic tree

Examples

Experimental program
Comparison scheme
Effect test

Embodiment

[0029] Such as figure 1 As shown, a logical tree-based table splitting and data extraction method is characterized in that it includes the following steps: table reading, logical division, table splitting, logical tree establishment, data extraction, and further includes:

[0030] Table reading: supports the reading of table data files in multiple formats, and converts the data in the table files into the unified format required by the current processing operation;

[0031] Logical division: divide the logical structure by reading the format of the table, including the division of logical rows and logical columns;

[0032] Further according to the attached figure 2 As shown in , according to the table logic in table T, in the horizontal direction, we can easily get that cells 8, 9, and 10 belong to a logical unit of one level, that is, {8,9,10}∈G, and similarly, {11 ,12,13}∈G; Similarly, expand one level up, {7,{8,9,10},{11,12,13}}∈F, {14,15,16}∈F,{ 17,18,19} ∈ F; and simil...

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 table splitting and data extracting method based on a logic tree, which comprises the following steps of: splitting a table according to logic rows and logic columns by constructing the table logic tree, and encoding by corresponding to the position of the logic tree. Through a table splitting mode of the logic tree, search query, splitting and data extraction are flexibly carried out on tables, the tables of different departments can be conveniently gathered to an upper-level department in the government affair data table processing process, meanwhile, needed data information can be rapidly extracted for a lower-level department, and intelligent association of the tables is achieved.

Description

technical field [0001] The invention relates to the field of form data management, in particular to a form splitting and data extraction method based on a logic tree. Background technique [0002] Tables are a visual communication mode and a means of organizing data. They are commonly used in the processing of information and data such as government affairs and finance. Forms with clear logic and strong flexibility are very conducive to the collection and refinement of data, and are the basis for supporting data analysis. At present, the structure and semantics of the form are complex and changeable, lack of effective organization and management, and the input and reading basically rely on manual processing. Especially in the process of managing a large number of tables from different organizations, it is necessary to redefine the format of the tables before summarizing and querying. As the amount of data increases, the efficiency is extremely poor. [0003] The invention ...

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): G06F16/901G06F16/903
CPCG06F16/9027G06F16/90335
Inventor 曾伟李响谭畅李科君陈小刚王汝平
Owner CETC BIGDATA RES INST 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