Database Testing

 

Code Q understands the importance of database testing setup and execution. This testing can often involve a series of different database abstractions, such as ETL operations, data-warehouses, data-marts and data-vaults.

 

 

Our testing might include testing a web form that inserts data into a database -- tracing that transaction from the web to the database is a very important testing process. Testing of that insertion and then validating that the right triggers are being executed can involve many different tools and technologies.

 

 

Code Q's practice-based testing group has experience:

 

• Testing the referential integrity of a database

• Testing database security including database permissions and privileges

• Testing the interfaces to the database such as GUIs, Java, and web services

• Testing Application programming interfaces (APIs) such as ODBC, JDBC, and OLEDB

• Testing data-format integrity

• Testing database and DataMart loads through specialized load tools

• Testing ETL operations

 

Code Q is well versed in many database test tools, such as:

 

• DBFit

• DBUnit

• OUnit for Oracle

• SQLUnit

• TOAD

• Visual Studio Team Edition for Database Professionals