Method and system for supporting multiple, historical, and future designs in a relational database

• US 6,408,312 B1
• Filed: 08/30/1999
• Issued: 06/18/2002
• Est. Priority Date: 08/30/1999
• Status: Expired due to Fees

• Current Assignee: Visionael Corp. (Upland Software, Inc.)
• Original Assignee: Visionael Corp. (Upland Software, Inc.)
• Inventors: Matthews, Richard, Forthman, Daniel
• Primary Examiner(s): Alam, Hosain T.
• Assistant Examiner(s): Ly, Anh
• Application Number:
  US09/385,783
• Time in Patent Office: 1,023 Days
• Field of Search: 707/1-10, 707/102, 707/103, 707/103.R, 707/9, 707/203, 709/226, 717/2
• US Class Current: 707/790
• CPC Class Codes: G06F 16/284 Relational databases
• CPC Class Codes: Y10S 707/96 Object-relational
• CPC Class Codes: Y10S 707/99931 Database or file accessing
• CPC Class Codes: Y10S 707/99939 Privileged access
• CPC Class Codes: Y10S 707/99954 Version management

Abstract

A method and system in accordance with the present invention receives correct information concerning a design in a database. The method comprises selecting a most recent instance of an object in the design and analyzing the dependencies of that object on the other objects in the design database. Through the use of a method and system in accordance with the present invention, relational database management systems will have the capability of building designs upon other designs by presenting the user with the appropriate versions of objects from earlier designs. The method and system in accordance with the present invention will also allow changes to the ordering of designs within restrictions based on the dependencies between the designs. This will give the user the ability to stay up-to-date on current network information, review previous network configurations and work on as many proposed network configurations as desired.

Claims

1. A method for receiving correct information concerning a plurality of designs in a database, wherein the plurality of designs comprises at least one public design and at least one private design and each design includes an effective date and a plurality of objects, the method comprising the steps of:

a) selecting a design in a design configuration, wherein the design configuration comprises at least one historical design, an as-built design, and at least one future design;

b) determining a most recent instance of each object of the selected design from the selected design or any public designs having an earlier effective date; and

c) analyzing the dependencies of the most recent instance of each object of the selected design on the plurality of objects of each of the plurality of designs.

2. The method of claim 1 in which the analyzing step (c) further comprises:

(c1) identifying all objects in one or more public designs upon which any object of the selected design depends; and

(c2) identifying all objects in one of more later designs that are dependent upon any object of the selected design.

3. The method of claim 2 wherein the one or more public designs have earlier effective dates.

4. The method of claim 3 wherein if there are no objects in the one or more later designs that are dependent upon any objects of the selected design, the selected design can be made private.

13. The method of claim 4, wherein the effective date of the selected design can be changed to any future date.

14. The method of claim 2, wherein if any objects in one or more later designs depends upon any object of the selected design, the effective date of the selected design can be changed to a date no later than the earliest effective date of the one or more later designs.

15. The method of claim 2, wherein if any objects in the selected design depend on any objects in the one or more earlier public designs, the effective date of the selected design can be changed to a date no earlier than the latest effective date of the one or more earlier public designs.

16. The method of claim 1, wherein the design comprises a network design and the plurality of objects include a map, location, floor, room, cabinet, device, port, and cable for the network design.

5. A system for receiving correct information concerning a plurality of designs in a database, wherein the plurality of designs comprises at least one public design and at least one private design and each design includes an effective date and a plurality of objects, the system comprising:

means for selecting a design in a design configuration, wherein the design configuration comprises at least one historical design, an as-built design, and at least one future design;

means for determining a most recent instance of each object of the selected design from the selected design or any public designs having an earlier effective date; and

means for analyzing the dependencies of the most recent instance of each object of the selected design on the plurality of objects of each of the plurality of designs.

6. The system of claim 5 in which the analyzing means further comprises:

means for identifying all objects in one or more public designs upon which any object of the selected design depends; and

means for identifying all objects in one or more later designs that are dependent upon any object of the selected design.

7. The system of claim 6 wherein the one or more public designs have earlier effective dates.

8. The system of claim 7 wherein if there are no objects in the one or more later designs that are dependent upon any objects of the selected design, the selected design can be made private.

17. The system of claim 8, wherein the effective date of the selected design can be changed to any future date.

19. The system of claim 6, wherein if any objects in the selected design depend on any objects in the one or more earlier public designs, the effective date of the selected design can be changed to a date no earlier than the latest effective date of the one or more earlier public designs.

20. The system of claim 5, wherein the design comprises a network design and the plurality of objects include a map, location, floor, room, cabinet, device, port, and cable for the network design.

9. A computer readable medium containing program instructions for receiving correct information concerning a plurality of designs in a database, wherein the plurality of designs comprises at least one public design and at least one private design and each design includes an effective date and a plurality of objects, the program instructions comprising the steps of:

a) selecting a design in a design configuration, wherein the design configuration comprises at least one historical design, an as-built design, and at least one future design;

b) determining a most recent instance of each object of the selected design from the selected design or any public designs having an earlier effective date; and

c) analyzing the dependencies of the most recent instance of each object of the selected design on the plurality of objects of each of the plurality of designs.

10. The computer readable medium of claim 9 in which the analyzing instruction (c) further comprises:

(c1) identifying all objects in one or more public designs upon which any object of the selected design depends; and

(c2) identifying all objects in one of more later designs that are dependent upon any object of the selected design.

11. The computer readable medium of claim 10 wherein the one or more public designs have earlier effective dates.

12. The computer readable medium of claim 11 wherein if there are no objects in the one or more later designs that are dependent upon any objects of the selected design, the selected design can be made private.

21. The computer readable medium of claim 12, wherein the effective date of the selected design can be changed to any future date.

22. The computer readable medium of claim 10, wherein if any objects in one or more later designs depends upon any object of the selected design, the effective date of the selected design can be changed to a date no later than the earliest effective date of the one or more later designs.

23. The computer readable medium of claim 10, wherein if any objects in the selected design depend on any objects in the one or more earlier public designs, the effective date of the selected design can be changed to a date no earlier than the latest effective date of the one or more earlier public designs.

24. The method of claim 9, wherein the design comprises a network design and the plurality of objects include a map, location, floor, room, cabinet, device, port, and cable for the network design.

18. The system of 1, wherein if any objects in one or more later designs depends upon any object of the selected design, the effective date of the selected design can be changed to a date no later than the earliest effective date of the one or more later designs.