Joining within a collection/Selecting a large set of values


hello everyone,

i'm testing documentdb new project, , @ moment i'm not sure if , how can realize use case. lets have following in collection:

about 500000 employee records:

{  "id": "1", "type": "employee", "name": "testname", "lastname": "testlastname" } // , more

and have team records

{  "id": "45612354", "type": "team", "teamname": "greatteam", "members": [ 1, 55049, 29969, 23492 ] }

there can 50000 teams 10000 members each.

as input, i've specific team id , want return employee records of team. in rdbms create 2 tables, query team id , member ids in employee table. how here?
let each member have personal team list , id, every query need in list of every employee -> potentially check millions of ids.

is join operator applicable in case? can efficiently udf one: http://stackoverflow.com/questions/25637142/select-with-multiple-values-in-documentdb ? case should not use documentdb?

thanks help.

sebastian


ok, let's pretend teams & employees :)

don't embed entire employee record on team, no.

what meant on team, embed an array of employees
, on employee, embed an array of teams
example above has.

then employee records doing join single query

select e employee e join t in e.teams t.team = "a"

how employees change teams?
b/c model, have read entire employee document, make change team array , replace entire employee document again documentdb doesn't support patch/update, yet.

the part unclear on how perform arrays of 10,000 elements.



Microsoft Azure  >  Azure Cosmos DB



Comments

Popular posts from this blog

Azure DocumentDB Owner resource does not exist

BizTalk Server 2013 Azure VM Log Shipping and HA for hosts

How to send non-standard Content-Type header ?