Re: [orientdb] Re: New benchmarks from Arango

Unfortunately performarces are very difficult to test, and benchmarks are very difficult to trust, especially if implemented by vendors. Riccardo 2015-06-12 8:33 GMT+02:00 scott molinari : > For me personally, I can't believe the results. However, I'd like to see > some proper results for Orient

[orientdb] Re: Mulitple Inheritance and duplicate properties

Sure and thanks for your time, What I want is to have three properties on all of my vertices: id, createAt and updateAt. My approach was to add these properties to directly to V. This way all classes that inherit V will automatically obtain these properties. However there are scenarios whe

Re: [orientdb] Re: New benchmarks from Arango

For me personally, I can't believe the results. However, I'd like to see some proper results for OrientDB too. I am sold on Orient over Arango currently, mainly due to the binary interface and because it has multi-master replication and easy sharding capabilities, which Arango still doesn't hav

Re: [orientdb] Re: Index on RIDs

Thanks for that Luigi. It makes the usage of the RID very clear, but I am personally still missing the magic part. How does it make OrientDB faster than an RDBMS, without the RID indexed in memory? Or are the values in the files cached in memory too as "hot data"? Scott -- --- You receiv

Re: [orientdb] Re: Index on RIDs

Thank you Luigi, this is more or less what I expected. Cheers, Riccardo 2015-06-12 7:57 GMT+02:00 Luigi Dell'Aquila : > Hi guys, > > I'd like to shed some light on this "magic" :-) > > a RID is made of two numbers (a short and a long, at this stage, but the > first one will become a long too

[orientdb] Re: Mulitple Inheritance and duplicate properties

I think what is needed is a new subclass C with your new additional fields, which would be a sibling of A and B and child of V. What you are currently building is what is called the diamond problem in class inheritance and it is obvious OrientDB (from what I know, which isn't much) doesn't accou

Re: [orientdb] Re: Index on RIDs

Hi guys, I'd like to shed some light on this "magic" :-) a RID is made of two numbers (a short and a long, at this stage, but the first one will become a long too in next releases, it's in the radmap). Say the RID is #xxx:yyy xxx is the cluster ID, it identifies the cluster where the record is s

Re: [orientdb] Help about ressources managment

Hi Antoine, I suggest you to use the factory, it is much faster than manually acquiring connections. If you are doing only read operations OrientGraphNoTx is ok, just make sure that every actor has its own connection, the main constraint you have here is that OrientDB connections are not thread sa

Re: [orientdb] Embed the Server

Hi James, all you find in the community edition is released under Apache 2.0 license, so no worries, you can use it in your project ;-) Luigi 2015-06-10 13:28 GMT+02:00 James Wang : > Hi All, > > We need > >- orientdb-enterprise-**.jar > > Does it mean that this feature is not available fo

[orientdb] Re: Can't connect to the database. Command Executor not foundcom

I've done that multiple times. It's a problem with some setting on my mac, i guess! On Thursday, June 11, 2015 at 8:42:39 PM UTC+5:30, James Wang wrote: > > download it again and try > > i don't use Mac > > On Thursday, 11 June 2015 16:00:00 UTC+1, Abhilash Panigrahi wrote: >> >> No. I can't cre

Re: [orientdb] Re: New benchmarks from Arango

Thank you, very interesting. Riccardo Il 12/giu/2015 07:11, "Ziink A" ha scritto: > I tried running the benchmarks on OrientDB. It causes a memory dump. > > > > On Thursday, June 11, 2015 at 8:36:55 AM UTC-7, scott molinari wrote: >> >> Hi, >> >> I just ran into this and I would imagine, you gen

Re: [orientdb] Re: new document inside a transaction

Hi Cristian, yes, thank you. I'd expect an error on the SQL statement at most, but not on the commit. Please post here a link to the issue and I'll take care of this Thanks Luigi 2015-06-09 18:31 GMT+02:00 Cristian Lorenzetto < cristian.lorenze...@gmail.com>: > if you want i ll post a bug in g

