69 search results - page 6 / 14 » A SQL database system for solving constraints |
EDBT
2009
ACM
15 years 3 months ago
2009
ACM
We investigate the problem of refining SQL queries to satisfy cardinality constraints on the query result. This has applications to the many/few answers problems often faced by da...
98
Voted
SIGMOD
2004
ACM
15 years 12 months ago
2004
ACM
In addition to indexes and materialized views, horizontal and vertical partitioning are important aspects of physical design in a relational database system that significantly imp...
SSDBM
2008
IEEE
15 years 6 months ago
2008
IEEE
We propose an automatic method for modeling a relational database that uses SQL triggers and foreign-keys to efficiently answer positive semantic queries about ground instances for...
201
click to vote
ICDE
2007
IEEE
16 years 1 months ago
2007
IEEE
We propose a class of constraints, referred to as conditional functional dependencies (CFDs), and study their applications in data cleaning. In contrast to traditional functional ...
150
click to vote
SIGMOD
2007
ACM
15 years 12 months ago
2007
ACM
We show that aggregate constraints (as opposed to pairwise constraints) that often arise when integrating multiple sources of data, can be leveraged to enhance the quality of dedu...