Hi Keith and list,
The "problem" was in efficiency, not operation. The data could be
configured and managed in a relational system but we had to write
absolutely baroque SQL in order to get the equivalent of a single
find...follow statement.
Flexibility is also an important element of
efficiency for us. The nature of our projects can be fairly fluid. We
haven't found an equivalent to changing our acedb model in order to
morph the database in the relational world. Our concept of how to
accomplish this project had changed substantially since the original
pilot and it caused major dislocations.
Hope that helps,
Sara
> Could I enquire as to what problems you had using a relational
database?
> Our group heavily uses acedb at the moment but we are looking into the
> *possibilities* of whether our data could also be stored in a
relational
> database.
>> Were there any *general* problems with relational databases that you
were
> having where acedb proved superior?
>> Regards,
>> Keith
>> ~ Keith Bradnam - UK CropNet (http://ukcrop.net) webmaster and
> ~ Arabidopsis Genome Resource (http://ukcrop.net/agr) developer.
> ~
> ~ Nottingham Arabidopsis Stock Centre, University Park,
> ~ University of Nottingham, NG7 2RD, UK. Tel: (0115) 951 3091
>>
Sent via Deja.com
http://www.deja.com/
