Javier Tuya

Javier Tuya

Auto-generated profile, based on publicly available information

Javier Tuya

University of Oviedo

Research Focus & Metrics

Academic Career Length

39Years (1988-Present)

(Calculated once Scilit publication data is synced: current year − year of first publication + 1)

Representative Publications

View All Publications
1 April 2007 in Information and Software Technology
Verified
Journal Article
Open access
JTJavier Tuya
Javier Tuya
MSMa José Suárez-Cabal
Ma José Suárez-Cabal
CRClaudio de la Riva
Claudio de la Riva
A set of mutation operators for SQL queries that retrieve information from a database is developed and tested against a set of queries drawn from the NIST SQL Conformance Test Suite. The mutation operators cover a wide spectrum of SQL features, including the handling of null values. Additional experiments are performed to explore whether the cost of executing mutants can be reduced using selective mutation or the test suite size can be reduced by using an appropriate ordering of the mutants. The SQL mutation approach can be helpful in assessing the adequacy of database test cases and their development, and as a tool for systematically injecting faults in order to compare different database testing techniques.

1 October 2008 in Computers & Operations Research
Verified
Journal Article
Open access
EDEugenia Díaz
Eugenia Díaz
JTJavier Tuya
Javier Tuya
RBRaquel Blanco
Raquel Blanco
JDJosé Javier Dolado
José Javier Dolado

17 February 2023 in Journal of Systems and Software
Verified
Journal Article
Open access
RBRaquel Blanco
Raquel Blanco
MGMANUEL TRINIDAD GARCIA
MANUEL TRINIDAD GARCIA
MSMaría José Suárez-Cabal
María José Suárez-Cabal
ACAlejandro Calderón
Alejandro Calderón
MRMercedes Ruiz
Mercedes Ruiz
JTJavier Tuya
Javier Tuya

15 January 2010 in Software Testing, Verification and Reliability
Verified
Journal Article
Open access
PDF file
JTJavier Tuya
Javier Tuya
MSMaría José Suárez‐Cabal
María José Suárez‐Cabal
CRClaudio de la Riva
Claudio de la Riva
In the field of database applications a considerable part of the business logic is implemented using a semi-declarative language: the Structured Query Language (SQL). Because of the different semantics of SQL compared with other procedural languages, the conventional coverage criteria for testing are not directly applicable. This paper presents a criterion specifically tailored for SQL queries (SQLFpc). It is based on Masking Modified Condition Decision Coverage (MCDC) or Full Predicate Coverage and takes into account a wide range of the syntax and semantics of SQL, including selection, joining, grouping, aggregations, subqueries, case expressions and null values. The criterion assesses the coverage of the test data in relation to the query that is executed and it is expressed as a set of rules that are automatically generated and efficiently evaluated against a test database. The use of the criterion is illustrated in a case study, which includes complex queries. Copyright © 2010 John Wiley & Sons, Ltd.

3 May 2010
Verified
Conference Paper
Open access
PDF file
CRClaudio de la Riva
Claudio de la Riva
MSMaría José Suárez-Cabal
María José Suárez-Cabal
JTJavier Tuya
Javier Tuya
Populating test databases with meaningful test data is a difficult task as it involves generating data for many joined tables that must be diverse enough to be able to reveal faults and small enough to make the testing process efficient. This paper proposes an approach for the automatic generation of a test database for a set of SQL queries using a test criterion specifically tailored for the SQL language (SQLFpc). Given as input a schema database and a set of test requirements derived from the application of the test criterion to the target queries, the approach returns a database instance which satisfies the test requirements. Both the schema and the test requirements are modeled in the Alloy language, after which the analyzer generates the test database. The approach is evaluated on a real case study and the results show its feasibility, generating a test database of reduced size with an elevated coverage and mutation score.

1 November 2006
Verified
Conference Paper
Open access
JTJavier Tuya
Javier Tuya
MSMa Jose Suarez-Cabal
Ma Jose Suarez-Cabal
CRClaudio de la Riva
Claudio de la Riva
We present a tool to automatically generate mutants of SQL database queries. The SQLMutation tool is available on the Web and it can be accessed using two different interfaces: A Web application to interactively generate the mutants and a Web service that allows it to be integrated with other applications developed using different platforms.