Table data importing method and system

A form data and group data technology, applied in the field of data processing, can solve the problem of repeated verification of form data ORM object sharing and reuse, etc., to achieve the effect of improving memory usage efficiency, improving import efficiency, and saving computer resources

Active Publication Date: 2017-09-08
深圳市天天来玩科技有限公司
View PDF3 Cites 13 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0014] The technical problem to be solved by the present invention is to provide a form data import method and system to solve the problem of repeated verification when form data is imported in batches and the problem of ORM object sharing and reuse

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 data importing method and system
  • Table data importing method and system
  • Table data importing method and system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0066] This embodiment provides a form data import method, such as figure 1 shown, including steps:

[0067] S11: Group the imported form data according to preset rules;

[0068] S12: Perform deduplication operations on the form data according to the grouping and verify in batches whether the grouped form data is legal;

[0069]S13: Determine whether the table data has passed the verification, if not, end the execution; if so, correspond each set of table data to a newly created ORM object.

[0070] ORM is object-relational mapping, which is a program technology used to realize the conversion between data of different types of systems in object-oriented programming languages. In effect, it actually creates a "virtual object database" that can be used in programming languages.

[0071] The ORM framework uses metadata to describe the details of object-relational mapping. Metadata generally adopts XML format and is stored in a special object-mapping file.

[0072] Among them...

Embodiment 2

[0111] This embodiment provides a form data import method, such as figure 2 shown, including steps:

[0112] S21: Determine whether the verification field length of the form data is greater than the preset field length, if so, adopt the grouping method of comprehensive weight;

[0113] S22: If the verification length of the form data is not greater than the preset field length, adopt the method of hash merge and grouping;

[0114] S23: Perform deduplication operations on the form data according to the grouping and verify in batches whether the grouped form data is legal;

[0115] S24: Determine whether the table data has passed the verification, if not, end the execution; if so, correspond each set of table data to a newly created ORM object.

[0116] The difference from Embodiment 1 is that step S11 includes step S21 and step S22.

[0117] There are many ways to group data, and they are very flexible. For example, you can group data with similar fields, group data with th...

Embodiment 3

[0151] This embodiment provides a form data import method, such as image 3 shown, including steps:

[0152] S31: Group the imported form data according to preset rules;

[0153] S32: Perform deduplication operations on the form data according to the grouping and verify in batches whether the grouped form data is legal;

[0154] S33: Judging whether the form data has passed the verification, if not, ending the execution;

[0155] S34: If the form data passes the verification, create an ORM object according to the group;

[0156] S35: traverse the grouped table data;

[0157] S36: Determine whether to traverse to the end of the group, if so, end the execution; otherwise, fill in the ORM object attributes and save the ORM object.

[0158] The difference from Embodiments 1 and 2 is that the step of associating each set of table data with a newly created ORM object specifically includes steps S33, S34, S35, and S36.

[0159] After the group verification is completed, an ORM o...

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 table data importing method and system. According to the method and the system, the problems that table data needs to be repeatedly verified in a batch importing process, and an ORM object is shared or reused are solved. The method comprises the following steps: (S1) grouping imported table data according to preset rules, wherein the each group of data is in common or similar; and (S2) judging whether the table data is successfully verified or not, if no, ending the execution, and if yes, enabling each group of table data to correspond to a newly-built ORM object. The table data is imported in a multi-thread manner, so that the importing efficiency is improved; the data in common is grouped and is verified in batch, so that the verification efficiency is improved, and the resources of a computer are saved; and one ORM object is shared by one group of data, so that the use efficiency of a memory is improved, and the consumption of the memory is reduced.

Description

technical field [0001] The invention relates to the field of data processing, in particular to a table data import method and system. Background technique [0002] A mature enterprise management system must contain many small information management systems, and the core of each information management system must be to realize the management function of data. [0003] Usually, the system needs to realize the function of importing Excel data into the database in batches, and the traditional way of importing data in Excel based on the ORM framework is to first read the data in the Excel file, and then traverse the read data by Excel row. When traversing each row, it is necessary to verify some key fields (column data) of this row to determine whether the data is legal. If it is not legal, it will stop execution and give an error message. If it is legal, it will insert data into the database by row. The general flow of the traditional ORM framework-based Excel batch import data...

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): G06F17/30
CPCG06F16/254
Inventor 张中山
Owner 深圳市天天来玩科技有限公司
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