[Lexicog] Digest Number 343

[Mike Sangrey]

On Sat, 2005-05-21 at 22:45 +0800, Allan Johnson wrote:
<snip>
> And a similar question - could a database be designed that would allow both
> a Standard MDF view and a PLB view (or Alternate MDF view) of the same
> data?

I think so.  You create tables that contain the lowest level items as
objects (in the object-oriented sense) and store all the raw data in
these tables.  Then, you create views (possibly compiled--as in
denormalized--into tables) that capture the different ways you want to
related the data.  These views would be hierarchical in your case.  You
would need to tie the relationships together with triggers so that as
entries are added or removed or changed, the relationships are
maintained.  Lastly, when the dictionary is finished, you could create
tables that better capture exactly the view (or views) you wish to place
on the data and users would access these tables.  This will work well
since the database is quite static at that point.  And note that this
will only be needed if one has to have high performance access relative
to the hardware one can afford.

That probably isn't that clear; but the basic idea is that access to the
raw data is always through tables which relate that data.  The tables
that relate the data are built according to the hierarchies as you've
defined them above.

> I think this is similar to a problem that was brought up by Michael
> Paul Johnson on another list, talking about XML Scripture formats and two
> competing hierarchies (paragraph-oriented and verse-oriented) that both
> need to be supported in a single database.  It seems that that had a
> workable solution, so maybe there's a way...
>
> Allan
>

--
Mike Sangrey
msangrey AT BlueFeltHat.org
Landisburg, Pa.
                        "The first one last wins."
            "A net of highly cohesive details reveals the truth."



------------------------ Yahoo! Groups Sponsor --------------------~-->
What would our lives be like without music, dance, and theater?
Donate or volunteer in the arts today at Network for Good!
http://us.click.yahoo.com/TzSHvD/SOnJAA/79vVAA/HKE4lB/TM
--------------------------------------------------------------------~->


Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/lexicographylist/

<*> To unsubscribe from this group, send an email to:
    lexicographylist-unsubscribe at yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/