Parallel sorting on a shared-nothing architecture using probabilistic splitting
PDIS '91 Proceedings of the first international conference on Parallel and distributed information systems
SRQL: Sorted Relational Query Language
SSDBM '98 Proceedings of the 10th International Conference on Scientific and Statistical Database Management
Progressive optimization in a shared-nothing parallel database
Proceedings of the 2007 ACM SIGMOD international conference on Management of data
Hi-index | 0.00 |
The decision-support (OLAP) applications commonly use orderbased 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.