Febri Dwiandriani, T. F. Kusumasari, M. A. Hasibuan
{"title":"Fingerprint clustering algorithm for data profiling using pentaho data integration","authors":"Febri Dwiandriani, T. F. Kusumasari, M. A. Hasibuan","doi":"10.1109/ICITISEE.2017.8285528","DOIUrl":null,"url":null,"abstract":"Data profiling is an abnormality in the search process data that undermine the value of the data. Type of data profiling analysis techniques to detect duplication of text within a single paragraph can by using a text cluster. In this paper aims at doing text algorithm transformation cluster with fingerprint method using Pentaho Data Integration (PDI). As for methods used to conduct implementation text cluster with Pentaho Data Integration is to do a mapping algorithm fingerprint method on component contained in Pentaho, then perform a transformation per component, and further evaluation of the results of a text cluster with open source data profiling tool. Implementation of text clusters with Pentaho Data Integration successfully done but there is still some rudimentary logic. The results from implementation of clusters number on the transformation by using Pentaho Data Integration is greater than a number of text clusters by using the OpenRefine tool.","PeriodicalId":130873,"journal":{"name":"2017 2nd International conferences on Information Technology, Information Systems and Electrical Engineering (ICITISEE)","volume":"189 1","pages":"0"},"PeriodicalIF":0.0000,"publicationDate":"2017-11-01","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"4","resultStr":null,"platform":"Semanticscholar","paperid":null,"PeriodicalName":"2017 2nd International conferences on Information Technology, Information Systems and Electrical Engineering (ICITISEE)","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.1109/ICITISEE.2017.8285528","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}
引用次数: 4
Abstract
Data profiling is an abnormality in the search process data that undermine the value of the data. Type of data profiling analysis techniques to detect duplication of text within a single paragraph can by using a text cluster. In this paper aims at doing text algorithm transformation cluster with fingerprint method using Pentaho Data Integration (PDI). As for methods used to conduct implementation text cluster with Pentaho Data Integration is to do a mapping algorithm fingerprint method on component contained in Pentaho, then perform a transformation per component, and further evaluation of the results of a text cluster with open source data profiling tool. Implementation of text clusters with Pentaho Data Integration successfully done but there is still some rudimentary logic. The results from implementation of clusters number on the transformation by using Pentaho Data Integration is greater than a number of text clusters by using the OpenRefine tool.
数据剖析是在数据搜索过程中出现的一种异常现象,它破坏了数据的价值。类型的数据分析技术可以通过使用文本聚类来检测单个段落中的重复文本。本文的目的是利用Pentaho Data Integration (PDI)对指纹方法进行文本算法转换聚类。使用Pentaho Data Integration实现文本聚类的方法是对Pentaho中包含的组件做映射算法指纹方法,然后对每个组件进行转换,再使用开源数据分析工具对文本聚类的结果进行进一步评估。使用Pentaho Data Integration成功地实现了文本集群,但仍然存在一些基本的逻辑。使用Pentaho Data Integration实现簇数转换的结果大于使用OpenRefine工具实现的文本簇数转换的结果。