×

Cascade feature for creating records in a database

  • US 7,562,091 B2
  • Filed: 12/16/2004
  • Issued: 07/14/2009
  • Est. Priority Date: 12/16/2004
  • Status: Active Grant
First Claim
Patent Images

1. A computer-implemented method of generating new records by a database program that serves as an interface to a database that stores at least a plurality of records in a computer readable medium, said computer-implemented method comprising:

  • receiving, by said database program, a request to enter data in a non-existing record in said database, wherein said non-existing record has not been created in said database, but is to be created as a first record in a first table which is related in a bidirectional relationship to a second table and at least one intermediate table between said first and second tables in said relationship, wherein said at least one intermediate table has at least one common field in common with each of said first and second tables;

    generating, by said database program, said first record in said first table in order to create said non-existing record;

    storing, by said database system, said first record in said computer readable medium;

    recursively providing a parent record as the next child record in said bidirectional relationship in order to (a) determine whether to propagate one or more values;

    copying match values from another parent record of the parent record to the next child record when said determining (a) determines to propagate said one or more values;

    copying match values from the next child record of the child record to the other parent record when said determining (a) determines to propagate said one or more values;

    entering, by said database program, said data into a field of said first record;

    (b) determining, by said database program, whether to propagate one or more values stored in common fields between said first, second, and at least one intermediate table in order to establish said bidirectional relationship for said first record; and

    automatically propagating, by said database program, at least one of said values stored in said common fields between said first, second, and at least one intermediate table in both directions, thereby automatically creating said bidirectional relationship between said first record and one or more records of said second table and at least one intermediate table.

View all claims
  • 2 Assignments
Timeline View
Assignment View
    ×
    ×