| 摘要 |
A computer-implemented method for dereferencing content of a link table in a database. The link table specifies a relationships between a plurality of other tables of the database. The link table includes a plurality of link records. The link tables has a link table record ID attribute and a foreign key attribute associated with a specific attribute of one of the plurality of other tables. The method includes creating a first user data model for the link table, the first user data model representing the link table as a child vector node and the foreign key attribute as an attribute of the child vector node. The method further includes substituting the foreign key attribute in the first user data model with a given attribute associated with the one of the plurality of the other tables, thereby forming a second user data model. Additionally, the method includes creating a dereferenced table from the link table using the second user data model. The dereferenced table provides, for each of the plurality of link records, content associated with the given attribute in a given record of the one of the other tables for a value associated with the foreign key attribute in the link table, the value associated with the foreign key attribute in the link table identifying the given record of the one of the other tables.
|
