We hope you enjoy your visit.

You're currently viewing our forum as a guest. This means you are limited to certain areas of the board and there are some features you can't use. If you join our community, you'll be able to access member-only sections, and use many member-only features such as customizing your profile, sending personal messages, and voting in polls. Registration is simple, fast, and completely free.


Join our community!


If you're already a member please log in to your account to access all of our features:

Username:   Password:
Add Reply
dbms and rdbms
Topic Started: Jun 7 2005, 10:08 AM (633 Views)
mohit_funkygang Jun 7 2005, 10:08 AM Post #1
i need mods for my site<br>visit http://funkygang.cjb.net
[ * * ]
 manytimes ive come thru this question but couldnt find a satisfactory answer can any1 try and help
Quote:
 
what is the difference between DBMS and RDBMS. What are the advantage of using an RDBMS over DBMS through practical example.
Offline Profile Quote Post Goto Top
 
Seth Jun 7 2005, 12:37 PM Post #2
Member Avatar
I has a pony
[ * * * * * * * * * ]
 You will almost never find a database management system that is NOT relational. You should never use a vanilla system; pick one that supports relations. This is to reduce user error through the use of foreign keys.
Offline Profile Quote Post Goto Top
 
Tommeh Jun 7 2005, 07:07 PM Post #3
Member
[ * ]
 You'll find that mySQL is not a true relational database, it does not support foreign keys or features such as cascading deletes, you have to specify join fields and perform cascading deletes yourself. :)
Offline Profile Quote Post Goto Top
 
Seth Jun 8 2005, 12:33 PM Post #4
Member Avatar
I has a pony
[ * * * * * * * * * ]
 :ermm:
Quote:
 
ON DELETE CASCADE is available starting from MySQL 3.23.50
Quote:
 
Starting from MySQL 3.23.44, InnoDB features foreign key constraints.
Offline Profile Quote Post Goto Top
 
1 user reading this topic (1 Guest and 0 Anonymous)
« Previous Topic · Technology Chat · Next Topic »
Add Reply