Method and device for determining data table association relationship

Abstract

The invention discloses a method and device for determining a data table association relationship, and relates to the technical field of computers. One specific embodiment of the method comprises thefollowing steps: S1, querying an associated field in a to-be-determined data table by utilizing an associated identifier, the associated field comprising a table name of the data table where an associated field associated with the associated field is located and the associated identifier, the associated field being a unique index of the data table where the associated field is located, and the associated field being an index of the to-be-determined data table; and S2, analyzing the associated fields, and obtaining the table names of the data tables where the associated fields corresponding tothe associated fields are located, so as to determine that the data tables are associated tables about the associated fields of the to-be-determined data tables. According to the embodiment, the change operation of the associated data table can be simplified, the application flexibility of the associated data table is improved, and meanwhile, the data consistency and integrity of the associated data table can be kept.

Description

Technical field [0001] The present invention relates to the field of computer technology, and in particular to a method and device for determining the association relationship of data tables. Background technique [0002] In Internet business, when we set the association relationship of data tables, we usually determine the master table and slave table in the data table association relationship by setting the primary key and foreign key of the related data table, so that different data tables are related Joint. The primary key in the main table is used to associate with other tables and serves as a unique identifier in the main table. The secondary table uses the primary key of the primary table as a foreign key, and can be associated with the primary table through the foreign key. [0003] In the process of implementing the present invention, the inventor found that the prior art has at least the following problem: due to the use of the primary key and the foreign key to determi...

AI Technical Summary

Problems solved by technology

[0003] In the process of realizing the present invention, the inventor found that there are at least the following problems in the prior art: due to the use of the data table association relationship determined by the primary key and the foreign key, when the data table is changed, it will be constrained by the foreign key

This makes the data table change operation must follow the foreign key constraints, the operation is quite cumbersome, and the foreign key determines the data generation relationship between the two data tables, which limits the application of the data table and will cause some problems that cannot be handled

However, if foreign keys are not used, new problems will also arise. In the rapid iteration of Internet business, it is often encountered that the database document and the database table structure are not completely consistent, making the database table structure difficult to maintain

Moreover, after the number of new tables continues to increase, the relationship between data tables becomes more and more complicated, and it is difficult to sort out the relationship between tables

Images