Case Studies/Clients
Case Study 1

Case Study 2

Past Clients

Home> Clients and Case Studies

*The following are case studies for corporations that KSG has consulted for in the past. To protect the confidentiality of the corporations, their names have been censored in the case study reports. These case study reports are intended to be used to demonstrate the type of methods KSG uses when consulting and not for any other commercial or academic purposes.

 

KSG Case Study 1

Client:                    A major computer company located in Osaka, Japan
Profile:                  Medium sized software developer in Japan with CMM Level 3 certification.
Application:              Linux, PostgreSQL, Java, Apache Web Server

 THE PROBLEM:

Generate effective website access statistics from a large distributed web server.

Most web access statistics generation systems are based on general/popular web server configurations like IIS or APACHE. So if there is a typically difference distributed web server configuration, and very specific statistics requirement, then all commercial web access statistics generation programs will fail. Our client (Daiwa computers) had this problem as they have a distributed web-based file system which was accessed by large distributed user base in Osaka and Tokyo.

THE CHALLENGE:

Using simple but powerful technology

THE SOLUTION:

Using XML as the basis of storing Web Server Access Statistics data.

Solution Overview:

The application is intended to access information from the log files of several distributed Apache Web Servers, and display the assimilated information in tabular and graph format. This information is to be displayed to users who are authenticated/authorized to view the information. The information is dynamic, and changes from time to time.

The log stores information on the various sites hosted on the Apache Web Server. The information to be displayed is: -

  1. Maximum hits per day
  2. Average hits per day
  3. Hit distribution by hours of the day
  4. Hit distribution by days of the week
  5. Hit distribution by months of the year

Process:

 


  1. The Application reads information from an XML file, to retrieve a list of users to whom e-mail has to be sent.
  2. The e-mail will contain a url, which directs the user to the site from where the information to be displayed will be provided.
  3. The user will be directed to an HTML Login/Password page to receive information.
  4. To view the information, the user will have to type in a user name and password for authentication. The information fed in will be checked against information stored earlier.
  5. Once the user is authenticated, s/he will be provided with the information received from the Apache Web Server log file. A call to the log file will be made only when the requisite information is needed. This will ensure that up-to-date information is always available.
  6. The information will be displayed across eight pages. Four of the pages will be used to display the information in a tabular format. The remaining four pages will display the same information through graphs. The graphs will be generated on the fly, using applets embedded in HTML pages.

Current Status:

Project is successfully completed. Client is satisfied with Knowledge Solution Group’s project consulting and offshore development abilities as well as Japanese language development abilities and facilities.

 

KSG Case Study 2

Client:                 A major Department of Transportation (DOT) for the United States Government
Profile:                    State Safety Office of (X)DOT
Application:            ASP, IIS5.0

 

PROJECT PROFILE:

We developed this solution for the State Govt. Department of Transportation (FDOT) and increased their effectiveness to handle accident emergencies and consolidate accident related data across the Florida state.

THE PROBLEM:

Consolidating data from all channels to a central database and allowing secured access to this data.

THE CHALLENGE:

Integration of data that in different formats and distributed. Providing singular access views across all different access channels.


WHAT WAS ACHIEVED?

The Web based Graphical User Interface for the Industrial Safety Information Management System (ISIMS) database improved the quality of the data, simplified data input and promoted the state’s Loss Prevention Procedure. This project delivered on time and within budget by KSG, improved the efficiency of data retrieval and input by it’s use of FDOT Intranet as opposed to the current Microsoft Access based application accessible from the Department’s WAN. Both the quality of the information collected and safety awareness within the Florida Department of Transportation, has be vastly improved since implementation of this project by offering a simple and easy to multi-channel interface application that is available to any workstation having FDOT Infonet access.

 

Red Text: Benefits of the solution provided by KSG

Blue Text: The technical Solution provided by KSG

 

Project Outline: Industrial Safety Information Management System (ISIMS)

The State Safety Office was desirous to modify the existing Industrial Safety Information Management System (ISIMS) in order to enable it to be utilized via the Intranet by Industrial Safety personnel throughout the state.

Project Description :

The Department of Transportation’s Loss Prevention Procedure (Topic No. 500-000-015-e) requires injuries/illnesses and vehicle crashes/incidents to be recorded and reported. The Industrial Safety Information Management System (ISIMS), maintained by the state Safety Office, is a system where data on all incidents involving DOT are recorded. The system allows electronic data input and retrieval by the Districts and provides the information that is utilized for program planning, and monitoring program implementation.

