Received: by 10.58.246.37 with SMTP id xt5mr5108384vec.13.1351012738194; Tue, 23 Oct 2012 10:18:58 -0700 (PDT) X-BeenThere: neo4j@googlegroups.com Received: by 10.52.30.49 with SMTP id p17ls992286vdh.4.gmail; Tue, 23 Oct 2012 10:18:56 -0700 (PDT) Received: by 10.58.74.41 with SMTP id q9mr5099654vev.14.1351012736138; Tue, 23 Oct 2012 10:18:56 -0700 (PDT) Received: by 10.58.74.41 with SMTP id q9mr5099652vev.14.1351012736109; Tue, 23 Oct 2012 10:18:56 -0700 (PDT) Return-Path: Received: from mail-vc0-f179.google.com (mail-vc0-f179.google.com [209.85.220.179]) by gmr-mx.google.com with ESMTPS id dj17si3360960vdb.1.2012.10.23.10.18.56 (version=TLSv1/SSLv3 cipher=OTHER); Tue, 23 Oct 2012 10:18:56 -0700 (PDT) Received-SPF: pass (google.com: domain of azeeztechni...@gmail.com designates 209.85.220.179 as permitted sender) client-ip=209.85.220.179; Authentication-Results: gmr-mx.google.com; spf=pass (google.com: domain of azeeztechni...@gmail.com designates 209.85.220.179 as permitted sender) smtp.mail=azeeztechni...@gmail.com; dkim=pass header...@gmail.com Received: by mail-vc0-f179.google.com with SMTP id f13so4117837vcb.10 for ; Tue, 23 Oct 2012 10:18:56 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :content-type; bh=oj0gmd6HOVfcI6WYFjviO1sC8sEev6t9hctrM8IDDCU=; b=Rzac1+4GNrShcY6HwqnGx+M3J2LUm6W3T5waaYtlTHwCVXQLAvfrKADXNqvGr+6v0M Y9souPNFx0xxV8JhfsAG6oNmKXVayAy5FLcmp66lEbDxCwHVEfWYUog2MLBDNq/RDxbo Sbq9AH4T70oB48FDjJR8hQvXun0EvHCo7t9pXgWrDHiN9xfM8adcNvzBhfLlqniy4v7a KCyNvbQE7AWI4YtOEQgMbYhM2/AwuUPVQOTDjD+RNqaeXe9L3IK/ORvFk8OkmzDy5ue7 WhOORQHVzHhus4ulf1xZReHtQo0xEdY8uz9Okk0n1yPbIwSWbXVQOxNCbiu5FsD9lvVz LLdA== Received: by 10.220.247.140 with SMTP id mc12mr3434621vcb.0.1351012735569; Tue, 23 Oct 2012 10:18:55 -0700 (PDT) MIME-Version: 1.0 Received: by 10.58.216.39 with HTTP; Tue, 23 Oct 2012 10:18:15 -0700 (PDT) In-Reply-To: References: From: Abdul Azeez Shaik Date: Tue, 23 Oct 2012 22:48:15 +0530 Message-ID: Subject: Re: [Neo4j] Neo4j for implementing Facebook like messaging system To: neo4j@googlegroups.com Content-Type: multipart/alternative; boundary=bcaec54a37ba30cefd04ccbd2ae9 --bcaec54a37ba30cefd04ccbd2ae9 Content-Type: text/plain; charset=ISO-8859-1 Thanks for the response Wes. Yes, its similar to status updates one. I have few concerns in this implementation 1. There is no traversal involved in this design (except user1, user2 matches) to leverage graph databases power. 2. As I have to save whole mail as just a property of node. What would be the efficiency of Lucene indexing? Also, when graph size grows big .i.e.when we search has to be performed in old mails as well. (In case of status update, there was no searching involved based on text in update and there was limit for update) Would love to more ideas on this. Thanks, Abdul On Tue, Oct 23, 2012 at 10:36 PM, Wes Freeman wrote: > Oh, I see the difficulty there. You'd want to search for messages just > between two users? Or within an inbox? I guess you might have to keep track > of the to/from as properties as part of the index, and I'm not even sure > you can mix a full-text with a properties-level index--anyone have a better > idea? > > > On Tue, Oct 23, 2012 at 12:53 PM, Wes Freeman wrote: > >> Your design sounds good and easy to query, kind of like the status >> updates but starting from two nodes. >> >> You can set up a full-text index for the message nodes themselves, so you >> could search them just via lucene, rather than having to scan through all >> of the nodes in the list. >> >> Wes >> >> >> On Tue, Oct 23, 2012 at 5:40 AM, Abdul Azeez Shaik < >> azeeztechni...@gmail.com> wrote: >> >>> Hi Peter, >>> >>> Its only messages or emails between two users(1:1) without any >>> attachments. Email itself can be large, almost similar to this mail. (Have >>> already implemented timeline and works pretty decent). >>> >>> As of now, i can think of having Messages node between two users. And >>> then further replies for the same thread would be added on top of this >>> Messages >>> >>> User1--->Message<--User2 >>> >>> Messages-->oldMessage1-->OldMessage2 >>> >>> However, this would work fine initially. But i am worried for the >>> support of inbox searching for individual message is large and if archive >>> grows big over the period of time. >>> >>> Thanks, >>> Abdul >>> >>> >>> On Tue, Oct 23, 2012 at 1:49 PM, Peter Neubauer < >>> peter.neuba...@neotechnology.com> wrote: >>> >>>> Mmh, >>>> do you have any details on this - what are the messages, how many, >>>> what would you imagine for the graph structure - is it pure messages >>>> or even timelines like status updates? >>>> >>>> Cheers, >>>> >>>> /peter neubauer >>>> >>>> G: neubauer.peter >>>> S: peter.neubauer >>>> P: +46 704 106975 >>>> L: http://www.linkedin.com/in/neubauer >>>> T: @peterneubauer >>>> >>>> Neo4j 1.8 GA - >>>> http://www.dzone.com/links/neo4j_18_release_fluent_graph_literacy.html >>>> >>>> >>>> On Tue, Oct 23, 2012 at 6:20 AM, Abdul Azeez Shaik >>>> wrote: >>>> > Hi Peter, >>>> > >>>> > As part of our application, i have to implement messaging system(only >>>> 1:1) >>>> > similar to Facebook messages. Right now, only DM am using is Neo4j to >>>> store >>>> > all other data. Would Neo4j be right database for this use case >>>> especially >>>> > if archive grows long? Or Shall i use some other nosql for messaging >>>> system >>>> > in combination with Neo4j? >>>> > >>>> > Kindly let me know if you have any pointers or articles on the same. >>>> > >>>> > Thanks, >>>> > Abdul >>>> > >>>> > -- >>>> > >>>> > >>>> >>>> -- >>>> >>>> >>>> >>> -- >>> >>> >>> >> >> > -- > > > --bcaec54a37ba30cefd04ccbd2ae9 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Thanks for the response Wes. Yes, its similar to status updates one.
I = have few concerns in this implementation
  1. There is no trav= ersal involved in this design (except user1, user2 matches) to leverage gra= ph databases power.
  2. As I have to save whole mail as just a property of node. What would be = the efficiency of Lucene indexing? Also, when graph size grows big .i.e.whe= n we search has to be performed in old mails as well. (In case of status up= date, there was no searching involved based on text in update and there was= limit for update)
