Question about Cypher

[Chris]

Hey guys,

I'll start off and give some information about what I'm trying to
accomplish: I'm writing my master thesis about citation analysis. Some
time ago I wrote a Ruby on Rails app (with MySQL) that aided me in
gathering the data I needed. MySQL is dreadful for graph things, so I
had my eyes on Neo4j. With the help of neoid (https://github.com/elado/
neoid) I was able to get my data into Neo4j 1.7. My nodes are authors
and documents and my relationships are "wrote" (author wrote document)
and cited (document cited document). All in all I now have 11926 nodes
and 29443 relationships.

Now I want to tinker with my data using Cypher. I've reading and
watching tutorials screencasts for 1.5 days now, but all my efforts to
reproduce what I saw seem to fail. This works:

start p=node(6609) match (p) -[:authorships]-> (document) <-
[:authorships]- (person) return person.ar_id, person.name,
count(document) order by count(document) DESC

ar_id is neoid's way to know which neo4j node corresponds with which
row in MySQL.

This doesn't work:

start p=node:person(ar_id="1") match (p) -[:authorships]-> (document)
<-[:authorships]- (person) return person.ar_id, person.name,
count(document) order by count(document) DESC

I get this error: "MissingIndexException: Index `person` does not
exist"
I've tried several other Indices (Person, people, People, etc.), but
no luck.

How can I define an index that lets me do queries like the one above?

Thanks for reading this,
Chris

[Chris]

So...

I'm gonna answer my own question here: As it turns out neoid creates
indices (it names them people_index, documents_index, etc.).

So using start p=node:people_index(ar_id="1")... worked as expected.

Sorry for the noise and have a nice weekend!

[Andres Taylor]

On Fri, Apr 27, 2012 at 5:25 PM, Chris <christoph...@gmail.com> wrote:

So...

I'm gonna answer my own question here: As it turns out neoid creates
indices (it names them people_index, documents_index, etc.).

So using start p=node:people_index(ar_id="1")... worked as expected.

Cool. Didn't know that. Thanks for sharing!

Andrés