[orientdb] Re: Mulitple Inheritance and duplicate properties

Here's what I want C to look like using your example: create property V.id binary create property V.createAt datetime create property V.updatedAt datetime create class A extends V create class B extends V create property A.someOtherField string create property B.andYetAnother integer create cl

[orientdb] Re: New benchmarks from Arango

I tried running the benchmarks on OrientDB. It causes a memory dump. On Thursday, June 11, 2015 at 8:36:55 AM UTC-7, scott molinari wrote: > > Hi, > > I just ran into this and I would imagine, you gents would want to know > about it and also, more than likely, do something about it. > > > http

[orientdb] Re: Mulitple Inheritance and duplicate properties

So you are actually wanting something like this? create class A extends V create class B extends V create property V.id binary create property V.createAt datetime create property V.updatedAt datetime create property A.someOtherField string create property B.andYetAnother integer create class C

[orientdb] Re: Mulitple Inheritance and duplicate properties

Hi Scott, Thanks for your response. I have properties and A and properties on B therefore C has to extend both A & B. This is the same kind of problems encountered with multiple inheritance when you program in C++. The problem is how OrientDB resolves ambiguities. What I want is to ha

[orientdb] Re: Mulitple Inheritance and duplicate properties

I would have thought it would need to go this way. create class A extends V create class B extends V create property A.id binary create property B.createAt datetime create property B.updatedAt datetime create class C extends A, B Class C should only have the 3 fields now, which I am sure wasn't

[orientdb] Issue with Adding Edge. OSerializationException

Hello All, Orient DB Version - 2.0 and 2.0.10 I have the following snippet of Code Object objectB = ..; //comes in as a request OrientVertex bVertex = graph.addVertex("class:BVertex"); List tags = objectB.getTags(); for(String tag : tags){ //A private method which retrieves the

[orientdb] Re: Mulitple Inheritance and duplicate properties

Anybody out there? I just need to know if this is the normal behavior. If so then I presume the work around is not to avoid multiple inheritance? Is my presumption correct? Cheers. On Thursday, June 11, 2015 at 5:16:27 AM UTC+12, Chris Waldron wrote: > > I wanted to add a UUID property cal

[orientdb] Re: Update en embedded list of string field by adding another string value

Try update PERSON *ADD* favColours=['red'] where perName='Luca' or update PERSON *ADD* favColours='red' where perName='Luca' On Thursday, June 11, 2015 at 7:53:50 AM UTC-7, Athanassios Hatzis wrote: > > Hi, I am a newcomer please help with the following > > I have created a class PERSON and a

[orientdb] How should time and spatial data be managed in OrientDB 2.0.10 ?

Hello OrientDB team and users ! This is my first question here and I'm french so excuse me for my poor english... I need to query historical data and location at the same time. For exemple, select all events close to a radius x where the time is greater then now. What is the best way to do thi

[orientdb] Re: distributed chat for orientdb

That's how OrientDB handles all that in v2.0+ - it automatically creates a new cluster for EACH distributed node/instance. Need a million devices, then scale up more OrientDB instances where node in the group has its own cluster as part of a base class (ie. Class Devices is contained in Devic

Re: [orientdb] New benchmarks from Arango

I think these benchmarks are from nodejs app. But OrientDb is a jvm based database. Why can't we make a benchmark with ArangoDb? On Fri, Jun 12, 2015 at 12:07 AM Chaitanya wrote: > +1 > > On Thu, Jun 11, 2015 at 9:06 PM scott molinari < > scottamolin...@googlemail.com> wrote: > >> Hi, >> >> I ju

Re: [orientdb] New benchmarks from Arango

+1 On Thu, Jun 11, 2015 at 9:06 PM scott molinari < scottamolin...@googlemail.com> wrote: > Hi, > > I just ran into this and I would imagine, you gents would want to know > about it and also, more than likely, do something about it. > > > https://www.arangodb.com/2015/06/performance-comparison-be

