Database design & administration

RSG’s clients often have the need to collect, process, and analyze large amounts of data. Our software team is skilled in architecting fast and efficient relational database systems in either open-source or licensed environments for data collection, conflation, mining, and analytics. We are well versed in N-tier architectures for distributed performance, backup strategies and data security, stored procedures, database tuning, and object-relational mapping between databases and software. We also have expertise optimizing the performance of shared databases and cloud services implementations. RSG can help clients select the right database technology and environment for the application, design relational models and schema, and perform the implementation, including related administration.

Wind Turbine Acoustics Research Study

RSG, in cooperation with Northeast Wind, Inc. (NEWind) and Epsilon Associates, Inc. (Epsilon), is working with the Massachusetts Clean Energy Center (MassCEC) and the

Read More

International Air Travel Itinerary Model

RSG built a web-based and SQL-driven global flight model engine that constructs all possible flight itineraries (up to three connections) under ever-changing input parameters.

Read More

Utah Statewide Travel Study

RSG designed and implemented a statewide household travel diary study for the six major planning agencies across Utah. The work included a one-day travel

Read More

Traveler Behavior Longitudinal Panel

As a complement to the Integrated Corridor Management (ICM) Initiative Demonstration projects that are being funded by U.S. DOT, the Volpe Center and RSG

Read More

Impact of Road Pricing on Traveler Behavior

RSG conducted a study with the Volpe National Transportation Systems Center (Volpe Center) to measure changes in travel behavior in response to road pricing

Read More