NDLI: Preference formulas in relational queries

Content Provider	ACM Digital Library
Author	Chomicki, Jan
Copyright Year	2003
Abstract	The handling of user preferences is becoming an increasingly important issue in present-day information systems. Among others, preferences are used for information filtering and extraction to reduce the volume of data presented to the user. They are also used to keep track of user profiles and formulate $\textit{policies}$ to improve and automate decision making.We propose here a simple, logical framework for formulating preferences as preference formulas. The framework does not impose any restrictions on the preference relations, and allows arbitrary operation and predicate signatures in preference formulas. It also makes the composition of preference relations straightforward. We propose a simple, natural embedding of preference formulas into relational algebra (and SQL) through a single winnow operator parameterized by a preference formula. The embedding makes possible the formulation of complex preference queries, for example, involving aggregation, by piggybacking on existing SQL constructs. It also leads in a natural way to the definition of further, preference-related concepts like ranking. Finally, we present general algebraic laws governing the winnow operator and its interactions with other relational algebra operators. The preconditions on the applicability of the laws are captured by logical formulas. The laws provide a formal foundation for the algebraic optimization of preference queries. We demonstrate the usefulness of our approach through numerous examples.
Starting Page	427
Ending Page	466
Page Count	40
File Format	PDF
ISSN	03625915
e-ISSN	15574644
DOI	10.1145/958942.958946
Volume Number	28
Issue Number	4
Journal	ACM Transactions on Database Systems (TODS)
Language	English
Publisher	Association for Computing Machinery (ACM)
Publisher Date	2003-12-01
Publisher Place	New York
Access Restriction	One Nation One Subscription (ONOS)
Subject Keyword	Preference queries Preferences Query optimization Relational algebra
Content Type	Text
Resource Type	Article
Subject	Information Systems

Sl.	Authority	Responsibilities	Communication Details
1	Ministry of Education (GoI), Department of Higher Education	Sanctioning Authority	https://www.education.gov.in/ict-initiatives
2	Indian Institute of Technology Kharagpur	Host Institute of the Project: The host institute of the project is responsible for providing infrastructure support and hosting the project	https://www.iitkgp.ac.in
3	National Digital Library of India Office, Indian Institute of Technology Kharagpur	The administrative and infrastructural headquarters of the project	Dr. B. Sutradhar bsutra@ndl.gov.in
4	Project PI / Joint PI	Principal Investigator and Joint Principal Investigators of the project	Dr. B. Sutradhar bsutra@ndl.gov.in Prof. Saswat Chakrabarti will be added soon
5	Website/Portal (Helpdesk)	Queries regarding NDLI and its services	support@ndl.gov.in
6	Contents and Copyright Issues	Queries related to content curation and copyright issues	content@ndl.gov.in
7	National Digital Library of India Club (NDLI Club)	Queries related to NDLI Club formation, support, user awareness program, seminar/symposium, collaboration, social media, promotion, and outreach	clubsupport@ndl.gov.in
8	Digital Preservation Centre (DPC)	Assistance with digitizing and archiving copyright-free printed books	dpc@ndl.gov.in
9	IDR Setup or Support	Queries related to establishment and support of Institutional Digital Repository (IDR) and IDR workshops	idr@ndl.gov.in

SQL query optimization through nested relational algebra

Efficient optimization of a class of relational expressions

Preference Formulas in Relational Queries

Safety and translation of relational calculus

Translating SQL Into Relational Algebra: Optimization, Semantics, and Equivalence of SQL Queries

Efficient algorithms for processing preference queries

Rule-based optimization and query processing in an extensible geometric database system

A survey on representation, composition and application of preferences in database systems

Optimization Strategies for Relational Queries

Preference formulas in relational queries

Similar Documents

SQL query optimization through nested relational algebra

Efficient optimization of a class of relational expressions

Preference Formulas in Relational Queries

Safety and translation of relational calculus

Translating SQL Into Relational Algebra: Optimization, Semantics, and Equivalence of SQL Queries

Efficient algorithms for processing preference queries

Rule-based optimization and query processing in an extensible geometric database system

A survey on representation, composition and application of preferences in database systems

Optimization Strategies for Relational Queries

Preference formulas in relational queries