Scoping method of table data structuration

Abstract

The invention provides a scoping method of table data structuration, belonging to the technical field of information, and comprising step 1 of listing table files defined in an information system for users to select; step 2 of establishing configuration files; step 3 of defining a mapping relation between a table cell and a database field; step 4 of appointing a scope keyword for the table cell in the table files; and step 5 of storing configuration file information. The invention provides the scoping method of the table data structuration, which can better solve the problem of treating information extraction and storage, a plurality of data objects and a logical relation among the data objects when taking table software as a data entry tool in a management information system, by using the mapping relation files of the table files and the database, and an appointed scoping method reported by the objects; and furthermore, the invention enhances flexibility and convenience during a system implementation process, and effectively shortens an implementation cycle of the system.

Description

technical field [0001] The invention belongs to the technical field of the information technology field, and in particular relates to a scope method for structuring table data. Background technique [0002] In some management information systems, due to the user's usage habits and intuitive expression, some form tool software (such as EXCEL) is often used as a data entry tool, or in some client tools in the form of a form (such as Schedule in 2D design drawings) to write information. For this part of the entered information, due to the needs of the background management information system, it usually needs to be stored in the database in the form of structured data, so as to realize the needs of data management and upstream and downstream data transmission in the information system. [0003] For some table entry information with relatively simple structure, you can directly use the database binding method in the system or directly fix the mapping relationship between table ...

AI Technical Summary

Problems solved by technology

However, in practical applications, these methods will have some unavoidable problems:

It is difficult to use a common database binding method to associate it with the database; and for the method of fixing the mapping relationship of the database in the program, developers need to modify the program whenever the format of the table changes or the number of types increases.

It greatly increases the workload of developers and the difficulty and cycle of system application, which is also not an ideal way of implementation

[0006] 2. Unable to handle complex data structures:

Images