JavaTechies / Personal Finance

Hello Cassandra Developer,           Today, we will talk about how does indexes work into Cassandra, mainly about SASI. Motivation factor : It's help you to fulltext search  It's can be get by secondary index on cassandra columns it's help you to get unpredicate search query on cassandra data model  How does it work (SSTable - secondary indexes):   Maintain complete indexes data into single SSTable( kind of concurrent thread safe map collection in java) Since it's single SSTable, it has memory issue and need good RAM when huge data. it's called as "Classic C* Indexes" Support few basic comparison operation ("="). It's based on SSTable format. Support into Cassandra older version (less than 3.3) SSTable need to play with memory & disk operation for indexes data. How does it work (SASI): Maintain the Token tree base format - (B tree collection concept in java) It's create the different separate SASI fo...

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 cassa...