In Summary
The processes of spreadsheet disambiguation produce a working database known as the “intermediate database”. The intermediate database consists of the following elements:
- • Spreadsheet system name
- • Row identifier
- • Column name
- • Value
- • Date of processing
- • Alternate name (optional)
The intermediate database is a working file. It can be edited, have data deleted, have alternate names added, and so forth. The alternate name allows disparate data elements to be grouped together. In addition, the alternate name allows for a bridge for other corporate data to be created.
The intermediate database serves as a basis for further processing.