Several tools provide mechanisms that allow the user to select from a variety of database systems. Tools store historical project information, which can be used to produce past defect trends. Queries provide a method to retrieve stored data. Tools provide the capability to query proprietary and commercial databases. Queries allow the user to sort and filter defect information.
Several tools provide graphical query builders and store the queries for later use.
Arithmetic analysis - A variety of algorithms, e.g., totals, percentages, averages, and ratios, are used in processing defect data. Examples include total number of defects opened, percentage of defects found during testing, average number of defects per module, and ratio of defects found per test case. Statistical analysis capabilities involve performing regressions or other statistical analysis. Several tools transport data into spreadsheets for statistical analysis. Redefined models compute results based on standardized models such as reliability, productivity, and complexity.