SQL for Stored and Inherited Relations
Litwin, Witold (2019), SQL for Stored and Inherited Relations, in Filipe, Joaquim; Smialek, Michal; Brodsky, Alexander; Hammoudi, Slimane, Proceedings of the 21st International Conference on Enterprise Information Systems - (Volume 1), SciTePress, p. 37-48. 10.5220/0007676700370048
TypeCommunication / Conférence
Conference title21st International Conference on Enterprise Information Systems (ICEIS 2019)
Conference cityHeraklion, Crete
Book titleProceedings of the 21st International Conference on Enterprise Information Systems - (Volume 1)
Book authorFilipe, Joaquim; Smialek, Michal; Brodsky, Alexander; Hammoudi, Slimane
MetadataShow full item record
Laboratoire d'analyse et modélisation de systèmes pour l'aide à la décision [LAMSADE]
Abstract (EN)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.
Subjects / KeywordsSQL Databases; Information Systems; Non-procedural Data Definition and Manipulation; Logical Navigation
Showing items related by title and author.
Constantin, Camelia; du Mouza, Cedric; Litwin, Witold; Rigaux, Philippe; Schwarz, Thomas (2016) Article accepté pour publication ou publié