| Author |
Thread Statistics | Show CCP posts - 0 post(s) |
ZeeOhSix
Blackwater Manufacturing and Logistics
   |
Posted - 2010.03.17 23:40:00 -
[1]
Note to self; do not hire RC as a DBA :)
I would offer that if you have the expertise you claim to, you'd recognize that until you see the schema, you really don't know what's possible and what's not. It may have been a short-sighted design, but we don't really know. It sounds like in the end they treat it as an attribute of an existing object, rather than a seperate object, and I can see why that would be attractive from a system design perspective.
OTOH, they did buy one of these for their database ;)
http://www.ramsan.com/products/ramsan-400.htm
The business of EVE is business!
|
ZeeOhSix
Blackwater Manufacturing and Logistics
|
Posted - 2010.03.18 21:08:00 -
[2]
 Originally by: Robert Caldera
absolute normalization is a curse if it comes to performance considerations
Goodness, but you're confused regarding the benefits of nomalization for high-transaction databases 
But it is entertaining reading  |
ZeeOhSix
Blackwater Manufacturing and Logistics
|
Posted - 2010.03.20 22:48:00 -
[3]
Originally by: Robert Caldera
Originally by: ZeeOhSix
Goodness, but you're confused regarding the benefits of nomalization for high-transaction databases
says who?
go trolling somewhere else if you have no clue
Says a 25 year DBA that's designed more high-transaction, large-scale databases than you've had zits - and that's saying something. You noted you were a DBA - what's your experience in designing large-scale transactional databases? Just name one.
The troll, sir, is you claiming something is "simple" and making consistent mis-statements about how databases actually work. I suggest you go back to your Microsoft Access playtime and leave real database work to professionals 
The business of EVE is business!
|
ZeeOhSix
Blackwater Manufacturing and Logistics
|
Posted - 2010.03.21 18:59:00 -
[4]
*sigh* I guess I'll take one pass, haul ass for fun, but this really isn't very interesting. Just another wanna-be dev telling the pros they're stupid.
Originally by: Robert Caldera
saying there is no way to get a simple attribute from a joined table lets look you like an idiot, tbh
This was not my statement, and the issue in question is not based on an attribute. Once again, you demonstrate that you simply don't understand high TPS relational databases.
Originally by: Robert Caldera
so, what mis-statement? show me one.
highly normalized blaaaahhhhh... improperly/too much normalized if the database table definition does miss the purpose and makes basic things impossible!!
This is just one, and the one that caught my eye initially as it demonstrates clearly you haven't done transactional DB work. Simple normalization, First normal form, is based on making "basic things" (queries) easy and avoiding data duplication. For high-transaction databases, this isn't enough as we need to be very aware of log overhead and dataset sizes. The purpose of this high level of normalization is performance, not ease of query. But this is all well beyond your ken; suffice to say that in terms of looking like an idiot - you're doing it right...just keep posting on the thread.
Originally by: Robert Caldera
yeah, my master.
Outstanding; with that acknowledgement and recognition, my work here is done.
The business of EVE is business!
|
| |
|