Reputation
1,488
Top tag
Next privilege 2,000 Rep.
Edit questions and answers
Badges
5 9
Newest
 Yearling
Impact
~76k people reached

1d
answered Making sense of these business rules
1d
comment Duplicate Same Table for Multiple locations
With regard to speed alone, it boils down to which takes more time: selecting the relevant rows out of a large table, or selecting the relevant table out of a large collection. If you have to do the selection at run time, the chances are selecting the relevant rows is faster, provided you have the right indexes.
1d
comment Duplicate Same Table for Multiple locations
Normalization is sometimes worthwhile, even when it doesn't yield a performance improvement. It can make data management and application programming smoother and easier, and less error prone.
Aug
20
comment How are databases able to process queries in parallel while still retaining correct order?
f the question were about concurrent execution, rather than parallel execution, problems relating to concurrency control and reproducibility have been studied since the 1970s. Look up "ACID Transactions", "concurrency control", and "serializability" for articles concerning this topic.
Aug
11
answered MySQL - replicate some tables between transaction and report database
Aug
4
comment Why would I need a third table in a one-to-many relationship?
Good point. The third table makes it possible to represent an optional relationship without introducing NULLS.
Jul
29
answered Why would I need a third table in a one-to-many relationship?
Jul
29
comment Why would I need a third table in a one-to-many relationship?
Either you misinterpreted what your professor said, or your professor misinformed you.
Jul
28
comment Why is Database Administration so hard?
I was a database consultant for a few years. The sick puppies I had to nurse back to health included not only corrupted databases but seriously damaged DBAs. An undergraduate major in psychology would have been helpful.
Jul
26
answered Database design appoach confirmation
Jul
25
comment Database design appoach confirmation
I think you are mixed up about parent and child. The existing structure you describe, with claim containing loanId, establishes a many to one relationship between claims and loans. Why do you say that in the legcy system the claim is taken as parent?
Jul
16
comment MySQL Db design: Optional data in separate table or as NULL values in original table
It depends on what you are going to do with the data. Without this information, we are just guessing about performance.
Jul
12
comment How to relate a table to other two?
Is there a name for some superclass that includes both venues and products as subclasses? There is a tag called subtypes that group together questions of that ilk.
Jul
10
revised Row for each date, or 31 columns?
added edit based on comments
Jul
10
comment Row for each date, or 31 columns?
There is a side point in the previous comment. "I once had to deal with". This illustrates a common (although not universal) feature of captured data. It tends to outlive it's expected lifespan, and is subjected to mission creep, usually by a hapless successor.
Jul
9
comment Row for each date, or 31 columns?
I'm going to leave adding more detail to others. What I will tell you is that what you are engaged in is data architecture, regardless of whether you are only a code monkey or not.
Jul
9
comment Row for each date, or 31 columns?
If you want to understand crosstabulation, you can start here, en.wiktionary.org/wiki/cross_tabulation and then follow the links.
Jul
9
comment Row for each date, or 31 columns?
The transition from code monkey to data architect is a rough one. I know, because I made that transition, many years ago. Data that is thrown together by code monkeys nearly always comes back to haunt people who come along later.
Jul
9
answered Row for each date, or 31 columns?
Jul
6
answered Are junction tables a good practice?