Is there any concept of stored procedures in Kassandra?

Question

My team now uses an RDBMS-based solution (more precisely, MSSQL) to manage the database, but we expect to move to Kassandra soon, as we expect a huge increase in traffic.

The application logic is now separate from the insertion logic, because the application calls only certain procedures in SQL that invoke some data validation and make the corresponding insertions.

I want to do something like this in Kassandra. However, I can not find anything that could help me with this. UDFs are not useful as they are mainly used in the request SELECT. I would appreciate community help / advice on this, thanks!

Answer 1

The closest function to the stored procedure will be batch , as it will allow you to “bundle” the various DML instructions related to insert, update, or delete.

If you are moving from RDBMS to Kassandra, one of the biggest problems is adapting to the required data modeling and, more specifically, to denormalizing the data. A data model is a key factor in the success (and failure) of any Cassandra implementation, and because of this you can find several resources on the net (to mention the basics of the eBay blog , Datastax Data Academy Data Model Course )

Good luck with your implementation!