Experimental results on change data capture methods implementation in different data structures to support real-time data warehouse

Harry Chandra

首页> 外文期刊>International journal of business information systems >Experimental results on change data capture methods implementation in different data structures to support real-time data warehouse

【24h】

Experimental results on change data capture methods implementation in different data structures to support real-time data warehouse

机译：实验结果对不同数据结构中的更改数据捕获方法实现，以支持实时数据仓库

获取原文

获取原文并翻译 | 示例

掌桥外文数据库（机构版） >>

开具论文收录证明 >>

文献代查 >>

页面导航

摘要
著录项
相似文献
相关主题

摘要

The need for rapid decision making in the organisation, causing the importance of developing a real-time data warehouse system. In addition, what also needs to be considered is how to make the extract, transform, load (ETL) processes carried out, would not interfere the performance of the operational database being used. One of the methods that can be used is change data capture. Nowadays, the data sources that companies used for many operations are usually coming from different sources. The proposed research will identified which one is the best change data capture method from three types of methods in three database application for each type of data structure to be tested, that supports the RTDW system making process. From the results of research conducted it is proved that the best change data capture method is different for each type of data source tested in the same environment.

机译：需要在组织中快速决策，从而导致开发实时数据仓库系统的重要性。此外，还需要考虑如何使提取，转换，加载（ETL）进程进行，不会干扰正在使用的操作数据库的性能。可以使用的方法之一是更改数据捕获。如今，用于许多操作的数据来源通常来自不同的来源。拟议的研究将识别哪一个是来自三种数据库应用程序中的三种类型方法的最佳变化数据捕获方法，用于测试每种类型的数据结构，支持RTDW系统制作过程。从研究结果进行了研究，证明了在同一环境中测试的每种类型的数据源不同的变化数据捕获方法是不同的。

著录项

来源
《International journal of business information systems》 |2020年第3期|373-402|共30页
作者
Harry Chandra;
展开▼
作者单位

School of Electrical Engineering and Informatics Institut Teknologi Bandung;

展开▼
收录信息
原文格式 PDF
正文语种 eng
中图分类
关键词
real-time data warehouse; RTDW; extract; transform; load; ETL; change data capture; data structures model; log-based; timestamp on file; timestamp on rows; trigger; replication;

机译：实时数据仓库;RTDW;提取;转换;加载;ETL;更改数据捕获;数据结构模型;基于日志;文件上的时间戳;时间戳;触发器上的时间戳;触发;复制;复制;

相似文献

外文文献
中文文献
专利

1. A rewrite/merge approach for supporting real-time data warehousing via lightweight data integration [J] . Cuzzocrea Alfredo, Ferreira Nickerson, Furtado Pedro Journal of supercomputing . 2020,第5期

机译：通过轻量级数据集成支持实时数据仓储的重写/合并方法
2. Coqlin Mill Updates Solution for Data Warehouse, Change Data Capture, and ETL on IBM i [J] . System iNEWS . 2012,第2期

机译：Coqlin Mill更新了IBM i上的数据仓库，变更数据捕获和ETL解决方案
3. Data Missing Mechanism and Missing Data Real-Time Processing Methods in the Construction Monitoring of Steel Structures [J] . Luo Y. F., Ye Z. W., Guo X. N., Advances in Structural Engineering . 2015,第4期

机译：钢结构施工监测中的数据遗漏机理及数据遗漏实时处理方法
4. Study on Log-Based Change Data Capture and Handling Mechanism in Real-Time Data Warehouse [C] . Shi JinGang, Bao YuBin, Leng FangLing, International Conference on Computer Science and Software Engineering . 2008

机译：实时数据仓库中基于日志的更改数据捕获和处理机制研究
5. Design and implementation of an institutional data warehouse from a decision support perspective. [D] . Denis, Marie-Chantal. 2008

机译：从决策支持的角度设计和实施机构数据仓库。
6. PS2-37: Design Considerations and Population Identification for Implementing a Dental Virtual Data Warehouse: Feasibility Table Structure and Data Elements [O] . Jay Fuehrer, Aaron Miller, Jimmy Kayastha, 2012

