Messages - OGroeger [ switch to compact view ]

Pages: prev1 2 [3] 4 5 6 7 8 ... 16next
11
General Software Discussion / Re: How can a BSOD ruin an mbr???
« on: October 13, 2007, 03:53 AM »
Hmm, maybe a hardware defect (harddisk or controller)? The hardware wreakes havoc and the os crashes afterwards?

12
@tinjaw:

There is your problem. You should never reuse such a key. Unique Primary Keys are the heart and soul of any database.

The emphasis is "business". A business key is something that you can use to distinguish between records and to find and identify records, e.g. a user name when the your entity is user, or an isbn nummer when you manage books, or a social card number. It is something that you would use in the "from" part of a select statement. You should not use this as primary key. The primary key should not have a business meaning, only a technical. Best is you let the database manage the primary key, for instance in ms sql use an identity column. The background of my question to Ralf Maximus was that i was interested whether his business key is unique or not.


@Ralf Maximus:
Absolutely yes, this sounds mature and well designed. Thank you for the inside view.

13
How do you face the situation when a record has been moved to the archive and afterwards a doublette has been inserted in the live db? I mean
  • a record has been moved to the archive
  • Someone inserts a new record with the identical business key as the archived record
  • The new record dates out and will be moved to the archive

I'm sorry to pester you with questions.

 

14
Coding Snacks / Re: Create an exit for Java hell
« on: October 03, 2007, 03:30 AM »
You could use one vm (VMWare) for each java version. This would ensure that you have a clean test environment and not unwanted side effects.

15
Whow, that sounds interesting. How do you determine that data are "old" and should be moved to the archive?

Pages: prev1 2 [3] 4 5 6 7 8 ... 16next
Go to full version