<!-- 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>