Efficient Relational Joins with Arithmetic Constraints on Multiple Attributes

Author(s):  
Chuang Liu ◽  
Lingyun Yang ◽  
I. Foster
Author(s):  
Xinyi Huang ◽  
Suphanut Jamonnak ◽  
Ye Zhao ◽  
Boyu Wang ◽  
Minh Hoai ◽  
...  

2021 ◽  
Vol 184 ◽  
pp. 104732
Author(s):  
Xu Zhang ◽  
Yahui Tian ◽  
Guoyu Guan ◽  
Yulia R. Gel

2021 ◽  
Vol 14 (7) ◽  
pp. 1228-1240
Author(s):  
Dimitrije Jankov ◽  
Binhang Yuan ◽  
Shangyu Luo ◽  
Chris Jermaine

When numerical and machine learning (ML) computations are expressed relationally, classical query execution strategies (hash-based joins and aggregations) can do a poor job distributing the computation. In this paper, we propose a two-phase execution strategy for numerical computations that are expressed relationally, as aggregated join trees (that is, expressed as a series of relational joins followed by an aggregation). In a pilot run, lineage information is collected; this lineage is used to optimally plan the computation at the level of individual records. Then, the computation is actually executed. We show experimentally that a relational system making use of this two-phase strategy can be an excellent platform for distributed ML computations.


2021 ◽  
Vol 12 (5) ◽  
Author(s):  
Alexandre F. Novello ◽  
Marco A. Casanova

A Natural Language Interface to Database (NLIDB) refers to a database interface that translates a question asked in natural language into a structured query. Aggregation questions express aggregation functions, such as count, sum, average, minimum and maximum, and optionally a group by clause and a having clause. NLIDBs deliver good results for standard questions but usually do not deal with aggregation questions. The main contribution of this article is a generic module, called GLAMORISE (GeneraL Aggregation MOdule using a RelatIonal databaSE), that extends NLIDBs to cope with aggregation questions. GLAMORISE covers aggregations with ambiguities, timescale differences, aggregations in multiple attributes, the use of superlative adjectives, basic recognition of measurement units, and aggregations in attributes with compound names.


Compstat ◽  
1994 ◽  
pp. 105-119 ◽  
Author(s):  
Dianne Cook ◽  
Noel Cressie ◽  
James Majure ◽  
Jürgen Symanzik

Sign in / Sign up

Export Citation Format

Share Document