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 3174

The development of the conceptual schema and/or the logical model and/or the physical settings of a database.

1
vote
It is likely that you would partition the table by time or region, etc. Also this is what indexes or caching already do. So your idea could be appropriate but you need to think about whether you are …
answered Jan 10 '14 by JamesRyan
2
votes
I don't know how to write this out in the above format but you are going to have a table for books, and a table for categories with a foreign key to the book. If there were more columns for the categ …
answered Oct 6 '11 by JamesRyan
0
votes
Your model above works for a list of flowers where the garden is not relevant. But it wouldn't work when flowers or gardeners could be in multiple gardens. You should have a table for each type of en …
answered Oct 30 '13 by JamesRyan
1
vote
Where info is personalised it should be normalised into linked tables that only join to rows where that optional column has been added. Also if you might be adding many columns or long data it is com …
answered Feb 19 '13 by JamesRyan
0
votes
Generate a calendar table (that's googleable) and join your other tables to it. This makes it easy to do overlaps, etc. in an efficient way. In case it is not clear this is the standard way. I have …
answered Jul 28 '15 by JamesRyan