JOIN query
- What strategies are there for providing SSDS functionality similar to JOIN without that query being available?
Is this limitation likely to be permanent, assuming that it results from inherent architectural considerations?
DigitalDirect Development Corporation
Antworten
- Hi Nicholas,
The absense of JOIN functionality is not permanent. It is on our list as a high-priority item and we will be adding it in one of the next sprints.
As for workarounds, for now you can implement this functionality on the client side or denormalize the data. Sorry, it's so clumsy right now.
I would be interested to know your thoughts on cross-container joins vs. joins within a single container. Do you need both? Is one more important than another?
Stan
Program Manager, Cloud DB- Als Antwort vorgeschlagenStan Kitsis - MSFTMSFTFreitag, 6. Juni 2008 22:37
- Als Antwort markiertDave Robinson - SQL AzureMSFT, BesitzerMittwoch, 2. Juli 2008 18:44
Alle Antworten
- Hi Nicholas,
The absense of JOIN functionality is not permanent. It is on our list as a high-priority item and we will be adding it in one of the next sprints.
As for workarounds, for now you can implement this functionality on the client side or denormalize the data. Sorry, it's so clumsy right now.
I would be interested to know your thoughts on cross-container joins vs. joins within a single container. Do you need both? Is one more important than another?
Stan
Program Manager, Cloud DB- Als Antwort vorgeschlagenStan Kitsis - MSFTMSFTFreitag, 6. Juni 2008 22:37
- Als Antwort markiertDave Robinson - SQL AzureMSFT, BesitzerMittwoch, 2. Juli 2008 18:44
- Stan,
Good! We just wanted to make sure that SSDS was moving in that direction; life without JOIN would be a problem. We were not looking forward to emulating a JOIN, doing a denormalize, whatever, in our middleware.
Initially, intra-container JOIN is fine, but for sure, we'll need to be doing cross-container JOINs as well.
We have a rather interesting visual DiscoveryServices application that we want to move from its SQL Server/Topic Map Server implementation to Live Mesh and SSDS, and the first thing our dev team worried about was being able to JOIN.
We need to be scalable right from the start, and these two cloud services look like they'll be important parts of our infrastructure. See www.digitaldirect.com for an overview.
Nick
DigitalDirect Development Corporation
Can you elaborate on the intra-container JOIN? you can already run queries against a container with a where clause that has predicates on different entity kinds.
Thanks much!
Tony
Tonyp- Tony,
I'll check with the dev team and see what specifically they have in mind. I'm just the CTO :) We anticipate highly spiky demand, so we'll have to check out the performance of various methods.
Nick
DigitalDirect Development Corporation
