Regression Testing of Database Applications Under an Incremental Software Development Setting

Rosero, Raúl H.; Gómez, Omar S.; Rodríguez, Glen

doi:10.1109/access.2017.2749502

Cited by 16 publications

(14 citation statements)

References 52 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…It is evident from the results that drastic reduction in test suite along sound mutation score is achieved with these methods. Rosero et al [60] utilize a combination of DB schema, random values and unit tests with unsupervised clustering for determining new features which are added to software products linked with databases or the test cases which relates to changes. Two DB applications are taken into consideration for examining different metrics like recall, precision, fault detection capability, test suite reduction and the F-measure.…”

Section: Clustering Algorithmmentioning

confidence: 99%

“…Experimental results imply that effective clusters of test cases are achieved with the proposed method. From Table 10, it is analyzed that out of 5 clustering based research studies, 2 of them focus on statement coverage [57], [58], other three studies deal with fault detection [60], mutation score [59], and code coverage [56] respectively.…”

Section: Clustering Algorithmmentioning

confidence: 99%

See 1 more Smart Citation

A Comprehensive Investigation of Modern Test Suite Optimization Trends, Tools and Techniques

et al. 2019

View full text Add to dashboard Cite

Software testing is an important but expensive activity of software development life cycle, as it accounts for more than 52% of entire development cost. Testing requires the execution of all possible test cases in order to find the defects in the software. Therefore, different test suite optimization approaches like the genetic algorithm and the greedy algorithm, etc., are widely used to select the representative test suite without compromising the effectiveness. Test suite optimization is frequently researched to enhance its competences but there is no study published until now that analyzes the latest developments from 2016 to 2019. Hence, in this article, we systematically examine the state-of-the-art optimizations' approaches, tools, and supporting platforms. Principally, we conducted a systematic literature review (SLR) to inspect and examine 58 selected studies that are published during 2016-2019. Subsequently, the selected researches are grouped into five main categories, i.e., greedy algorithm (seven studies), meta-heuristic (28 studies), hybrid (six studies), clustering (five studies), and general (12 studies). Finally, 32 leading tools have been presented, i.e., existing tools (25 tools) and proposed/developed tools (seven tools) along 14 platform supports. Furthermore, it is noted that several approaches aim at solving the single-objective optimization problem. Therefore, researchers should focus on dealing with the multi-objective problem, as multi-objective versions outperform the single-objective ones. Moreover, less attention has been given to clustering-based techniques. Thus, we recommend exploring the machine learning and artificial intelligencebased optimization approaches in the future. A broad exploration of tools and techniques, in this article, will help researchers, practitioners, and developers to opt for adequate techniques, tools, or platforms as per requirements.

show abstract

Section: Clustering Algorithmmentioning

confidence: 99%

Section: Clustering Algorithmmentioning

confidence: 99%

A Comprehensive Investigation of Modern Test Suite Optimization Trends, Tools and Techniques

et al. 2019

View full text Add to dashboard Cite

show abstract

“…Many researches has proposed various regression testing methods to optimize the test cases by using ant colony optimization [27][28] [29]and genetic algorithm [27] [30][31] [32] .Here algorithm was proposed for regression test case prioritization by using the nature of the bees. This was particularly focused on the metric, change coverage among the various versions, in the open source application jtopas which was obtained from the repository (SIR) [33]. The jtopas application consist of 5.4k lines of code in the form of a java library the various classes, test classes, test method was tabulated in the table 1 [33].…”

Section: Proposed Systemmentioning

confidence: 99%

“…This was particularly focused on the metric, change coverage among the various versions, in the open source application jtopas which was obtained from the repository (SIR) [33]. The jtopas application consist of 5.4k lines of code in the form of a java library the various classes, test classes, test method was tabulated in the table 1 [33]. A.…”

Section: Proposed Systemmentioning

confidence: 99%

“…The various Regression techniques are shown in figure 3 [25]. Software testing helps to the users to complete the software depending upon the requirements with error free [33].The regression testing cost is depend upon the product size, executed test cases and the resources to perform the test [34].the test case prioritization depending upon the entities like type of an application and requirements of the user. Based upon the execution time user can know the time for executing the each test case [35].…”

Section: Introductionmentioning

confidence: 99%

See 1 more Smart Citation

A Regression Test Based on the Test Case Prioritization Techniques by using the Nature of Bees

2019

IJITEE

View full text Add to dashboard Cite

 Abstract: The software testing is a crucial role in the software development lifecycle. Testing can be done by the user who have full knowledge on the software, who has no knowledge and who has knowledge little bit on the software and the software testing can be tested in various level with various tests like unit, integrate, user, regression, acceptance etc.. The major and most important test is the regression testing. To perform the regression testing it takes more time. The current paper was focused on the regression testing to reduce the execution time and to improve the faults detection rate by considering the parameter of change coverage. The proposed system uses the test case prioritization techniques by using the nature of the bees. After performing the experimental study on an open source applications, the proposed system shows the efficiency and effectiveness in terms of the runtime and detecting faults when compared with the traditional system.

show abstract

On the importance of CI/CD practices for database applications

Fluri,

Fornari,

Pustulka

2024

J Software Evolu Process

View full text Add to dashboard Cite

SummaryContinuous integration and continuous delivery (CI/CD) automate software integration and reduce repetitive engineering work. While the use of CI/CD presents efficiency gains, in database application development, this potential has not been fully exploited. We explore the state of the art in this area, with a focus on current practices, common software tools, challenges, and preconditions that apply to database applications. The work is grounded in a synoptic literature review and contributes a novel generic CI/CD pipeline for database system application development. Our generic pipeline was tailored to three industrial development use cases in which we measured the benefits of integration and deployment automation. The measurements demonstrate clearly that introducing CI/CD had significant benefits. It reduced the number of failed deployments, improved their stability, and increased the number of deployments. Interviews with the developers before and after the implementation of the CI/CD show that the pipeline brings clear benefits to the development team (i.e., a reduced cognitive load). These findings put current database release practices driven by business expectations, such as fixed release windows, in question.

show abstract

Regression Testing of Database Applications Under an Incremental Software Development Setting

Cited by 16 publications

References 52 publications

A Comprehensive Investigation of Modern Test Suite Optimization Trends, Tools and Techniques

A Comprehensive Investigation of Modern Test Suite Optimization Trends, Tools and Techniques

A Regression Test Based on the Test Case Prioritization Techniques by using the Nature of Bees

On the importance of CI/CD practices for database applications

Contact Info

Product

Resources

About