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.     

双活塞式压力计准确度等级的确定

双活塞式压力计基于不同结构可分为双活塞式压力真空计和双量程活塞式压力计两种。针对后者的结构特点,分析两套活塞系统共用一套砝码的问题,根据活塞的参数以及专用砝码质量计算出标称值下的实际压力值。本研究根据不同压力量程段来划分活塞式压力计的准确度等级,实现活塞式压力计的溯源性校准,以保证压力量传中的准确性和一致性。     

新型军械装备损坏程度评估方法研究

根据新型军械装备损坏程度具有不确定性的特点,提出了基于D-S证据理论的新型军械装备损坏程度评估方法,并求出了新型军械装备损坏程度区分.通过对典型新型军械装备损坏程度的评估,验证了该方法的有效性和实用性.     

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

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

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

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

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

广告制胜的先决要素——视觉强度

视觉强度是所有诉诸视觉的艺术和设计追求的目的之一。广告是视觉艺术。若要释放这股强劲的潜能,视觉强度是视觉力量的保证。视觉强度,即对于视觉客体来说,是指对视觉主体的刺激或冲击程度;对于视觉主体来说,是指接受视觉对象刺激或冲击的强度,也称视觉感知度。一个人对不同的视觉对象产生不同的视觉感知度,而同一个视觉客体对不同人也可产生不同的冲击或刺激程度。空间与时间的差异也可引起视觉强度的差异。