Paper Info
Title
Applying constraint logic programming to SQL test case generation
Abstract
We present a general framework for generating SQL query test cases using Constraint Logic Programming. Given a database schema and a SQL view defined in terms of other views and schema tables, our technique generates automatically a set of finite domain constraints whose solutions constitute the test database instances. The soundness and correctness of the technique w.r.t. the semantics of Extended Relational Algebra is proved. Our setting has been implemented in an available tool covering a wide range of SQL queries, including views, subqueries, aggregates and set operations.
Year
DOI
Venue
2010
10.1007/978-3-642-12251-4_15
FLOPS
Keywords
Field
DocType
available tool,sql query test case,schema table,constraint logic programming,database schema,finite domain constraint,technique w,extended relational algebra,sql query,sql test case generation,test database instance,relation algebra
SQL,Conjunctive query,Stored procedure,Programming language,Computer science,Language Integrated Query,Set operations,Data definition language,Algorithm,Theoretical computer science,Query by Example,Null (SQL)
Conference
Volume
ISSN
ISBN
6009
0302-9743
3-642-12250-7
Citations 
PageRank 
References 
6
0.43
14
Authors
3
Name
Order
Citations
PageRank
Rafael Caballero125416.97
Yolanda García-Ruiz2223.12
Fernando Sáenz-Pérez36915.50