Databases

All of our systems engineers have both a solid understanding and experience with SQL Relational Database Management Systems (RDBMs).

Commercial Databases

On the commercial proprietary side, we can provide consulting services for Oracle and Microsoft SQL Server. For Oracle, our staff has training and experience in both the DBA and PL/SQL scripting roles. For MSSQL, we have experience with Transact SQL for writing stored procedures and functions within the database.

Open Source Databases

On the open source side, we use both the enterprise-level PostgreSQL DBMS and MySQL which has become very popular in the PHP world. As an Object/Relational database, PgSQL has supported many features like views, stored procedures, and transactions for years. MySQL is starting to support these advanced features but only under special circumstances like non-default table types that many developers don't know about yet. Over the last couple of years we have been involved with database scalability projects for both databases. This includes configuration tweaking and replication.