Show simple item record

hal.structure.identifierLaboratoire d'analyse et modélisation de systèmes pour l'aide à la décision [LAMSADE]
dc.contributor.authorLitwin, Witold
dc.date.accessioned2019-10-09T09:56:03Z
dc.date.available2019-10-09T09:56:03Z
dc.date.issued2019
dc.identifier.urihttps://basepub.dauphine.fr/handle/123456789/20055
dc.language.isoenen
dc.subjectSQL Databasesen
dc.subjectInformation Systemsen
dc.subjectNon-procedural Data Definition and Manipulationen
dc.subjectLogical Navigationen
dc.subject.ddc005en
dc.titleSQL for Stored and Inherited Relationsen
dc.typeCommunication / Conférence
dc.description.abstractenA 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.en
dc.identifier.citationpages37-48en
dc.relation.ispartoftitleProceedings of the 21st International Conference on Enterprise Information Systems - (Volume 1)en
dc.relation.ispartofeditorFilipe, Joaquim
dc.relation.ispartofeditorSmialek, Michal
dc.relation.ispartofeditorBrodsky, Alexander
dc.relation.ispartofeditorHammoudi, Slimane
dc.relation.ispartofpublnameSciTePressen
dc.relation.ispartofdate2019
dc.subject.ddclabelProgrammation, logiciels, organisation des donnéesen
dc.relation.ispartofisbn978-989-758-372-8en
dc.relation.conftitle21st International Conference on Enterprise Information Systems (ICEIS 2019)en
dc.relation.confdate2019-05
dc.relation.confcityHeraklion, Creteen
dc.relation.confcountryGreeceen
dc.relation.forthcomingnonen
dc.identifier.doi10.5220/0007676700370048en
dc.description.ssrncandidatenonen
dc.description.halcandidateouien
dc.description.readershiprechercheen
dc.description.audienceInternationalen
dc.relation.Isversionofjnlpeerreviewednonen
dc.relation.Isversionofjnlpeerreviewednonen
dc.date.updated2019-10-09T09:51:59Z
hal.identifierhal-02309464*
hal.version1*
hal.update.actionupdateFiles*
hal.author.functionaut


Files in this item

Thumbnail

This item appears in the following Collection(s)

Show simple item record