Access path query language for relational database systems
Abstract Database management systems offer a very reliable and attractive data organization for fast and economical information storage and processing for diverse applications. It is much more important that the information should be easily accessible to users with varied backgrounds, professional a...
Published in: | Software: Practice and Experience |
---|---|
Main Authors: | , , |
Format: | Article in Journal/Newspaper |
Language: | English |
Published: |
Wiley
1983
|
Subjects: | |
Online Access: | http://dx.doi.org/10.1002/spe.4380130802 https://api.wiley.com/onlinelibrary/tdm/v1/articles/10.1002%2Fspe.4380130802 https://onlinelibrary.wiley.com/doi/pdf/10.1002/spe.4380130802 |
id |
crwiley:10.1002/spe.4380130802 |
---|---|
record_format |
openpolar |
spelling |
crwiley:10.1002/spe.4380130802 2024-06-02T08:05:48+00:00 Access path query language for relational database systems Patnaik, L. M. Shailendra, Phule Rao, K. Venkateswara 1983 http://dx.doi.org/10.1002/spe.4380130802 https://api.wiley.com/onlinelibrary/tdm/v1/articles/10.1002%2Fspe.4380130802 https://onlinelibrary.wiley.com/doi/pdf/10.1002/spe.4380130802 en eng Wiley http://onlinelibrary.wiley.com/termsAndConditions#vor Software: Practice and Experience volume 13, issue 8, page 661-670 ISSN 0038-0644 1097-024X journal-article 1983 crwiley https://doi.org/10.1002/spe.4380130802 2024-05-03T11:15:26Z Abstract Database management systems offer a very reliable and attractive data organization for fast and economical information storage and processing for diverse applications. It is much more important that the information should be easily accessible to users with varied backgrounds, professional as well as casual, through a suitable data sublanguage. The language adopted here (APPLE) is one such language for relational database systems and is completely nonprocedural and well suited to users with minimum or no programming background. This is supported by an access path model which permits the user to formulate completely nonprocedural queries expressed solely in terms of attribute names. The data description language (DDL) and data manipulation language (DML) features of APPLE are also discussed. The underlying relational database has been implemented with the help of the DATATRIEVE‐11 utility for record and domain definition which is available on the PDP‐11/35. The package is coded in Pascal and MACRO‐11. Further, most of the limitations of the DATATRIEVE‐11 utility have been eliminated in the interface package. Article in Journal/Newspaper DML Wiley Online Library Software: Practice and Experience 13 8 661 670 |
institution |
Open Polar |
collection |
Wiley Online Library |
op_collection_id |
crwiley |
language |
English |
description |
Abstract Database management systems offer a very reliable and attractive data organization for fast and economical information storage and processing for diverse applications. It is much more important that the information should be easily accessible to users with varied backgrounds, professional as well as casual, through a suitable data sublanguage. The language adopted here (APPLE) is one such language for relational database systems and is completely nonprocedural and well suited to users with minimum or no programming background. This is supported by an access path model which permits the user to formulate completely nonprocedural queries expressed solely in terms of attribute names. The data description language (DDL) and data manipulation language (DML) features of APPLE are also discussed. The underlying relational database has been implemented with the help of the DATATRIEVE‐11 utility for record and domain definition which is available on the PDP‐11/35. The package is coded in Pascal and MACRO‐11. Further, most of the limitations of the DATATRIEVE‐11 utility have been eliminated in the interface package. |
format |
Article in Journal/Newspaper |
author |
Patnaik, L. M. Shailendra, Phule Rao, K. Venkateswara |
spellingShingle |
Patnaik, L. M. Shailendra, Phule Rao, K. Venkateswara Access path query language for relational database systems |
author_facet |
Patnaik, L. M. Shailendra, Phule Rao, K. Venkateswara |
author_sort |
Patnaik, L. M. |
title |
Access path query language for relational database systems |
title_short |
Access path query language for relational database systems |
title_full |
Access path query language for relational database systems |
title_fullStr |
Access path query language for relational database systems |
title_full_unstemmed |
Access path query language for relational database systems |
title_sort |
access path query language for relational database systems |
publisher |
Wiley |
publishDate |
1983 |
url |
http://dx.doi.org/10.1002/spe.4380130802 https://api.wiley.com/onlinelibrary/tdm/v1/articles/10.1002%2Fspe.4380130802 https://onlinelibrary.wiley.com/doi/pdf/10.1002/spe.4380130802 |
genre |
DML |
genre_facet |
DML |
op_source |
Software: Practice and Experience volume 13, issue 8, page 661-670 ISSN 0038-0644 1097-024X |
op_rights |
http://onlinelibrary.wiley.com/termsAndConditions#vor |
op_doi |
https://doi.org/10.1002/spe.4380130802 |
container_title |
Software: Practice and Experience |
container_volume |
13 |
container_issue |
8 |
container_start_page |
661 |
op_container_end_page |
670 |
_version_ |
1800750691469230080 |