Advanced search
Start date
Betweenand


Relational Conditional Set Operations

Full text
Author(s):
Lescano, Alexis I. Aspauza ; Cordeiro, Robson L. F. ; Bellatreche, L ; Dumas, M ; Karras, P ; Matulevicius, R ; Awad, A ; Weidlich, M ; Ivanovic, M ; Hartig, O
Total Authors: 10
Document type: Journal article
Source: NEW TRENDS IN DATABASE AND INFORMATION SYSTEMS, ADBIS 2021; v. 1450, p. 12-pg., 2021-01-01.
Abstract

A set is a collection of different objects. Some basic operations from the Theory of Sets are the set membership (is an element of), subset (subset of), intersection (boolean AND), and difference (-). However, these operations have limitations because of the implicit use of the identity predicate. That is, a tuple is a member of a set if it is identical to any tuple in the set. Many applications need other comparison predicates that are not limited to identity. This paper presents the new Relational Conditional Set Operations, or RelCond Set Operations (is an element of(c), subset of(c), boolean AND(c), -(c)) for short. Our operators are naturally suited to answer queries of conditional membership, subset, intersection, and difference with customized predicates. For example, they are potentially useful in applications of product sales with units and prices, job promotion, and internship. We validate our proposals by studying the first of these applications. (AU)

FAPESP's process: 16/17078-0 - Mining, indexing and visualizing Big Data in clinical decision support systems (MIVisBD)
Grantee:Agma Juci Machado Traina
Support Opportunities: Research Projects - Thematic Grants