面向关系型数据与知识图谱的数据集成技术综述

目前,各个国家和地区均已将大数据视为重要的战略资源.然而,大数据时代普遍存在数据流通困难、数据监管不足等问题,致使数据孤岛现象严重,数据质量低下,数据要素潜能难以释放.这驱使研究人员探索数据集成技术,以打破数据壁垒、实现信息共享、提升数据质量,进而激活数据要素潜能.关系型数据和知识图谱作为两种至关重要的数据组织与存储形式,在现实生活中应用广泛.为此,聚焦关系型数据和知识图谱,归纳总结并分析实体解析、数据融合、数据清洗3方面的数据集成关键技术,最后展望未来研究方向与趋势.     

An Efficient Schema Transformation Technique for Data Migration from Relational to Column-Oriented Databases

Data transformation is the core process in migrating database from relational database to NoSQL database such as column-oriented database. However, there is no standard guideline for data transformation from relational database to NoSQL database. A number of schema transformation techniques have been proposed to improve data transformation process and resulted better query processing time when compared to the relational database query processing time. However, these approaches produced redundant tables in the resulted schema that in turn consume large unnecessary storage size and produce high query processing time due to the generated schema with redundant column families in the transformed column-oriented database. In this paper, an efficient data transformation technique from relational database to column-oriented database is proposed. The proposed schema transformation technique is based on the combination of denormalization approach, data access pattern and multiple-nested schema. In order to validate the proposed work, the proposed technique is implemented by transforming data from MySQL database to HBase database. A benchmark transformation technique is also performed in which the query processing time and the storage size are compared. Based on the experimental results, the proposed transformation technique showed significant improvement in terms query processing time and storage space usage due to the reduced number of column families in the column-oriented database.     

Multi-response optimization of the electrical discharge machining of insulating zirconia

In this study, electrical discharge machining has been used to machine insulating zirconia via the assisting electrode method. The process parameter optimization was investigated by combining the Taguchi method with grey relational analysis. The application of Taguchi–grey relational analysis is proven to effectively improve the performance of electrical discharge machining in drilling insulating zirconia. The results of this analysis indicate that the final optimal process parameters are a peak current of 8 A, a pulse duration of 16?µs, a duty cycle of 0.5, and a flushing pressure of 6?MPa. Additionally, the material removal rate, electrode wear rate, and hole taper ratio increase by 39%, 1.5%, and 1.3%, respectively, which improves the grey relational grade by 6.8%. The electrical resistance test confirms that the conductivity of the conductive layer obtained using the final optimal process parameters is better than that of the conductive layer obtained using the initial optimal process parameters. Energy spectrum analysis reveals that the conductive layer is composed of C, Cu, Zn, Zr, and O. Analysis of variance shows that the most significant component of the multi-responses is the peak current, with a 51.4% contribution.     

面向动态模糊数据的关系数据库系统的研究

为使关系数据库系统具备处理动态模糊数据的能力,将动态模糊理论和关系数据库理论相结合,通过分析面向动态模糊数据的关系数据库系统的功能,构造了该数据库的系统结构,探讨了实现该数据库的方法,对面向动态模糊数据的关系数据库系统做了初步的研究。     

iFIX组态软件在污水处理控制系统中的应用

介绍组态软件iFIX在污水控制系统中的应用,提出了系统进行组态过程中的两个主要技术问题,iFIX和关系数据库的通信以及日报表的生成,并给出解决方法。     

浅谈产品设计中的细节意识的重要性

现在,产品设计对大家已不是一个陌生的概念,细节设计体现在产品设计的方方面面,从产品设计之初到设计结束,细节设计一直贯穿在产品设计之中。细节往往决定一件设计的成败,注重细节往往能让我们把想做的事完成的更好。     

Architecture analysis of enterprise systems modifiability - Models, analysis, and validation

Enterprise architecture (EA) models can be used in order to increase the general understanding of enterprise systems and to perform various kinds of analysis. This paper presents instantiated architectural models based on a metamodel for enterprise systems modifiability analysis, i.e. for assessing the cost of making changes to enterprise-wide systems. The instantiated architectural models detailed are based on 21 software change projects conducted at four large Nordic companies. Probabilistic relational models (PRMs) are used for formalizing the EA analysis approach. PRMs enable the combination of regular entity-relationship modeling aspects with means to perform enterprise architecture analysis under uncertainty. The modifiability metamodel employed in the analysis is validated with survey and workshop data (in total 110 experts were surveyed) and with the data collected in the 21 software change projects. Validation indicates that the modifiability metamodel contains the appropriate set of elements. It also indicates that the metamodel produces estimates within a 75% accuracy in 87% of the time and has a mean accuracy of 88% (when considering projects of 2000 man-hours or more).     

XML文档到关系数据库的映射策略

在分析已有数据映射策略的基础上,提出新的XML 文档到关系数据库存储的映射策略和算法,以避免在数据转换过程中丢失信息,解决在查询和重构时因转换结果中关系过多或过少带来的问题。结合实例给出转换后的关系表,从而证明该映射策略能有效处理元素的循环引用,并保留元素之间的结构关系。     

基于遗传算法的关系数据库水印优化算法研究

提出了利用遗传算法在关系数据库海量的元组中选择最优元组进行水印嵌入,实现了水印短时间内的优化嵌入,大大提高了水印嵌入的效率。同时,采用纠错编码技术和投票选取机制来增加水印的鲁棒性。实验结果表明,这种关系数据库水印优化方案大大提高了水印嵌入的效率,并可以较好地协调水印的鲁棒性和数据库可用性之间的矛盾,实现了关系数据库水印的优化。     

首饰设计教学中关于艺术首饰与商业首饰的问题

艺术首饰是完全为艺术而服务的首饰,它本身就是一门艺术,属于纯艺术的范畴,艺术首饰的设计也就成了一种纯艺术活动。商业首饰则是为商业销售而服务的首饰,其创作动机和目的都在于产品的成功销售。高度发达的当代工艺美术正力图打破纯艺术与实用艺术之间的界限,这就为传统意义上的纯艺术和工艺美术建造了一个崭新的发展空间,为艺术首饰与商业首饰的融合提供了基础和可能,也为高校的首饰设计教学带来了新的思路。