Abstract:Traditional database queries follow a simple model: they define constraints that each tuple in the result must satisfy. This model is computationally efficient, as the database system can evaluate the query conditions on each tuple individually. However, many practical, real-world problems require a collection of result tuples to satisfy constraints collectively, rather than individually. In this paper, we present package queries, a new query model that extends traditional database queries to handle complex constraints and preferences over answer sets. We develop a full-fledged package query system, implemented on top of a traditional database engine. Our work makes several contributions. First, we design PaQL, a SQL-based query language that supports the declarative specification of package queries. We prove that PaQL is as least as expressive as integer linear programming, and therefore, evaluation of package queries is in general NP-hard. Second, we present a fundamental evaluation strategy that combines the capabilities of databases and constraint optimization solvers to derive solutions to package queries. The core of our approach is a set of translation rules that transform a package query to an integer linear program. Third, we introduce an offline data partitioning strategy allowing query evaluation to scale to large data sizes. Fourth, we introduce SketchRefine, a scalable algorithm for package evaluation, with strong approximation guarantees ($(1 \pm\epsilon)^6$-factor approximation). Finally, we present extensive experiments over real-world and benchmark data. The results demonstrate that SketchRefine is effective at deriving high-quality package results, and achieves runtime performance that is an order of magnitude faster than directly using ILP solvers over large datasets.

Query Relaxation Using Malleable Schemas

An Ontology-Based Semantic Retrieval Approach for Heterogeneous 3D CAD Models

INSPIRE: A Framework for Incremental Spatial Prefix Query Relaxation

Enhancing Algebraic Query Relaxation with Semantic Similarity

Schema Optimization and Conflict Mechanism in Relational Database System Migration

Answering queries on schema mappings

A survey on SPARQL query relaxation under the lens of RDF reification

Improving package recommendations through query relaxation

Automatic Recommendations for Evolving Relational Databases Schema

Storing and querying GML in object-relational databases.

Relaxing Relationship Queries on Graph Data

Relaxation Match for Structural Web Services

Using Meta-Structures in Database Design.

Toward Programmable Strategy for Co-existence of Relational Schemes.

Efficient subject-oriented evaluating and mining methods for data with schema uncertainty

Intelligent Database Flexible Querying System by Approximate Query Processing

Scalable Package Queries in Relational Database Systems

MoMQ: Mixture-of-Experts Enhances Multi-Dialect Query Generation across Relational and Non-Relational Databases

Algebraic Meta-structure Handling of Huge Database Schemata

Semplore: An Ir Approach To Scalable Hybrid Query Of Semantic Web Data

Generating Multidimensional Schemata from Relational Aggregation Queries