Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mikebird
Aged Yak Warrior
529 Posts |
 Posted - 2010-12-07 : 11:17:58
|
| Why's it called a database?It would be more meaningful to call it a data holddatastoredatabankdatabucketA base without walls or a lid might be prone to loss and leakage |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2010-12-07 : 11:21:57
|
| Ted Codd's original paper was called "A Relational Model of Data for Large Shared Data Banks". Don't know who or when they went with database but it's a little entrenched now. |
 |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2010-12-07 : 11:30:56
|
| A database was meant to hold tables with distinct rows.Depending on your definition a database is in 1st normal form.Seems to me that 1st normal form has changed - now prohibits repeating groups while I thought was 2nd.Might be a Codd vs Date thing but this was leading to Boyce-Codd - maybe it's Codd vs Boyce.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2010-12-07 : 11:39:43
|
| Supposedly he changed a few definitions from his original paper and codified (hehehe) them in the 12 rules:http://en.wikipedia.org/wiki/Codd's_12_rulesThe normal form definitions came in dribs and drabs:http://en.wikipedia.org/wiki/Normal_forms |
|
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2010-12-07 : 11:51:43
|
| Think these are as I remember them apart from the repeating groups moved from 2 to 1.This was from a postgrad course (open university) I did in relational databases - didn't really know what they wre before then.Thinking back it was a tutor that said this and I can remember being a bit surprised at the time so maybe he got it wrong.It's odd - the course has been updated (been nearly 20 years) so I'm retaking it.Now it hardly mentions normalistion but is more about relational theory but mainly sql.Gives a mention to Codd but doesn't go into rules or anything like that.It does allow you to use sql server though (as well as any other popular dbms) so that makes it easier. Lot of people are having problems with mysql.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-12-07 : 12:13:56
|
"Lot of people are having problems with mysql."You giving them a helping hand? or adopting a missionary position?  |
|
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2010-12-07 : 12:25:00
|
| >> You giving them a helping hand?Nope.I did think of using this for the course to learn it but have decided to take the easy way out.Calling a table a relation feels a bit odd now.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
?