CN100421104C - Method for processing data of database system - Google Patents

Abstract

The invention is a method for processing data of database system, the method is to set up a comparison table in the database system, the comparison table includes the name of the non-index field in each record of the traditional database, and the code corresponding to the said name, make the data content of the non-index field originally stored in the traditional database, can be compiled into a description string containing code and every said data content according to the comparison table, and store it into a description field of a record of the database of the invention, make the database system read the description field of each record later, can look for the said code in the description string, look for the corresponding field name in the comparison table, and display every said field name and its corresponding data content on the corresponding field of an output picture of the database respectively.

Description

Data processing method of database system

technical field

The present invention relates to the database field in computer software, especially a method for processing data in a database system, which can edit the data content in the non-index field in each record of a traditional database into a description according to a comparison table The character string is stored in the description field of a record in the database of the present invention. When the database system reads each record, the name of each non-index field and its corresponding data content can be compared according to the comparison table. Displayed on an output screen of the database.

Background technique

A general database system is mainly composed of multiple databases and a database program. Generally speaking, before establishing a database system, it is necessary to store each data content in a record (Record) according to Its characteristics are classified and planned into different fields (Field). For example, the product order of a general manufacturer includes order number, type, part name, unit price...etc. The product order can be regarded as the database A record in , has fields such as order number, type, part name, unit price, etc. Therefore, when planning each database, it is necessary to define its attributes according to the content to be stored in each field, for example: "text" , "Number", "Date"... etc., and set the length of each field, and input and output conditions to complete the definition of each field in each database, and finally, use the database program to execute each Input, output and conversion of field data content between databases.

In a traditional database system, each record in the database must define its field characteristics according to the content of the data to be stored. Please refer to Figure 1. The characteristics usually include the name and attribute of each field , length and conditions, where the name is used to represent the name of the data stored in the field (such as: order number), and the attribute is used to represent the data attributes stored in the field (such as: text, integer, date, etc.), the The length is used to represent the number of bits of data content that can be entered in this field, and the condition is used to represent the identification condition of the data content that can be entered in this field (for example: must be an integer greater than 50000 and less than 60000). After completing the definition of each field one by one, please refer to Figure 2, the database program can design the input and output screens of each database according to the fields planned in each database, use Through the input and output screen of the database, the user can input the content of the data to be stored into each field in the corresponding database one by one, or read and display the stored data from each field in the corresponding database. data content.

Generally speaking, the database system is used to store a large number of records in different categories. Therefore, if you want to find a specific record from a large number of records, or make a relationship between different databases, you must In each record, select at least one field as an index field, so that the database system can search for a specific record according to the index field, so as to display the data content of the record on the database screen; or between different databases For correlation search, the index field usually refers to the data field in a database that is more likely to be associated with other databases, so the index field generally has unique characteristics to avoid inaccurate searches when searching to the records associated with the index field.

According to the above, since in the traditional database system, the length of each field in each database needs to be defined first, so after the construction of the database system is completed, regardless of the fields in each record of each database, Whether there is input data content, or whether the length of the input data content is less than the defined length, the database system will open a storage space on the storage device according to the defined maximum length to store the record . In this way, each database may waste a lot of unnecessary storage space because many fields do not store data, or the length of the stored data is shorter than its defined length. This shortcoming is especially obvious in a huge database system , Therefore, how to effectively use the storage space on the storage device to store each input data is the primary problem to be solved in the current database system.

In recent years, due to the rapid development of the Internet, all walks of life have continuously set up websites to provide various services. In particular, multinational companies use the Internet as the transmission and query of company data to provide the latest information to their subsidiaries. The company or its cooperating manufacturers, operators, consumers, etc., when performing various data services or inquiries on the Internet, it is necessary to integrate multiple huge database systems, so that users can be in the most The required data can be obtained in a short time. Therefore, the effective use of the storage space on the storage device to store every piece of fast-flowing data on the Internet has become an important issue for enterprises when promoting information networking.

Contents of the invention

In view of the disadvantages that the traditional databases may waste a lot of unnecessary storage space because many fields do not store data, or the length of the stored data is less than the defined length, a database system of the present invention is specially developed and designed. The method for storing and reading records, the method is to edit the data in the non-index field in the traditional database into a description word string according to a comparison table, store it in a description field of the database of the present invention, and read the description When specifying the description string of a field, the data content of each non-indexed field can be displayed on the database screen according to the comparison table.

The main purpose of the present invention is that the comparison table includes the title of the non-index field in the traditional database, and the code corresponding to the title, and the data content of the non-index field in the traditional database can be edited to include A description word string of each of the code and data content, and store it in the description field of a record in the database of the present invention, so that when the database system of the present invention reads the description field, it can The code in the character string searches for the corresponding field name in the comparison table, and displays each data content on a corresponding field of an output screen of the database according to each field name.

Wherein, when the database system receives the non-index data input through the corresponding fields of the input data table, it can convert the corresponding field names of the data table into corresponding codes according to the comparison table, and use a specific editor Definition, add an identification symbol between the code corresponding to each non-index data and its data content, and add a separator between adjacent data, so as to edit all non-index data input through the input screen into one Description string.

