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: Wed Jul 17 2002 - 08:54:36 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 813F815904 for <cavexml-outgoing_at_ethz.ch>; Thu, 18 Jul 2002 11:03:17 +0200 (CEST)
Received: by karmail.ethz.ch (Postfix on SuSE eMail Server 2.0, from userid 28) id 554D3157AB; Thu, 18 Jul 2002 11:03:15 +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 4114615904 for <cavexml-loopcheck_at_ethz.ch>; Thu, 18 Jul 2002 11:03:14 +0200 (CEST)
Received: by karmail.ethz.ch (Postfix on SuSE eMail Server 2.0, from userid 96) id 2147614BA1; Thu, 18 Jul 2002 11:03:12 +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 D80FC15904 for <cavexml_at_cartography.ch>; Thu, 18 Jul 2002 11:03:11 +0200 (CEST)
Received: from relay1.melbpc.org.au (newglider.melbpc.org.au [203.12.152.9]) by karmail.ethz.ch (Postfix on SuSE eMail Server 2.0) with ESMTP id 6BB9B14A7E for <cavexml_at_cartography.ch>; Thu, 18 Jul 2002 11:03:08 +0200 (CEST)
Received: from localhost.melbpc.org.au (localhost.melbpc.org.au [127.0.0.1]) by relay1.melbpc.org.au (8.12.5/8.11.6) with ESMTP id g6I8lIwl015522 for <cavexml_at_cartography.ch>; Thu, 18 Jul 2002 18:47:20 +1000 (EST) (envelope-from matthews_at_melbpc.org.au)
Content-Type: text/plain; charset="us-ascii"; format=flowed
Date: Wed, 17 Jul 2002 16:54:36 +1000
From: Peter MATTHEWS <matthews_at_melbpc.org.au>
In-Reply-To: <20020716151729.AA81B157C0_at_karmail.ethz.ch>
Message-Id: <5.1.0.14.1.20020717115522.01d490d0@popa.melbpc.org.au>
Received: from relay1.melbpc.org.au (localhost.melbpc.org.au [127.0.0.1]) by localhost.melbpc.org.au (AvMailGate-2.0.0.6) id 29845-0A31A1F8; Wed, 17 Jul 2002 17:01:03 +1000
Received: from peter.melbpc.org.au (a1-29.melbpc.org.au [203.12.158.29]) by relay1.melbpc.org.au (8.12.3/8.11.6) with ESMTP id g6H710sm029842 for <cavexml_at_cartography.ch>; Wed, 17 Jul 2002 17:01:02 +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


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