<!-- MHonArc v2.4.4 -->
<!--X-Subject: [MUD-Dev] Re: Databases: was Re: skill system -->
<!--X-From-R13: wnpbo ynatgubea <wynatgubeaNgbjregrpuvap.pbz> -->
<!--X-Date: Wed, 24 Jun 1998 07:21:12 -0700 -->
<!--X-Message-Id: 9193945826E7D0118BB4080009DBF8F61221A0@TTECH -->
<!--X-Content-Type: text/plain -->
<!--X-Head-End-->
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<html>
<head>
<title>MUD-Dev message, [MUD-Dev] Re: Databases: was Re: skill system</title>
<!-- meta name="robots" content="noindex,nofollow" -->
<link rev="made" href="mailto:jlangthorn#towertechinc,com">
</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="msg01191.html">Previous</a>
| <a href="msg01193.html">Next</a>
]
Thread:
[ <a href="msg01191.html">Previous</a>
| <a href="msg01014.html">Next</a>
]
Index:
[ <A HREF="author.html#01192">Author</A>
| <A HREF="#01192">Date</A>
| <A HREF="thread.html#01192">Thread</A>
]
<!--X-TopPNI-End-->
<!--X-MsgBody-->
<!--X-Subject-Header-Begin-->
<H1>[MUD-Dev] Re: Databases: was Re: skill system</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: Databases: was Re: skill system</LI>
<LI><em>From</em>: jacob langthorn <<A HREF="mailto:jlangthorn#towertechinc,com">jlangthorn#towertechinc,com</A>></LI>
<LI><em>Date</em>: Wed, 24 Jun 1998 09:18:29 -0500</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>
> On Sat, 20 Jun 1998, Jon A. Lambert wrote:
>
> > On 16 Jun 98, s001gmu#nova,wright.edu wrote:
> > > On Thu, 11 Jun 1998, T. Alexander Popiel wrote:
> > >
> > > > In message: <<A HREF="msg00971.html">9193945826E7D0118BB4080009DBF8F611737D@TTECH</A>>
> > > > jacob langthorn <jlangthorn#towertechinc,com>
> writes:
> > > > >
> > > > > Has any one tried using Orical or SQL to manage the data
> base
> > > > >for the mud? If so what sorta luck did you have?
> > > >
>
[jacob langthorn] Deleted.......
> > RDBs are ideal for mapping objects with static runtime attributes.
>
> Bingo. Not all of us are on the 'fully programable' band wagon. In
> fact,
> I think we are not even on the 'completely levelless' band wagon
> either.
>
> > In order to succesfully map an object with dynamic runtime
> attributes
> > to an RDB, the object must be reflective. That is it must be at
> > all times self-aware of it's attributes. In addition the RDB
> ideally
> > is designed in such a way as to implement object reflectivity
> instead
> > of the object directly. This requires an interface or translator
> > module. One can certainly map an object directly to an RDB
> > using what static properties are known to all objects and putting
> the
> > dynamic properties into a binary blob.
>
> Let me attempt to restate the above, to test my understanding. Please
> correct if I mess anything up. :)
>
> There are 2 kinds of objects (to generalize).
> 1) Objects whose properties are compiled in. (A rock is a rock is a
> rock)
> 2) Objects who can change their properties at run time. (a rock can
> become
> an intelligent rock on the fly)
>
> 1 maps nicely to a RDB because each of the objects compiled in simply
> gets
> its own table, with one column for each property. 2 does not map well
> because the setup listed for 1 (one table per object, one column per
> property) will just not work as the properties themselves change and
> changing a table's layout in SQL is ... expensive ... to say the
> least.
>
> One suggested solution to mapping 2 into a RDB is to map out the basic
> objects/properties as in 1, and then cram all the changeable ones into
> a
> Blob field. The problem is that the blob field then needs to be
> interpreted at run time, essentially recreating a large portion of the
> DB
> layer in code (storing not only data, but how the data is used).
> This, in
> essence, defeats the purpose of using a RDB to begin with.
>
[jacob langthorn] I think you are confusing tables with records
or I am.
I was thinking of building a table with all the atributes of
objects, another
for Characters, and areas and so on. My hope is to have the
server track
the relations, ie a character record points to the object
record's that the
character has picked up, as well as which area s/he is in. When
a character
picks up a new object his record simply gains a pointer to the
objects record
record.Along this vein all objects have the abilaty to take on
all of the posible
properties properties in the system, ie your rock would just
gain a flag in the
colum for flying. the same would aply for characters and areas.
I appologieze
if this seems a litle scrambled, it was writen on the fly so to
speak.
Deleted.....
Jacob Langthorn
>
</PRE>
<!--X-Body-of-Message-End-->
<!--X-MsgBody-End-->
<!--X-Follow-Ups-->
<HR>
<!--X-Follow-Ups-End-->
<!--X-References-->
<!--X-References-End-->
<!--X-BotPNI-->
<UL>
<LI>Prev by Date:
<STRONG><A HREF="msg01191.html">[MUD-Dev] Re: Databases: was Re: skill system</A></STRONG>
</LI>
<LI>Next by Date:
<STRONG><A HREF="msg01193.html">[MUD-Dev] Re: Analysis and specification - the dirty words of mud development?</A></STRONG>
</LI>
<LI>Prev by thread:
<STRONG><A HREF="msg01191.html">[MUD-Dev] Re: Databases: was Re: skill system</A></STRONG>
</LI>
<LI>Next by thread:
<STRONG><A HREF="msg01014.html">[MUD-Dev] META: The web is a live again!</A></STRONG>
</LI>
<LI>Index(es):
<UL>
<LI><A HREF="index.html#01192"><STRONG>Date</STRONG></A></LI>
<LI><A HREF="thread.html#01192"><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>[MUD-Dev] Re: OT: Announcement</STRONG>, <EM>(continued)</EM>
<ul compact>
<LI><strong><A NAME="01048" HREF="msg01048.html">[MUD-Dev] Re: OT: Announcement</A></strong>,
Nathan F Yospe <a href="mailto:yospe#hawaii,edu">yospe#hawaii,edu</a>, Mon 15 Jun 1998, 18:17 GMT
</LI>
</ul>
</LI>
<LI><strong><A NAME="01019" HREF="msg01019.html">[MUD-Dev] Re: Databases: was Re: skill system</A></strong>,
John Bertoglio <a href="mailto:alexb#internetcds,com">alexb#internetcds,com</a>, Sun 14 Jun 1998, 04:53 GMT
<UL>
<li><Possible follow-up(s)><br>
<LI><strong><A NAME="01094" HREF="msg01094.html">[MUD-Dev] Re: Databases: was Re: skill system</A></strong>,
John Bertoglio <a href="mailto:alexb#internetcds,com">alexb#internetcds,com</a>, Wed 17 Jun 1998, 02:49 GMT
</LI>
<LI><strong><A NAME="01191" HREF="msg01191.html">[MUD-Dev] Re: Databases: was Re: skill system</A></strong>,
##Make Nylander <a href="mailto:thenewt#use,usit.net">thenewt#use,usit.net</a>, Wed 24 Jun 1998, 13:31 GMT
</LI>
<LI><strong><A NAME="01192" HREF="msg01192.html">[MUD-Dev] Re: Databases: was Re: skill system</A></strong>,
jacob langthorn <a href="mailto:jlangthorn#towertechinc,com">jlangthorn#towertechinc,com</a>, Wed 24 Jun 1998, 14:21 GMT
</LI>
</UL>
</LI>
<LI><strong><A NAME="01014" HREF="msg01014.html">[MUD-Dev] META: The web is a live again!</A></strong>,
J C Lawrence <a href="mailto:claw#under,engr.sgi.com">claw#under,engr.sgi.com</a>, Sat 13 Jun 1998, 02:36 GMT
<LI><strong><A NAME="01006" HREF="msg01006.html">[MUD-Dev] Away on a trip</A></strong>,
Bryce <a href="mailto:S006JBH#nova,wright.edu">S006JBH#nova,wright.edu</a>, Fri 12 Jun 1998, 20:56 GMT
<UL>
<li><Possible follow-up(s)><br>
<LI><strong><A NAME="01011" HREF="msg01011.html">[MUD-Dev] Away on a trip</A></strong>,
Bryce <a href="mailto:S006JBH#nova,wright.edu">S006JBH#nova,wright.edu</a>, Fri 12 Jun 1998, 23:47 GMT
</LI>
</UL>
</LI>
<LI><strong><A NAME="00989" HREF="msg00989.html">[MUD-Dev] Re: Off topic! ...</A></strong>,
J C Lawrence <a href="mailto:claw#under,engr.sgi.com">claw#under,engr.sgi.com</a>, Fri 12 Jun 1998, 00:37 GMT
</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>
