PROJECTS

INTERNET/ INTRANET BASED TIME TRACKING

This project is an excellent example of building a system using the latest Internet/Intranet technologies. The client needed a time tracking system, accessible from both inside the office and remotely. To achieve this we chose a three-tiered architecture structure and utilized Java technology (MS Visual J++). This allowed access from anywhere using a Java enabled web browser.

Database Engine used was MS SQL Server. A Java Server application is executed under Windows NT. The client interface is in the form of 6 Java Applets. Users load Applets from MS Internet Information Server either remotely (Internet) or locally (Intranet). Client applets maintain connection with server application using TCP/IP socket connections. Server application connects with MS SQL Server via ODBC. To minimize bandwidth requirements the queries to the server are stored procedures.

Server application allows isolation of database structure and no direct connection with MS SQL Server from client applets. As a result, a potential hacker would not be able to carry out an unauthorized database inquiry or modify database data. User authentication is based on standard MS IIS settings and ASP scripts.

Utilizing Java technology for Client Interface allowed full functionality from within any Java enabled web browser.

The system stores the necessary configuration data in the Operating System registry. To provide registry access via ASP-scripts an ActiveX component was developed.

Total size of Java source text for the project is 630Kb. The project comprises 6 Java Applets, 1 Java Server Application, 2 ASP Scripts, 1 HTML Page, 1 ActiveX Component, and SQL Scripts.