panda17

5 ms·

1.
Grok Normalization(damirsystems.com)
3 points by panda17 6y ago|0 comments
2.
by panda17 6y ago
Regarding the "industry term", search: site:oracle.com "alternate key" site:microsoft.com "alternate key" site:ibm.com "alternate key"
3.
by panda17 6y ago
In general there can be more than one candidate key for a given relation (table). Only one candidate key is "primary", all others are "alternate".
4.
by panda17 6y ago
A thing is uniquely identified by T, category by C. May read it as: CREATE TABLE thing (T_ID integer, C_ID integer)
5.
by panda17 6y ago
Sorry, firewall thing -- dependent on recent (geo-ip) threats. Nothing to do with ads -- no ads.
6.
SQL X-to-Y(damirsystems.com)
64 points by panda17 6y ago|30 comments
7.
Teaching normalization past 1NF in basic DB courses considered harmful(damirsystems.com)
2 points by panda17 7y ago|0 comments
8.
by panda17 7y ago
Consider starting with these two papers, and then ... Michael Stonebraker et al., Architecture of a Database System, 2007. Michael Stonebraker et al., The End of an Architectural Era, 2007.
9.
MySQL Type Horrors(damirsystems.com)
1 points by panda17 7y ago|0 comments
10.
What is the correct way of creating a one-to-one relationship?(dba.stackexchange.com)
1 points by panda17 8y ago|0 comments
11.
MySQL Type Horrors(damirsystems.com)
1 points by panda17 9y ago|0 comments
12.
Explainable Decisions(dmcommunity.org)
2 points by panda17 9y ago|0 comments
13.
Monkey Business (Puzzle, SQL)(damirsystems.com)
1 points by panda17 9y ago|0 comments
14.
What are the options for storing hierarchical data in a relational database?(stackoverflow.com)
3 points by panda17 9y ago|0 comments
15.
SEND+MORE=MONEY (SQL)(damirsystems.com)
2 points by panda17 9y ago|0 comments
16.
Anchor Modeling(anchormodeling.com)
1 points by panda17 9y ago|0 comments
17.
Composite primary key vs. an additional ID column?(stackoverflow.com)
1 points by panda17 9y ago|0 comments
18.
What is Multi Dimensional OLAP CUBE, and give example with more than 3?(stackoverflow.com)
2 points by panda17 9y ago|0 comments
19.
How to check if a table exists in a given schema (PgSQL)(stackoverflow.com)
1 points by panda17 9y ago|0 comments
20.
How to design this database to avoid cyclic dependency?(dba.stackexchange.com)
1 points by panda17 9y ago|0 comments
21.
Cyber Security Incident Scenario(damirsystems.com)
1 points by panda17 9y ago|0 comments
22.
Eight Queens in SQL(damirsystems.com)
2 points by panda17 9y ago|0 comments
23.
Murder Mystery (SQL)(damirsystems.com)
3 points by panda17 9y ago|0 comments
24.
Reindeer Ordering (SQL)(damirsystems.com)
2 points by panda17 9y ago|1 comments
25.
Contradiction in Database(damirsystems.com)
1 points by panda17 9y ago|0 comments
26.
How to Understand the Fifth Normal Form?(stackoverflow.com)
3 points by panda17 9y ago|0 comments
27.
Types and Typos in SQL(damirsystems.com)
2 points by panda17 9y ago|0 comments
28.
Cyber Security Incident Scenario(damirsystems.com)
1 points by panda17 9y ago|0 comments