Formal Relational Database Management Systems provide many aggregate functions while NoSQL database Cassandra supports only count functions. So, there is a shortage in analyzing the data. In this thesis, to resolve this shortage, Cassandra provides ag...
Formal Relational Database Management Systems provide many aggregate functions while NoSQL database Cassandra supports only count functions. So, there is a shortage in analyzing the data. In this thesis, to resolve this shortage, Cassandra provides aggregate functions by using command extension. Furthermore, it defines commands and forms of temporal data for aggregate functions. It also proposes algorithms for extended aggregate functions. To implement aggregate functions for temporal data, Cassandra extends commands. Extended aggregate functions are count, average, sum, max, min, rank, and stddev. In case of using temporal data, this paper implements extended commands using recent temporal data, a.m. data or p.m. data and user-defined temporal data.
In this paper several types of examples for extended aggregate functions for temporal data are tested in Cassandra System. The proposal provides not only basic aggregate functions, but aggregate functions for temporal data. Therefore, user-oriented interface can improve performance of searching process.