How do you handle sequences broken across pages or columns?
The whole sequence is reconstructed according to continuation rules, and the break-point positions and the basis for continuation are recorded. A page break is not treated as two independent sequences, and we do not stitch by length — continuation must have a basis in layout or numbering, otherwise it manufactures two erroneous records.
What do you do when the notation for modified residues is not standardized?
The original representation is kept and a separate normalized field is created, recording the modification type and site. Different documents may write the same modification differently, and normalizing outright would mask the differences — and those differences are often the part downstream users care about most.
Are sequence similarity and sequence identity the same thing?
No. The determination is based on position-by-position alignment; we do not merge things that merely look alike, and differing sites are marked separately. If similar sequences are wrongly merged, downstream loses critical variant information outright.
How do you handle data such as traditional Chinese medicine knowledge bases?
Entities such as herbs, ingredients, targets and diseases are scattered across several source tables; the focus of processing is cross-table linkage and conflict resolution for the same entity, not single-table extraction. The hard part of such tasks is entity alignment, not text recognition.