The proposed Web based Graphical User Interface for the existing ISIMS database improves the quality of the data, simplifies data input and promotes the state’s Loss Prevention Procedure. This project will improve the efficiency of data retrieval and input by it’s use of DOT Intranet as opposed to the current Microsoft Access based application accessible from the Department’s WAN. Both the quality of the information collected and safety awareness within the Florida Department of Transportation, can be vastly improved by offering a simple and easy to interface application that is available to any workstation having DOT Infonet access,

1. Overall objective of FDOT’s  ISIMS improvement Project

    • Move from high bandwidth Microsoft Access database to a quick, lightweight browser based application.
    • Further involve DOT personnel in the Loss Prevention Procedure and provide broader access to reports.
    • Expand potential users from exclusively DOT Industrial safety personnel to all supervisors and managers throughout the state who may have a need for this information.
    • Centralize file location as opposed to distributed files requiring manual synchronizing and thereby simplifying database management.
    • Accomplishment of enhancements, improvements or expansion of the program’s function, without taking the database out of service or having to replace-install application software.

2. Proposed Technical and Logistic Specifications for the DOT’s ISIMS improvement Project:

    • Security Access: Selective Read/Write permissions based on user level. Each user (Safety Personnel and Others) will have different Write/Edit capabilities according to their login/password combination.
    • All login and read/write/edit operations will be logged/audited and tagged (with timestamp) with login name of the person performing this action. Thus any abnormality and un-authorized activity will be immediately tracked and accounted for.
    • Record maintenance, Add/Edit/Delete Records will be fully operational and user friendly and intuitively designed GUI will help user in all steps
    • Query and search of all possible key words, combination of key words and simple phrases will be possible. Search within search results will be implemented. There will be prepared as well as custom queries.
    • Report generation facility can be either in-house (within the software and part of it) or it can be interfaced with a generalized report writing software like Actuate Reports or Power-Builder Report Writing Utility. Both custom reporting and predetermined/preprogrammed report writing and report generation/printout facility will be made.
    • Individual Reports/Custom Reports and Query/Search Results can be printed in customized formats.
    • Data export will facility will be provided for Delimited Text data format as well as Report Data to interface ISIMS with external report writing utility like Actuate Reports or Power-Builder Report Writing Utility
    • Hypertext links, all reference information, online user manual and user help with intuitive user help, will be provided.
    • All data input will be via secured interactive Web Forms.

3. Projected Benefits of the DOT’s ISIMS improvement Project:

    • The proposed improvement permits an electronic workflow approach that will reduce labor and paperwork requirements.
    • There will be more efficient utilization of LAN/WAN resources.
    • The interface will be user friendly and intuitive.
    • It is expected to muster greater participation in Loss Prevention Procedure throughout the state.
    • The system will simplify and converge all database management and maintenance requirements as compared to existing distributed database management and maintenance setup.                                                                                                                
SCOPE OF TECHNOLOGIES TO BE USED FOR ISIMS PROJECT

The scope of this project is restricted to the expansion of DOT’s existing Intranet Web pages and Industrial Safety portal contents. Recommended Server Side and Client Side Technologies are proposed, but not limited to the following:

  • Database:  MS SQL Server (or Oracle 8i)
  • Web Server: MS-IIS 4.0. Running on NT 4.0 (or MS IIS 5.0, running on MS Windows 2000 Server or MS Windows XP-Server)
  • Middleware: ASP (ADO), ActiveX, VBScripts, Javascripts and PERLscripts.
  • Content: HTML, CSS, DHTML, XML and XSL.
  • FrontEnd: MS Internet Explorer  (IE.) 5.0 or (IE.) 6.0 

Current Status :

Project is successfully completed. Client is satisfied with Knowledge Solution Group’s project consulting and offshore development abilities.

 

Past Clients

KSG has collaborated with many respected companies since its inception in 2001. Here is a list of just a few of the companies that have been satisfied with KSG's consulting services:

 

3

Sun Microsystems

 

Axa Life Insurance

 

State of Florida Department of Transportation

 

AIG-Chiyoda Life Insurance Japan

 

Carnegie Mellon University

 

111

KPMG

 

Bakbone

 

1

UBS

2

SEKOM

1

Microsoft Corporation