Search Results
| 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 |
| Code | code:"if (foo != bar)" |
| Sections |
title:apples body:"apples oranges" |
| URL | url:"*.example.com" |
| Saves | in:saves |
| 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 database-design
Search options not deleted
user 21083
The development of the conceptual schema and/or the logical model and/or the physical settings of a database.
18
votes
Why are constraints applied in the database rather than the code?
Most referential integrity constraints that are implemented outside of the database can be defeated, so if you want your data to have guaranteed integrity at all times then you have to apply constrain …
- 2,188
3
votes
Data Warehouse Design and Double Dipping
I don't see why you can't have a factless fact table, with the Event, Athlete, and Country as dimensions. You are using the table to record events, rather than measures.
I guess that athletes can cha …
- 2,188
2
votes
Accepted
Relational database primary key requirements
For each relation (ie. table) the primary key value must be unique and immutable (ie. it doesn't change).
You're likely to have a relation for location, one for rooms, one for racks. The primary key …
- 2,188
1
vote
List partitioning or filtering a non-partitioned table, which incurs lower cost?
The performance benefits of partition pruning depend on the proportion of rows being selected from the table and the efficiency with which the rows can be isolated to their own partition(s).
If you a …
- 2,188