The database system stores the index and non-index data input through the input data table into corresponding records of the database one by one according to the following steps:

First, display the input data form on a display device, the corresponding field for inputting index data in the data form is linked to the index field defined in a database, and the corresponding field for inputting non-index data in the data form field, linked to a lookup table;

directly store the index data input into the data table into the index field in the corresponding record of the database, and read the corresponding fields in the data table for inputting non-index data one by one;

Determine whether any data is entered in each corresponding field, if so, perform the following steps;

Determine whether it is a last corresponding field, if so, perform the following steps;

According to the read field names of the non-indexed data, find the corresponding codes from the code comparison table, and use each of the codes to write the non-indexed data into a description string according to a certain editing method , to store in the description field of this database.

According to the following steps, the database system searches out a record to be searched from the corresponding database according to the index data input through the output data table:

First, according to the index data input into the output data table, from the corresponding database, search and read a record associated with the input index data;

Then, read the data stored in each index field of the record, and display it on the data table of the output screen to display the corresponding field of the index data, and read the data stored in the description field of the record description string;

According to the codes and field names set in the comparison table, interpret all the non-index data implied in the description string one by one;

The interpreted non-index data are displayed one by one on the corresponding field for displaying the non-index data on the data table of the output screen.

Description of drawings

Fig. 1 is a schematic diagram of definitions of fields in each record of a traditional database;

FIG. 2 is a schematic diagram of a data table in a traditional database;

Fig. 3 is the definition diagram of each field in each record of database of the present invention;

Fig. 4 is the picture schematic diagram of the data table in the database of the present invention;

Fig. 5 is the schematic diagram of the code comparison table of the present invention;

Fig. 6 is a schematic diagram of a screen of a data table according to an embodiment of the present invention;

Fig. 7 is a schematic flow diagram of storing a record into the database by the database system of the present invention;

FIG. 8 is a schematic flowchart of searching a record from the database by the database system of the present invention.

Main component number:

Data Sheet................6

Corresponding fields of index data... 60

Corresponding fields of non-index data...62

Detailed ways

The present invention is a method for storing and reading records in a database system. The method first defines the field format for a plurality of data to be stored in each database in a database system. The field of the index and a description field (Remark), taking the parts database of a general manufacturer as an example, please refer to Figure 3 and Figure 6, the fields that can be used as the index include the part number Pnc (Parts code), the part name Descr ( Description) and part type TP (Parts Type)... etc., so in the parts database, each part record only includes the index field and the description field, as shown in Figure 4, the The description field is used to store a description string. In the present invention, the data belonging to the non-index field in each record of the traditional database can be input to the corresponding field of an input data table through an input screen of the database, and then a comparison table is used to convert the data Edit the data in each field on the table into a description string, store it in the description field of each record, and when reading the record later, the database system of the present invention can compile the description field according to the comparison table Each of the data content in the output screen is displayed in the corresponding field of the data table in an output screen.

In the present invention, please refer to Fig. 5 and shown in Fig. 6, this comparison table includes the title (such as: CPQ Part no) that belongs to the non-index data in each record, and the code (such as: PN) The data input to the corresponding field of the input data table can be edited into a description string including each code and data content according to the comparison table, and stored in each record of the database In the description field, in this way, when the database system reads each record, it can search for the corresponding field name in the comparison table for the code in the description string in the description field, and put each The field name and the corresponding data are respectively displayed on the corresponding fields of the data table in an output screen of the database.

Referring to Fig. 6, when the database system of the present invention receives the non-index data input by the user through the corresponding field of the data table of an input screen, it can use the corresponding field name of the data table according to the comparison table ( Such as: CPQ Part no) into the corresponding code (such as: PN), and use a specific editing definition to add an identification symbol (such as: =) between the code corresponding to each non-index data and its data content, and Between adjacent data, add a separator (such as: ~) to edit all non-index data input through the input screen into a description string (such as: PN=470013-471～CFG=FMWZ～. .....), and store it in the description field of a record of the aforementioned database of the present invention. Therefore, in the future, when the database system of the present invention reads each of the records, by identifying the position of the identification symbol, each of the codes and their corresponding data content can be read correctly, and separated by the The symbol correctly identifies the end position of each data content, and the start position of another code and its corresponding data content following.

In the present invention, please also refer to shown in Fig. 6, the data table 6 of an input screen or output screen designed by the database program of this database system, this data table 6 is provided with a plurality of respectively for input or output The corresponding fields 60, 62 of index data and non-index data, the user can input the content of the data to be stored into each corresponding field 60, 62 on the data table 6 one by one through the data table 6, or from the database Output and display the data content to be read in each corresponding field 60, 62 of the data table 6. Because the corresponding field 62 for inputting non-indexed data on the data sheet 6 is designed according to the field name used on the comparison table, so if you want to increase the field, reduce the data table 6 for inputting non-indexed data The number of corresponding fields 62 in the data table 6 only needs to be modified by modifying the number of corresponding fields 62 on the data table 6 and the field names and codes on the comparison table. It is not necessary to follow the traditional database system at all, and must be added or deleted by adding or deleting each database field, so the present invention can avoid the database system not working properly due to improper addition or deletion of data fields in the database.

