SRQL:排序关系查询语言

Proceedings. Tenth International Conference on Scientific and Statistical Database Management (Cat. No.98TB100243) Pub Date : 1998-07-01 DOI:10.1109/SSDM.1998.688114

R. Ramakrishnan, D. Donjerkovic, Arvind Ranganathan, K. Beyer, M. Krishnaprasad

{"title":"SRQL:排序关系查询语言","authors":"R. Ramakrishnan, D. Donjerkovic, Arvind Ranganathan, K. Beyer, M. Krishnaprasad","doi":"10.1109/SSDM.1998.688114","DOIUrl":null,"url":null,"abstract":"A relation is an unordered collection of records. Often, however there is an underlying order (e.g., a sequence of stock prices), and users want to pose queries that reflect this order (e.g., find a weekly moving average). SQL provides no support for posing such queries. We show how a rich class of queries reflecting sort order can be naturally expressed and efficiently executed with simple extensions to SQL.","PeriodicalId":120937,"journal":{"name":"Proceedings. Tenth International Conference on Scientific and Statistical Database Management (Cat. No.98TB100243)","volume":"48 1","pages":"0"},"PeriodicalIF":0.0000,"publicationDate":"1998-07-01","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"85","resultStr":"{\"title\":\"SRQL: Sorted Relational Query Language\",\"authors\":\"R. Ramakrishnan, D. Donjerkovic, Arvind Ranganathan, K. Beyer, M. Krishnaprasad\",\"doi\":\"10.1109/SSDM.1998.688114\",\"DOIUrl\":null,\"url\":null,\"abstract\":\"A relation is an unordered collection of records. Often, however there is an underlying order (e.g., a sequence of stock prices), and users want to pose queries that reflect this order (e.g., find a weekly moving average). SQL provides no support for posing such queries. We show how a rich class of queries reflecting sort order can be naturally expressed and efficiently executed with simple extensions to SQL.\",\"PeriodicalId\":120937,\"journal\":{\"name\":\"Proceedings. Tenth International Conference on Scientific and Statistical Database Management (Cat. No.98TB100243)\",\"volume\":\"48 1\",\"pages\":\"0\"},\"PeriodicalIF\":0.0000,\"publicationDate\":\"1998-07-01\",\"publicationTypes\":\"Journal Article\",\"fieldsOfStudy\":null,\"isOpenAccess\":false,\"openAccessPdf\":\"\",\"citationCount\":\"85\",\"resultStr\":null,\"platform\":\"Semanticscholar\",\"paperid\":null,\"PeriodicalName\":\"Proceedings. Tenth International Conference on Scientific and Statistical Database Management (Cat. No.98TB100243)\",\"FirstCategoryId\":\"1085\",\"ListUrlMain\":\"https://doi.org/10.1109/SSDM.1998.688114\",\"RegionNum\":0,\"RegionCategory\":null,\"ArticlePicture\":[],\"TitleCN\":null,\"AbstractTextCN\":null,\"PMCID\":null,\"EPubDate\":\"\",\"PubModel\":\"\",\"JCR\":\"\",\"JCRName\":\"\",\"Score\":null,\"Total\":0}","platform":"Semanticscholar","paperid":null,"PeriodicalName":"Proceedings. Tenth International Conference on Scientific and Statistical Database Management (Cat. No.98TB100243)","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.1109/SSDM.1998.688114","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}

引用次数: 85

摘要

关系是记录的无序集合。然而，通常存在一个潜在的顺序(例如，股票价格序列)，并且用户希望提出反映该顺序的查询(例如，查找周移动平均线)。SQL不支持提出这样的查询。我们将展示如何通过简单的SQL扩展自然地表达和有效地执行反映排序顺序的丰富查询类。

本文章由计算机程序翻译，如有差异，请以英文原文为准。

查看原文

微信好友朋友圈 QQ好友复制链接

本刊更多论文

SRQL: Sorted Relational Query Language

A relation is an unordered collection of records. Often, however there is an underlying order (e.g., a sequence of stock prices), and users want to pose queries that reflect this order (e.g., find a weekly moving average). SQL provides no support for posing such queries. We show how a rich class of queries reflecting sort order can be naturally expressed and efficiently executed with simple extensions to SQL.

求助全文

通过发布文献求助，成功后即可免费获取论文全文。去求助

来源期刊

Proceedings. Tenth International Conference on Scientific and Statistical Database Management (Cat. No.98TB100243)

自引率

0.00%

发文量