Relational Conditional Set Operations

Autor(es)

Lescano, Alexis I. Aspauza ; Cordeiro, Robson L. F. ; Bellatreche, L ; Dumas, M ; Karras, P ; Matulevicius, R ; Awad, A ; Weidlich, M ; Ivanovic, M ; Hartig, O

• Tipo de documento: Artigo Científico
• Fonte: NEW TRENDS IN DATABASE AND INFORMATION SYSTEMS, ADBIS 2021; v. 1450, p. 12-pg., 2021-01-01.

Resumo

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)

• Processo FAPESP: 16/17078-0 - Mineração, indexação e visualização de Big Data no contexto de sistemas de apoio à decisão clínica (MIVisBD)
• Beneficiário: Agma Juci Machado Traina
• Modalidade de apoio: Auxílio à Pesquisa - Temático