Reputation
2,739
Top tag
Next privilege 3,000 Rep.
Cast close & reopen votes
Badges
11 27
Newest
 Necromancer
Impact
~139k people reached

23h
answered Database design - need someone to guide me
Jul
28
comment Multiple types of parts with multiple types of information (unspecified amount)
See you next year when you ask "how the heck do I analyze EAV data?"
Jul
25
awarded  Necromancer
Jul
24
revised Postgres DDL and DML best practices and coding standards
added 136 characters in body
Jul
21
answered DB design for employee working hours constraints
Jul
18
comment Plural vs Singular Table Name
what does "too close for clarity" mean?
Jul
17
awarded  Necromancer
Jul
17
answered Plural vs Singular Table Name
Jul
17
revised How to do jUnit testing by PostgreSQL?
added 139 characters in body
Jul
17
answered How to do jUnit testing by PostgreSQL?
Jul
14
comment Where to put the currency field?
The price column is in the currency table? That's what you said but I don't think that's what you meant. Also, you should call "fields" "columns" round here :)
Jul
6
comment Are junction tables a good practice?
Are you writing your database in assembler since you only care about performance?
Jul
3
revised What are Measures and Dimensions in Cubes
added 2 characters in body
Jul
3
comment Modeling invoices and orders
@RexGrammer 1. ideally shipment addr goes in order line, but do what you like :) 2. Probably don't need employeeId in invoice. 3. store unit price and quantity in order line. don't store calculcated values in your operational db. 4. could store null for customerId, or create an "anonymous" customer. 5. you'll want to record payments too. don't need invoice if pay up front.
Jul
3
comment Modeling invoices and orders
@RexGrammer that Silverston book also covers discounts etc as per your other question
Jul
3
comment Modeling invoices and orders
ya, don't store the total. it will be v fast to calculate the order total from the lines.
Jul
3
revised Modeling invoices and orders
added 350 characters in body
Jul
3
answered Modeling invoices and orders
Jul
3
comment Database design, many rows or many columns?
EAV <> normalized
Jun
29
answered Performance impact of adding a foreign key to a 1M rows table