SQL for Stored and Inherited Relations

Witold Litwin

2019

Abstract

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.

Paper Citation

in Harvard Style

Litwin W. (2019). SQL for Stored and Inherited Relations.In Proceedings of the 21st International Conference on Enterprise Information Systems - Volume 1: ICEIS, ISBN 978-989-758-372-8, pages 37-48. DOI: 10.5220/0007676700370048

in Bibtex Style

@conference{iceis19,
author={Witold Litwin},
title={SQL for Stored and Inherited Relations},
booktitle={Proceedings of the 21st International Conference on Enterprise Information Systems - Volume 1: ICEIS,},
year={2019},
pages={37-48},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0007676700370048},
isbn={978-989-758-372-8},
}

in EndNote Style

TY - CONF

JO - Proceedings of the 21st International Conference on Enterprise Information Systems - Volume 1: ICEIS,
TI - SQL for Stored and Inherited Relations
SN - 978-989-758-372-8
AU - Litwin W.
PY - 2019
SP - 37
EP - 48
DO - 10.5220/0007676700370048