The week's pick
Reseach Article
An Efficient Technique for Web Log Preprocessing using Microsoft Excel
| International Journal of Computer Applications |
| Foundation of Computer Science (FCS), NY, USA |
| Volume 90 - Number 12 |
| Year of Publication: 2014 |
| Authors: Chintan H. Makwana, Kirit R. Rathod |
10.5120/15774-4517
|
Chintan H. Makwana, Kirit R. Rathod . An Efficient Technique for Web Log Preprocessing using Microsoft Excel. International Journal of Computer Applications. 90, 12 ( March 2014), 25-28. DOI=10.5120/15774-4517
Abstract
Web log file shows the behavior of user when they access the website. It is in text format and automatically generated by web server whenever user accesses the website. Entry of particular web page with date, time, cs-method, cs-uri-stem and other information is generated automatically in text file for every access of web page. Web Usage Mining is different mining technique apply on weblog file to discover the different pattern which is useful for efficient design of website, performance enhancement of server etc. Mining of web log file consist of three steps Data Preprocessing, Pattern Discovery and Pattern Analysis. Data preprocessing task convert the web log file in database by applying data extraction, data storage and data cleaning technique. In existing technique data extraction from the log file is perform line by line and store in multidimensional array and then extracted data field will be store in database and then data cleaning is performed. In this research paper, a new technique is being proposed for Data Preprocessing of web log using Microsoft Excel. The experimental results show that the proposed new technique using Microsoft excel file is an effective compare to existing technique.
References
- P. Nithya and Dr. P. Sumathi, Novel Pre-Processing Technique for Web Log Mining by Removing Global Noise and Web Robots, IEEE National Conference on Computing and Communication Systems (NCCCS), 2012
- S. Chitra and Dr. B. Kalpana, A Novel Preprocessing Mixed Ancestral Graph Technique for Session Construction, IEEE International Conference on Computer Communication and Informatics (ICCCI-2013), Jan. 04 – 06, 2013, Coimbatore, INDIA
- Manisha Valera and Kirit Rathod, A Novel Approach of Mining Frequent Sequential Pattern from Customized Web Log Preprocessing, International Journal of Engineering Research and Applications, Vol. 3, Issue 1, February 2013, 269-380
- Surbhi Anand and Rinkie Rani Aggarwal, An Efficient Algorithm for Data Cleaning of Log File using File Extenstions, International Journal of Computer Applications, 48(8), June 2012, 13-18
- V. Chitraa and Dr. Antony Selvadoss Thanamani, A Novel Techniques for Sessions Identification in Web Usage Mining Preprocessing, International Journal of Computer Applications, 34(9), November 2011, 23-27
- Margaret H. Dunham, Data Mining Introductory and Advanced Topics, 8th Impression, Person, 2012, 193-218.
- Ms. Dipa Dixit and Ms. M Kiruthika, PREPROCESSING OF LOG FILES, International Journal on Computer Science and Engineering(IJCSE), Vol. 02, No. 07, 2010, 2447-2452.
- Vijayashri Losarwar, Dr. Madhuri Joshi, "Data Preprocessing in Web Usage Mining", International Conference on Artificial Intelligence and Embedded Systems (ICAIES'2012) July 15-16, 2012 Singapore.
Index Terms
Keywords