Anup Pokhrel

Date of Award

Fall 10-2001

Document Type


Degree Name

Master of Science in Information Systems (MSIS)

First Advisor

Minghua Wang

Second Advisor

Ronghua Shan

Third Advisor

Richard Christoph

Fourth Advisor

Stephen Krebsbach


The project deals with the implementation of a MSIS lab for Dakota State University. I have divided this project into 3 chapters. The MSIS lab concentrates in various networking and database issues as well as some project management skills and concepts. Chapter 1 of the project report is an outline of the project management skills and the overall concepts of the project. Chapter 2 is based upon the networking concepts in subnetting, Intranet design and performance analysis of NT and web server using ITS 4.0. The key concepts in this report will be in the design aspects of a subnetting of a network using class C network and finding the corresponding network and host addresses using a JavaScript program. This part of the report also tries to list the design considerations on building an intranet with web-enabled features. The main issue will be the creation of a www based web site with a corresponding URL. A DNS name was created for the translation of the host IP to the URL addresses. A similar FTP site was also created for the Intranet. A prototype of this proposed site has been generated by considering our networking course as a pilot project. The other part in this section was in the performance monitoring of an ITS 4.0 web server and some guidelines in improving the performance of the web server. This part also implemented some of the guidelines to improve the performance for an TIS server to host multiple web pages and FTP sites. Analyzing log files has always been a challenge for web administrators as it can generate a lot of details regarding the performance and security features of the web site. Log files traditionally are text based files and can be read easily but as the web sites grow in number, the log files starts to grow in size and in a busy site generating reports and storing them in a sequential manner becomes an arduous task, so if this log file was mapped to a relational database then the storing of the log files will be more ordered and structural. This is helpful in generating reports through queries. The parameters that can be generated by these log files include the client's IP address, login time, page, bytes sent and received. By using efficient SQL statements various reports can be generated. Chapter 3 of the project deals with the database design. This part discusses the need for an efficient backup and recovery system for an ORACLE 8i server.

This part also covers the need of a well-tuned ORACLE server. I have also analyzed some tuning parameters for a DSS and OLAP applications using ORACLE.