Unique indexes on Graph vertex/edge properties
I need to ensure global uniqueness for things like username/email/mobile number/etc. Since we no longer have traditional SQL, this capability is lacking. Allow me to define unique indexes so the write region has only one occurrence of a distinct value.
Ideally, this should also make FILTERED unique indexes possible.
Work for this feature has been started. Will update here when this feature becomes generally available.
We're hosting some data in SQL Server since it needs to have the global uniqueness rule. If Cosmos DB can offer the same feature, we can migrate away from SQL Server completely.
Any progress on this?
Both Mongo API, SQL API allow user to set "unique keys" to ensure data integrity, it would be great if Gremlin API can also support this, otherwise it's hard to support concurrency.
MongoDB API supports unique keys, but we need this functionality for Graph as well.
Graph model can be the same as your relational one. I think you need to store unique values into corresponding unique graph nodes. I.e. you need node for each phone number.