You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@cassandra.apache.org by "@Nandan@" <na...@gmail.com> on 2017/12/08 01:39:46 UTC
Reg:- Data modelling For E-Commerce Pattern data modelling for Search
Hi Peoples,
As currently around the world 60-70% websites are excelling with E-commerce
in which we have to store huge amount of data and select pattern based on
Partial Search, Text match, Full-Text Search and all.
So below questions comes to mind :
1) Is Cassandra a correct choice for data modeling which gives complex
Search patterned as Amazon or eBay is using?
2) If we will use denormalized data modeling then is it will be effective?
Please clarify this.
Thanks and Best regards,
Nandan Priyadarshi
Re: Reg:- Data modelling For E-Commerce Pattern data modelling for
Search
Posted by Jon Haddad <jo...@jonhaddad.com>.
You’re going to have duplicate data no matter what you do. Creating indexes is another representation of the data, it’s not free.
Yes, storing it in two places is more work, but I’ve typically had to do that anyways. My search queries are almost never an exact match to my Cassandra data model.
If you want to try to do everything in Cassandra, try the two links I listed. I can’t endorse either, as I’ve never used them, but I’ve heard nice things about both in passing.
Jon
> On Dec 7, 2017, at 7:05 PM, @Nandan@ <na...@gmail.com> wrote:
>
> Thanks. But again my questions come back at the same place that how to do data modeling because If we will do denormalized then we have to allow a lot of data duplication, as well as Insert and Update, will also need to think because based on this we have to insert data into multiple tables at same time.
>
>
> On Fri, Dec 8, 2017 at 10:54 AM, Jon Haddad <jon@jonhaddad.com <ma...@jonhaddad.com>> wrote:
> I mean ES is great as a search engine. I would use Cassandra as my source of truth, and also index my data in ES.
>
> I typed my original message before I walked my dog, I should have also pointed out https://github.com/strapdata/elassandra <https://github.com/strapdata/elassandra> and https://github.com/Stratio/cassandra-lucene-index <https://github.com/Stratio/cassandra-lucene-index>, but I haven’t used either one.
>
> Jon
>
>
>> On Dec 7, 2017, at 5:59 PM, @Nandan@ <nandanpriyadarshi298@gmail.com <ma...@gmail.com>> wrote:
>>
>> Hi Jon,
>> Do you mean Elastic search for storing data or Data should be store into Cassandra and use Elastic Search for Select records from tables. ?
>>
>>
>> On Fri, Dec 8, 2017 at 9:50 AM, Jon Haddad <jon@jonhaddad.com <ma...@jonhaddad.com>> wrote:
>> 1. No, Apache Cassandra is pretty terrible for search on it’s own. Even with SASI.
>> 2. Maybe, but it’s complicated, and doing it right takes a lot of experience. I’d use Elastic Search instead.
>>
>>
>>
>> > On Dec 7, 2017, at 5:39 PM, @Nandan@ <nandanpriyadarshi298@gmail.com <ma...@gmail.com>> wrote:
>> >
>> > Hi Peoples,
>> >
>> > As currently around the world 60-70% websites are excelling with E-commerce in which we have to store huge amount of data and select pattern based on Partial Search, Text match, Full-Text Search and all.
>> >
>> > So below questions comes to mind :
>> > 1) Is Cassandra a correct choice for data modeling which gives complex Search patterned as Amazon or eBay is using?
>> > 2) If we will use denormalized data modeling then is it will be effective?
>> >
>> > Please clarify this.
>> >
>> > Thanks and Best regards,
>> > Nandan Priyadarshi
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: user-unsubscribe@cassandra.apache.org <ma...@cassandra.apache.org>
>> For additional commands, e-mail: user-help@cassandra.apache.org <ma...@cassandra.apache.org>
>>
>>
>
>
Re: Reg:- Data modelling For E-Commerce Pattern data modelling for Search
Posted by "@Nandan@" <na...@gmail.com>.
Thanks. But again my questions come back at the same place that how to do
data modeling because If we will do denormalized then we have to allow a
lot of data duplication, as well as Insert and Update, will also need to
think because based on this we have to insert data into multiple tables at
same time.
On Fri, Dec 8, 2017 at 10:54 AM, Jon Haddad <jo...@jonhaddad.com> wrote:
> I mean ES is great as a search engine. I would use Cassandra as my source
> of truth, and also index my data in ES.
>
> I typed my original message before I walked my dog, I should have also
> pointed out https://github.com/strapdata/elassandra and https
> ://github.com/Stratio/cassandra-lucene-index, but I haven’t used either
> one.
>
> Jon
>
>
> On Dec 7, 2017, at 5:59 PM, @Nandan@ <na...@gmail.com>
> wrote:
>
> Hi Jon,
> Do you mean Elastic search for storing data or Data should be store into
> Cassandra and use Elastic Search for Select records from tables. ?
>
>
> On Fri, Dec 8, 2017 at 9:50 AM, Jon Haddad <jo...@jonhaddad.com> wrote:
>
>> 1. No, Apache Cassandra is pretty terrible for search on it’s own. Even
>> with SASI.
>> 2. Maybe, but it’s complicated, and doing it right takes a lot of
>> experience. I’d use Elastic Search instead.
>>
>>
>>
>> > On Dec 7, 2017, at 5:39 PM, @Nandan@ <na...@gmail.com>
>> wrote:
>> >
>> > Hi Peoples,
>> >
>> > As currently around the world 60-70% websites are excelling with
>> E-commerce in which we have to store huge amount of data and select pattern
>> based on Partial Search, Text match, Full-Text Search and all.
>> >
>> > So below questions comes to mind :
>> > 1) Is Cassandra a correct choice for data modeling which gives complex
>> Search patterned as Amazon or eBay is using?
>> > 2) If we will use denormalized data modeling then is it will be
>> effective?
>> >
>> > Please clarify this.
>> >
>> > Thanks and Best regards,
>> > Nandan Priyadarshi
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: user-unsubscribe@cassandra.apache.org
>> For additional commands, e-mail: user-help@cassandra.apache.org
>>
>>
>
>
Re: Reg:- Data modelling For E-Commerce Pattern data modelling for
Search
Posted by Jon Haddad <jo...@jonhaddad.com>.
I mean ES is great as a search engine. I would use Cassandra as my source of truth, and also index my data in ES.
I typed my original message before I walked my dog, I should have also pointed out https://github.com/strapdata/elassandra <https://github.com/strapdata/elassandra> and https://github.com/Stratio/cassandra-lucene-index <https://github.com/Stratio/cassandra-lucene-index>, but I haven’t used either one.
Jon
> On Dec 7, 2017, at 5:59 PM, @Nandan@ <na...@gmail.com> wrote:
>
> Hi Jon,
> Do you mean Elastic search for storing data or Data should be store into Cassandra and use Elastic Search for Select records from tables. ?
>
>
> On Fri, Dec 8, 2017 at 9:50 AM, Jon Haddad <jon@jonhaddad.com <ma...@jonhaddad.com>> wrote:
> 1. No, Apache Cassandra is pretty terrible for search on it’s own. Even with SASI.
> 2. Maybe, but it’s complicated, and doing it right takes a lot of experience. I’d use Elastic Search instead.
>
>
>
> > On Dec 7, 2017, at 5:39 PM, @Nandan@ <nandanpriyadarshi298@gmail.com <ma...@gmail.com>> wrote:
> >
> > Hi Peoples,
> >
> > As currently around the world 60-70% websites are excelling with E-commerce in which we have to store huge amount of data and select pattern based on Partial Search, Text match, Full-Text Search and all.
> >
> > So below questions comes to mind :
> > 1) Is Cassandra a correct choice for data modeling which gives complex Search patterned as Amazon or eBay is using?
> > 2) If we will use denormalized data modeling then is it will be effective?
> >
> > Please clarify this.
> >
> > Thanks and Best regards,
> > Nandan Priyadarshi
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@cassandra.apache.org <ma...@cassandra.apache.org>
> For additional commands, e-mail: user-help@cassandra.apache.org <ma...@cassandra.apache.org>
>
>
Re: Reg:- Data modelling For E-Commerce Pattern data modelling for Search
Posted by "@Nandan@" <na...@gmail.com>.
Hi Jon,
Do you mean Elastic search for storing data or Data should be store into
Cassandra and use Elastic Search for Select records from tables. ?
On Fri, Dec 8, 2017 at 9:50 AM, Jon Haddad <jo...@jonhaddad.com> wrote:
> 1. No, Apache Cassandra is pretty terrible for search on it’s own. Even
> with SASI.
> 2. Maybe, but it’s complicated, and doing it right takes a lot of
> experience. I’d use Elastic Search instead.
>
>
>
> > On Dec 7, 2017, at 5:39 PM, @Nandan@ <na...@gmail.com>
> wrote:
> >
> > Hi Peoples,
> >
> > As currently around the world 60-70% websites are excelling with
> E-commerce in which we have to store huge amount of data and select pattern
> based on Partial Search, Text match, Full-Text Search and all.
> >
> > So below questions comes to mind :
> > 1) Is Cassandra a correct choice for data modeling which gives complex
> Search patterned as Amazon or eBay is using?
> > 2) If we will use denormalized data modeling then is it will be
> effective?
> >
> > Please clarify this.
> >
> > Thanks and Best regards,
> > Nandan Priyadarshi
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@cassandra.apache.org
> For additional commands, e-mail: user-help@cassandra.apache.org
>
>
Re: Reg:- Data modelling For E-Commerce Pattern data modelling for
Search
Posted by Jon Haddad <jo...@jonhaddad.com>.
1. No, Apache Cassandra is pretty terrible for search on it’s own. Even with SASI.
2. Maybe, but it’s complicated, and doing it right takes a lot of experience. I’d use Elastic Search instead.
> On Dec 7, 2017, at 5:39 PM, @Nandan@ <na...@gmail.com> wrote:
>
> Hi Peoples,
>
> As currently around the world 60-70% websites are excelling with E-commerce in which we have to store huge amount of data and select pattern based on Partial Search, Text match, Full-Text Search and all.
>
> So below questions comes to mind :
> 1) Is Cassandra a correct choice for data modeling which gives complex Search patterned as Amazon or eBay is using?
> 2) If we will use denormalized data modeling then is it will be effective?
>
> Please clarify this.
>
> Thanks and Best regards,
> Nandan Priyadarshi
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@cassandra.apache.org
For additional commands, e-mail: user-help@cassandra.apache.org
RE: [EXTERNAL] Re: Reg:- Data modelling For E-Commerce Pattern data
modelling for Search
Posted by "Durity, Sean R" <SE...@homedepot.com>.
DataStax Enterprise (pay to license) has embedded SOLR search with Cassandra if you don’t want to move the data to another cluster for indexing/searching. Similar to Cassandra modeling, you will need to understand the exact search queries in order to build the SOLR schema to support them.
The basic answer, though, is that Cassandra itself is not built for handling search queries like the ones you mention.
Sean Durity
From: Bradford Stephens [mailto:bradfordstephens@gmail.com]
Sent: Friday, December 08, 2017 11:31 AM
To: user@cassandra.apache.org
Subject: [EXTERNAL] Re: Reg:- Data modelling For E-Commerce Pattern data modelling for Search
Hi -- you want to use Elasticsearch with a Cassandra store for the blob data.
On Thu, Dec 7, 2017 at 7:39 PM, @Nandan@ <na...@gmail.com>> wrote:
Hi Peoples,
As currently around the world 60-70% websites are excelling with E-commerce in which we have to store huge amount of data and select pattern based on Partial Search, Text match, Full-Text Search and all.
So below questions comes to mind :
1) Is Cassandra a correct choice for data modeling which gives complex Search patterned as Amazon or eBay is using?
2) If we will use denormalized data modeling then is it will be effective?
Please clarify this.
Thanks and Best regards,
Nandan Priyadarshi
--
Bradford Stephens
roboticprofit.com<https://urldefense.proofpoint.com/v2/url?u=http-3A__roboticprofit.com&d=DwMFaQ&c=MtgQEAMQGqekjTjiAhkudQ&r=aC_gxC6z_4f9GLlbWiKzHm1vucZTtVYWDDvyLkh8IaQ&m=ikZ3YF5-SWCOTuc2-q7yt_YZ6SX3LvKHZ8adbkKUdxw&s=-Qb2tFJ7mier1bZv0n99FbMORDffnAeIeK6zIm4oesY&e=>
Data for Driving Revenue
________________________________
The information in this Internet Email is confidential and may be legally privileged. It is intended solely for the addressee. Access to this Email by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. When addressed to our clients any opinions or advice contained in this Email are subject to the terms and conditions expressed in any applicable governing The Home Depot terms of business or client engagement letter. The Home Depot disclaims all responsibility and liability for the accuracy and content of this attachment and for any damages or losses arising from any inaccuracies, errors, viruses, e.g., worms, trojan horses, etc., or other items of a destructive nature, which may be contained in this attachment and shall not be liable for direct, indirect, consequential or special damages in connection with this e-mail message or its attachment.
Re: Reg:- Data modelling For E-Commerce Pattern data modelling for Search
Posted by Bradford Stephens <br...@gmail.com>.
Hi -- you want to use Elasticsearch with a Cassandra store for the blob
data.
On Thu, Dec 7, 2017 at 7:39 PM, @Nandan@ <na...@gmail.com>
wrote:
> Hi Peoples,
>
> As currently around the world 60-70% websites are excelling with
> E-commerce in which we have to store huge amount of data and select pattern
> based on Partial Search, Text match, Full-Text Search and all.
>
> So below questions comes to mind :
> 1) Is Cassandra a correct choice for data modeling which gives complex
> Search patterned as Amazon or eBay is using?
> 2) If we will use denormalized data modeling then is it will be effective?
>
> Please clarify this.
>
> Thanks and Best regards,
> Nandan Priyadarshi
>
--
Bradford Stephens
roboticprofit.com
Data for Driving Revenue