Persistence in Data Warehousing
Persistence in Data Warehousing
复制标题
数据仓库的持久性
DOI：
--
复制
发表时间：
2012
期刊：
影响因子：
--
通讯作者：
V. Köppen
中科院分区：
文献类型：
--
作者：
Thorsten Winsemann;V. Köppen
在访问数据进行分析和报告时，数据仓库中冗余数据的持久性通常是合理的。但是，还有其他原因可以持续存储数据，在设计数据仓库时通常不会识别出数据。由于数据的处理和维护是复杂的，需要巨大的努力，因此冗余的量度降低了。最新的内存技术可为数据访问提供良好的响应时间。这是出现的问题，什么是为了持续存储哪些目的的数据。我们提出了用于数据持久性的目的汇编，并将其用作决策是否存储数据的基础。
Persistence of redundant data in Data Warehouses is often simply justified with an achievement of better performance when accessing data for analysis and reporting. However, there are other reasons to store data persistently, which are often not recognized when designing Data Warehouses. As processing and maintenance of data is complex and requires huge effort, less redundancy downsizes effort. Latest in-memory technologies enable good response times for data access. That arises the question, what data for what purposes really need to be stored persistently. We present a compendium of purposes for data persistence and use it as a basis for decision-making whether to store data or not.