[orientdb] How connect OrientDB in distributed mode through the API

2014-09-23 Thread Vladimir Ziankevich
At first, possibly my question is very stupid, but Assume I have two OrientDB servers configured in distributed mode. For example there are corresponding URL's: orientdb.node1.com orientdb.node2.com Also there is TestDistributedDatabase on both nodes. And I have DNS configured properly (like de

[orientdb] Re: min() works surprisingly long

2014-08-05 Thread Vladimir Ziankevich
this > > select ID from CustomType order by ID limit 1 > > Cheers, > Fabrizio > > On Monday, August 4, 2014 5:59:07 PM UTC+1, Vladimir Ziankevich wrote: >> >> Hi all! >> >> There are about 600 000 vertices of specific type (let say CustomType) in >

[orientdb] min() works surprisingly long

2014-08-04 Thread Vladimir Ziankevich
Hi all! There are about 600 000 vertices of specific type (let say CustomType) in my graph database. Also CustomType have unique LONG field 'ID'. I've created index for this field (create index customtype_id on CustomType (ID) unique). So searching through the IDs ( select from CustomType where

[orientdb] How to use Fetching plans properly?

2014-07-16 Thread Vladimir Ziankevich
Hi guys! In my test graph database I'm trying to retrive list of vertices with enabled fetching. I do the next: public List getPeopleByName(OrientGraph graph, String name) { Iterable people = graph.command( new OCommandSQL( "select from People whe

Re: [orientdb] Re: How to retrieve subgraph

2014-07-16 Thread Vladimir Ziankevich
a = (TRAVERSE out('root for'), out('child > of') FROM [Linda_ID, Shaun_ID, Jeff_ID]), $b = (TRAVERSE in('child of') > FROM [Linda_ID, Shaun_ID, Jeff_ID]) > > > Best regards, > Artem Orobets > > *Orient Technologies the Company behind OrientDB* >

Re: [orientdb] Re: How to retrieve subgraph

2014-07-15 Thread Vladimir Ziankevich
x27;root for'), out('child > of') FROM [Linda_ID, Shaun_ID, Jeff_ID]), $b = (TRAVERSE in('child of') > FROM [Linda_ID, Shaun_ID, Jeff_ID]) > > > Best regards, > Artem Orobets > > *Orient Technologies the Company behind OrientDB* > > > 2014

Re: [orientdb] Re: How to retrieve subgraph

2014-07-15 Thread Vladimir Ziankevich
gt; Artem Orobets > > *Orient Technologies the Company behind OrientDB* > > > 2014-07-14 18:39 GMT+03:00 Vladimir Ziankevich >: > >> Of course my picture is just small part. Just demonstrative example. >> >> понедельник, 14 июля 2014 г., 17:43:53 UTC+3 пользова

[orientdb] Re: How to retrieve subgraph

2014-07-14 Thread Vladimir Ziankevich
your picture is only a part of a bigger graph then probably query is not > valid. > > On Monday, 14 July 2014 15:36:39 UTC+1, Vladimir Ziankevich wrote: >> >> But If I travers by V.in_root_for, V.out_root_for does not it mean that >> I get all the vertices of t

[orientdb] Re: How to retrieve subgraph

2014-07-14 Thread Vladimir Ziankevich
ist of some vertices then just put ids of those separated by > comma. > > I typed my query without having console handy but I assume the idea is > right. > > On Monday, 14 July 2014 15:10:38 UTC+1, Vladimir Ziankevich wrote: >> >> I included 'Linda', 'Ge

Re: [orientdb] Re: How to retrieve subgraph

2014-07-14 Thread Vladimir Ziankevich
But I do not get why do you include 'Linda', 'George' and 'child of' >> vertices? >> >> >> On Monday, 14 July 2014 14:37:53 UTC+1, Vladimir Ziankevich wrote: >>> >>> At first I am sorry for my question, but I really can'

Re: [orientdb] Re: How to retrieve subgraph

2014-07-14 Thread Vladimir Ziankevich
ries on some real >> graph models. >> The query would probably look like: >> traverse V.in_root_for, V.out_root_for, V.out_child_of from [ >> id_of_New_York_islanders] >> >> >> But I do not get why do you include 'Linda', 'George' and 'chi

[orientdb] Re: How to retrieve subgraph

2014-07-14 Thread Vladimir Ziankevich
he query would probably look like: > traverse V.in_root_for, V.out_root_for, V.out_child_of from [ > id_of_New_York_islanders] > > > But I do not get why do you include 'Linda', 'George' and 'child of' > vertices? > > On Monday, 14 July 2014 14:37:

[orientdb] How to retrieve subgraph

2014-07-14 Thread Vladimir Ziankevich
At first I am sorry for my question, but I really can't understand how to solve my problem. Imagine, I have a graph of relationships which consists of: 1) family tree: one child can heve only one parent 2) graph of interests (hockey teams root for...) Example of the graph:

[orientdb] Problem with CONTAINSTEXT

2014-06-18 Thread Vladimir Ziankevich
I've tried to use FULLTEXT index and CONTAINSTEXT feature. So at first I have created index: create index location_name on Location (name) FULLTEXT then I ve executed query: select name from Location where name CONTAINSTEXT 'Lon' Some results were retrieved: London East London Londerzeel But w

Re: [orientdb] Re: How to search by vertex and linked vertices

