<pedrocorreia.net ⁄>
<portugal ⁄><tecnologia ⁄><desporto ⁄><musica ⁄><mundo ⁄><ciencia ⁄><software ⁄><programacao ⁄><entretenimento ⁄><misc ⁄>
 

<Are foreign keys really necessary in a database design? ⁄ >




clicks: 154 154 2008-08-23 2008-08-23 goto misc myNews misc  Bookmark This Bookmark This


Many people responded and there were all kinds of opinions. The strange thing I noticed was that many people including Joel Spolsky do not use foreign key constraints in their databases.

You can build a complete application without even using a single foreign key constraint. Foreign keys, as a matter of fact are not essential in your databases, but they help a lot in programming and making robust systems. Hence the use of foreign key integrity constraints is strongly recommended.



este é só um excerto do artigo, para aceder ao artigo completo, clique no link em baixo:
this is just a small excerpt from the article, to access the full article please click in the link below:
http://www.diovo.com/2008/08/are-foreign-keys-really-necessary-in-a-da...




Subscribe News RSS  Subscribe News Updates by E-mail





myNews <myNews show="rand" cat="misc" ⁄>

How the boring stuff gets done in Open Source ? It doesn't !

Writing code is fun. Debugging used to be painful, especially with all the segfa (...)

clicks: 218 218 2007-06-12 2007-06-12 goto url (new window) t-a-w.blogspot.... goto myNews misc


The reality of working for yourself

I enjoy working for myself. Being my own boss and making decisions on pretty muc (...)

clicks: 198 198 2007-05-13 2007-05-13 goto url (new window) nextbigleap.com... goto myNews misc


The 30 skills every IT person should have

1. Be able to fix basic PC issues. These can be how to map a printer, back up fi (...)

clicks: 167 167 2008-06-04 2008-06-04 goto url (new window) infoworld.com/a... goto myNews misc


How can a programmer become famous in his/her community?

When you browse between programming communities from different parts of the worl (...)

clicks: 169 169 2007-04-27 2007-04-27 goto url (new window) 82.110.105.85/d... goto myNews misc


Gmail Gets 13 Experimental New Features

Starting at 6PM Pacific Time tonight, Google will start rolling out Gmail Labs, (...)

clicks: 177 177 2008-06-08 2008-06-08 goto url (new window) lifehacker.com/... goto myNews misc


Web 2.0 Layer Styles

The visual style that has come to be associated with the term Web 2.0 has explod (...)

clicks: 147 147 2008-08-03 2008-08-03 goto url (new window) logographics-de... goto myNews misc


25 Free Computer Science Books

As a computer scientist I'm always looking to improve my knowledge of the subjec (...)

clicks: 37 37 2008-12-21 2008-12-21 goto url (new window) coderholic.com/... goto myNews misc


Tips and tricks for designing logos

Creating a logo design is a pretty exhausting task what with having to think of (...)

clicks: 181 181 2007-07-27 2007-07-27 goto url (new window) wipeout44.com/a... goto myNews misc