Basically I am trying to decide on if our data is a good use case to store in a nosql DB . Currently our data is stored in MS SQL , where we get a row per session.
In our data, we have sessions, users (IE customers) and flights.
Our data is currently stored by session. So each new session gets a new row. Each user might have multiple sessions on the same flight, or the same sesssion could also have the same user with multiple flights, or the same session can have multiple users.
The reason we started to think of using a could noSQL DB is to be able to get an aggregated look of the data in easier ways. IE the data is currently stored by session, but what if we want stats by user, or by flight, etc. The thought was a NoSQL DB makes it easier to query shopping data on different levels, be it on the user, session or flight level
The more I read about it, the more I think we should stick with SQL but just wanted opinions