Re: [orientdb] Re: select all vertices with no incoming edges

Thanks! quinta-feira, 4 de Junho de 2015 às 11:20:13 UTC+1, Luigi Dell'Aquila escreveu: > > sorry, typo there ;-) > > select from V WHERE in().size() = 0 > > 2015-06-04 12:19 GMT+02:00 Luigi Dell'Aquila >: > >> Hi David, >> >> you can also do this: >> >> select from V were in().size() = 0 >> >>

Re: [orientdb] Is there an alternative to ODatabaseDocumentPool?

Hi, There is documentation which you asked http://orientdb.com/docs/last/Document-Database.html . On Tue, Jun 9, 2015 at 12:00 PM Chaitanya wrote: > Hi Andrey, Could you point me to the sample or documentation. I am little > confused here. Thank you in advance. > > On Tue, Jun 9, 2015 at 2:29 PM

[orientdb] New benchmarks from Arango

Hi, I just ran into this and I would imagine, you gents would want to know about it and also, more than likely, do something about it. https://www.arangodb.com/2015/06/performance-comparison-between-arangodb-mongodb-neo4j-and-orientdb/ Scott -- --- You received this message because you are

[orientdb] Re: Update en embedded list of string field by adding another string value

Hi, I failed with sql and then i have tried with java api OrientGraph g=new OrientGraph(currentPath); String colorToAdd="blue"; Iterable result=g.command(new OSQLSynchQuery("select from Person where perName='Luca'")).execute(); for(Vertex v:result){ OTrackedList track=v.getProperty("favColours")

[orientdb] Re: Can't connect to the database. Command Executor not foundcom

download it again and try i don't use Mac On Thursday, 11 June 2015 16:00:00 UTC+1, Abhilash Panigrahi wrote: > > No. I can't create a database either! > > On Thursday, June 11, 2015 at 8:09:21 PM UTC+5:30, James Wang wrote: >> >> Thought you had problem using the Java API. >> >> Can you create

[orientdb] Re: Can't connect to the database. Command Executor not foundcom

No. I can't create a database either! On Thursday, June 11, 2015 at 8:09:21 PM UTC+5:30, James Wang wrote: > > Thought you had problem using the Java API. > > Can you create a database from console.sh please? > > On Thursday, 11 June 2015 12:00:01 UTC+1, Abhilash Panigrahi wrote: >> >> No problem

[orientdb] Re: Can't connect to the database. Command Executor not foundcom

It was working just fine a few days ago. And it is still working on my colleagues' macs as well! On Thursday, June 11, 2015 at 8:01:01 PM UTC+5:30, SavioL wrote: > > i believe is a problem that occurs only on mac, because on linux and > windows it is ok (i did test it now with this version of

[orientdb] Update en embedded list of string field by adding another string value

Hi, I am a newcomer please help with the following I have created a class PERSON and a collection property favColours CREATE PROPERTY PERSON.favColours EMBEDDEDLIST STRING Then I created a record INSERT INTO PERSON content {perName:'Luca',perAge:34} Then I have updated successfully that record

[orientdb] Re: Can't connect to the database. Command Executor not foundcom

Thought you had problem using the Java API. Can you create a database from console.sh please? On Thursday, 11 June 2015 12:00:01 UTC+1, Abhilash Panigrahi wrote: > > No problem. I'm able to connect to the remote server. I get the problem > only when i try to interact with the database! > > On T

[orientdb] Re: Can't connect to the database. Command Executor not foundcom

i believe is a problem that occurs only on mac, because on linux and windows it is ok (i did test it now with this version of orientdb), but another my colleague he has a mac with the connect by console on his remote db has the same problem as you... -- --- You received this message because

[orientdb] Re: Linking Records in a Transaction Does not Work

Hi Giulia, Thanks for the response. This works. However, by the frequent db.commit() s I lose the atomicity of the transaction, hence the ability to rollback. That's the only worry. On Thursday, June 11, 2015 at 2:52:30 PM UTC+5:30, Giulia Brignoli wrote: > > Hi Omega, > > Try this function:

Re: [orientdb] Re: Help on query syntax

May be some one from OrientDB can help on this. Bye > Il giorno 11/giu/2015, alle ore 15:54, scott molinari > ha scritto: > > Like I said, I am not sure how this would best fit with OrientDB as the > database. What language are you using? Your idea sounds like the vertex/ > record level ten

Re: [orientdb] Re: Help on query syntax

Like I said, I am not sure how this would best fit with OrientDB as the database. What language are you using? Your idea sounds like the vertex/ record level tenancy control and yes, I think that could work as you suggest.I am just not sure if it should be called the "tenant" base class or just

Re: [orientdb] Data loss: WARN Page in file post.pcl with index 2185 was placed in wrong free list, this error will be fixed automatically.

Hi, Sorry for delay I am on it now. On Wed, Jun 10, 2015 at 5:36 PM Ricardo M. Vilchis wrote: > Hi, Andrey > > Did you get the file? > > Is there anything I can check?, > I'm not an expert on java but I managed to compile the project. > > -- > Best regards > Ricardo M. Vilchis > > El lunes, 8 de

[orientdb] Re: Can't connect to the database. Command Executor not foundcom

I get the error when I try to connect to the database. i.e when i type in connect remote:localhost:2424/GratefulDeadConcerts root I get the following error after that: Error: com.orientechnologies.common.exception.OException: Error on creation of shared resource Error: com.orientechnologies

[orientdb] Re: Query with Join and Group by

Hi Lucas. Unfortunately, I don't know the fields that you have in the classes and I can't help concretely, but I try to help by creating a random properties for two classes.In OrientDB don't use the JOIN, then there aren't relational tables and consequently the fields ID you used to link th

[orientdb] Re: A Hint for the IN-Operator needed

Hi, I have created this graph and when i run the query i get the following result In the f

Re: [orientdb] Re: Help on query syntax

Hi Scott, Yes, extra fields only on contacts is not enough for my customer needs. For multitenancy i prefer to have some centralized, Centrico has also a “server” application that schedule some operation on db that are cross tenant. What do you think on have an object Tenant that can have some f

[orientdb] Re: Can't connect to the database. Command Executor not foundcom

ok perfect, to interact with the db Testing for example, there are these command: connect remote:localhost:2424/Testing root root CREATE CLASS V1 EXTENDS V CREATE VERTEX V1 SET name = 'name1' select from V1 +-+--+- # |@RID |@CLASS|name +-+--+- 0 |#13:0|V1|

[orientdb] Re: Help on query syntax

Ok, now we are getting closer. So only the contact object will allow custom fields? What about custom objects relating to the standard contact object? Funny, I am working on a similar idea. I'll go with what you've said for now. >From a database architectural standpoint, you will need some f

[orientdb] Re: Can't connect to the database. Command Executor not foundcom

No problem. I'm able to connect to the remote server. I get the problem only when i try to interact with the database! On Thursday, June 11, 2015 at 4:26:46 PM UTC+5:30, SavioL wrote: > > with this command (written in the console): > > connect remote:localhost:2424 root root > > have you got im

[orientdb] Re: Can't connect to the database. Command Executor not foundcom

with this command (written in the console): connect remote:localhost:2424 root root have you got immediately problem? Il giorno martedì 9 giugno 2015 09:24:03 UTC+2, Abhilash Panigrahi ha scritto: > > Every time I try to connect to a database, or create a database, i > encounter the follo

[orientdb] Re: Can't connect to the database. Command Executor not foundcom

I use the orientdb console. Like I mentioned, I am a Java noob. On Thursday, June 11, 2015 at 3:53:50 PM UTC+5:30, SavioL wrote: > > do you use the orientdb console or use the Java ide (for example eclipse > to run your code)? > > Also I get a blank line if I write echo $CLASSPATH on my linux te

[orientdb] Re: Can't connect to the database. Command Executor not foundcom

do you use the orientdb console or use the Java ide (for example eclipse to run your code)? Also I get a blank line if I write echo $CLASSPATH on my linux terminal... Il giorno martedì 9 giugno 2015 09:24:03 UTC+2, Abhilash Panigrahi ha scritto: > > Every time I try to connect to a database,

[orientdb] Re: Can't connect to the database. Command Executor not foundcom

When I type in echo $CLASSPATH on terminal it shows an empty line. On typing in java-cp, i get the error "Error: -cp requires class path specification". I am a Java noob here. I had tried to tamper with this a few days ago. On Thursday, June 11, 2015 at 3:32:48 PM UTC+5:30, James Wang wrote: >

[orientdb] Re: Can't connect to the database. Command Executor not foundcom

hi, that's what you need? -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this g

[orientdb] Re: A Hint for the IN-Operator needed

Hi, which version of OrientDB are you using? Alessandro -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to orient-database+unsubscr...@googlegroups.com. For mo

[orientdb] Re: Can't connect to the database. Command Executor not foundcom

Please post your CLASSPATH, or what after the java -cp On Thursday, 11 June 2015 10:46:40 UTC+1, SavioL wrote: > > > Hi, > > try this code, have you got the same error? > > import java.io.IOException; > import com.orientechnologies.orient.client.remote.OServerAdmin; > import com.tinkerpop.bluepri

[orientdb] Re: Index on RIDs

agreed On Thursday, 11 June 2015 06:38:06 UTC+1, scott molinari wrote: > > I was wondering, is an index automatically created on the RID? I would > imagine it is, just wanted to be sure. > > Also, are there any plans to create something like a sparse index in > MongoDB? Or does Orient already h

[orientdb] Re: Can't connect to the database. Command Executor not foundcom

Hi, try this code, have you got the same error? import java.io.IOException; import com.orientechnologies.orient.client.remote.OServerAdmin; import com.tinkerpop.blueprints.Vertex; import com.tinkerpop.blueprints.impls.orient.OrientGraph; public class Test { private static String remote =

[orientdb] Re: Linking Records in a Transaction Does not Work

Hi Omega, Try this function: db.begin(); var bRid = db.command("INSERT INTO B(name) VALUES(\"Jack\") RETURN @rid"); *db.commit();* db.command("INSERT INTO A(name) VALUES(\"Jack\")"); *db.commit();* db.command("UPDATE A SET bLinkList =* [*"+ bRid+"*]*"); *db.commit();* You need to add "[]" in

[orientdb] Re: Help on query syntax

Hi Alessandro, Scott Yes, i did a double check and found an error in my sql, there was not the closure apex on hasDetail, so the query now is ok, thank you a lot. Thanks also to Scott, i really appreciate your thoughts regarding the model i'm using. I'm new to orientDb, i'm doing a little bit o

[orientdb] Re: select custom function in graph.command

Hi Bryan, I had received your file and I'm working on , when I'm done I'll let you know Alessandro > -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to orient

[orientdb] Re: Help optimize a query and/or graph design

Hi SavioL, Thank you for your answer. I have a concern, would the response time increase as number of Likes increase? On Thursday, June 11, 2015 at 11:14:05 AM UTC+3, SavioL wrote: > > Hi, > > you should take before all users Americans who likes as the id of the movie > you want, and then fil

[orientdb] Re: Distributed DB Issue - Lucene Index write.lock file does not let replication to work

Observed that write.lock file is only getting created when "dserver" is started. Guys any help? On Thursday, 11 June 2015 11:12:56 UTC+5:30, Kapil Ranade wrote: > > Version: orientdb-community-2.1-rc3 > > I get following exception when I start dserver on two machines. As you can > see one of t

[orientdb] Re: Help on query syntax

Hi Giovanni, I have tried the query SELECT EXPAND( out('hasDetail') ) FROM Module WHERE code = 'Module' and I have got only the vertex Module with the code Module Regards, Alessandro -- ---

[orientdb] Re: Can't connect to the database. Command Executor not foundcom

OrientDB 2.0.10 [community and enterprise. Tried both. Same error :( ] I am using Mac OS X. On Tuesday, June 9, 2015 at 3:10:01 PM UTC+5:30, SavioL wrote: > > Hi, > > which version are you using?? > -- --- You received this message because you are subscribed to the Google Groups "OrientDB"

[orientdb] Re: Query with Join and Group by

Ho Lucas, which version are you using? and can you post your schema? Bye, Giulia -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to orient-database+unsubscr...

Re: [orientdb] Re: OrientDB v2.1 and changes in Multi-Threading

Hi guys, If you used OrientDB correctly, you will have no problem. If an *IllegalStateException* starts to be raised that's good news: your code used the same DB instance across threads with weird and unpredictable results. Instead in case you manage multiple database from the same thread, you sho

[orientdb] Re: To find all the posible paths between two nodes

However you can try to use the dijkstra function. For example, if you have this schema: and uses this query: select dijkstra(#12:0, #12:3, 'weight') you'll get:

[orientdb] Re: Help optimize a query and/or graph design

Hi, you should take before all users Americans who likes as the id of the movie you want, and then filter by number. SELECT userid FROM ( select from (SELECT expand(in("Likes")) FROM Movie where movieid = 112) WHERE country="us" ) limit 500 regards Savio L. Il giorno mercoledì 10 giugno 201

[orientdb] Query with Join and Group by

How to write query with joins as oracle example below: select c.ORG_ID, count(u.chave) from compromisso c join USUARIO u on c.RESPONSAVEL_ID = u.id join ESTABELECIMENTO est on est.id = c.ESTABELECIMENTO_ID join EMPRESA em on est.EMPRESA_ID = em.id group by c.ORG_ID -- --- You received t

[orientdb] Working example of POJO serialization with embedded List<>?

Sorry if this has been covered elsewhere. I've been trying to use http://orientdb.com/docs/2.0/orientdb.wiki/Object-2-Record-Java-Binding.html and StackOverflow to help me understand how to construct a POC for storing domain objects in document or graph form. (I recognize that there is Frames

Re: [orientdb] Help optimize a query and/or graph design

Hi Enrico, I'm using Orientdb 2.0.5. On Wednesday, June 10, 2015 at 6:53:17 PM UTC+3, Enrico Risa wrote: > > Hi Khaled > > which version of OrientDB are you using? > > > > 2015-06-10 14:29 GMT+02:00 Khaled Bakhit >: > >> Hello, >> >> I need help optimizing a query or maybe even update the g

Re: [orientdb] Re: select custom function in graph.command

Hi alessandro. Did you get my attached file? if you did not get my db file, here it is. thank you. regards, bryan. 2015-06-10 18:01 GMT+09:00 : > Hi Bryan, > can you post your schema ? > > Regards, > Alessandro > > -- > > --- > You received this message because you are subscribed to a topic i

[orientdb] Re: To find all the posible paths between two nodes

Hi Sagir, which version are you using? Bye, Giulia -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to orient-database+unsubscr...@googlegroups.com. For more opt

[orientdb] Re: Index on RIDs

Thanks Ziink. I should have realized the sparse bit reading the index docs. That is a big "duh!" on my part. It will be interesting to hear what the OrientDB team have to say about how the RID magic happens. :-) Scott -- --- You received this message because you are subscribed to the Googl

[orientdb] Re: Index on RIDs

>From what I understand, RIDs are not indexed per se. They are actual addresses so there are one better than an index. Indexes in OrientDB are sparse by default. You'd have to use something like following to include null values CREATE INDEX addresses ON Employee (address) notunique *METADATA