CODEWITHSUNDEEP
databasenosql
syv
syv

Reputation: 3608

Using NoSQL and RDBS together

Using NoSQL & RDBMS in same application is advisable? Managing relational/transaction data into RDBMS and dynamic data ito NoSQL and latter that will be used for Analytic?

Upvotes: 0

Views: 1417

Answers (1)

Dinkar Thakur
Dinkar Thakur

Reputation: 3103

Yes

You can use Both NoSQL and RDBMS in same application, In fact many project uses the same approach.

In a working environment you have a Relation-Mapping between different entities of your business and mostly Normalized. So its advisable to use an RDBMS there. Although some NoSQL solutions are out there in which you can handle these BUT on your own but you're never going to need it, as in NoSQL you can place the related data in one Big Table, but then here you have to think much about the structure of that. In case of RDBMS the structure is straight forward (Normalized mostly).

So its better to use RDBMS here.

Now in case of Analytics you should use NoSQL, as the content is mostly linear and you will require a "flat structure". Only one table having all required fields. This approach in GOOD as compared to different tables because as the data grows JOINS are going to make the Query so slow that retrieving Data will be pain in ass. Although there are so many solution in RDBMS provided by some of the big names in Database Technologies, I'm not in favor of using them.

Also Analytics is something in which the parameters you are analyzing are changing frequently a Non-Schema Based DB can increase your productivity to large extent.

Telling from personal experience : We were using MSSQL as main DB for the site and for the Analysis but as the data grew we tried many ways, finally settling on using Mongo as the Analytic Database and MSSQL as main DB.

SO the project uses MSSQL for transaction (functional) working and Mongo for Analytics.

Upvotes: 1

Related Questions