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 relation

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,

[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 fil