High-level programming features for improving the efficiency of a relational database system
- 1 September 1981
- journal article
- Published by Association for Computing Machinery (ACM) in ACM Transactions on Database Systems
- Vol. 6 (3) , 464-485
- https://doi.org/10.1145/319587.319604
Abstract
This paper discusses some high-level language programming constructs that can be used to manipulate the relations of a relational database system efficiently. Three different constructs are described: (1) tuple identifiers that directly reference tuples of a relation; (2) cursors that may iterate over the tuples of a relation; and (3) markings, a form of temporary relation consisting of a set of tuple identifiers. In each case, attention is given to syntactic, semantic, and implementation considerations. The use of these features is first presented within the context of the programming language PLAIN, and it is then shown how these features could be used more generally to provide database manipulation capabilities in a high-level programming language. Consideration is also given to issues of programming methodology, with an important goal being the achievement of a balance between the enforcement of good programming practices and the ability to write efficient programs.Keywords
This publication has 11 references indexed in Scilit:
- The Y programming languageACM SIGPLAN Notices, 1981
- System R: An architectural overviewIBM Systems Journal, 1981
- Extending the database relational model to capture more meaningACM Transactions on Database Systems, 1979
- Theseus—a programming language for relational databesesACM Transactions on Database Systems, 1979
- The data management facilities of PLAINPublished by Association for Computing Machinery (ACM) ,1979
- Access path selection in a relational database management systemPublished by Association for Computing Machinery (ACM) ,1979
- Some high level language constructs for data of type relationACM Transactions on Database Systems, 1977
- The design and implementation of INGRESACM Transactions on Database Systems, 1976
- Decomposition—a strategy for query processingACM Transactions on Database Systems, 1976
- System RACM Transactions on Database Systems, 1976