<!-- MHonArc v2.4.4 -->
<!--X-Subject: [MUD-Dev] Re: Databases: was Re: skill system -->
<!--X-From-R13: ##[nxr @lynaqre <gurarjgNhfr.hfvg.arg> -->
<!--X-Date: Wed, 24 Jun 1998 06:31:49 -0700 -->
<!--X-Message-Id: 199806241331.JAA03590#use,usit.net -->
<!--X-Content-Type: text -->
<!--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:thenewt#use,usit.net">
</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="msg01190.html">Previous</a>
| <a href="msg01192.html">Next</a>
]
Thread:
[ <a href="msg01094.html">Previous</a>
| <a href="msg01192.html">Next</a>
]
Index:
[ <A HREF="author.html#01191">Author</A>
| <A HREF="#01191">Date</A>
| <A HREF="thread.html#01191">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>: ##Make Nylander <<A HREF="mailto:thenewt#use,usit.net">thenewt#use,usit.net</A>></LI>
<LI><em>Date</em>: Wed, 24 Jun 1998 09:31:10 -0400 (EDT)</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>
[Original message sent by s001gmu#nova,wright.edu]
|
| 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.
I'd say this is not inherent to a query language or RDB model
per se, but rather to the implementation of a particular database
engine.
| Unless I misunderstand, a RDB uses reflectivity, just not as easily
| mutable reflectivity. You can't just add a new variable on the fly... you
| would have to create a new table, identical to the last + one new column,
| and then transfer all the old data over, adding in the new variable
| somehow.
You can do this quite easily in, for instance, MS DAO/Jet (Access) --
TableDefs("TableName").Fields.Append "FieldName". DAO has
pretty nifty scheme of organizing databases to collections of
objects (a Database is a collection of TableDefs, each of which is
a collection of Fields. A collection is, essentially, a linked
list of objects). You can create and drop tables, fields and
indexes run-time very easily. Access is not very efficient in
physical storage management, but again, this is due to
implementation (Access is a "flat file" database), not design.
MNy
--
I never regret my failures, but I regret every missed opportunity.
</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="msg01190.html">[MUD-Dev] mud-related event: Dr. K...</A></STRONG>
</LI>
<LI>Next by Date:
<STRONG><A HREF="msg01192.html">[MUD-Dev] Re: Databases: was Re: skill system</A></STRONG>
</LI>
<LI>Prev by thread:
<STRONG><A HREF="msg01094.html">[MUD-Dev] Re: Databases: was Re: skill system</A></STRONG>
</LI>
<LI>Next by thread:
<STRONG><A HREF="msg01192.html">[MUD-Dev] Re: Databases: was Re: skill system</A></STRONG>
</LI>
<LI>Index(es):
<UL>
<LI><A HREF="index.html#01191"><STRONG>Date</STRONG></A></LI>
<LI><A HREF="thread.html#01191"><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="01047" HREF="msg01047.html">[MUD-Dev] OT: Announcement</A></strong>,
s001gmu <a href="mailto:s001gmu#nova,wright.edu">s001gmu#nova,wright.edu</a>, Mon 15 Jun 1998, 16:57 GMT
<UL>
<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>
</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>
