Electronic table general-purpose data parsing and leading-in method

A spreadsheet and data analysis technology, applied in electrical digital data processing, special data processing applications, instruments, etc., can solve problems such as heavy workload, poor reusability, poor maintainability, etc., to increase availability and avoid mapping. and the effect of logical processing

Inactive Publication Date: 2009-06-10
INSPUR SOFTWARE CO LTD
View PDF0 Cites 25 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Benefits of technology

This technology helps analyze large amounts of tabular data quickly without any extra steps or complicated calculations. It allows for more complex models based on realistic scenarios such as sales transactions. Additionally, this technique improves efficiency when generating analyzes from analyzed data sources. Overall, these technical improvements improve performance and functionality of an algorithm used during simulation testing.

Problems solved by technology

This patented technical problem addressed in this patents relates to improving the efficiency and reliance of creation of documents containing electronform content. Specifically, current methods require manual entry from an administrator who manually enters specifications onto tables stored within their computer systems. However, these existing ways have limitations like requiring significant effort and being prone to user error due to poor documentation quality. Therefore there is a demand for efficient automation tools that allow administrators to efficiently enter large amounts of data without having excessive repetitive tasks.

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

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0050] Method of the present invention is made up of following several parts:

[0051] (1) The spreadsheet data analysis import model;

[0052] (2) Data location method;

[0053] (3) The representation of primary and foreign keys;

[0054] (4) Judgment rules for valid records in multi-row tables

[0055] (5) Processing of enumerated values;

[0056] (6) the safety of the model;

[0057] They are described below.

[0058] (1) Spreadsheet data analysis import model

[0059] According to the requirements of data import, the content in the spreadsheet is finally mapped to tables and columns in the database. Therefore, the core content of the analysis model is also composed of two parts: the table model and the column model. In addition, the analysis model provides an enumeration Value model to handle key-value mappings.

[0060] 1. Table model

[0061] serial number model element illustrate 1 serial number Equivalent to the serial number of the data shee...

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 for analyzing and importing general data of an electronic form, which aims to solve the problems of the data analysis and importing of declaration materials such as applications and reports which take the electronic form as a carrier, and realize the universality of analytical and importing logic by abstracting a data analysis and importing model of the electronic form and establishing the data analysis and importing model inside a template file of the electronic form. The method comprises: (1) the data analysis and importing model; (2) a data positioning mode; (3) representation modes of primary and external keys; (4) a judgment rule of effective record of a multi-row table; (5) the processing of an enumeration value; and (6) the safety of the model. The adoption of the method can realize the self-explanation of data of the electronic form, improve the reusability and maintainability of the analytical and importing logic, and reduce workload of repeating coding during the hard coding of the analytical and importing logic.

Description

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

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
Owner INSPUR SOFTWARE 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