SQL for Stored and Inherited Relations
| Autor: | Witold Litwin |
|---|---|
| Přispěvatelé: | Laboratoire d'analyse et modélisation de systèmes pour l'aide à la décision (LAMSADE), Université Paris Dauphine-PSL, Université Paris sciences et lettres (PSL)-Université Paris sciences et lettres (PSL)-Centre National de la Recherche Scientifique (CNRS) |
| Jazyk: | angličtina |
| Rok vydání: | 2019 |
| Předmět: |
SQL
Relation (database) Computer science 020206 networking & telecommunications 02 engineering and technology SQL Databases 0202 electrical engineering electronic engineering information engineering Information system 020201 artificial intelligence & image processing [INFO]Computer Science [cs] Arithmetic computer Value (mathematics) Non-procedural Data Definition and Manipulation Logical Navigation computer.programming_language Information Systems |
| Zdroj: | Proceedings of the 21st International Conference on Enterprise Information Systems-(Volume 1) 21st International Conference on Enterprise Information Systems (ICEIS 2019) 21st International Conference on Enterprise Information Systems (ICEIS 2019), May 2019, Heraklion, Greece. pp.37-48, ⟨10.5220/0007676700370048⟩ ICEIS (1) |
| DOI: | 10.5220/0007676700370048⟩ |
| Popis: | A stored and inherited relation (SIR) is a stored relation (SR) extended with inherited attributes (IAs) calculated as in a view. Without affecting the normal form of the SR, IAs can make queries free of logical navigation or of value expressions. A view of the SR can do the same. The virtual (dynamic, computed...) attributes (VAs) possibly extending SRs at major DBSs, can do as well for value expressions defining them. VAs are less procedural to declare than any alternate view. Likewise, altering any attribute of an SR with VAs leading to view altering otherwise is less procedural. We propose extensions to SQL generalizing the latter two properties to SIRs. In particular, one may define IAs through value expressions not supported as VAs at present. Also, to define an IA instead of a VA is at most as procedural. We motivate our proposals through the "biblical" Supplier-Part DB. We postulate SIRs standard on SQL DBSs. |
| Databáze: | OpenAIRE |
| Externí odkaz: |
|