Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Favorites infavorites:mine
infavorites:1234
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with Search options user 1050

Questions about data that is organized into types and subtypes.

4
votes
subclass that join superclass data with subclass data. Finally, there is a tag in this area that collects questions like yours together. Here it is: subtypes
answered Oct 27 '14 by Walter Mitty
2
votes
Try searching "single table inheritance" or "class table inheritance". Especially the web pages from Martin Fowler. Also, if you use a technique called "shared primary key", you can reference a per …
answered Mar 13 '15 by Walter Mitty
1
vote
It sounds like your categories are a case of the subtypes pattern. Accordingly, I've added the tag subtypes to your question. There are two design patterns that you may want to look into. The … first one is called "Single Table Inheritance". This design involves collecting all the subtypes (or, if you prefer, subclasses) into one table, and leaving values missing (NULL) in places where they …
answered Nov 25 '14 by Walter Mitty
0
votes
design. If you want to explore the trade offs between the two techniques, I suggest you look up Martin Fowler's treatment of the subject. You can see a summary of them here and here. You may also want to add this tag to your question, in order to get more answers. subtypes
answered Dec 5 '14 by Walter Mitty
4
votes
Your case is an instance of class/subclass modeling. Or, as you have diagrammed it in ER, generalization/specialization. There are three techniques that will help you design mysql tables to cover th …
answered Mar 11 '13 by Walter Mitty
1
vote
In ER modeling, IsA relationships go by the name "generalization/specialization". A search on this should give you a few pointers. Diagramming this pattern requires using a notation that was origina …
answered Mar 11 '15 by Walter Mitty
1
vote
question of how to implement subclasses (or subtypes) in SQL tables. Some of those questions are grouped under this tag: subtypes. Over in StackOverflow, there are even more such questions, and …
answered Oct 28 '17 by Walter Mitty
0
votes
How you do the select depends on your table design. Your EER depicts the entities, relationships and attributes nicely, but doesn't say anything about table design. (That's as it should be, IMO). A …
answered Jan 25 '15 by Walter Mitty
4
votes
This is a case of what's called "generalization/specialization" in ER lingo. It's really the same thing as what object models call "superclass/subclass" as you have done. There are two separable iss …
answered Nov 6 '15 by Walter Mitty
2
votes
wish to include this tag in your original question: subtypes Here are three of the techniques in a nutshell: single table inheritance, class table inheritance, and shared primary key. Single table … headaches) If there are no attributes that are specialized to the subtypes , then no inheritance (from a data perspective) is needed. So it won't make any difference to the relational design …
answered Apr 16 '15 by Walter Mitty
2
votes
The answer from MDCCL is a superb summary of the concepts behind superclass/subclass or generalization/specialization as depicted at the EERD level. This answer is intended to point out three desig …
answered Jul 6 '15 by Walter Mitty