Scientific and Statistical Database Management, International Conference on (1998)
Apr. 1, 1998 to Apr. 3, 1998
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
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.
query language, relational algebra, sequence algebra, sequence data, time-series, SQL, SRQL
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.