CIM Concepts - Database Services

CIM Concepts provides a full spectrum of database services from initial database design through ongoing database administration. We've got you covered with...

Oracle

SQL Server

Informix

MS Access

Database Design

A robust database design up front can save you time and money in the future by handling additional data more readily. CIM Concepts works with clients to thoroughly understand data requirements. We can advise on either transactional (OLTP) or analytical (OLAP) design strategies. We use modeling tools such as AllFusion ERwin to refine and present a complex design in visual manner.

Implementation and Tuning

CIM Concepts can implement the accepted design on your choice of database platform, installing and configuring the database software if necessary. We understand and build in tuning elements (such as appropriate indexes) from the start. Once operational, we continue to monitor and tune databases in the test and production phases.

Stored SQL Code

Our database experts are well versed in coding views and stored SQL elements -- triggers, procedures, and functions -- to ease the burden from applications code. Good design dictates that constraints and rules for maintaining data integrity are coded within the database itself, while business rules are coded within the application layer.

Database Administration

Unfortunately for information technology directors, complex relational database systems like Oracle and SQL Server need trained database administrators (DBA's) to support them. CIM Concepts can help with your database administration needs, whether for planning, short-term crisis resolution, or ongoing support. database file storage

Monitoring and Tuning

When application performance degrades over time, it is often a sign that database tuning is needed. Creation of a key index, or generation of missing index statistics, can increase response time by tenfold or more in some cases. Maybe your sluggish database can be brought back to life -- let us take a look!

Backup and Recovery

Disaster planning is not fun or flashy, but is absolutely necessary for any computing environment. Simply copying raw datafiles to tape does NOT protect Oracle or SQL Server data. CIM Concepts DBA's can design, implement, and document comprehensive backup and recovery strategies for your database environment.

Extract, Transform and Load

ETL is an acronym for Extract, Transform, and Load -- the automated process of moving data from one format and environment to another. Each database platform has its own tools and methods for data load. CIM Concepts knows the tools for each environment and can design an efficient ETL process for your situation.