Cassandra Materialized view vs Index


Cassandra, it's not new now, mostly all developer should know it somehow or might read some where.

if you are not part of this big data column base database development usage then grab it and learn it for your next scaling problem at data level, what you are or you would face in project work :) this help you !!!

Today, let's me give you detail about cassandra materialised view (new feature in 3.0 cassandra) and how it's work.

Also, how it's defer than apply index on column in your single data model table.

Real life issue with cassandra :


  • Data model best practice  suggest you to make read faster, use query base data model, do not worry about write or duplicate of data at the cassandra level, it can be handle by your application
  • But, it's not easy to handle this at application level when we simple change one or few row and it's effect to update many data model even if it's part of one entities or one record object.
What was solution pre cassandra 3.0 
  • Cassandra community has answer either build query base data model mean each query execution should have one table in cassandra so read operation become faster.
  • Another quick solution if you wont like above approach 
    • use concept of index on query column and use single table in data model (fun) 
    • fun behind this, application need to write and maintain the single table in cassandra side for all CRUD operation. - here you are thinking for better write , not read :(
What was post cassandra 3.0 

  • Cassandra(indirectly datastak might be) introduce the concept of Materialise view .
  • More info : link
Let's understand simple example : 



Here, how would you make cql.

Here, How you can get same thing with Local Indexes  ?


How does it hit at node level in cluster env.  ?


 Since Index column is not partition key, it has to hit all nodes in your cluster env.


Problem : it would hit your performance but if you are looking for predicate base query or application does not know which column query got execute then it's OK also it's ok if you are looking for fulltext search functionality, you dont have any option as of now :).

 Let's see how does it help here ?


Since Cassandra managed partition key or create partition key while making the materialized views,
it wont be talk with all your nodes but only which has real your result data :)

Let's quick look, how does it compare and who will WIN.

Enjoy and keep using the cassandra  for your product .

thanks to apache cassandra & datastak.

 

Comments

Post a Comment

Popular posts from this blog

Step by step guide on how to pay Income Tax that is due

Image
1. Select Challan 280 Go to the tax information network of the Income Tax Department and select Challan 280. Click here to go to the government website and pay your tax 2.Enter Personal Info For individuals paying tax, select  . Please choose the Assessment Year correctly  . Choose   if you are paying taxes after the Financial Year has ended. View mandatory fields to be filled in Note:  Choose "(100) ADVANCE TAX" if you are paying taxes during the financial year. Choose "(400) TAX ON REGULAR ASSESSMENT" if you get a demand notice from the Tax Department. 3.Double check info You will be redirected to the net banking page. Double check the information entered here and enter the income tax amount to be paid in the income tax field. Tip:  You can leave surcharge, education cess, interest and penalty blank. 4. Check Receipt (Challan 280) This is your Challan 280. You will be able to see details about your payment on...
Read more

Simple way producer–consumer problem's implementation in NodeJs

Problem Name :  Producer-Consumer Problem (Also Known as Bounded Buffer Problem ) Goal :  It's explain you "multi-process resource synchronization problem". Problem Statement :  there are many producers and many consumers, the work of producer is to generate/produce things/jobs/items any things and the work of consumer is to consume things/jobs/items/any things produced/generated by producer. What is the NodeJs ?                   Node.js is a platform built on  Chrome's JavaScript runtime  for easily building fast, scalable network applications. Node.js uses an event-driven, non-blocking I/O model that makes it lightweight and efficient, perfect for data-intensive real-time applications that run across distributed devices. Code : var express = require('express'); var app = express(); var queue = []; //Default Handler app.get('/',function(req,res){ res.send('Producer/Consumer Server');...
Read more

Rajiv Gandhi Equity Savings Scheme

    (I) Introduction to Rajiv Gandhi Equity Savings Scheme, 2012 1) What is Rajiv Gandhi Equity Savings Scheme, 2012 (RGESS)? With an objective to encourage flow of savings of the small investors in domestic capital market, the Government of India announced a scheme named Rajiv Gandhi Equity Savings Scheme, 2012 (RGESS). 2) Does RGESS offer any tax benefits? A new section 80CCG under the Income Tax Act, 1961 on ‘Deduction in respect of investment under an equity savings scheme’ has been introduced to give tax benefits to ‘New Retail Investors’ who invest up to `50,000 in ‘Eligible Securities’ and have gross total annual income less than or equal to Rs.10 Lakhs. 3) Who is a ‘New Retail Investor’? A ‘New Retail Investor’ is any resident Individual  ü who has not opened a demat account and has not made any transactions in the equity or derivative segment as on the date of notification of the scheme i.e., November 23, 2012. OR ü ...
Read more