Categories

See More
Popular Forum

MBA (4887) B.Tech (1769) Engineering (1486) Class 12 (1030) Study Abroad (1004) Computer Science and Engineering (988) Business Management Studies (865) BBA (846) Diploma (746) CAT (651) B.Com (648) B.Sc (643) JEE Mains (618) Mechanical Engineering (574) Exam (525) India (462) Career (452) All Time Q&A (439) Mass Communication (427) BCA (417) Science (384) Computers & IT (Non-Engg) (383) Medicine & Health Sciences (381) Hotel Management (373) Civil Engineering (353) MCA (349) Tuteehub Top Questions (348) Distance (340) Colleges in India (334)
See More

Which choice of technology for this?

General Tech Technology & Software

Max. 2000 characters
Replies

usr_profile.png

User

( 3 months ago )

I face the following problem. The target is to develop a DB to store the following schema:

You have PRODUCTS that can be composed of both PRIMARY_PRODUCTS and also other PRODUCTS.

My first question is to know which one of SQL DB or NoSQL technology would be recommended for this? I don't really know well NoSQL and I am not sure it is worth spending time investigating if the whole concept is not suited with the pb. If NoSQL is worth looking at, which version is recommended? I was looking at Cassandra but there are so many types that the universe is quite big.

If NoSQL is not suited for this, so we need to revert to SQL. Do you thing that hierarchyId is suited?

usr_profile.png

User

( 3 months ago )


Both SQL or NoSQL can store and retrieve data of this kind, and both technologies can be made to do this job.

The major differences are elsewhere: in a nutshell, transactions and guaranteed consistency for SQL versus high performance for readers for NoSQL.

In your precise situation SQL, with its support for transactions, will ensure that viewers will see a composite product when all sub-products have been successfully stored.

In most real-life situations, however, the chance of a viewer seeing a partially-committed product on a NoSQL system is so slim as to be irrelevant: future reads of the product will be correct.

what's your interest


forum_ban8_5d8c5fd7cf6f7.gif