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. In this paper, we show how a rich class of queries reflecting sort order can be naturally expressed and efficiently executed with simple extensions to SQL.

• Type: Conference
• Year: 1998
• Where: SSDBM
• Authors: Raghu Ramakrishnan, Donko Donjerkovic, Arvind Ranganathan, Kevin S. Beyer, Muralidhar Krishnaprasad
• Keywords: Database, Queries Reflecting Sort, SSDBM 1998, Unordered Collection, Weekly Moving Average