The Community for Technology Leaders
Scientific and Statistical Database Management, International Conference on (1998)
Capri, Italy
Apr. 1, 1998 to Apr. 3, 1998
ISBN: 0-8186-8575-1
pp: 84
Raghu Ramakrishnan , University of Wisconsin-Madison
Donko Donjerkovic , University of Wisconsin-Madison
Arvind Ranganathan , University of Wisconsin-Madison
Kevin S. Beyer , University of Wisconsin-Madison
Muralidhar Krishnaprasad , University of Wisconsin-Madison
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. 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.
INDEX TERMS
query language, relational algebra, sequence algebra, sequence data, time-series, SQL, SRQL
CITATION

R. Ramakrishnan, D. Donjerkovic, K. S. Beyer, A. Ranganathan and M. Krishnaprasad, "SRQL: Sorted Relational Query Language," Scientific and Statistical Database Management, International Conference on(SSDBM), Capri, Italy, 1998, pp. 84.
doi:10.1109/SSDM.1998.688114
96 ms
(Ver 3.3 (11022016))