Re: [edict-jmdict] interworking of database submissions and maintenance

[Jim Breen <Jim.Breen@**********************>]

[wmaton ([edict-jmdict] interworking of database submissions and maintenance) writes:]
>> I was thinking that the forms used to submit things into the database
>> and the one used to maintain them are separate, so would it be a good
>> idea to keep a database for each form?

Well, for adding new entries, I feel there are at least 3 mechanisms/forms:

- a simple form for straightfoward entries. Maybe a bit like the
present one at http://www.csse.monash.edu.au/~jwb/wwwnewword.html
although it might be a simpler one-kanji, one-reading version;

- a more complex form for more complex entries

- an offline bulk-entry format whereby a major contributor could build
entries on their own system and upload them for inclusion in the edit process.

Most edits involve changing the translation(s). The next most common changes
are things like adding alternative readings, adding a "uk", etc.
That suggest a hierarchy of edit forms.

>> Here's what I'm thinking:  The master data will be reachable through
>> the maintenace/administrative interface that editors will use for
>> corrections and such.  To prevent a casual (non-expert) user from
>> 'polluting' the database, maybe those should go into a separate, but
>> like-structured database?  
>>   Then an editor could go through that, and
>> if they are happy with the content, commit the chosen entries to the
>> master database.  The 'submissions' database would of course be
>> emptied upon committing to the master database.

Pretty much what I enviaged, but to me that doesn't imply a 
"database for each form"; just an empty database of the same structure
for holding submitted/modified entries awaiting approval.

>> The only down side would be the added work of having two databases,
>> but I think that's a minor thing compared to the system as a whole.

Very minor, I'd think.

Jim

-- 
Jim Breen                                http://www.csse.monash.edu.au/~jwb/
Clayton School of Information Technology,               Tel: +61 3 9905 9554
Monash University, VIC 3800, Australia                  Fax: +61 3 9905 5146
(Monash Provider No. 00008C)                ジム・ブリーン@モナシュ大学