Entities and fields

New Message Reply About this list Date view Thread view Subject view Author view

From: Peter MATTHEWS (matthews_at_melbpc.org.au)
Date: Thu Jul 18 2002 - 09:43:35 CEST


Return-Path: <owner-cavexml-outgoing_at_ethz.ch>
Delivered-To: cavexml-archive_at_cartography.ch
Received: from localhost (localhost [127.0.0.1]) by karmail.ethz.ch (Postfix on SuSE eMail Server 2.0) with ESMTP id D393C15904 for <cavexml-outgoing_at_ethz.ch>; Thu, 18 Jul 2002 09:59:48 +0200 (CEST)
Received: by karmail.ethz.ch (Postfix on SuSE eMail Server 2.0, from userid 28) id AAEF315800; Thu, 18 Jul 2002 09:59:46 +0200 (CEST)
Delivered-To: cavexml-loopcheck_at_ethz.ch
Received: from localhost (localhost [127.0.0.1]) by karmail.ethz.ch (Postfix on SuSE eMail Server 2.0) with ESMTP id 96C4815904 for <cavexml-loopcheck_at_ethz.ch>; Thu, 18 Jul 2002 09:59:45 +0200 (CEST)
Received: by karmail.ethz.ch (Postfix on SuSE eMail Server 2.0, from userid 96) id 72E231341D; Thu, 18 Jul 2002 09:59:43 +0200 (CEST)
Delivered-To: cavexml_at_cartography.ch
Received: from localhost (localhost [127.0.0.1]) by karmail.ethz.ch (Postfix on SuSE eMail Server 2.0) with ESMTP id 2845215904 for <cavexml_at_cartography.ch>; Thu, 18 Jul 2002 09:59:43 +0200 (CEST)
Received: from koala.melbpc.org.au (koala.melbpc.org.au [203.12.152.23]) by karmail.ethz.ch (Postfix on SuSE eMail Server 2.0) with ESMTP id 9DF477EB1 for <cavexml_at_cartography.ch>; Thu, 18 Jul 2002 09:59:39 +0200 (CEST)
Received: from localhost.melbpc.org.au (localhost.melbpc.org.au [127.0.0.1]) by koala.melbpc.org.au (8.12.3/8.11.6) with ESMTP id g6I7hFwq023025 for <cavexml_at_cartography.ch>; Thu, 18 Jul 2002 17:43:15 +1000 (EST) (envelope-from matthews_at_melbpc.org.au)
Content-Type: text/plain; charset="us-ascii"; format=flowed
Date: Thu, 18 Jul 2002 17:43:35 +1000
From: Peter MATTHEWS <matthews_at_melbpc.org.au>
Message-Id: <5.1.0.14.1.20020718174220.01d6d5a0@popa.melbpc.org.au>
Received: from koala.melbpc.org.au (localhost.melbpc.org.au [127.0.0.1]) by localhost.melbpc.org.au (AvMailGate-2.0.0.6) id 23003-4E37227A; Thu, 18 Jul 2002 17:42:55 +1000
Received: from peter.melbpc.org.au (a2-79.melbpc.org.au [203.12.157.79]) by koala.melbpc.org.au (8.12.3/8.11.6) with ESMTP id g6I7grut022990 for <cavexml_at_cartography.ch>; Thu, 18 Jul 2002 17:42:54 +1000 (EST) (envelope-from matthews_at_melbpc.org.au)
Subject: Entities and fields
To: cavexml_at_cartography.ch
X-Mailer: QUALCOMM Windows Eudora Version 5.1
X-Sender: matthews_at_popa.melbpc.org.au
X-Loop: cavexml
Sender: owner-cavexml_at_karmail.ethz.ch
Precedence: bulk
Reply-To: cavexml_at_cartography.ch
X-Virus-Scanned: by AMaViS perl-11

I sent this yesterday but it did not seem to reach the list, so here it is
again. Apologies if you got it twice.

Peter
==============================================================
At 18:27 10-07-02 -0400, Richard Knapp wrote:
>One thing I'm having trouble in reading the model is differentiating
>between attributes and child entities. What exactly is a field?
[snip]

and

At 11:06 16-07-02 -0400, Richard Knapp wrote:
>On Tue, 16 Jul 2002 17:50:27 +1000, Peter MATTHEWS wrote:
>
>[snip]
> > What we are actually trying to get to is definitively finding out all the
> > data fields we need to consider when we design the XML part, and, just
> as ...
>
>... and Elements.

This flags up that I should have included some more definitions under
"Other Definitions", especially as XML's use of terms is different to
normal database use of terms. I have deliberately used the db term "field"
instead of the db term "attribute" because XML uses the term attribute in a
very specific way which is too restrictive at this stage of our
discussions. XML also uses the term "entity" in a specialised way quite
differently to normal English usage of the term and to db usage of the
term. We can revert to XML usage when we come to designing the XML itself.

While discussing the data model my usage has therefore corresponded to
normal usage of the terms "field" and "entity", so I propose adding their
definitions to the "Other Definitions" section as follows to make that clearer:

Entity
   A real-world thing, event or concept that we want to record data about.
These are
   represented by the squares in the diagram. Examples are Cave,
Instrument, Trip.

Field
   A property of an Entity. In a database table, the fields are normally
represented by
   the columns in the table. For example, "start date" is a field of the
entity "trip",
   so in a table which listed trips, [Start Date] would be one of the
columns. Fields
   are not being shown in the diagram, but will be listed out when we come
to discuss
   them in detail in Task 6.3. In an XML file, any particular field would
be represented
   either as an "element" or sub-element in its own right, or as an
"attribute" of another
   element, depending on various considerations about that field.

Comments on these definitions? Are they acceptable at this stage?

Peter


New Message Reply About this list Date view Thread view Subject view Author view

This archive was generated by hypermail 2b30 : Wed Jul 31 2002 - 23:00:00 CEST