Sybase触发器在基于IP网络流量计费中的应用

Sybase Application of Trigger in Network Account Based on IP Flow

按流量网络计费的过程中采集的数据量非常巨大,而使用数据库触发器技术可以高效准确累计网络流量。文中介绍了触发器的工作原理,提出了基于IP网络流量的网络计费的一种模式,并且给出解决网络计费中实时累计流量的触发器示例。经过软件测试,使用触发器能大大提高网络计费数据累加的效率和性能。

There are very huge account data in gaining network flow based on IP.By using trigger technology, can add up network flow more efficiently and accurately.Here shows the principle of trigger,and offers a mode of network account based on IP flow.Further more,a specific example of trigger is given and explained for soluting the problem that lies in accumulative total of network flow.With the software testing,it is concluded that using the database trigger can improve the efficiency and performance of network accumulation accounts.