Patentable/Patents/US-6408312
US-6408312

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

PublishedJune 18, 2002
Assigneenot available in USPTO data we have
Inventorsnot available in USPTO data we have
Technical 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.

Patent Claims
24 claims

Legal claims defining the scope of protection, as filed with the USPTO.

1

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

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

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

4

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.

5

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

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

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

8

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.

9

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

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

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

12

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.

13

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

14

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

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

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.

17

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

18

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.

19

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

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.

21

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

22

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

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

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.

Classification Codes (CPC)

Cooperative Patent Classification codes for this invention. Click any code to explore related patents in that topic.

Patent Metadata

Filing Date

August 30, 1999

Publication Date

June 18, 2002

Want to explore more patents?

Browse 5M+ US patents with plain-English claim translations and AI-generated analysis.

Citation & reuse

Analysis on this page is generated by Patentable — an AI-powered patent intelligence platform. AI-generated summaries, explanations, and analysis may be reused with attribution and a visible link back to the canonical URL below. Patent abstracts and claims are USPTO public domain.

Cite as: Patentable. “Method and system for supporting multiple, historical, and future designs in a relational database” (US-6408312). https://patentable.app/patents/US-6408312

© 2026 Patentable. All rights reserved.

Patentable is a research and drafting-assistant tool, not a law firm, and does not provide legal advice. Documents we generate are drafts for review by a licensed patent attorney.