Similarity-Aware EQUALS and IN Operator in Cassandra and Its Application in Agriculture

With the exponential growth of the Internet, the need of handling the sort of unstructured, messy and unpredictable data became so urgent. This makes NoSQL databases to be introduced to compensate for the inefficiency of traditional relational databases in dealing with these kind of data. Among those NoSQL databases, Cassandra gained popularity than the rest and today it is at use in over 1500 companies like Reddit, Netflix, Instagram, GitHub, eBay. The EQUALS and IN operator are the two most basic tools used in Cassandra Query Language (CQL) to compare two or more data items. However, the two operators are not capable of dealing with non-traditional data types like images as instead of looking for similarity between two images, they use identity (=) which is not always the correct method. Thus, this paper introduces similarity-aware EQUALS and IN operator which is very much capable of dealing with modern complex data types like images. These operators based on similarity can be used in various fields like Agriculture for finding regions capable of growing a particular crop. In this paper, we demonstrate the application of the two operators in Agriculture.