Click here to Skip to main content
14,266,139 members
   

Database

 
QuestionUnable to Get the Proper Result : SQL Query Help Needed Pin
arulsuju29-Aug-18 12:14
memberarulsuju29-Aug-18 12:14 
SuggestionRe: Unable to Get the Proper Result : SQL Query Help Needed Pin
Richard Deeming30-Aug-18 1:37
mveRichard Deeming30-Aug-18 1:37 
AnswerRe: Unable to Get the Proper Result : SQL Query Help Needed Pin
Jochen Arndt30-Aug-18 2:04
mveJochen Arndt30-Aug-18 2:04 
QuestionMongoDB document or model planning, best Pin
jkirkerx23-Aug-18 13:38
professionaljkirkerx23-Aug-18 13:38 
AnswerRe: MongoDB document or model planning, best Pin
jschell23-Aug-18 14:35
memberjschell23-Aug-18 14:35 
GeneralRe: MongoDB document or model planning, best Pin
jkirkerx24-Aug-18 6:49
professionaljkirkerx24-Aug-18 6:49 
GeneralRe: MongoDB document or model planning, best Pin
jschell25-Aug-18 3:57
memberjschell25-Aug-18 3:57 
AnswerRe: MongoDB document or model planning, best Pin
lw@zi 23-Aug-18 20:45
professional lw@zi 23-Aug-18 20:45 
Disclaimer: I have only played around with MongoDB for fun. No real application experience yet.

One of the things I had read about a document based DB is to identify the aggregate. An aggregate will be a complete record. In your case, country on its own is not complete as it needs states as well. So, I would have a single document with something like this:
{
    "_id": "DB generated Id",
    "Name": "Country Name",
    "States": [{
        "Name": "State 1"
    }, {
        "Name": "State 2"
    }]
}

Now, if states on themselves are a complete record, then another document to hold state list can be used. This will lead to duplication which is absolutely fine AFAIK in NoSQL World.
"It is easy to decipher extraterrestrial signals after deciphering Javascript and VB6 themselves.", ISanti[^]

GeneralRe: MongoDB document or model planning, best Pin
jkirkerx24-Aug-18 6:50
professionaljkirkerx24-Aug-18 6:50 
GeneralRe: MongoDB document or model planning, best Pin
jschell25-Aug-18 4:00
memberjschell25-Aug-18 4:00 
AnswerRe: MongoDB document or model planning, best Pin
Nathan Minier24-Aug-18 1:31
professionalNathan Minier24-Aug-18 1:31 
GeneralRe: MongoDB document or model planning, best Pin
jkirkerx24-Aug-18 6:58
professionaljkirkerx24-Aug-18 6:58 
GeneralRe: MongoDB document or model planning, best Pin
jkirkerx24-Aug-18 9:16
professionaljkirkerx24-Aug-18 9:16 
GeneralRe: MongoDB document or model planning, best Pin
Nathan Minier24-Aug-18 9:28
professionalNathan Minier24-Aug-18 9:28 
GeneralRe: MongoDB document or model planning, best Pin
jkirkerx24-Aug-18 10:07
professionaljkirkerx24-Aug-18 10:07 
GeneralRe: MongoDB document or model planning, best Pin
jschell25-Aug-18 4:03
memberjschell25-Aug-18 4:03 
GeneralRe: MongoDB document or model planning, best Pin
jkirkerx25-Aug-18 8:12
professionaljkirkerx25-Aug-18 8:12 
GeneralRe: MongoDB document or model planning, best Pin
jschell16-Sep-18 11:00
memberjschell16-Sep-18 11:00 
QuestionOrders and Supply Pin
Member 1098931222-Aug-18 19:41
memberMember 1098931222-Aug-18 19:41 
QuestionWhat do you think of MongoDB? Pin
jkirkerx13-Aug-18 13:14
professionaljkirkerx13-Aug-18 13:14 
AnswerRe: What do you think of MongoDB? Pin
Eddy Vluggen14-Aug-18 0:46
mveEddy Vluggen14-Aug-18 0:46 
GeneralRe: What do you think of MongoDB? Pin
jkirkerx14-Aug-18 7:00
professionaljkirkerx14-Aug-18 7:00 
GeneralRe: What do you think of MongoDB? Pin
Eddy Vluggen14-Aug-18 7:10
mveEddy Vluggen14-Aug-18 7:10 
GeneralRe: What do you think of MongoDB? Pin
jkirkerx14-Aug-18 8:44
professionaljkirkerx14-Aug-18 8:44 
GeneralRe: What do you think of MongoDB? Pin
Eddy Vluggen14-Aug-18 8:58
mveEddy Vluggen14-Aug-18 8:58 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.