Order Based Analysis Functions in NCR Teradata Parallel RDBMS

  • Ambuj Shatdal
Conference paper
Part of the Lecture Notes in Computer Science book series (LNCS, volume 1777)


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.


Processing Unit Grouping Expression Order Specification Cumulative Total Client Machine 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 1.
    F. Zemke, et al. Proposal for OLAP functions. ANSI NCITS H2-99-155. April, 1999.Google Scholar
  2. 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. 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. 4.
    NCR Corporation. Teradata Application Programming with Embedded SQL for C, Cobol and PL/1, August 1997.Google Scholar
  5. 5.
    R. Ramakrishnan, et al. SRQL: Sorted Relational Query Language. In Proc. of SSDBM’ 1998, Capri, Italy, July 1998.Google Scholar
  6. 6.
    Red Brick Systems. Decision-Makers, Business Data, and RISQL. White Paper, Sep. 1995.Google Scholar
  7. 7.
    TPP Council. TPC benchmark D (decision support). Standard Specification 1.0. May 1995.Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2000

Authors and Affiliations

  • Ambuj Shatdal
    • 1
  1. 1.NCR CorporationMadisonUSA

Personalised recommendations