Operating a Network Using Relational Database Methodology

• US 20110125810A1
• Filed: 11/22/2009
• Published: 05/26/2011
• Est. Priority Date: 11/22/2009
• Status: Abandoned Application

• Current Assignee: AT&T Intellectual Property I LP (AT&T, Inc.)
• Original Assignee: AT&T Intellectual Property I LP (AT&T, Inc.)
• Inventors: Chen, Xu, Mao, Zhuoqing M., Van der Merwe, Jacobus E., Mao, Yun
• Application Number:
  US12/623,424
• Publication Number:
  US 20110125810A1
• Time in Patent Office: Days
• US Class Current: 707/812
• CPC Class Codes: H04L 41/024 using relational databases for representation of network management data, e.g. managing via structured query language [SQL]

Abstract

In one embodiment, the disclosed technology involves modeling network elements, such as router configurations and link information, as well as any generic network status, as data in a relational database. Various network data, such as router states and link states are abstracted into tables in the relational database. Network management operations may then be represented as a series of transactional database queries and insertions. As a result, the database automatically propagates, to the appropriate network elements, state changes that are written to database tables, thereby implementing various network operations. Tables in the database can be constructed at various levels of abstraction, as required to satisfy network operational demands. Programmability is provided by a declarative language composed of a series of database queries and insertions.

Claims

1. A method comprising:

a. changing, at an address of a memory device, the address associated with a cell of a table in a relational database, data representative of a characteristic associated with a component of a network; and

b. communicating, to a component of the network, information associated with the data change.

2. The method of claim 1 further comprising changing the characteristic based on the communicated information.

3. The method of claim 1 wherein the component of the network to which the information is communicated is the same component that has a characteristic represented by the data, and further comprising changing the characteristic of the component to which the information is communicated, based on the communicated information.

4. The method of claim 2 wherein the database is a centralized database.

5. The method of claim 2 wherein the database is distributed over a plurality of network components.

6. The method of claim 2 wherein the one component is selected from the group consisting of a switch, a router and a communications link.

7. The method of claim 2 wherein a declarative, rule-based language is used to interact with the database.

8. The method of claim 2 wherein each of at least two tables in the database represent the network at a different level of abstraction.

9. The method of claim 8 wherein the levels of abstraction are selected from the group consisting of service, network and device levels of abstraction

10. The method of claim 2 wherein changing the characteristic of the at least one component is associated with a network operation selected from the group consisting of planned maintenance, emergency repair, fault management, configuration management, traffic management, performance management, and security management.

11. The method of claim 2 further comprising specifying a constraint in the relationship between the data associated with at least two network elements.

20. The method of claim 2 wherein the database is adapted to constraint the relationship between the data associated with the two network elements

12. A method of operating a network comprising:

a. receiving information associated with a change in data entered in a memory device, the data entered at a memory position of the memory device associated with a cell of a relational database, the data being associated with a characteristic of a component of a network; and

b. changing the characteristic of the component based on the received information.

13. A network comprising:

a. at least two network devices

b. a memory device with memory positions associated with cells of at least one table of a relational database, the cells associated with at least one characteristic of at least one network device;

c. a data entry device for entering data into the memory positions;

d. a communication device for communicating information associated with a change in the data in a memory position associated with the at least one characteristic of the at least one network device, and

e. the at least one network device adapted to change a characteristic of the at least one network device based on the communicated information.

14. The network of claim 13 wherein the database is centralized.

15. The network of claim 13 wherein the database is distributed over a plurality of network devices.

16. The network of claim 13 wherein the network device is selected from the group consisting of a switch, a router, and a communications link.

17. The network of claim 13 wherein the database is adapted for use with a declarative, rule-based language.

18. The network of claim 13 wherein each of at least two tables in the database represent the network at a different level of abstraction.

19. The network of claim 13 wherein the levels of abstraction are selected from the group consisting of service, network and device levels of abstraction