With regard to how you store your data in a standardised format I would suggest you consider CSV files.
in reply to Strategy for simple data management
- Easy to manipulate with Perl:
- Easy to import and export to/from spreadsheets.
- Easy to backup - you can store them on a thumb drive or optical media.
- Easy to 'debug' - when you encounter problems with your data you can open your file with a text editor and see exactly what data you have.
- Easy to share via email or in the cloud.