Re: [orientdb] Uniqe Index in SubClasses

2016-07-27 Thread Luigi Dell'Aquila
Of course this is true only if the parent class is empty, otherwise you have to define a non-unique index on the parent class as well Thanks Luigi 2016-07-28 8:58 GMT+02:00 Luigi Dell'Aquila : > There is just no need to define indexes on the parent class, as long as > you have indexes on the s

Re: [orientdb] Uniqe Index in SubClasses

2016-07-27 Thread Luigi Dell'Aquila
There is just no need to define indexes on the parent class, as long as you have indexes on the same properties on the subclass. Eg. if you have a class A with two subclasses A1 and A2 and both subclasses have an index on "name", if you do a SELECT FROM A WHERE name = 'foo' it will use the indexe

Re: [orientdb] Uniqe Index in SubClasses

2016-07-27 Thread hartmut bischoff
Thanks for the quick response. Unfortunately, this leads to other Questions, probably due to a lac of skills on my side 1. How does this affect queries based on the superclass? The Match-Query presented in another topic is already slow. 2. Do I have to define two indexes, one on the supercla

Re: [orientdb] What is the stable version for production?

2016-07-27 Thread Luigi Dell'Aquila
Hi Eswar, You can always find latest stable version here http://orientdb.com/download/ This version is preferred for production purposes. Note: if you hold for a few hours you'll find 2.2.6, we are releasing it now ;-) Thanks Luigi 2016-07-28 8:35 GMT+02:00 eswar reddy : > may I know which

[orientdb] What is the stable version for production?

2016-07-27 Thread eswar reddy
may I know which version is stable version for Production environment -- --- 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...@googlegroup

Re: [orientdb] Uniqe Index in SubClasses

2016-07-27 Thread Luigi Dell'Aquila
Hi Hartmut, There is no specific configuration to specify that an index is unique at class level, but you can just avoid to define the index on the superclass, as the query engine will use the subclasses index if needed (first level inheritance only) Thanks Luigi 2016-07-28 7:07 GMT+02:00 har

[orientdb] Uniqe Index in SubClasses

2016-07-27 Thread hartmut bischoff
As mentioned before, my test-suite-Vertices have the following structure: - V - - - Contract - - ContractDetail - - Sector - - Category - Industry - Subcategory Contracts got an unique Index "Con_id" and Sector "name". names are unique on class-level only. My "qui

[orientdb] Re: Elastic Data Model

2016-07-27 Thread 'scott molinari' via OrientDB
Hi, For 1. Have a look at the new Teleporter system. http://orientdb.com/orientdb-labs/teleporter/ http://orientdb.com/orientdb-teleporter-making-migrations-easier/ http://orientdb.com/docs/last/Teleporter-Home.html For 2. First thing, although ODB is a No-SQL database, there are always gotcha

[orientdb] Elastic Data Model

2016-07-27 Thread SN
I am working in banking industry. Banks have a well defined relational data model to support core banking functionality. What I want to do is to represent that the bank data model in OrientDB to accomplish two things: 1. I want to retail all the relationships defined by baking data model 2. I

Re: [orientdb] Spatial Module Doc available in 2.2.x examples mixes lat/long

2016-07-27 Thread Tore Austrått
Thanks Enrico I used google coord and that worked. I wrongly assumed that was the system in question. I will review the docs you provided. Tore 27. jul. 2016 21.01 skrev "Enrico Risa" : > Hi Tore > > the docs is not incorrect. > The Spatial Module uses the spatial reference system EPSG 4326 > >

Re: [orientdb] Spatial Module Doc available in 2.2.x examples mixes lat/long

2016-07-27 Thread Enrico Risa
Hi Tore the docs is not incorrect. The Spatial Module uses the spatial reference system EPSG 4326 http://spatialreference.org/ref/epsg/wgs-84/ and the x & y are projected in longitude (-180 +180) and latitude( -90 +90). See here http://geojson.org/geojson-spec.html#positions and here http://

[orientdb] Spatial Module Doc available in 2.2.x examples mixes lat/long

2016-07-27 Thread Tore
http://orientdb.com/docs/2.1/Spatial-Module.html The examples are mixing latitude and longitude. Please check this: (it appears the restaurant is located in Ethiopia) This goes for all the examples. Please correct. Thanks. INSERT INTO Restaurant SET name = 'Dar Poeta', location = {"@class":

Re: [orientdb] OrientDB2.2 Match Statement, API

2016-07-27 Thread hartmut bischoff
Short Addition: Performed the query in Studio: MATCH {class: Industry, as: Industries} <-- {} <-- {} <-- { as: asset } > RETURN Industries, asset >  > 1 > { > 2 > "result": [ > 3 > { > 4 > "@type": "d", > 5 > "@version": 0, > 6 > "Industries": "#

Re: [orientdb] OrientDB2.2 Match Statement, API

2016-07-27 Thread hartmut bischoff

[orientdb] Re: Estimated release date of v3.0?

2016-07-27 Thread alessandrorota04
Hi, you could see http://orientdb.com/docs/2.2/Roadmap.html Hope it helps. -- --- 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...@googleg

[orientdb] Estimated release date of v3.0?

2016-07-27 Thread Auke te Winkel
Hi guys! There are some nice features proposed for OrientDB v3.0 ( http://orientdb.com/docs/2.1/Roadmap.html#release-30). However, it seems that the planned release dates of a RC and final version haven't been updated lately. Is there anyone from the team able to give an estimate when a final v