Database Development Best Practices Methodology
Develop, Optimize, Validate
The approach begins with developers on a project team. The developers have access to a version control system that enables team coding and simplifies the sharing of code. Through best practices, each developer can build code faster and cleaner, with fewer bugs, by employing the following steps:
- Prepare – Define the test and other criteria by which code will fully meet functional requirements
- Write and Compile – Build the code units according to pre-defined project coding standards
- Test Code – Use unit testing to identify gaps between code and functional requirements
- Debug – Use an advanced source code debugger to quickly identify and fix problematic code
- Optimize SQL Statements – Scan code for problematic SQL statements that may cause serious bottlenecks in performance and with one click, find the most efficient SQL alternative - Learn more about Quest SQL Optimizer for Oracle
Delivering efficient and easy-to-maintain code depends on optimization of the SQL statements themselves. According to industry analysts, at least 60 percent of database performance issues are SQL-related1.
The optimization process combines a quality review of all source code in the VCS repository and a code scan to identify potential SQL performance issues. Once identified, problematic SQL statements are then rewritten in every possible way with the best one being returned to the source code.
Development managers and team leaders can schedule this entire process and produce a report, presented as a Code Review dashboard, which allows them to visualize code metrics and potential SQL performance problems for multiple programs. This Web-based report allows key stakeholders to identify all project code that either performs well and is ready for validation or needs to be returned to development and fixed.
Once the code is tested and optimized, it is promoted to quality assurance. Before deploying applications into production, it is essential for quality assurance teams to perform testing that validates code for functionality using automated regression testing, and for scalability under production-like conditions, which includes user load. This helps to ensure code will perform optimally in production.
Development organizations that implement Quest’s Quest’s Toad Development Suite for Oracle will reduce the impact of inefficient code on productivity, future development cycles and the bottom line.
Go back to Toad for Oracle Web pages
Footnote 1: Refer to – http://www.nist.gov/public_affairs/releases/n02-10.htm