How can we improve Azure Cosmos DB?

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.

61 votes
Vote
Sign in
(thinking…)
Sign in with: oidc
Signed in as (Sign out)
You have left! (?) (thinking…)
Mary shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

5 comments

Sign in
(thinking…)
Sign in with: oidc
Signed in as (Sign out)
Submitting...
  • John commented  ·   ·  Flag as inappropriate

    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.

  • Eva commented  ·   ·  Flag as inappropriate

    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.

  • Jason commented  ·   ·  Flag as inappropriate

    MongoDB API supports unique keys, but we need this functionality for Graph as well.

  • Anonymous commented  ·   ·  Flag as inappropriate

    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.

Feedback and Knowledge Base