Context based Cassandra query language
Shivendra Kumar Pandey, Sudhakar · 2017
NoSQL databases are distributed, non-relational databases designed for large-scale data storage and for parallel data processing across a large number of commodity servers. Cassandra is a NoSQL database that stores data in non-related tabular forms. Cassandra works on “query at a time” and “query at a table” concept. In our daily life the queries of a user are related to each other. If queries by a user are related, that is, the current query is related to the previous query, then there is no support in Cassandra to state this. Cassandra runs each query on the entire table because Cassandra has neither memory to remember the result of a previous query, nor supports VIEW or JOIN on tables (or keyspace). Cassandra uses Big Table (of Google) for data storage which has thousands of columns and millions of rows, so it is not efficient to run the query on such a huge table, after knowing that the result of the previous query is sufficient to answer our current query. To solve such problems of Cassandra database, we implemented a new query language named as “Context Based Cassandra Query Language”. CBCQL is internally mapped to Cassandra Query Language (CQL) so it has the same power as Cassandra, but provides additional functionality of querying on result of previous query. In this paper, CBCQL is explained with examples.