Optimization Modelling in Multilayer Networks Using SQL and OPLScripts

"Multi-layer telecommunication networks are becoming the predominant transport architecture. T1/E1 circuits, SDH lower and higher layers, wavelength division multiplexing (WDM), optical fiber pairs and cables are all stacked one over the other. This paper proposes a relational database scheme to represent all these layers in such a way that makes it easier to define and build optimization design models. Two relevant optimization models are described: fiber pair routing and VC-over-STM routing. Multicommodity network flow models are built using OPLScript. The first problem is modelled using an arc-path and the second one, using a node-arc formulation. These formulations are mapped onto the proposed database."