Data integration

• US 7,308,454 B2
• Filed: 11/11/2002
• Issued: 12/11/2007
• Est. Priority Date: 11/09/2001
• Status: Expired due to Term

• Current Assignee: British Telecommunications PLC (BT Group PLC), Michael P. Toepel, Zap - It Corporation
• Original Assignee: British Telecommunications PLC (BT Group PLC)
• Inventors: Abineri, Robert F, Jackson, Maatthew, Shackle, Terry
• Primary Examiner(s): Rimell, Sam
• Assistant Examiner(s): Cao, Phuong-Thao
• Application Number:
  US10/494,941
• Publication Number:
  US 20050015397A1
• Time in Patent Office: 1,856 Days
• Field of Search: 707100-102, 707/1
• US Class Current: 1/1
• CPC Class Codes: G06F 16/289 Object oriented databases
• CPC Class Codes: Y10S 707/99942 Manipulating data structure, e.g. compression, compaction, compilation

Abstract

An inventory management system includes a database for storing object oriented network inventory data. Data on network components is input into the database as different selected classes of objects. An object identifier is selectively added dependent on the class of object. At least one class of objects can accommodate other objects such that is stored as a modified object tree without all objects contributing to the object identifier.

Claims

1. A method of loading disparate sets of records into a database stored in a storage medium, said method comprising:

storing data in said storage medium listing a set of levels to be included in a generic containment hierarchy, wherein a record in said database is referenced by a full multi-level index comprising a level value for each level in said generic containment hierarchy;

receiving a set of records, each record including an abbreviated multi-level index comprising a set of level values, for a corresponding set of levels included in a specific containment hierarchy whose levels form a subset of said generic containment hierarchy; and

for each of said records, inserting values for each level present in said generic containment hierarchy but absent from said specific containment hierarchy in between consecutive values of said abbreviated multi-level index to generate a full multi-level index to said record.

2. The method as in claim 1 wherein said inserting step comprises:

storing data associating one or more level values in said abbreviated multi-level index with one or more level values for insertion at an immediately higher level in said generic hierarchy.

3. The method as in claim 2 wherein said data is stored in the form of a specific hierarchy.

4. The method as in claim 2 further comprising the step of storing one or more further sets of records representing further containment hierarchies.

5. The method as in claim 1 wherein said full multi-level index represents a hierarchy of containers in an inventory database.

6. The method as in claim 5 wherein said inventory database represents the inventory of a telecommunications network operator.

7. A database system with contents representing a communications network, said database system comprising:

a first element manager arranged in operation to output a first file comprising records labeled in accordance with a first specific containment hierarchy;

a computer system storing a network inventory database;

means providing communication between said element managers and said computer system;

software stored on said computer system configured to integrate records from said first files into said network inventory database by;

storing data listing a set of levels to be included in a generic containment hierarchy, wherein a record in said database is referenced by a full multi-level index comprising a level value for each level in said generic containment hierarchy;

receiving records from said first file, each record including an abbreviated multi-level index comprising a set of level values for a corresponding first set of levels included in said first specific containment hierarchy whose levels form a subset of said generic containment hierarchy; and

for each of said records from said first file, inserting values for each level present in said generic containment hierarchy but absent from said first specific containment hierarchy in between consecutive values of said abbreviated multi-level index to generate a full multi-level index to said record.

8. The database system as in claim 7 further comprising:

a second element manager arranged in operation to output a second file comprising records labeled in accordance with a second specific containment hierarchy sharing at least one level with said first specific containment hierarchy, said software stored on said computer being further configured to implement a method comprising;

receiving records from said second file, each record including an abbreviated multi-level index comprising a set of level values for a corresponding second set of levels included in said second specific containment hierarchy whose levels form a subset of said generic containment hierarchy; and

for each of said records from said second file, inserting values for each level present in said generic containment hierarchy but absent from said second specific containment hierarchy in between consecutive values of said abbreviated multi-level index to generate a full multi-level index to said record.