2014-06-18 Thread Vladimir Ziankevich
; *Orient Technologies the Company behind OrientDB* > > > 2014-06-18 9:29 GMT+03:00 Riccardo Tasso >: > >> Why are you using Lucene if you don't need full-text features? >> >> I would try with: >> >> SELECT FROM Location WHERE name LIKE 'Lon%&#x

Re: [orientdb] Re: How to search by vertex and linked vertices

2014-06-18 Thread Vladimir Ziankevich
Riccardo Tasso написал: > > Why are you using Lucene if you don't need full-text features? > > I would try with: > > SELECT FROM Location WHERE name LIKE 'Lon%' OR > out('language').name LIKE 'Lon%' LIMIT 20 > > > 2014-06-17 13:58 GMT+02

[orientdb] Re: How to search by vertex and linked vertices

2014-06-17 Thread Vladimir Ziankevich
ass='Location' order by name_en), $b = ( SELECT FROM Location where name_en LUCENE 'Minsk*' ), $c = UNIONALL( $a, $b ) But the main question is still not answered. Is there any way to make similar search without traversing? вторник, 17 июня 2014 г., 13:22:00 UTC+3 пользова

[orientdb] How to search by vertex and linked vertices

2014-06-17 Thread Vladimir Ziankevich
I have the next database schema: vertex type Location(properties: id, name) vertex type Alias(properties: name) edge type Language(properties: name) Each vertex of Location can have multiple edges with Aliases. For example: location(1,London) -> edge language(name='english') ->

[orientdb] OrientDB management of database changes

2014-05-27 Thread Vladimir Ziankevich
I'm wondering how to support work of multiple developers on OrientDB, how to organize tracking, managing and applying database changes. We have to imlement very sophisticated export of data from old relational DB (MS SQL) to OrientDB. Export affects db schema. Each developer has his local databas

[orientdb] Property of non-primitive type in the Graph DB

2014-05-27 Thread Vladimir Ziankevich
I am playing with OrientDB in graph mode. Is there any ability to create vertex(declare vertex type) with property of user non-primitive custom class? For example, There is type Car. Car has 'id', 'model' and 'engine' properties. id is Long, model is String. But can engine be of type Engine whi

Re: [orientdb] Vertices with multiple Clusters

2014-05-27 Thread Vladimir Ziankevich
Hi! Any ideas why records only from default default cluster retrieved? понедельник, 19 мая 2014 г., 15:16:41 UTC+3 пользователь Lvc@ написал: > > On 19 May 2014 14:02, Vladimir Ziankevich > > wrote: > >> Inheritance looks useful but not in this case: >> Germany needs

Re: [orientdb] Vertices with multiple Clusters

2014-05-20 Thread Vladimir Ziankevich
c@ написал: > > On 19 May 2014 14:02, Vladimir Ziankevich > > wrote: > >> Inheritance looks useful but not in this case: >> Germany needs to be in WestEurope and in CustomRegion, Netherlands is in >> Benelux and in WestEurope. >> >> I think additiona

Re: [orientdb] Vertices with multiple Clusters

2014-05-19 Thread Vladimir Ziankevich
stEurope extends V > create class CustomRegion extends V > > Then create the country that extends the right aggregate, example: > > create class Belgium extends Benelux > create class Netherlands extends Benelux > create class Luxemburg extends Benelux > create class Germany exte

[orientdb] Vertices with multiple Clusters

2014-05-19 Thread Vladimir Ziankevich
I have a question about clusters mechanism. Is it possible for the specific vertex to belong to multiple clusters F.e. There are class Country and concrete vertices USA, United Kingdom, France, Germany, Russia, Belgium, Netherlands, Luxemburg. I would like to create some clusters like 'Benelux',

Re: [orientdb] Re: Oriendb Lucene

2014-05-15 Thread Vladimir Ziankevich
est snapshot from here > > https://oss.sonatype.org/content/repositories/snapshots/com/orientechnologies/orientdb-community/1.7-SNAPSHOT/ > > > 2014-05-15 12:44 GMT+02:00 Vladimir Ziankevich > > >: > >> Hi all! >> I have some problems with setting up lucene

[orientdb] Re: Oriendb Lucene

2014-05-15 Thread Vladimir Ziankevich
> > Hi all! > I have problems with setting up lucene plugin. I have installed OrientDB 1.7-rc2. I followed steps described in https://github.com/orientechnologies/orientdb-lucene/wiki : downloaded the latest plugin jar (lucene-1.7-SNAPSHOT-plugin.jar) from https://github.com/orientechnologies/o

Re: [orientdb] Re: Oriendb Lucene

2014-05-15 Thread Vladimir Ziankevich
> it does't work with OrientDB 1.7-rc2 >>> you have to download the latest snapshot from here >>> https://oss.sonatype.org/content/repositories/snapshots/com/ >>> orientechnologies/orientdb-community/1.7-SNAPSHOT/ >>> >>> >>> 2014-05-15 12:44 G

[orientdb] Re: Oriendb Lucene

2014-05-15 Thread Vladimir Ziankevich
Hi all! I have some problems with setting up lucene plugin. I ve installed OrientDB 1.7-rc2. I followed steps described on this page https://github.com/orientechnologies/orientdb-lucene/wiki downloaded the latest plugin lucene-1.7-SNAPSHOT-plugin.jar, put it in the 'plugins' directory. But on th