2. You ask:
==========
speaking about the data model: for the next edition of wals online, we
will add examples. i wonder, how you model these in sswl. i've seen
that you have these triplets (phrase, gloss, translation). do you also
have some sort of alignment between the parts of phrase and gloss? in
our data i've also found cases of multiple translations for the same
phrase. does your data model allow this?
=========
Each example for language L has a sentence number (also known
as example number).
In the examples table there are multiple rows with the same sentence number,
one for phrase, one for gloss, one for translation, and then zero or
more with property-values that the example illustrates.
So, it's easy to add new property-values to examples.
A property alternatetranslation would be entirely possible (the
data model doesn't care).
Phrase and gloss are aligned because there is a gloss element
for every phrase.
3.
=============
another thing i noticed: the URLs for your language pages are formed
with the name of the language. are you expecting to keep these URLs
stable over time? with wals we had to change language names quite a
bit, so abstracting the URL from the name may be useful.
============
We are generating the pages on the fly every few minutes, so the worst
thing that would happen if we changed the name of a language is that
there would still be a page with the old language name.
This doesn't seem to me to be a problem.
3.
=========
>
> Our data format is very simple.
> We have three main tables in our mysql database:
>
> In every case, we use the schema technique "property-as-value".
> Thus if someone adds a new property P into properties
> and then wants to apply that to language L, that person would
> simply insert:
>
> L, P, Yes into the languages table (there are other fields, but
> these are the essential one).
i see. so the properties are basically boolean (with the additon of
"not applicable"). so each single value of a feature (in wals speak)
would be a property in sswl, e.g the values of
http://wals.info/feature/112 would translate to properties like "has
Negative affix for negative morphemes", ... right?
============
Yes, that is correct I think but Chris should confirm.
4.
==============
if that's the case, do you consider allowing grouping of properties?
with wals we still stick to the values of the 2005 edition, which
seems sometimes too coarse. e.g. for feature "consonant inventories"
(http://wals.info/feature/1) it would seem more appropriate to simply
store the number of consonants, and leave the decision about a
grouping ("small", "moderately small", ...) to some output logic. the
case of numeric values for properties doesn't seem to fit well into
your model, though.
===============
We don't know of a good property hierarchy. If you have one, we're interested.
5.
===========
anyway, it's intersting to see your project evolve; and it's certainly
good to have people around dealing with the same kind of data :)
best regards,
robert
=========
Agreed. Warm Regards, Dennis