Click here to Skip to main content
15,899,314 members
Home / Discussions / Database
   

Database

 
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 
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 
Disclaimer: this approach is rooted in Domain Driven Design, which is a common approach to NoSQL structuring. This is a super-rough look at entities vs value types in DDD.

I'm generally in agreement with @lw@zi, but it depends on your use case of states. If a data structure needs to be a domain-level entity, or is going to be directly referenced by multiple domain models, then it should have it's own store; otherwise it should be nested in a parent; it really has nothing to do with how much data is being tracked by an individual data structure.

If you will only ever present states in conjunction with countries, such as form fields and address resolution, without additional selection vectors then there is no reason to make it a reference and give it its own table.

If states are important on their own in the domain model or if multiple vectors might be used to access the data, such as if you have references to specific state agencies (NY DMV vs NC DMV, etc.), then you should make it a reference.
"Never attribute to malice that which can be explained by stupidity."
- Hanlon's Razor

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
jschell25-Aug-18 4:03 

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.