Abstract
TransGuide is an Advanced Traffic Management System (ATMS) in use by the Texas Department of Transportation (TxDOT). This paper investigates the complexities of storing data generated from a number of sources in a fashion that provides a timely transmission of data to the end-users of the TransGuide system.