Database Application

14,000,000 Leading Edge Experts on the ideXlab platform

Scan Science and Technology

Contact Leading Edge Experts & Companies

Scan Science and Technology

Contact Leading Edge Experts & Companies

The Experts below are selected from a list of 17046 Experts worldwide ranked by ideXlab platform

Feng-jian Wang - One of the best experts on this subject based on the ideXlab platform.

  • A Web Database Application model for software maintenance
    Proceedings. Fourth International Symposium on Autonomous Decentralized Systems. - Integration of Heterogeneous Systems -, 1999
    Co-Authors: Hsien-chou Liao, Jiun-liang Chen, Feng-jian Wang
    Abstract:

    Web Database Application programs may consist of hundreds of files. The interoperations among these files could be complex, and most of them are lack of design documents. When a programmer maintains (changes) some programs of an Application, the program files affected by the changes need be updated simultaneously to keep the functional consistency. One major difficulty of maintenance is how to identify these affected parts, especially in Web Database Applications. In this paper, we present a model, called HED model, for the maintenance of Web Database Applications. HED model decomposes a Web Database Application into three diagrams, hyperlink diagrams, entity-relationship diagrams, and data-flow diagrams, which are used to represent different aspects of a Web Database Application. Based on the HED model, the programs files affected by a program change can be identified precisely via the structure and Database analyses. In addition, a maintenance tool is implemented to demonstrate the capability of the HED model.

  • ISADS - A Web Database Application model for software maintenance
    Proceedings. Fourth International Symposium on Autonomous Decentralized Systems. - Integration of Heterogeneous Systems -, 1999
    Co-Authors: Hsien-chou Liao, Jiun-liang Chen, Feng-jian Wang
    Abstract:

    Web Database Application programs may consist of hundreds of files. The interoperations among these files could be complex, and most of them are lack of design documents. When a programmer maintains (changes) some programs of an Application, the program files affected by the changes need be updated simultaneously to keep the functional consistency. One major difficulty of maintenance is how to identify these affected parts, especially in Web Database Applications. In this paper, we present a model, called HED model, for the maintenance of Web Database Applications. HED model decomposes a Web Database Application into three diagrams, hyperlink diagrams, entity-relationship diagrams, and data-flow diagrams, which are used to represent different aspects of a Web Database Application. Based on the HED model, the programs files affected by a program change can be identified precisely via the structure and Database analyses. In addition, a maintenance tool is implemented to demonstrate the capability of the HED model.

