IRMA-International.org: Creator of Knowledge
Information Resources Management Association
Advancing the Concepts & Practices of Information Resources Management in Modern Organizations

Set-Oriented Queries in SQL

Set-Oriented Queries in SQL
View Sample PDF
Author(s): Antonio Badia (University of Louisville, USA)
Copyright: 2016
Pages: 24
Source title: Handbook of Research on Innovative Database Query Processing Techniques
Source Author(s)/Editor(s): Li Yan (Nanjing University of Aeronautics and Astronautics, China)
DOI: 10.4018/978-1-4666-8767-7.ch002

Purchase

View Set-Oriented Queries in SQL on the publisher's website for pricing and purchasing information.

Abstract

Set-oriented queries are those that require a condition to hold of an arbitrary set of rows, either when comparing the set to a single row or to another set of rows. Examples of such queries are universally quantified queries and skyline queries. These queries, while important for data processing, are difficult to write and difficult to process. In this chapter we review research dealing with the specification and optimization of such queries. We present several approaches proposed to deal with universal quantification as well as with set predicates in general.

Related Content

Hrithik Raj, Ritu Punhani, Ishika Punhani. © 2023. 31 pages.
Divi Anand, Isha Kaushik, Jasmehar Singh Mann, Ritu Punhani, Ishika Punhani. © 2023. 21 pages.
Jayanthi G., Purushothaman R.. © 2023. 10 pages.
Anshika Gupta, Shuchi Sirpal. © 2023. 14 pages.
Reet Kaur Kohli, Seneha Santoshi, Sunishtha S. Yadav, Vandana Chauhan. © 2023. 13 pages.
Poonam Tanwar. © 2023. 14 pages.
Monika Mehta, Shivani Mishra, Santosh Kumar, Muskaan Bansal. © 2023. 16 pages.
Body Bottom