Database definition

The design is focused on lowering the IT barrier for non-expert and avoiding complex systems. The structure might change as the works progresses and new requirements arise.

There are two table classes:

Verbatim

It contains exactly the sources data, such as from the Abecedarium B, though with some additional encoding; for example, in addition to transcribe the note latine, the language code la must put in the key lang to facilitate machine processing.
Example: abc_b

Transformed

Created from verbatim tables or other sources.
Example: work

The Repositorios data are stored in a simple directory structure; the term "database" is abused to designate this structure. Files are plain text contarining key-value pair; example, 397vb2, meaning: sheet 397, verso, right column, second entry. Collections of key-value pairs are also combined into one single file as record-jar format; example, for the structure of the Abecedarium B.

Relevant data in the directory structure "database" is converted into SQLite, a proper database, with normalised data, no data repetition. Data is gathered and presented together as required, such a view combining data from work and person.

The naming convention follows the Catálogo Concordado (column 2), lower case, no accents, and using the character _ as separator in place of a blank space; also, for the abc_b and reg_b it has been extended to accommodate the additional structure.

Structure of the Abecedarium B is well advanced. The table reg_b1 must be verbatim, but it is not at present. It contains data from the Lagarto Project.