According to Wikipedia a single version of the truth is described as “is a technical concept describing the data warehousing ideal of having either a single centralised database, or at least a distributed synchronised database, which stores all of an organisation’s data in a consistent and non-redundant form“
A single source of the truth is described as “refers to a data storage principle to always source a particular piece of information from one place“
- What is the difference between a single centralized database and to source information from one place?
- What does it mean to store data is a “consistent” and “non-redundant form”?
- How does relate to scenarios when data is stored in multiple sources which are then coalesced?
- In contrast how do you describe when you are attempting to have consistent definitions e.g. The definition of a customer in one source is the same in another source?
2