Re: [GENERAL] Design advice requested

2013-05-09 Thread Julian
On 09/05/13 17:42, Johann Spies wrote: Hallo Julian, Thanks for your reply. Firstly, don't worry too much about speed in the design phase, there may be differences of opinion here, but mine is that even with database design the first fundamental layer is the relationship

[GENERAL] Design advice requested

2013-05-08 Thread Johann Spies
Apologies for the long email. I would appreciate some advice designing a database which can become very complicated. The purpose of the database is to be a source for bibliometric research. Some background: I work with various sources: * The largest source consists of tagged delimited text

Re: [GENERAL] Design advice requested

2013-05-08 Thread Julian
On 08/05/13 21:21, Johann Spies wrote: Basically my request is for advice on how to make this database as fast as possible with as few instances of duplicated data while providing both for the updates on level 0 and value added editing on level 1. Regards Johann Hi Johann. Firstly, don't