References and arrow notation instead of join operation in query languages
Închide
Conţinutul numărului revistei
Articolul precedent
Articolul urmator
990 6
Ultima descărcare din IBN:
2023-12-17 12:16
Căutarea după subiecte
similare conform CZU
004.822:81'37 (1)
Inteligență artificială (307)
Lingvistică. Limbi (5052)
SM ISO690:2012
SAVINOV, Alexandru. References and arrow notation instead of join operation in query languages. In: Computer Science Journal of Moldova, 2012, nr. 3(60), pp. 313-333. ISSN 1561-4042.
EXPORT metadate:
Google Scholar
Crossref
CERIF

DataCite
Dublin Core
Computer Science Journal of Moldova
Numărul 3(60) / 2012 / ISSN 1561-4042 /ISSNe 2587-4330

References and arrow notation instead of join operation in query languages
CZU: 004.822:81'37

Pag. 313-333

Savinov Alexandru
 
SAP Research Dresden, SAP AG
 
 
Disponibil în IBN: 6 decembrie 2013


Rezumat

We study properties of the join operation in query languages and describe some of its major drawbacks. We provide strong arguments against using joins as a main construct for retrieving related data elements in general purpose query languages and argue for using references instead. Since conventional references are quite restrictive when applied to data modeling and query languages, we propose to use generalized references as they are defned in the concept-oriented model (COM). These references are used by two new operations, called projection and de-projection, which are denoted by right and left arrows and therefore this access method is referred to as arrow notation. We demonstrate advantages of the arrow notation in comparison to joins and argue that it makes queries simpler, more natural, easier to understand, and the whole query writing process more productive and less error-prone.

Cuvinte-cheie
Data modeling, query languages, concept-oriented model, arrow notation, data semantics.,

join, reference