Order Based Analysis Functions in NCR Teradata Parallel RDBMS
The decision-support (OLAP) applications commonly use order-based analysis functions like Rank, Cumulative Total, Moving Average. In past, the applications were forced to compute these important analysis functions outside the database. This resulted in loss of performance and inconvenience. In the NCR Teradata RDBMS V2R3.0.0, we have taken the lead by providing these functions as part of the extended SQL. In this paper we describe the feature and the algorithms. The feature allows computations on very large data sets and makes it significantly faster than what was previously possible.
KeywordsProcessing Unit Grouping Expression Order Specification Cumulative Total Client Machine
Unable to display preview. Download preview PDF.
- 1.F. Zemke, et al. Proposal for OLAP functions. ANSI NCITS H2-99-155. April, 1999.Google Scholar
- 2.D. DeWitt, et al. Parallel External Sorting using Probabilistic Splitting. In Proc. of the PDIS Conference, Miami Beach, FL, December, 1991.Google Scholar
- 3.NCR Corporation. Teradata RDBMS For Unix SQL Reference, Volume 3, SQL Data Manipulation Language, Version 2 Release 3.0.0, Dec. 1998.Google Scholar
- 4.NCR Corporation. Teradata Application Programming with Embedded SQL for C, Cobol and PL/1, August 1997.Google Scholar
- 5.R. Ramakrishnan, et al. SRQL: Sorted Relational Query Language. In Proc. of SSDBM’ 1998, Capri, Italy, July 1998.Google Scholar
- 6.Red Brick Systems. Decision-Makers, Business Data, and RISQL. White Paper, Sep. 1995.Google Scholar
- 7.TPP Council. TPC benchmark D (decision support). Standard Specification 1.0. May 1995.Google Scholar