SQL Server Performance Forum – Threads Archive

Database basics

Hi 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.
_________
Satya SKJ
Moderator
SQL-Server-Performance.Com

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
http://www.insidesql.de
http://www.familienzirkus.de

Some good books and papers available here: http://www.dbdebunk.com /Argyle

<blockquote id="quote">quote:<hr height="1" noshade id="quote"> Some good books and papers available here: http://www.dbdebunk.com</a> <hr height="1" noshade id="quote"></blockquote id="quote"> Yes, CJ Date and Fabian Pascal site. One of the true valuable sources on the internet. 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 Database Design for Mere Mortals (Second Edition) von Michael J. Hernandez Addison-Wesley; ISBN: 0-201-75284-0 Some $40 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> In your case this might also be of interest http://www.intelligententerprise.com/info_centers/database/</a> http://www.thethirdmanifesto.com/</a> 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=’

‘ />] Frank http://www.insidesql.de</a> http://www.familienzirkus.de</a>

]]>