Content dereferencing in website development

• US 20020091677A1
• Filed: 01/16/2001
• Published: 07/11/2002
• Est. Priority Date: 03/20/2000
• Status: Abandoned Application

• Current Assignee: Ampersand Corp.
• Original Assignee: Ampersand Corp.
• Inventors: Sridhar, Mandayam Andampikai
• Application Number:
  US09/765,058
• Publication Number:
  US 20020091677A1
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/2423 Interactive query statement specification based on a database schema
• CPC Class Codes: G06F 16/972 Access to data in other repository systems, e.g. legacy data or dynamic Web page generation

Abstract

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.

Claims

1. A computer-implemented method for dereferencing content of a link table in a database, said link table specifying relationships between a plurality of other tables of said database, said link table comprising a plurality of link records, said link tables having a link table record ID attribute and a foreign key attribute associated with a specific attribute of one of said plurality of other tables, comprising:

creating a first user data model for said link table, said first user data model representing said link table as a child vector node and said foreign key attribute as an attribute of said child vector node;

substituting said foreign key attribute in said first user data model with a given attribute associated with said one of said plurality of said other tables, thereby forming a second user data model;

creating a dereferenced table from said link table using said second user data model, said dereferenced table providing, for each of said plurality of link records, content associated with said given attribute in a given record of said one of said other tables for a value associated with said foreign key attribute in said link table, said value associated with said foreign key attribute in said link table identifying said given record of said one of said other tables.

2. The computer-implemented method of claim 1 wherein said given attribute is an attribute arbitrarily selected from attributes of said one of said plurality of other tables.

3. The computer-implemented method of claim 2 wherein said given attribute is the first attribute that comes after the record ID attribute in said one of said plurality of other tables.

4. The computer-implemented method of claim 2 further comprising:

presenting said second user data model to a user prior to said creating;

permitting said user to specify a user-specified attribute as a substitute for said foreign key attribute, said user-specified attribute representing either a single attribute of said one of said plurality of other tables or a compound attribute that includes multiple attributes of said one of said plurality of other tables; and

updating said given attribute with said user-specified attribute.