Single point of truth
Single Point of Truth ( SPOT ) (also Single Source of Truth SSOT ) German "the single point of truth" is a principle in software technology to have a general database that claims to be correct and that one can rely on can leave. A data model in which a generally valid database is to be made available, with the necessary data quality and reliability, is especially important when data is kept redundant.
Data warehouses contain copied and thus redundant data. Your content with data extracted from any data sources and, if necessary, refined through cleansing and transformation, can be fully or partially defined as a single point of truth. If all evaluations (analyzes and other applications) use this integrated database, it is possible to avoid contradicting statements.
For the practical implementation of the SPOT principle, there are functional and technical requirements , whereby the functional (or business) requirements are often greater than the requirements for IT. Since the data warehouse in which the SPOT data model is represented has to provide certain technical functions, it is necessary for someone to define these functions as requirements from a technical point of view. To do this, z. For example, it should be made clear from which systems data are taken and which perspectives should be used.
While the SPOT principle deals with (intentional) redundancy , the don't-repeat-yourself principle aims to avoid redundancy.
See also
literature
- Manfred Soeffky: Data Warehouse: Process and System Management . it-research, 1998.
Web links
- SPOT in data warehousing (PDF; 361 kB)
Individual evidence
- ↑ Reinhard Bär: Lean reporting: Optimizing the efficiency in reporting . Springer Fachmedien Wiesbaden, 2014, ISBN 978-3-8348-2292-5 .