OLAP query algorithm based on real-time semantic dimension hierarchical

Computer Engineering and Applications ›› 2012, Vol. 48 ›› Issue (4): 149-151.

• 数据库、信号与信息处理 • Previous Articles Next Articles

OLAP query algorithm based on real-time semantic dimension hierarchical

REN Feng, CAO Dun, FU Ming

College of Computer and Communication, Changsha University of Science & Technology, Changsha 410114, China

Received:1900-01-01 Revised:1900-01-01 Online:2012-02-01 Published:2012-04-05

一种基于实时语义维层次链的OLAP查询算法

任凤，曹敦，傅明

长沙理工大学计算机与通信学院，长沙 410114

Abstract

Abstract: Nowadays, the result of OLAP query obtains from all other clients. For example：DSCD algorithm and DQDC algorithm aim to research the way to get the result of querying quickly, However, Data Cube in other clients can not be updated on real time. So it is easy to lead the result of query distortion. It has an effect on the efficiency of OLAP. In order to improve the efficiency of the real-
time query of OLAP, this paper proposes a real-time semantic OLAP search algorithm. Through the experiment, it unifies the results of inquiry speed and distortion rate of two aspects, demonstrates that the RTOS algorithm can effectively improve the OLAP decision analysis performance on the P2P environment.

Key words: On-Line Analysis Processing（OLAP）, Data Cube, P2P network, Real-time Semantic OLAP Search（RTOS） algorithm

摘要： 目前，P2P环境下的OLAP查询策略都是基于从客户端获取查询结果集，如DSCD算法和DQDC算法等主要是研究怎样快速地从客户端获取查询结果集，由于客户端的Data Cube的实时数据更新效率低，易导致查询结果失真，从而影响OLAP的查询效率。为了提高P2P网络中OLAP的实时查询效率，提出了一种RTOS（Real-time Semantic OLAP Search，实时语义的OLAP查询）算法，并结合查询速度和失真率两方面的实验证明，该算法能有效地提高P2P环境下OLAP的决策分析性能。

关键词: 联机分析处理（OLAP）, 数据立方体, 点对点网络, 实时语义的OLAP查询（RTOS）算法

REN Feng, CAO Dun, FU Ming. OLAP query algorithm based on real-time semantic dimension hierarchical[J]. Computer Engineering and Applications, 2012, 48(4): 149-151.

任凤，曹敦，傅明. 一种基于实时语义维层次链的OLAP查询算法[J]. 计算机工程与应用, 2012, 48(4): 149-151.

[1]	ZHAO Zhiguo, TAN Bang, XIA Shiying, TAN Minsheng. P2P network comprehensive trust model based on time series [J]. Computer Engineering and Applications, 2017, 53(15): 127-131.
[2]	TANG Shanshan, ZHU Yuelong, ZHU Kai. Parallel computation of shell fragments cube Map/Reduce-based [J]. Computer Engineering and Applications, 2015, 51(22): 124-129.
[3]	JI Meili1, WANG Xinhua1，2. Research on cooperative caching in mobile P2P network [J]. Computer Engineering and Applications, 2012, 48(9): 70-73.
[4]	LI Jie. P2P trust evaluation model with amount of information for rough set [J]. Computer Engineering and Applications, 2012, 48(6): 90-93.
[5]	LI Chunxiu1，2, LIU Fang’ai1，2. Resources search strategy based on ant colony algorithm in unstructured P2P networks [J]. Computer Engineering and Applications, 2012, 48(4): 97-99.
[6]	FAN Yuanyuan, MI Xifeng. Structured P2P approach for high efficient distributed task scheduling [J]. Computer Engineering and Applications, 2012, 48(19): 97-100.
[7]	SHI Zhibin, WANG Bo. Application research of reductive formal context on data cube [J]. Computer Engineering and Applications, 2012, 48(15): 24-28.
[8]	LI Ji，LI Gang . P2P reputation model based on trust attenuation vector [J]. Computer Engineering and Applications, 2011, 47(9): 86-88.
[9]	ZHOU Pan，YANG Kehua，ZHOU Limin. OLAP query method in P2P network [J]. Computer Engineering and Applications, 2011, 47(8): 108-111.
[10]	WEN Guofeng^1，2，CHEN Liwen¹. Building and application of data warehouse of completed construction projects [J]. Computer Engineering and Applications, 2011, 47(4): 245-248.
[11]	NI Zhiwei1，2，ZHOU Zhiqiang1，2，GONG Weifeng1，2，MENG Jinhua1，2. Metarule-guided mining of association rules based on classification of dimensions [J]. Computer Engineering and Applications, 2011, 47(30): 140-143.
[12]	YANG Lei，ZHONG Ting，QIN Zhi-guang. Distributed P2P trust model based double metric [J]. Computer Engineering and Applications, 2010, 46(5): 13-16.
[13]	WANG Jian-yong¹，GONG Fu-ting²，LI Yu-ling³. Resource searching strategy of reducing redundancy in unstructured P2P network [J]. Computer Engineering and Applications, 2010, 46(36): 122-125.
[14]	LIU Hao¹，QING Tong²，ZHANG Lian-ming³. Incentive mechanisms for P2P network based on repeated game [J]. Computer Engineering and Applications, 2010, 46(35): 75-77.
[15]	PAN Ming-xia，WANG Yu. Storage of hierarchical dimension in port data MOLAP [J]. Computer Engineering and Applications, 2010, 46(3): 211-214.

OLAP query algorithm based on real-time semantic dimension hierarchical

一种基于实时语义维层次链的OLAP查询算法

PDF

Knowledge

Abstract

Cite this article

share this article

References

Related Articles 15

Recommended Articles

Metrics