Click here to Skip to main content
15,907,183 members
Home / Discussions / Database
   

Database

 
AnswerRe: Run correctly from code VB.NET Pin
Richard MacCutchan23-Sep-18 22:13
mveRichard MacCutchan23-Sep-18 22:13 
GeneralRe: Run correctly from code VB.NET Pin
Computechsoft23-Sep-18 22:34
Computechsoft23-Sep-18 22:34 
GeneralRe: Run correctly from code VB.NET Pin
Richard MacCutchan23-Sep-18 22:50
mveRichard MacCutchan23-Sep-18 22:50 
GeneralRe: Run correctly from code VB.NET Pin
Computechsoft23-Sep-18 23:02
Computechsoft23-Sep-18 23:02 
GeneralRe: Run correctly from code VB.NET Pin
Richard MacCutchan23-Sep-18 23:11
mveRichard MacCutchan23-Sep-18 23:11 
GeneralRe: Run correctly from code VB.NET Pin
Richard Deeming24-Sep-18 8:13
mveRichard Deeming24-Sep-18 8:13 
AnswerRe: Run correctly from code VB.NET Pin
thatraja23-Sep-18 23:21
professionalthatraja23-Sep-18 23:21 
QuestionHow to retrieve List content in JSP from Hibernate Query Language Pin
Mr ARUL SUJU D15-Sep-18 12:38
Mr ARUL SUJU D15-Sep-18 12:38 
Questionstoring a byte[] array in MongoDB Pin
jkirkerx6-Sep-18 12:42
professionaljkirkerx6-Sep-18 12:42 
AnswerRe: storing a byte[] array in MongoDB [solved] Pin
jkirkerx7-Sep-18 6:53
professionaljkirkerx7-Sep-18 6:53 
GeneralRe: storing a byte[] array in MongoDB [solved] Pin
Nathan Minier11-Sep-18 3:09
professionalNathan Minier11-Sep-18 3:09 
GeneralRe: storing a byte[] array in MongoDB [solved] Pin
jkirkerx13-Sep-18 18:48
professionaljkirkerx13-Sep-18 18:48 
QuestionCreate View from another View Pin
jar86956-Sep-18 1:59
jar86956-Sep-18 1:59 
AnswerRe: Create View from another View Pin
Mycroft Holmes6-Sep-18 12:28
professionalMycroft Holmes6-Sep-18 12:28 
QuestionUnable to Get the Proper Result : SQL Query Help Needed Pin
arulsuju29-Aug-18 12:14
arulsuju29-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
professionalJochen 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
jschell23-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
jschell25-Aug-18 3:57 
AnswerRe: MongoDB document or model planning, best Pin
dan!sh 23-Aug-18 20:45
professional dan!sh 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
jschell25-Aug-18 4:00 
AnswerRe: MongoDB document or model planning, best Pin
Nathan Minier24-Aug-18 1:31
professionalNathan Minier24-Aug-18 1:31 

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.