S.c. Cheung - One of the best experts on this subject based on the ideXlab platform.

  • Fault-based testing of Database Application programs with conceptual data model
    Fifth International Conference on Quality Software (QSIC'05), 2005
    Co-Authors: W.k. Chan, S.c. Cheung
    Abstract:

    Database Application programs typically contain program units that use SQL statements to manipulate records in Database instances. Testing the correctness of data manipulation by these programs is challenging. When a tester provides a Database instance to test such a program, the program unit may output faulty SQL statements and, hence, manipulate inappropriate Database records. Nonetheless, these failures may only be revealed in very specific Database instances. This paper proposes to integrate SQL statements and the conceptual data models of an Application for fault-based testing. It proposes a set of mutation operators based on the standard types of constraint used in the enhanced entity-relationship model. These operators are semantic in nature. This semantic information guides the construction of affected attributes and join conditions of mutants. The usefulness of our proposal is illustrated by an example in which a missing-record fault is revealed.

Phyllis G. Frankl - One of the best experts on this subject based on the ideXlab platform.

  • JDAMA: Java Database Application mutation analyser
    Software Testing Verification & Reliability, 2011
    Co-Authors: Chixiang Zhou, Phyllis G. Frankl
    Abstract:

    Database Application programs are ubiquitous; hence, good techniques for testing them are needed. Several approaches to testing Database Applications have been proposed recently, including test generation techniques and adequacy criteria. Tuya et al. proposed mutation-based adequacy criteria for Database queries and developed a set of mutation operators for Structured Query Language SELECT statements. This paper extends that approach by integrating it with analysis and instrumentation of the Application bytecode. The design and implementation of a tool, Java Database Application Mutation Analyser (JDAMA), are described. JDAMA instruments Application bytecode so as to compare the results of queries executed by the Application under test to the results of mutants of those queries. JDAMA can be used to support mutation testing for Java Database Applications. A second, potentially more useful Application of JDAMA is to support experiments evaluating testing techniques for Database Applications, in which query mutation is used to seed faults into subject Applications. The paper illustrates these uses of JDAMA with experiments comparing two approaches to test generation and experiments evaluating coverage criteria. Copyright © 2011 John Wiley & Sons, Ltd.

  • Mutation Testing for Java Database Applications
    2009 International Conference on Software Testing Verification and Validation, 2009
    Co-Authors: Chixiang Zhou, Phyllis G. Frankl
    Abstract:

    Database Application programs are ubiquitous, so good techniques for testing them are needed. Recently, several research groups have proposed new approaches to generating tests for Database Applications and for assessing test data adequacy. This paper describes a mutation testing tool, JDAMA (Java Database Application mutation analyzer), for Java programs that interact with a Database via the JDBC interface. Our approach extends the mutation testing approach for SQL by Tuya et al, by integrating it with analysis and instrumentation of the Application bytecode. JDAMA's use is illustrated through a small study which uses mutation scores to compare two test generation techniques for Database Applications.

  • ICST - Mutation Testing for Java Database Applications
    2009 International Conference on Software Testing Verification and Validation, 2009
    Co-Authors: Chixiang Zhou, Phyllis G. Frankl
    Abstract:

    Database Application programs are ubiquitous, so good techniques for testing them are needed. Recently, several research groups have proposed new approaches to generating tests for Database Applications and for assessing test data adequacy. This paper describes a mutation testing tool, JDAMA (Java Database Application Mutation Analyzer), for Java programs that interact with a Database via the JDBC interface. Our approach extends the mutation testing approach for SQL by Tuya et al, by integrating it with analysis and instrumentation of the Application bytecode. JDAMA's use is illustrated through a small study which uses mutation scores to compare two test generation techniques for Database Applications.

Hsien-chou Liao - One of the best experts on this subject based on the ideXlab platform.

  • A Web Database Application model for software maintenance
    Proceedings. Fourth International Symposium on Autonomous Decentralized Systems. - Integration of Heterogeneous Systems -, 1999
    Co-Authors: Hsien-chou Liao, Jiun-liang Chen, Feng-jian Wang
    Abstract:

    Web Database Application programs may consist of hundreds of files. The interoperations among these files could be complex, and most of them are lack of design documents. When a programmer maintains (changes) some programs of an Application, the program files affected by the changes need be updated simultaneously to keep the functional consistency. One major difficulty of maintenance is how to identify these affected parts, especially in Web Database Applications. In this paper, we present a model, called HED model, for the maintenance of Web Database Applications. HED model decomposes a Web Database Application into three diagrams, hyperlink diagrams, entity-relationship diagrams, and data-flow diagrams, which are used to represent different aspects of a Web Database Application. Based on the HED model, the programs files affected by a program change can be identified precisely via the structure and Database analyses. In addition, a maintenance tool is implemented to demonstrate the capability of the HED model.

  • ISADS - A Web Database Application model for software maintenance
    Proceedings. Fourth International Symposium on Autonomous Decentralized Systems. - Integration of Heterogeneous Systems -, 1999
    Co-Authors: Hsien-chou Liao, Jiun-liang Chen, Feng-jian Wang
    Abstract:

    Web Database Application programs may consist of hundreds of files. The interoperations among these files could be complex, and most of them are lack of design documents. When a programmer maintains (changes) some programs of an Application, the program files affected by the changes need be updated simultaneously to keep the functional consistency. One major difficulty of maintenance is how to identify these affected parts, especially in Web Database Applications. In this paper, we present a model, called HED model, for the maintenance of Web Database Applications. HED model decomposes a Web Database Application into three diagrams, hyperlink diagrams, entity-relationship diagrams, and data-flow diagrams, which are used to represent different aspects of a Web Database Application. Based on the HED model, the programs files affected by a program change can be identified precisely via the structure and Database analyses. In addition, a maintenance tool is implemented to demonstrate the capability of the HED model.

W.k. Chan - One of the best experts on this subject based on the ideXlab platform.

  • Fault-based testing of Database Application programs with conceptual data model
    Fifth International Conference on Quality Software (QSIC'05), 2005
    Co-Authors: W.k. Chan, S.c. Cheung
    Abstract:

    Database Application programs typically contain program units that use SQL statements to manipulate records in Database instances. Testing the correctness of data manipulation by these programs is challenging. When a tester provides a Database instance to test such a program, the program unit may output faulty SQL statements and, hence, manipulate inappropriate Database records. Nonetheless, these failures may only be revealed in very specific Database instances. This paper proposes to integrate SQL statements and the conceptual data models of an Application for fault-based testing. It proposes a set of mutation operators based on the standard types of constraint used in the enhanced entity-relationship model. These operators are semantic in nature. This semantic information guides the construction of affected attributes and join conditions of mutants. The usefulness of our proposal is illustrated by an example in which a missing-record fault is revealed.