SQL Server Performance Forum – Threads Archive
Database basicsHi All: Where can i find on the internet a site giving me the basics of databases. Like the difference between RDBMS and DBMS, etc.? Thanx
Gotohttp://www.searchdatabase.techtarget.com which is a good site for beginners. A Relational DBMS (RDBMS_ considers the relationships betweeen entities (tables). E.g. a record on one (parent) table can have several records in another (child) related table- this would be a one-to-many relationship. The DBMS manages user requests (and requests from other programs) so that users and other programs are free from having to understand where the data is physically located on storage media and, in a multi-user system, who else may also be accessing the data.
http://www.aisintl.com/case/library/Date_Birth%20of%20the%20Relational%20Model-1.html might be a good starting point. Alsohttp://www.firstsql.com/tutor.htm . I did an article for SQL Server Central on the history of SQL
http://www.sqlservercentral.com/columnists/fkalis/abriefhistoryofsql.asp An article on Codd’s rules will be published there in two weeks or so. And I finished an article about different database models, which is due to be released soon, but I don’t know when. Frank
Some good books and papers available here: http://www.dbdebunk.com /Argyle
<blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><br />Some good books and papers available here:<br /><br /<a target="_blank" href=http://www.dbdebunk.com>http://www.dbdebunk.com</a><br /><hr height="1" noshade id="quote"></blockquote id="quote"></font id="quote"><br />Yes, CJ Date and Fabian Pascal site. One of the true valuable sources on the internet. <br />Although the books (specifically ‘An Introduction to Database System’, 8th edition) is quite expensive at some $100. I would recommend this only when you decide to dive very deep into the stuff. For (very) basic introduction I think this one is better (and it’s not soo dry<br /><br />Database Design for Mere Mortals (Second Edition) von Michael J. Hernandez<br />Addison-Wesley; ISBN: 0-201-75284-0<br />Some $40<br /><br />I’ve collected some of my favorite links here<a target="_blank" href=http://www.insidesql.de/scripts/sqlserverlinks.php>http://www.insidesql.de/scripts/sqlserverlinks.php</a><br /><br />In your case this might also be of interest <br /<a target="_blank" href=http://www.intelligententerprise.com/info_centers/database/>http://www.intelligententerprise.com/info_centers/database/</a><br /<a target="_blank" href=http://www.thethirdmanifesto.com/>http://www.thethirdmanifesto.com/</a><br /><br />Btw, I you have question, one method that almost always works, is to come back here and ask! Can save a lot of time and mental health [<img src=’/community/emoticons/emotion-1.gif’ alt=’‘ />]<br /><br />Frank<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br /<a target="_blank" href=http://www.familienzirkus.de>http://www.familienzirkus.de</a>