Bugs item #482977, was opened at 2001-11-17 19:47
You can respond by visiting:
http://sourceforge.net/tracker/?func=detail&atid=390117&aid=482977&group_id=27350
Category: Database interface
Group: current cvs
>Status: Closed
>Resolution: Wont Fix
Priority: 5
Submitted By: Malcolm Box (mbox)
Assigned to: Malcolm Box (mbox)
Summary: declarations table not in 1NF
Initial Comment:
The new declarations table is joined to indexes via
declid and langid. But currently declid is globally
unique, so the langid field in indexes is redundant,
though it might speed up language based searching.
If declid was made non-unique across languages it would
mean that languages could manage their own namespace
without having to get a declid assigned from the
database. However, having it unique makes the indexes
lookup faster.
----------------------------------------------------------------------
>Comment By: Malcolm Box (mbox)
Date: 2001-12-06 06:40
Message:
Logged In: YES
user_id=215386
The table is normalised if you consider the tuple (langid,
declid) to be the key. Currently declid is globally unique,
but this may change.
The design is cleaner as it is, so NGTF
----------------------------------------------------------------------
You can respond by visiting:
http://sourceforge.net/tracker/?func=detail&atid=390117&aid=482977&group_id=27350
|
