Abstract—Network administrators are always interested in analyz-ing the activities and bandwidth usage of network users in order to manage network. Usually, third party tools are being used for such analysis, but third party tools suffer from slow response and lack of customization options. In this paper, we present a novel approach for the effective and very flexible multi-dimensional analysis of network usage, by directly analyzing the ISA Server Proxy Logs. In this approach, we accumulate the ISA Server logs into SQL Server and transform it into the dimensional model using SQL Server Integration Services. Dimensional model is a database modeling technique for the efficient analysis of large datasets. In order to evaluate the effectiveness of our proposed approach, we analyze ISA Server Proxy logs generated at a local university.
Index Terms—Dimensional Analysis, Dimensional Modeling, ISA Server Logs, Proxy Server Logs, SQL Server Integration Services.
Salman Ahmed Shaikh is with the Dept. of Computer Systems and Software Engineering, Mehran University of Engineering and Technology, Jamshoro, Pakistan.
**Dr. Manzoor Hashmani is with the Dept. of Computer Systems and Software Engineering, Mehran University of Engineering and Technology, Jamshoro, Pakistan.
Cite: Salman Ahmed Shaikh and Manzoor Hashmani, "Multi-Dimensional Analysis of ISA Server Logs," International Journal of Computer Theory and Engineering vol. 1, no. 3, pp. 272-275, 2009.