NETWORK DATABASE AND POLLER

This MS-SQL database is a repository for monitoring complex networks. A Dot NET Property Grid-like front end enables the user to browse through the network. The multidimensional data cube reflects the current and historic state of a network of daisy-chained fiber modems, IP radios, IP-to-serial devices and multi-drop serial connections.

DMS/VMS DATABASE

Because web-based interfaces (as well as some on the desktop as well) do not multi-thread, this MS-SQL database does the heavy lifting for multi-threaded communication to variable message signs located throughout the Colorado Front Range. Database triggers send and clear messages via modems, fiber-optic networks, and serial networks, and maintain a history of NTCIP Sets and Gets.

TIGER DATABASE

Before Google became the 800-pound gorilla of mapping databases, there was the US Census Bureau's TIGER Database. Our implementation of the database included algorithms to decompose the lat-long chains and recompose them into polys before delivering the data to front-end mapping software. It also merged USGS Gazeteer data on landmarks.

MESONET DATABASE

MESONET soil data is available online, but it is usually presented as graphical data (maps) rather than tabular data. This database compiles MESONET data from a number of external NOAA databases and records soil temperature, soil moisture, precipitation, and temperature for access by a user front-end that finds a "best-fit" for vegetable garden planting times.

DATABASE XML FOR EXPLICIT

Sometimes, despite all other options, it is necessary to pull data out of MS-SQL using the XML FOR EXPLICIT option, which will deliver a structured XML document in line with the needs of the presentation layer. More often than not, this is due to a database structure that predates the presentation layer. We don't love it, but we have wide experience with it.

ALEXANDER ANIMATION DATABASE PT 1

Between the early 1920s and late 1950s, who was the biggest animation studio? Alexander Film. The original Alexander Film Company has long been out of business, but the current owners of the archives of hand-drawn animation flimsies and hand painted cels wanted to compile a database of a portion of the 5,000,000 cels and drawings.

ALEXANDER ANIMATION DATABASE PT 2

Part of the back end for a web application, the database stores thousands of cell images, which were originally painted in what is called in animation parlance "2's" and "3's" and "4's". The middleware accesses images portions and creates a composited final image.

ONLINE JOB SEEKER DATABASE

Part of a small stand-alone desktop application, this database compiles listings scraped from the web for application-layer sorting and searching.

ROAD CONDITIONS DATABASE

In most states road conditions are compiled by the Highway Patrol or State Troopers. This database is a backend component of an automated cable television reporting service. It compiles data from multiple sources in a tri-state area and feeds the data to the application layer. Triggers within the database filter and evaluate the road conditions and serve up appropriate xml strings with references to keyed images.

PD-CAD INCIDENT DATABASE

This database takes strings from the police department computer-aided dispatching systems, parses the strings, filters for traffic accidents and road incidents (and disposes of other police-related data), geocodes the addresses for latitude and longitude, and stores the data for mapping apps. Longitudinal data can be used for trend detection.

TRAFFIC RADAR SPEED DATABASE

Speed data from radar sensors usually come as an Octet String that is broken into segments, which contain individual vehicle speeds, lane counts, average lane speeds, occupancy, and volume data for multiple lanes traveling in multiple directions. This data is parsed either by a trigger or the software poller that opens the ports to the device and reads the data.

SCHEDULING DATABASE

This Matrix sign scheduler posts LED matrix messages at predetermined times. The scheduler allows for operator and supervisory overrides that are based on numeric authorization levels. As messages expire, the database rolls back previous messages and posts them to the devices.

IMAGE/VIDEO DATABASES

We cut our teeth on these sorts of databases, compiling video segments and still images databases stored on videodisks, CD-ROMS, DVDs, and disk drives.

WEATHER DATABASES

We originally built these databases for automated weather reports for television presentation, but also used the data for operation center consoles. The data was collected through acessing NOAA and MESONET stations.