Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

SQL coverage-based automatic testing method for application software in database based on

A technology for automated testing and application software, which is applied in software testing/debugging, special data processing applications, electrical digital data processing, etc., and can solve complex SQL statement test design, missing test content, and interactive behavior testing between software and databases. Sufficiency and other issues to achieve the effect of improving test sufficiency and effectiveness

Active Publication Date: 2015-05-20
胡兢玉 +1
View PDF7 Cites 14 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

If the characteristics of the database application software are not fully considered in the test design, and the test data and test methods are only designed for the business processing logic, but the complex SQL statements are not fully tested, such software testing will miss important test content, resulting in Insufficient testing of software-database interaction behavior hides software errors
At present, there are some test tools and standards for database management systems, but there is a lack of software test automation methods for the characteristics of database application software

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • SQL coverage-based automatic testing method for application software in database based on
  • SQL coverage-based automatic testing method for application software in database based on
  • SQL coverage-based automatic testing method for application software in database based on

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0027] Embodiments of the present invention are described in detail below, examples of which are shown in the drawings, wherein the same or similar reference numerals denote the same or similar elements or elements having the same or similar functions throughout. The embodiments described below by referring to the figures are exemplary only for explaining the present invention and should not be construed as limiting the present invention.

[0028] The SQL coverage-based automated testing method for database application software according to an embodiment of the present invention will be described below with reference to the accompanying drawings.

[0029] figure 1 It is a flowchart of an automatic testing method for database application software based on SQL coverage according to an embodiment of the present invention. Such as figure 1 As shown, the method includes the following steps:

[0030] Step S101: Establish a grammar rule table for database access, wherein the gramm...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The invention discloses a SQL coverage-based automatic testing method for an application software in a database. The automatic testing method comprises the following steps: establishing a grammatical rule table for database access; statically analyzing a source code depending on a self-defined grammatical rule with the adoption of a lexical analysis and grammatical analysis technology, and acquiring code information related to the database access; dynamically analyzing the source code by adopting an ASM technology, respectively traversing multiple categories in the source code, and acquiring information, related to the database access, in each category; integrating a static analysis result and a dynamic analysis result to generate a database access behavior characteristic model, and constructing a database access behavior characteristic database according to the database access behavior characteristic model; and capturing database access dynamic execution characteristics when the source code is executed, carrying out matching calculation on the database access dynamic execution characteristics and the database access behavior characteristic database, and acquiring test coverage data based on SQL. The automatic testing method is capable of improving the adequacy and the effectiveness of an SQL coverage test and does not influence the execution characteristic of tested software while the SQL coverage test is realized.

Description

technical field [0001] The invention relates to the technical field of database and software testing, in particular to an automatic testing method for database application software based on SQL coverage. Background technique [0002] Database application software is the application software based on the operation of the database management system. This software adds, modifies, deletes and queries the data in the database by embedding SQL language data manipulation statements in the program code to realize the necessary business processing logic. Complete the functions expected by users. [0003] In modern life, the amount of information is increasing, the distribution of information is becoming more and more extensive, and the demand for information utilization is increasing and complex, which leads to the increase in the number and complexity of database application software, which has become an important software testing object. [0004] Coverage testing method is an impo...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
IPC IPC(8): G06F11/36G06F17/30
Inventor 胡兢玉李华莹常宁曹晖田旭董昕陈光刘怡静
Owner 胡兢玉
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com