database design
- inverted vector database: each FCN is a record (census)
- spreadsheet: (one) (songs, MyMusic, iTunes)
- spreadsheet: or multiple sheets/FCNs in a spreadsheet with consistent field structures (e.g. general ledger), each FCN is a month.
- relational db: each table/FCN is a dataset with a key field, fields can be different in each FCN (movies.sf).
