vendredi 9 janvier 2015

Which is best choice MongoDB / Cassandra / Redis / ElasticSearch?

We are planning to build a travel website in which we will be integrating a multiple APIs (eg. DOTW, GTA, Expedia) for Hotels. I have initially tried to use MySQL but since there huge amount of data in hotels and it may contain numerous one to many relationships with Images, Amenities and Rooms, so when we have a data around 200000 Hotels from various provider and if we store there Amenities, Images and Rooms in conjunction with Hotels the search becomes very slow. Even fetching all details for just one hotel may results in join from atleast four tables, and scanning over 200000 hotels records. So we are planning to migrate our product schema to any NoSQL database to make our search as fast as possible.


Also sometimes we need to run certain schedulers on our database for eliminating duplicate hotels from our database and also updating the newly added hotels which are added by our providers.


Our tech stack is basically on Java, J2EE along with Springs and Hibernate.


I have read about about MongoDB, Cassandra, Redis and ElasticSearch but I am now confused about which to use to optimize the website search performance.


Aucun commentaire:

Enregistrer un commentaire