An Experiment to Design an Operation and Maintenance System Integrating Apriori Association Rules for a Telecom Platform

Algorithm 1

Some of the core code in data collection.

#!/bin/bash.

[process data and time variables]

#connect to the platform backend database

USERNUM=`sqlplus -s [database user name]/[database password] <<EOF

[SQLstatement]

#output the results to a log file

echo filedate$yy-$mm >./record/$yy-$mm-usernum.rec

echo lastdate$yy2-$mm2 >>./record/$yy-$mm-usernum.rec

echo $USERNUM >>./record/$yy-$mm-usernum.rec