WTT allows its users to quickly generate freight bills, computing expenses and profit. I wrote a data conversion utility in Visual Basic that would extract data from an existing system and populate a Microsoft Access database. Using ADO, I pull player information based on several search criteria. Over 2000 workstations have the application installed, and 1000s more have access to the Web query tools. I designed and implemented a 2gb database for Idaho Power, the State of Idaho's primary power utility, to maintain water and weather data collected from various sources.
Stored procedures allow statistical and denormalization routines to run unattended at night.
Users running the client application can direct ad-hoc query results to the screen, text file, web browser, or to an Excel chart via automation. A conversion from an existing database provided a baseline for the structure, but discussion with analysts from the US Geological Survey and the US Bureau of Reclamation was required to design a format which would be able to accommodate data collected from numerous sources. After a thorough testing period, the application was deployed to dozens of users. Using Help Breeze version 2.0 I was able to easily compile these Microsoft Word documents into online, context-sensitive help for the application. HDB has been running efficiently since March 1998, providing fast access to over 30 million records of data.