Cassandra - Interview Questions and Answers for 'Nosql vs relational' | Search Interview Question

Cassandra - Interview Questions and Answers for 'Nosql vs relational' - 2 question(s) found - Order By Newest

Q1. How different is the Search algorithm when we query Cassandra Tables and When we query Oracle Tables ?

Ans. Relational Database uses linear search if we don't query using indices. Performance for linear search is O(n). If indices have been used , relational database uses binary search. Performance for binary search is O(Log n).

Casandra uses hash search. Performance for Hash Search is O(1).

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve cassandra vs oracle nosql vs relational search algorithm}

Related Questions

What is the difference between Oracle , Cassandra and Redis ?

What is Apache Cassandra ?

Is Cassandra read optimized or Write optimized ?

How Cassandra provides better Read performance than Oracle Indices ?

Can we query Cassandra Tables without specifying the partition id in the where clause ?

What are the restrictions on querying Cassandra Tables ?

Which of the following databases - Cassandra / Oracle - provides more flexibility about querying the database ?

Why was Cassandra written in Java and not C++ ?

Q2. Which of the following databases - Cassandra / Oracle - provides more flexibility about querying the database ?

Database

Ans. Oracle as it is not modeled for a particular query or set of queries.

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve Cassandra Nosql database nosql vs relational database}