Services Survey Site Map Tools Extranet Search

Data Processing
Data Management
Data Warehouse
Data Access
Data Collection
Reporting


DSC Services Data Management.

DSC uses our centralized Data Trust Management system to ensure what goes in to our system is exactly what comes out.  What exactly is our Data Trust Management sysytem.  Well to start with our system includes a centralized relational database (Microsoft SQL Server 2000) that serves as the backbone for our database system.  The database resides on Dell poweredge servers which provide excellent reliability and redundant systems to provide continuous uptime.  Our servers implement hardware based RAID 5 technology to prevent crashes in the unlikely event of a disk failure.  In addition to RAID systems, a DLT tape library backs up the database ever day to ensure data availability.  Finally if that is not enough, the Backup tapes are stored in a secure off-site location.

The system also incorporates multiple software checks and balances to ensure data accuracy.  Some of these procedures include server based stored procedures, and triggers that ensure the referential integrity between tables in the database.  Custom DTS import/export programs that ensures the data arrives and leaves as it is supposed to, and custom cleaning programs to ensure the data is transformed correctly.

 

 

 

 

 

Copyright 1999 DSC Services Inc. All rights reserved.