that are at the same level in the classificatory hierarchy. For example, instead of (two categories of)
(a) torture, and (b) beating, a list should be created that has torture with various sub-categories,
such as beating and electric shocks, etc.45 This is already a fairly well-established practice in some
Zimbabwean organisations involved in human rights data collection. Other lists of controlled
vocabulary would include amongst others, regions of the country, State security agencies and proxy
forces and so on.
It is important to remember that data processors apply the definitional decisions to the raw
information that is available. This is the point at which there must be as much standardisation and
consistency in terms of interpretation and definition – and the project management will have to
assess the integrity of the coding process on an ongoing basis. This also underscores the importance
of ensuring comprehensive training and ‘dummy runs’ before the processing is initiated.
This is tiring and time-consuming work. If the controlled vocabulary is complicated, the data
processing will be much slower. This will obviously impact on the time taken to complete the
project. At this stage it is impossible to give an accurate prediction on how long it would take to
process 7,000 statements or to sufficiently train a team of coders and processors. A very general
estimate based on previous experiences would be that ten data processors would take between four
to six months to complete the task. This would probably be at the slower end of the ‘market’. This
involves coding, as well as entering the data into the database. In many projects, these functions are
separated. It took eight data coders and five processors over 15 months to process 8000 statements
in Timor Leste, yet elsewhere others have argued that at ‘full steam’ a data processor can process as
many as 10 to 12 statements a day. “As a very general rule of thumb, one data processor can do as
many interviews in a day as an interviewer can do in a week.”46
Database representation
The database must be able to represent all the information in the processed data, and must be able
to produce the analytical reports that you are seeking to engage. In other words, it will be necessary
to draw up a list of questions that you think the available data should be able to address.
Having the data already available, however, does allow for the database design and construction
process to be more tailored around the existing information sources. In this regard, it would be
necessary to take samples of individual cases (narratives and so on) to determine exactly what detail
of information has been captured. Inevitably, large-scale databases often require further changes
to the database design as additional fields of information are identified. This is often an ongoing
process in situations where the data is being gathered from scratch. In this scenario, however, much
of this can be avoided from the initial stages of the project.
It is recommended that the project engage a professional human rights relational database design
expert to facilitate the database design process.47 The project will need an in-house database
programmer to handle the plethora of issues that inevitably arise. The project should consider how
best the external professional can impart skills and expertise to the in-house programmer.
45
ibid., p. 33.
ibid., p. 74.
47
A more detailed exposition of database design is available on request.
46
37
Select target paragraph3
Add to table of contents