机译：PS2-37：实施牙科虚拟数据仓库的设计考虑因素和总体标识：可行性表结构和数据元素
7. ABSTRACT Various body parts or organs can be analysed to identify the different diseases in the human body. Fingernail analysis is one of the ways to identify disease in the human body. Nails are the body part which are farthest from the heart and therefore receive oxygen at last. As a result the nails are the first who show the symptoms of a disease in the human body. Fingernails can be easily captured for diagnosis and there are no heavy equipment or no specific conditions required to use nail image for disease diagnosis, like in other tests and scanning processes. Human nails deliver beneficial information about complaints or any nutritive imbalances in the human body depending upon their shape, texture and colour. In human beings, numerous systemic and skin diseases can be easily analyzed through careful examination of nails of both the limbs. A lot of nail illnesses have been found to be primary signs of numerous underlying systemic illnesses. The colour, texture or shape changes in nails are signs of many diseases mainly affecting nails. Considering all these properties of nails a system is proposed that uses digital image processing (DIP) methods for identifying such changes in the human nail to get more precise results and predict numerous diseases effortlessly. With the emerging Internet of Things (IOT) concept the generated report is made available remotely, this will help users to reduce transportation efforts. As the system has to deal with large and private data, the security of data must be ensured. To keep the data confidential, the Blockchain concept which is one of the most emerging concepts in the field of data management is used. The paper contains the implementation of the digital image processing for feature extraction of nail images, usage of IOT (ThingSpeak cloud) for data storage and implementation of Blockchain to keep the system secured and theft free. KEY WORDS: Int ernet of thin gs (IOT), Image proc essin g, Thin gSpeak, RG B vavalues, Mean pi xel vavalues, Bloc kchain , Hash key. Disease Diagnostic System: Abnormalities in Human Nail [O] . Pranav S. Wazarkar 2020

机译：摘要的各个身体部位或器官可被分析以识别在人体内的不同的疾病。指甲分析来识别人体疾病的方法之一。指甲是身体一部分是离心脏最远，因此在最后接受氧气。作为结果，指甲是第一谁表现出人体疾病的症状。指甲可以容易地捕获用于诊断和没有重装或需要使用指甲图像用于疾病诊断，比如在其他测试和扫描过程没有特定的条件。人的指甲提供有关投诉或取决于它们的形状，纹理和色彩在人体内的任何营养失衡有益的信息。在人类中，许多全身性皮肤疾病是可以很容易地通过两个四肢指甲的仔细检查分析。很多指甲病已发现众多潜在系统性疾病的主要症状。在指甲的颜色，质地和形状的变化是许多疾病主要影响指甲的迹象。考虑到所有的指甲的这些性能的系统被提出，用于识别人指甲这样的变化以获得更精确的结果，并毫不费力预测许多疾病用途的数字图像处理（DIP）方法。随着物联网（IOT）的概念，新兴的互联网将生成的报告提供远程，这将帮助用户降低运输工作。由于系统必须处理大量的私人数据，数据的安全性必须得到保证。为了保持数据的机密性，使用Blockchain的概念，它是在数据管理领域的大多数新兴的概念之一。本文包含了数字图像处理的指甲图像，IOT（ThingSpeak云）的使用为数据存储和执行Blockchain的特征提取的执行，以保持固定的系统和盗窃免费。关键词：诠释薄GS（IOT），图像的ERNET PROC essin克，薄型gSpeak，RG乙vavalues，平均数PI XEL vavalues，阵营kchain，哈希密钥。疾病诊断系统：在人类指甲异常
8. Federal Implementation Guideline for Electronic Data Interchange: ASC X12 003050Transaction Set 848S Material Safety Data Sheet (Semi-Structured). Implementation Convention [R] . Favreau, J. P. 1998

机译：联邦电子数据交换实施指南：asC X12 003050Transaction set 848s材料安全数据表（半结构）。执行公约

Experimental results on change data capture methods implementation in different data structures to support real-time data warehouse

摘要

著录项

相似文献

相关主题

期刊订阅