Network inventory management system

1. A method for managing network resources, the method comprising:

populating a network resource database with a plurality of circuits, wherein a circuit of the plurality of circuits includes at least one segment, by

determining a first path between two devices for the at least one segment, wherein the two devices include a first device and a second device;

identifying a capacity for the at least one segment, wherein the capacity relates to a bandwidth available to the at least one segment,

generating a data set for the circuit of the plurality of circuits, wherein the data set includes the first path, the devices, and the capacity for all of the at least one segment with the respective circuit, and

storing the data set of the circuit of the plurality of circuits in the network resource database;

generating a query of the network resource database for a desired circuit of the plurality of circuits;

preprocessing the query including the data set of the circuit of the plurality of circuits; and

returning a result for the desired circuit including the first path, the devices, and the capacity corresponding to the circuit of the data set.

2. The method of claim 1 , wherein the first path is a physical connection between the two devices.

3. The method of claim 2 , further comprising

determining a first port on the first device and a second port on the second device to form the physical connection; and

including the first port and the second port for the physical connection within the data set for the circuit.

4. The method of claim 1 , wherein the at least one segment includes a plurality of network divisions that form the capacity, each of the network divisions using a portion of the bandwidth within the at least one segment.

5. The method of claim 4 , further comprising including the plurality of network divisions for the at least one segment within the data set for the circuit.

6. The method of claim 5 , further comprising identifying a network division of the network divisions within the at least one segment for the result for the desired circuit.

7. The method of claim 1 , further comprising determining a second path for the at least one segment, wherein the second path includes a separate physical connection between the two devices from a physical connection for the first path.

8. A method for managing network resources using a network resource database, the method comprising:

receiving a request for a desired circuit within a network;

querying the network resource database with information for the desired circuit;

retrieving data from a plurality of tables within the network resource database;

generating an intermediate table based on the data from the plurality of tables, wherein the intermediate table includes data of a stored circuit related to the desired circuit;

further querying the plurality of tables for data related to a segment of the stored circuit;

updating the intermediate table with the data related to the segment; and

producing a list of connection data from the data of the stored circuit for the desired circuit using the intermediate table.

9. The method of claim 8 , further comprising determining a network division within the segment of the stored circuit, wherein the network division corresponds to the desired circuit.

10. The method of claim 9 , further comprising deriving the segment of the stored circuit from the network division.

11. The method of claim 10 , further comprising, starting with the segment using the network division, using network division path data to determine a final segment for the list of connection data by analyzing at least one segment of a parent circuit for the stored circuit.

12. The method of claim 11 , further comprising determining if the parent circuit needs to be reversed.

13. The method of claim 11 , further comprising retrieving data for the parent circuit from the plurality of tables within the network resource database.

14. The method of claim 13 , further comprising updating the intermediate table based on the data for the parent circuit.

15. The method of claim 8 , further comprising automatically querying the network resource database for additional circuit data if the list of connection data includes a cloud segment.

16. The method of claim 8 , further comprising automatically querying the network resource database for additional data if a parent circuit of the stored circuit uses a ring topology.

17. The method of claim 8 , further comprising automatically querying the network resource for additional circuit data of the segment of stored circuit.

18. A network capacity resource management system comprising:

a processor;

a memory in communication with the processor and having stored thereon, processor-executable instructions for configuring the processor to perform operations comprising

receiving a request for a desired circuit within a network;

querying a network resource database within the network capacity resource management system with information for the desired circuit;

retrieving data from a plurality of tables within the network resource database;

generating an intermediate table based on the data from the plurality of tables, wherein the intermediate table includes data of a stored circuit related to the desired circuit;

further querying the plurality of tables for data related to a segment of the stored circuit;

updating the intermediate table with the data related to the segment; and

producing a list of connection data from the data of the stored circuit for the desired circuit using the intermediate table.

19. The network capacity resource management system of claim 18 , further comprising a user interface to display the list of connection data.

20. The network capacity resource management system of claim 18 , further comprising an inventory server to support the network resource database.