Method and system for storing irregular fields

Abstract

The invention provides a method for storing irregular fields, which comprises the following steps: creating a main table, and storing basic fields based on the same classification in the main table, wherein classification type fields and classification data storage fields used for storing the information of self-owned fields are further stored in the main table; creating a classification table, and storing the classification information in the classification table, wherein the sequences of the information of the self-owned fields in the classification data storage fields in the main table arefurther stored in the classification table; and creating an attribute table, and storing the attributes of all the classified self-owned fields in the attribute table. The invention can not only avoidthe problem of a large amount of redundant data caused by the data stored in a huge table, but also prevent a plurality of tables from being created, thereby avoiding the maintenance cost caused by aplurality of fragmentary table structures.

Description

technical field [0001] The present invention relates to database technology, and more particularly relates to an irregular field storage method and system. Background technique [0002] Among the existing data structures, there is an irregular data structure as follows: most of the basic fields of this data structure are the same, but there are still some distinct own fields between its different classifications. It is also the data of shops. They all have common information fields such as name, address, and contact number. However, there are different information fields between different industries and categories, such as the number of private rooms and special dishes in the catering industry; when vehicles are transported, each vehicle has a limit on the tonnage it can carry, etc. . What's more, these own fields are uncertain, because each industry will have its own newly added fields. For example, cash was used when paying in the past, but now people use credit cards, s...

AI Technical Summary

Problems solved by technology

As a result, a huge number of tables is caused, which causes a lot of maintenance overhead when adding and changing its own fields, and also brings a lot of query overhead when searching for data

[0004] To solve the large amount of data redundancy caused by storing irregular data and the huge maintenance overhead caused by the table structure, a new irregular field storage method and system is required

Images