10: The Mnemonic Dictionary

While the primary purpose of spreadsheet disambiguation is to extract context and values from spreadsheet data, there is another valuable byproduct. The process allows the creation of a data dictionary of terms that are found on the spreadsheets. The dictionary that contains these terms can be called the “mnemonic dictionary”.

The purpose of the mnemonic dictionary is to catalog the metadata that is found on all the spreadsheets that participate in corporate data. The mnemonic dictionary is concerned only with metadata from spreadsheets that are destined for corporate data. On the other hand, the corporate database is concerned with both context and values of this data.