In the present invention, the length of the description field in the database is set by estimating the total length of all non-index data in each record to be stored in the database, and the length of the description field is reduced or When adding non-index data stored in each record, it can be easily achieved by only changing the length of the description field. In addition, since the description field is used to store all non-index data entered in each record, it There is no need to pre-configure field storage space for storing each piece of non-index data in the storage device as in the traditional database system, so that the capacity of the database can be appropriately reduced.

In a preferred embodiment of the present invention, as shown in FIG. 7, the database program of the database system is to use the index and non-index data input by the user through the data table of an input screen according to the following steps, To store one record in one database one by one:

Step 701, firstly, display a data table of an input screen on a display device, the corresponding fields used for inputting index data in the data table are linked to the index fields defined in a database, and the data table is used for Enter the corresponding field of non-index data, which is linked to a comparison table;

Step 702, after the user inputs the index and non-index data into the corresponding fields one by one through the data table on the input screen, the database system will input the index data of the data table and store them directly in the database. In the index field in the record, and read the corresponding fields in the data table for inputting non-index data one by one;

Step 703, judging whether any data is input in each corresponding field, if so, proceed to step 704, otherwise, proceed to step 706;

Step 704, judge whether it is the last corresponding field, if so, perform the following steps, otherwise, perform step 706;

Step 705, according to the read field name of the non-index data, find the corresponding code from the code comparison table, and use each of the codes to write the non-index data into a description string to be stored in a description field of the database;

In step 706, after the next corresponding field is read, the processing is performed according to step 705.

In this embodiment, as shown in FIG. 8, the database program of the database system is to search from a corresponding database according to the index data input by the user through a data table on an output screen according to the following steps. Make a record to search:

Step 801, firstly, after the user enters the index data into the corresponding field through the data table of the output screen, the database system searches and reads from a corresponding database according to the index data input into the data table. a record associated with the input index data;

Step 802, read the data stored in each index field of the record, and display it on the data table of the output screen to display the corresponding field of the index data, and read the data stored in the description field of the record description string for

Step 803, according to the codes and field names set in the comparison table, all non-index data implied in the description string are interpreted one by one;

Step 804 , displaying the interpreted non-indexed data one by one on the corresponding field for displaying the non-indexed data on the data table of the output screen.

The above description is only the best specific embodiment of the present invention, but the structural features of the present invention are not limited thereto. Any changes or modifications made by those skilled in the art within the field of the present invention can be covered by this invention. within the scope of the claimed invention.

Claims (5)

1. A method for processing data of a database system, characterized in that: the method is aimed at a plurality of data to be stored, defining a plurality of fields of each record in each database in a database system, the described The fields include a plurality of fields used as indexes and a description field, and the data not used as indexes are input to the corresponding fields of the data table one by one through the data table of an input screen of the database system, and then use a comparison Table, edit the data entered in each corresponding field on the data sheet into a description string, and store it in the description field of each record, so that when the record is read later, the database system can follow the The comparison table compiles each data content in the description field, and displays them respectively on the corresponding fields of the data table in an output screen. 2. The method for processing data in a database system according to claim 1, wherein the comparison table includes the name of the non-index data to be stored in each record, and the code corresponding to the name, input The data to the corresponding field of the input data table is edited into a description word string including each code and data content according to the comparison table. 3. The method for processing data of the database system as claimed in claim 1 or 2, wherein the database system can, when receiving the non-index data input through the corresponding field of the input data table, according to The comparison table converts the corresponding field name of the data table into the corresponding code, and uses a specific editing definition to add an identification symbol between the code corresponding to each non-index data and its data content, and in the adjacent Add a separator between data to edit all non-index data input through the input screen into a description string. 4. The data processing method of the database system according to claim 3, wherein the database system stores the index and non-index data input through the input data table one by one in the In the corresponding record of the database: First, display the input data form on a display device, the corresponding field for inputting index data in the data form is linked to the index field defined in a database, and the corresponding field for inputting non-index data in the data form field, linked to a lookup table; directly store the index data input into the data table into the index field in the corresponding record of the database, and read the corresponding fields in the data table for inputting non-index data one by one; Determine whether any data is entered in each corresponding field, if so, perform the following steps; Determine whether it is a last corresponding field, if so, perform the following steps; According to the read field names of the non-index data, find the corresponding codes from the code comparison table, and use each of the codes to write the non-index data into a description string according to a certain editing method, to store in the description field of this database. 5. The method for processing data in a database system as claimed in claim 4, characterized in that: the database system searches the corresponding database according to the index data input through the output data table according to the following steps Make a record to search: First, according to the index data input into the output data table, from the corresponding database, search and read a record associated with the input index data; Then, read the data stored in each index field of the record, and display it on the data table of the output screen to display the corresponding field of the index data, and read the data stored in the description field of the record description string; According to the codes and field names set in the comparison table, interpret all the non-index data implied in the description string one by one; The interpreted non-index data are displayed one by one on the corresponding field for displaying the non-index data on the data table of the output screen.

Images