Would love to more ideas on this.

= Thanks,
Abdul

On Tue, Oct 23,= 2012 at 10:36 PM, Wes Freeman <freeman....@gmail.com> w= rote:
Oh, I see the difficulty there. You'd wa= nt to search for messages just between two users? Or within an inbox? I gue= ss you might have to keep track of the to/from as properties as part of the= index, and I'm not even sure you can mix a full-text with a properties= -level index--anyone have a better idea?


On Tue, Oct 23, 2012 at 12:53 PM, Wes Freema= n <freeman....@gmail.com> wrote:
Your design sounds good and easy to query, kind of like the status updates = but starting from two nodes.

You can set up a full-text = index for the message nodes themselves, so you could search them just via l= ucene, rather than having to scan through all of the nodes in the list.

Wes


On Tue, Oct 23, 2012 at 5:40 AM, Abdul Azeez Shaik= <azeeztechni...@gmail.com> wrote:
Hi Peter,

Its only messag= es or emails between two users(1:1) without any attachments. Email itself c= an be large, almost similar to this mail. (Have already implemented timelin= e and works pretty decent).

As of now, i can think of having Messages node between = two users. And then further replies for the same thread would be added on t= op of this Messages

User1--->Message<--User2=

Messages-->oldMessage1-->OldMessage2
However, this would work fine initially. But i am worried for = the support of inbox searching for individual message is large and if archi= ve grows big over the period of time.

Thanks,
Abdul


On Tue, Oct 23, 2012 at 1:49 PM, Peter Neubauer <peter.neuba...@neotechnology.com> wrote:
Mmh,
do you have any details on this - what are the messages, how many,
what would you imagine for the graph structure - is it pure messages
or even timelines like status updates?

Cheers,

/peter neubauer

G: =A0neubauer.peter
S: =A0peter.neubauer
P: =A0+46 704 106975
L: =A0 ht= tp://www.linkedin.com/in/neubauer
T: =A0 @peterneubauer

Neo4j 1.8 GA - http://www.dzone.com/links/neo4j_1= 8_release_fluent_graph_literacy.html


On Tue, Oct 23, 2012 at 6:20 AM, Abdul Azeez Shaik
<azeeztech= ni...@gmail.com> wrote:
> Hi Peter,
>
> As part of our application, i have to implement messaging system(only = 1:1)
> similar to Facebook messages. Right now, only DM am using is Neo4j to = store
> all other data. Would Neo4j be right database for this use case especi= ally
> if archive grows long? Or Shall i use some other nosql for messaging s= ystem
> in combination with Neo4j?
>
> Kindly let me know if you have any pointers or articles on the same. >
> Thanks,
> =A0Abdul
>
> --
>
>

--



--
=A0
=A0


--
=A0
=A0

--bcaec54a37ba30cefd04ccbd2ae9--