Michigan Data Systems P.O. Box 930804 Wixom, MI 48393 | 866-734-2623 (Toll Free)

Web Sites, Web Development, Applications, Database Integration and Networking.

Maintenance

Database Integration

Your database is clearly one of the most important aspects of your IT infrastructure. Ongoing maintenance, optimization, and disaster recovery procedures are all important aspects of protecting your data. As your business grows, these issues become more vital as both the number of transactions processed and the overall overall volume of data increases.

In order to maximize performance, we can recommend various tuning techniques including the proper indexing of your tables, data file disk allocation schemes, server hardware issues, query optimization, and many other strategies that will keep your database running efficiently.

In terms of disaster recovery, it is crucial that your data and transaction logs are backed up correctly and those backups are available in the event there is an outage. As relational database files are being accessed at all hours, this can sometimes impede your backup software from working as expected as some of these programs will skip files that are being accessed at the time of the backup. This situation can be managed by ensuring your backup software is configured correctly and we can help you do this.

In terms of new development, our philosophy is that the database is the foundation on which you will build your application on. Correct design and implementation is critical regardless whether your are running an eCommerce web site or a small time tracking application. We have extensive experience with SQL Server™, Oracle™, Sybase SQLAnywhere™, as well as the open source PostgreSQL™, and MySQL™ database servers.

© 2007 Michigan Data Systems. All rights reserved.	Visitors	537537