Node:Database, Next:Topology algorithm, Previous:Misc modules, Up:Top

Database

Database Organisation

We have placed the datas in the different bases in nine different tables.

                             --------------
                             |  port_info |
                             --------------
                             | id         |
                             | port       |
                             | bw         |
                             --------------
 ---------------                    |                 -------------
 | vlan_config |\              id_computer            |  type     |
 --------------- \                = id               /-------------
 | id          |  \                 |               / | id        |
 | port        |    id_computer     |          type   | nom       |
 | vlan        |     = id           |          = id   -------------
 ---------------        \           |         /
                         \          |        /
 ---------------          \  ----------------             -------------
 | remote      |           \ |  computer    |             | vlan_list |
 ---------------             ----------------             -------------
 | host_id     | id_computer | id_computer  | id_computer | id        |
 | port        |---- = ----- | type         | ---- = ---  | vlan      |
 | remote_mac  |   host_id   | flag         |     id      -------------
 | vlan        |             | last_up_date |
 ---------------             | tested       |
                             | constructor  |
                             ----------------
 ---------------              ·     |        \          ------------
 | tree        |             ·      |         \         | vlan_tag |
 ---------------    id_computer     |      id_computer  ------------
 | id_father   |   > id_father      |          = id  \  | id       |
 | father_port |   > id_son         |                 \ | vlan     |
 | id_son      | ·             id_computer              ------------
 | son_port    |·                 = id
 | vlan        |                    |
 ---------------                    |
                             ---------------
                             | asso_mac_ip |
                             ---------------
                             | id          |
                             | mac         |
                             | ip          |
                             ---------------

• computer : is the main table. It permits us to store the last date where the computer reponds to a SNMP query and the type of the computer. The field tested is an information used by the tree building algorithm.
• type : defines the different types of computer that you can met : switch, station, router...
• port_info : It permits to keep in memory band width of a given computer on a precise port.
• asso_mac_ip : makes the correspondence between the identifier of a computer, the MAC address, and the IP address.
• vlan_config : show which vlan goes through a port of an host.
• vlan_list : give all vlans which go through an host.
• vlan_tag : give, for a port of an host, which tag about vlan is made.
• tree : give all links between an host (the father) and all of its sons with a specified vlan.
• remote : store all adress MAC which are known by the host for a each port.