Method for organizing a relational database used for storing data

Abstract

A method and program product for organizing a relational database used for the storage of data related to the configuration and placement of equipment in field sites. The method includes recording, maintaining, and viewing placement and configuration of equipment in remote field sites. Additionally, the method includes defining equipment in terms of components, such as modules, shelves, and racks. Once components are defined and stored in the database, they are configured by specifying interrelationships between components. The program product includes a computer useable medium having computer program logic stored therein for enabling a computer to store data associated with the configuration and placement of equipment in field sites, the equipment includes rails, shelves, and modules. The computer program logic includes a relational database organization having a product catalog for storing data associated with the components, a configuration library for storing data associated with the equipment, a site hierarchy repository for storing data associated with the field sites, and an equipment placement library for storing data associated with a location of said equipment within the field sites.