Case Studies - Database design, development & administration

General Electric

Business Problem: Application specific web site requires a database, which can handle over 100 million records. The database must provide sub second response time to numerous queries and updates. Database must handle the integration of large data files from external accounting systems allowing for expedited inserts and updates.

Solution:

  • TSG designed a SQL Server database and schema, which would quickly handle automated aggregation of data from multiple accounting systems.
  • Developed extensive set of stored procedures to facilitate inserts, updates, queries and view to support extensive web based application comprising of over 40 different analytical tools.
  • Designed a suite of Data Transformation Services (DTS) packages to allow for the automated loading of accounting financial files through a web based submission process.
  • Created an extensive suite of exception reports based on GE’s performance metrics. Exception reports utilize SQL Server Jobs, SQL Mail and stored procedures to automatically deliver non-conformance analysis to key analysts.
  • Devised a comprehensive database maintenance plan, which automatically re-indexes, optimizes, and securely backs up GE databases.

Pogo, Inc

Business Problem: – Production data for the corporation was scattered across multiple locations (Houston, Midland, Canada, and Thailand) in a variety of different databases (Access, SQL Server, Oracle, and Excalibur) which made it very difficult for Corporate headquarters to adequately track production performance.

Solution:

  • TSG assisted Pogo in the conversion of Reserves and Economic databases from Access to SQL Server. This conversion required translation utilities to move data to a different schema as required by the software upgrade.
  • TSG developed a data mart, which automatically synchronized nightly production from four different production systems via the Internet. Systems included SQL Server, Oracle, and Excalibur databases.
  • TSG worked with POGO IS to devised a comprehensive database maintenance plan, which automatically re-indexes, optimizes, and securely backs up corporate databases.

BenefitsHighway.com

Business Problem: BenefitsHighway wanted to substantially increase the number of simultaneous users that could access their web site. Their current Access database was insufficient to handle the anticipated increase in web site hits. Additionally BenefitsHighway want to make substantial improvements to the application, which required extensive database schema redesign.

Solution:

  • TSG ported all data from an Access Database into SQL Server.
  • Designed new database schema to support additional functionality added to the BenefitsHighway web based application. Schema modifications supported dynamic links to Health Care Provider Web Sites, new Human Resource Management Module, and substantially expanded the benefits tracking capabilities of the web site.
  • Developed stored procedures to support ADO calls from associated web pages. Over 25 different analytical tools are supported along with Microsoft Office integration.
  • Devised a comprehensive database maintenance plan, which automatically re-indexes, optimizes, and securely backs up GE databases.
  • TSG provides on-going web and database hosting for BenefitsHighway

Back to List