Traffic analysis apparatus for traffic information data warehouse of telephone network

摘要

PURPOSE: An apparatus for analyzing traffic in a telephone network traffic information data warehouse is provided to efficiently offer basic data necessary for various communication fields by applying a multi-dimensional modeling to the traffic data collected from CTMS/Local and CTMS/Toll using a mass database and analyzing the traffic data at various search points of view. CONSTITUTION: A multi-dimensional modeling part(102) executes modeling for the contents of a telephone network traffic information table(101) by analysis subjects on the basis of analysis facts and analysis dimensions after loading a database with the traffic data source files collected from CTMS/Local and CTMS/Toll. A fact table generation part(103) generates a fact/dimension table(104) for modeled analysis facts and dimensions. A summary table generation part(106) generates a summary table(106) for the contents of an inquiry requiring much time in the case of searching the contents of the fact table. An information search part(108) searches the contents of the fact/dimension table(104) through a private/public network(107) multi-dimensionally.