[SERVER-12100] What are the common document structures used by MongoDB for analytical models Created: 15/Dec/13 Updated: 09/Jan/14 Resolved: 09/Jan/14 |
|
| Status: | Closed |
| Project: | Core Server |
| Component/s: | Querying |
| Affects Version/s: | 2.5.4 |
| Fix Version/s: | None |
| Type: | Question | Priority: | Minor - P4 |
| Reporter: | Mark Kromer | Assignee: | Unassigned |
| Resolution: | Done | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Participants: |
| Description |
|
We are looking at 3 common possibilities for modeling star joins in a single collection to mimic OLAP / data mart models for analytics in MongoDB: 1. Fact grain embedded in the array , , , { "claim_id" : 4456, "claim_dt" : ISODate(“2010-01-06”), "Primary_Dx" : "323.9", "DRG" : 322, "net_pay_amt" : 552.75, "LOS" : 1 }] 2. Simple Array of Values (creates a M:M mapping OLAP problem) 3. Array contains a collection of references to other documents. How often do you feel that we’ll see references like this? { Are these the most common models that you see or is there a recommendation from Mongo in building analytic models in Mongo? |
| Comments |
| Comment by Scott Hernandez (Inactive) [ 09/Jan/14 ] |
|
Mark, these types of questions are best asked on the mongodb-user groups (https://groups.google.com/group/mongodb-user) where the community can be involved, and it is possible that it has already been discussed. Primary this SERVER jira project is meant for filing bugs, enhancement requests and deal with code contributions (pull requests). This sounds a bit like a guidance/consulting question and if you have a contact at mongodb, you might want to contact them directly to setup time/a-call to discuss these types of broad questions. |