<!-- MHonArc v2.4.4 --> <!--X-Subject: [MUD-Dev] Re: DBMS in MU*'s --> <!--X-From-R13: Xrebra Dhvtebx/Ofzbqnv <nfzbqnvNjkf.ay> --> <!--X-Date: Sun, 19 Jul 1998 11:45:25 -0700 --> <!--X-Message-Id: 7718286E10FD.AAADA8#smtp01,wxs.nl --> <!--X-Content-Type: text/plain --> <!--X-Reference: 7718286B1145.AAA3184#smtp01,wxs.nl --> <!--X-Reference: 77182868FA7.AAA22A6#smtp04,wxs.nl --> <!--X-Reference: 19980719112511.A29330#flagstaff,Princeton.EDU --> <!--X-Reference: 19980719133740.A7341#flagstaff,Princeton.EDU --> <!--X-Head-End--> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <html> <head> <title>MUD-Dev message, [MUD-Dev] Re: DBMS in MU*'s</title> <!-- meta name="robots" content="noindex,nofollow" --> <link rev="made" href="mailto:asmodai#wxs,nl"> </head> <body background="/backgrounds/paperback.gif" bgcolor="#ffffff" text="#000000" link="#0000FF" alink="#FF0000" vlink="#006000"> <font size="+4" color="#804040"> <strong><em>MUD-Dev<br>mailing list archive</em></strong> </font> <br> [ <a href="../">Other Periods</a> | <a href="../../">Other mailing lists</a> | <a href="/search.php3">Search</a> ] <br clear=all><hr> <!--X-Body-Begin--> <!--X-User-Header--> <!--X-User-Header-End--> <!--X-TopPNI--> Date: [ <a href="msg00258.html">Previous</a> | <a href="msg00260.html">Next</a> ] Thread: [ <a href="msg00258.html">Previous</a> | <a href="msg00668.html">Next</a> ] Index: [ <A HREF="author.html#00259">Author</A> | <A HREF="#00259">Date</A> | <A HREF="thread.html#00259">Thread</A> ] <!--X-TopPNI-End--> <!--X-MsgBody--> <!--X-Subject-Header-Begin--> <H1>[MUD-Dev] Re: DBMS in MU*'s</H1> <HR> <!--X-Subject-Header-End--> <!--X-Head-of-Message--> <UL> <LI><em>To</em>: <A HREF="mailto:mud-dev#kanga,nu">mud-dev#kanga,nu</A></LI> <LI><em>Subject</em>: [MUD-Dev] Re: DBMS in MU*'s</LI> <LI><em>From</em>: Jeroen Ruigrok/Asmodai <<A HREF="mailto:asmodai#wxs,nl">asmodai#wxs,nl</A>></LI> <LI><em>Date</em>: Sun, 19 Jul 1998 20:46:15 +0200</LI> <LI><em>Reply-To</em>: <A HREF="mailto:mud-dev#kanga,nu">mud-dev#kanga,nu</A></LI> </UL> <!--X-Head-of-Message-End--> <!--X-Head-Body-Sep-Begin--> <HR> <!--X-Head-Body-Sep-End--> <!--X-Body-of-Message--> <PRE> At 19:37 19-07-98 , you wrote: >On Sun, Jul 19, 1998 at 05:46:53PM +0200, Jeroen Ruigrok/Asmodai wrote: >> At 17:25 19-07-98 , you wrote: >> Freeware SQL Daemons/servers out there for FreeBSD or Windows NT? > >PostgreSQL is free. Or was last I checked about two months ago. Reading <<A HREF="http://www.postgresql.org">http://www.postgresql.org</A>> as I type this =) >It claims to be an ORDBMS, which basically means you can define tables that >inherit their structure from other tables. Which works well enough for an >object model, although I'm having a problem defining direct objects on it. A ORDBMS would be better than either a OO- or R-DBMS alone in my humble revised opinion as objects (or items and such) are related to a person or location, but can be children of one parent. Imagine a inn where all knives were created by hand instead of creating childs from a parent. >How do I implement an object model that specifies what objects provide >direct objects for various verbs? There isn't a one-to-one mapping between >classes as defined above and direct-object-classes. For example, say we >have a class liquid_container; now both a wineskin and a crystal goblet are >liquid_containers. But one provides a direct object to "break" and one >does not. > >Multiple inheritance may provide a solution. That is, I create an empty >table (class) "fragile" and nestle it under "object". Then the goblet >inherits both "liquid_container" and "fragile". And if someone tries to >break it, we look to see if it's a member of "fragile" (or "fragile*" if I >have subclassed "fragile" in the meantime). > >I'm worried that this will cause a huge explosion in the number of tables, >though. Plus an awful lot of ugly special case code in the server. I understand yer concern, but is a 'condition' table (or something like that) which lists the states an object can be in not the solution then? I mean, create a table with entries like: rock, glass, velvet, wood and paper and assign values about the subject being able to break, torn apart etc... This would eliminate multiple tables and generally provide a good addition to the MU*. HTH, -- Jeroen Ruigrok van der Werven / Asmodai <asmodai(at)wxs.nl> ICQ-UIN: 1564317 .:. Ninth Circle Enterprises Network/Security Specialist As far as ye can't tell, I am the Future in Computer Hell... </PRE> <!--X-Body-of-Message-End--> <!--X-MsgBody-End--> <!--X-Follow-Ups--> <HR> <ul compact><li><strong>Follow-Ups</strong>: <ul> <li><strong><A NAME="00668" HREF="msg00668.html">[MUD-Dev] Re: DBMS in MU*'s</A></strong> <ul compact><li><em>From:</em> J C Lawrence <claw#under,engr.sgi.com></li></ul> </UL></LI></UL> <!--X-Follow-Ups-End--> <!--X-References--> <UL><LI><STRONG>References</STRONG>: <UL> <LI><STRONG><A NAME="00256" HREF="msg00256.html">[MUD-Dev] Re: DBMS in MU*'s</A></STRONG> <UL><LI><EM>From:</EM> Jeroen Ruigrok/Asmodai <asmodai#wxs,nl></LI></UL></LI> <LI><STRONG><A NAME="00251" HREF="msg00251.html">[MUD-Dev] DBMS in MU*'s</A></STRONG> <UL><LI><EM>From:</EM> Jeroen Ruigrok/Asmodai <asmodai#wxs,nl></LI></UL></LI> <LI><STRONG><A NAME="00255" HREF="msg00255.html">[MUD-Dev] Re: DBMS in MU*'s</A></STRONG> <UL><LI><EM>From:</EM> "Adam J. Thornton" <adam#phoenix,Princeton.EDU></LI></UL></LI> <LI><STRONG><A NAME="00258" HREF="msg00258.html">[MUD-Dev] Re: DBMS in MU*'s</A></STRONG> <UL><LI><EM>From:</EM> "Adam J. Thornton" <adam#phoenix,Princeton.EDU></LI></UL></LI> </UL></LI></UL> <!--X-References-End--> <!--X-BotPNI--> <UL> <LI>Prev by Date: <STRONG><A HREF="msg00258.html">[MUD-Dev] Re: DBMS in MU*'s</A></STRONG> </LI> <LI>Next by Date: <STRONG><A HREF="msg00260.html">[MUD-Dev] Re: Scripting Design Notes</A></STRONG> </LI> <LI>Prev by thread: <STRONG><A HREF="msg00258.html">[MUD-Dev] Re: DBMS in MU*'s</A></STRONG> </LI> <LI>Next by thread: <STRONG><A HREF="msg00668.html">[MUD-Dev] Re: DBMS in MU*'s</A></STRONG> </LI> <LI>Index(es): <UL> <LI><A HREF="index.html#00259"><STRONG>Date</STRONG></A></LI> <LI><A HREF="thread.html#00259"><STRONG>Thread</STRONG></A></LI> </UL> </LI> </UL> <!--X-BotPNI-End--> <!--X-User-Footer--> <!--X-User-Footer-End--> <ul><li>Thread context: <BLOCKQUOTE><UL> <LI><strong><A NAME="00251" HREF="msg00251.html">[MUD-Dev] DBMS in MU*'s</A></strong>, Jeroen Ruigrok/Asmodai <a href="mailto:asmodai#wxs,nl">asmodai#wxs,nl</a>, Sun 19 Jul 1998, 12:46 GMT <UL> <LI><strong><A NAME="00255" HREF="msg00255.html">[MUD-Dev] Re: DBMS in MU*'s</A></strong>, Adam J. Thornton <a href="mailto:adam#phoenix,Princeton.EDU">adam#phoenix,Princeton.EDU</a>, Sun 19 Jul 1998, 15:28 GMT <UL> <LI><strong><A NAME="00256" HREF="msg00256.html">[MUD-Dev] Re: DBMS in MU*'s</A></strong>, Jeroen Ruigrok/Asmodai <a href="mailto:asmodai#wxs,nl">asmodai#wxs,nl</a>, Sun 19 Jul 1998, 15:46 GMT <UL> <LI><strong><A NAME="00258" HREF="msg00258.html">[MUD-Dev] Re: DBMS in MU*'s</A></strong>, Adam J. Thornton <a href="mailto:adam#phoenix,Princeton.EDU">adam#phoenix,Princeton.EDU</a>, Sun 19 Jul 1998, 17:47 GMT <UL> <LI><strong><A NAME="00259" HREF="msg00259.html">[MUD-Dev] Re: DBMS in MU*'s</A></strong>, Jeroen Ruigrok/Asmodai <a href="mailto:asmodai#wxs,nl">asmodai#wxs,nl</a>, Sun 19 Jul 1998, 18:45 GMT <UL> <LI><strong><A NAME="00668" HREF="msg00668.html">[MUD-Dev] Re: DBMS in MU*'s</A></strong>, J C Lawrence <a href="mailto:claw#under,engr.sgi.com">claw#under,engr.sgi.com</a>, Tue 11 Aug 1998, 23:14 GMT <UL> <LI><strong><A NAME="00678" HREF="msg00678.html">[MUD-Dev] Re: DBMS in MU*'s</A></strong>, quzah <a href="mailto:quzah#geocities,com">quzah#geocities,com</a>, Wed 12 Aug 1998, 10:55 GMT </LI> </UL> </LI> </UL> </LI> </UL> </LI> </UL> </LI> </UL> </LI> <LI><strong><A NAME="00267" HREF="msg00267.html">[MUD-Dev] Re: DBMS in MU*'s</A></strong>, Ross Nicoll <a href="mailto:rnicoll#lostics,demon.co.uk">rnicoll#lostics,demon.co.uk</a>, Mon 20 Jul 1998, 07:34 GMT </LI> <LI><strong><A NAME="00666" HREF="msg00666.html">[MUD-Dev] Re: DBMS in MU*'s</A></strong>, J C Lawrence <a href="mailto:claw#under,engr.sgi.com">claw#under,engr.sgi.com</a>, Tue 11 Aug 1998, 22:26 GMT </LI> </UL> </LI> </UL></BLOCKQUOTE> </ul> <hr> <center> [ <a href="../">Other Periods</a> | <a href="../../">Other mailing lists</a> | <a href="/search.php3">Search</a> ] </center> <hr> </body> </html>