Database Services

BKI provides professional services utilizing a full range of industry standard database system software including: Oracle, SQL Server, Microsoft Access, Sybase, and SQL Anywhere. Our database services feature:

 

Database Modeling - We will design a database to accomodate all of your data storage and application development needs.

 

Database Integration - Many organizations have data scattered in different places and in different formats. BKI can integrate these sources into a single database upon which to base a common user interface.

 

Database Improvements - Older databases are often developed as flat-file systems with one record containing all possible fields of data. We can help improve the performance of the database and reduce input errors by "normalizing" the structure with lookup tables and other improvements.

 

Database Systems - BKI develops standalone database applications that can run with or without the GIS.

 

GeoDatabase Development - A GeoDatabase (GDB) is a special database used to store geographic information. We have worked with this format since its inception around 1999 and have participated in helping to develop standardized data structures.

 

Highlights of our Database Services include:

 

Phenix City Crime Database Integration to GIS

BKI developed a data transfer process to obtain periodic crime information updates from the Police Department’s...

more »

Phenix City Hydrant Database Integration to GIS

Phenix City had an existing hydrant information database, but it had no link to a GIS. The City contracted BKI...

more »

Jefferson County Program Management Database Services

BKI was tasked to provide general GIS support for Jefferson County’s Sewer Infrastructure Management System (SIMS) as a task amendment to an existing Program Management contract...

more »