Thanks for the answers. I'll take here point 5 and 6. >> 5) does neo4j have a replication tool? I.e. is it possible to sync a >> > remote and a embedded database instance? Hibernate used to help here. >> > Are there tools to help? >> > >> >> Yes. There are two. There is a hot backup option for making backups of live >> running databases. And there is the relatively new HA (high availability) >> infrastructure for keeping clusters of databases synchronized. The various >> databases can be running as embedded or as server, it does not matter, they >> can still be synchronized. There are rules, however as to which is master, >> and which is best to write to. See >> http://wiki.neo4j.org/content/High_Availability_Cluster
That sounds nice. My scenario is something like: I have a centralized database. On the Desktop side I have a workstation on which I do GIS analysis. People want to get a chunk of data of interest, so they can "pollute" them with their analyses until they are happy. So it is a bit the concept of a distributed versioning system. I have my local workspace, on which I play, then I could push back that result I liked. Anything like that around? :) > Another way is doing online backups, > http://docs.neo4j.org/chunked/milestone/operations-backup.html > >> >> 6) Timeseries. The only way to hande then seems to be the timeline, right? [...] > I have recently added a TimelineIndex (with a LuceneTimeline implementation > class) which uses an Index as backend instead of the graph and may be > faster. > > See > https://github.com/neo4j/graphdb/blob/master/lucene-index/src/test/java/org/neo4j/index/timeline/TestTimeline.javafor > an example of the source and > http://components.neo4j.org/neo4j/1.3.M05/apidocs/org/neo4j/index/lucene/TimelineIndex.htmlfor > javadoc of the interface. I am not sure if I do not see it or if it is not there. I see how a timeline index is build. But then, how do I get that timeline from a just opened database instance? It would be really great to have s simple example like the matrix ones on the wiki, in which a timeline is created, the database is closed, then reopened and the timeline is queried. If I am just blinded by too much info at one time, feel free to smash me with a link/hint. Thanks, Andrea > >> >> I have no experience with the timeline class. I have always rolled my own >> time index, and it was fast. >> >> However, the most likely issue you are facing is with too many >> transactions. >> Group your commits. The easiest way to do this is every 1000, or 10000 >> (pick >> a number between these two :-), just do >> tx.success();tx.finish();tx=db.beginTx(); >> >> The above number of 9000 could be added in one single commit. So move the >> try{]finally{} around the entire loop. Then add the intermediate commits as >> described above if you think you will get more data than that. I personally >> commit every 1000. I found going to a bigger number helped, but not that >> much. Most of the performance gains are achieved in the first 1000. >> >> And how do I run to query it? I couldn't find any docs and testcase to >> > get the timeline from a database instance and to query it. >> > >> >> I don't know that class well enough to answer, sorry. >> >> 7) Foreign keys. Do they always simply get Relationships? >> > >> >> A foreign key is an rdbms concept. You could do it the rdbms way by storing >> a property on one node that can be looked up in an index to get the other >> node, but that would be like deliberately not using the graph. So it is >> generally correct to model a 'foreign key' as a relationship. But perhaps >> I'm not understanding what you mean by 'do they get relationships'? >> (there is not, as far as I remember, any mention of the term 'foreign key' >> in the neo4j docs, so perhaps you should give an example of what you mean) >> >> Well, that is it for a first round. If you find the time to answer this, >> > thanks. >> > >> >> Hope the answers helped. >> >> Regards, Craig >> _______________________________________________ >> Neo4j mailing list >> User@lists.neo4j.org >> https://lists.neo4j.org/mailman/listinfo/user >> > > > > -- > Mattias Persson, [matt...@neotechnology.com] > Hacker, Neo Technology > www.neotechnology.com > _______________________________________________ > Neo4j mailing list > User@lists.neo4j.org > https://lists.neo4j.org/mailman/listinfo/user > _______________________________________________ Neo4j mailing list User@lists.neo4j.org https://lists.neo4j.org/mailman/listinfo/user