I am importing information from various source systems and putting them into local databases for reporting. For example, one of the sources is Google Analytics.
Here are some attributes of this import process:
- I am collecting data from the source system (e.g. Google Analytics).
- The data goes into my local database.
- The data flows in one direction, i.e. the only write access on the local database is the importer process.
- The local database is a view of the source system. i.e. it is not a full-fidelity copy of the upstream database.
Given these attributes, would my local database be called a data mart, data vault or data warehouse?
This word choice is important to me because our company will be publishing our tools as open source. If we describe what our tool does using the best industry-accepted terminology then it will be more valuable.