Full-Text Search:
Home|Journal Papers|About CNKI|User Service|FAQ|Contact Us|中文
《Journal of Anshan Normal University》 2005-04
Add to Favorite Get Latest Update

Design and Implementation of OLAP System Based on Relational Database

ZHAO Yu-hai, LI Qiu-ju(Department of Mathematics,Anshan Normal University,Anshan Liaoning 114005,China)  
This paper designs an OLAP system based on relational database, which includes OLAPmodeling, materialized views selection and OLAP visual analysis. The system can extract the interesting data from the data warehouse, can build the Cube model, generate the materialized views, then translate the queries that from the users to the Cube into the queries based on materialized views. Finally, the query results are friendly presented to the users by graph and multidimensional report. And it can also conveniently drill down and rotate, and can achieve slicing and dicing operations by switching the dimensions. The paper focused on the technical issues of design and implementation of above modules.
【CateGory Index】: TP311.13
Download(CAJ format) Download(PDF format)
CAJViewer7.0 supports all the CNKI file formats; AdobeReader only supports the PDF format.
【References】
Chinese Journal Full-text Database 3 Hits
1 WEI Jin-qiang~1,GAO Lei~2,LI Jin-hong~1(1.College of Information Engineering,North China University of Technology,Beijing 100041,China;2.Administration Department,Bejing Technology and Business University,Beijing 100037,China);UTILIZE OLAP SOFTWARE TO REALIZE EDUCATIONAL ADMINISTRATION DIMENSIONAL ANALYTIC SYSTEM[J];Journal of Beijing Technology and Business University(Natural Science Edition);2006-04
2 JIA Zhi-hua~1 ZHANG Ya-han~2 WEI Xiang~1 (1 Shijiazhuang Department of Computer Engineering and technical school Shijiazhuang,Hebei 050000,China) (2 Shijiazhuang Institute of Electrical and Mechanical Services Department of Vocational and Technical Shijiazhuang,Hebei 050000,China);Research on OLAP for Multidimensional Data Analysis of Enterprises[J];China Computer & Network;2008-11
3 Liu Lijuan Geng Yushui Wang Xin'gang (School of Information Science and Technology,Shandong Institute of Light Industry,Jinan 250353,Shangdong,China);THE RESEARCH AND PRACTICE OF OLAP TECHNOLOGY WITH B/S STRUCTURE[J];Computer Applications and Software;2009-02
【Co-citations】
Chinese Journal Full-text Database 10 Hits
1 TAN Xin(Anhui Electric Power Training Center,Hefei 230022,China);Data warehouse and its design[J];Journal of Anhui Electric Power College for Staff;2003-01
2 ZHENG Binet al(Fujian Institute of Economics Management,Fuzhou,Fujian 350002);Elementary Discussion on the Application of Data from Agro-product Market[J];Journal of Anhui Agricultural Sciences;2008-18
3 SUN Huai-ning (Information and Technology Department of Huainan Normal University, Huainan 232001,China);Design and Realization of Teaching Quality Monitoring System Base on Delphi[J];Journal of Anqing Teachers College(Natural Science Edition);2004-03
4 JIA Xu_guang, HUANG Hou_kuan,HUANG Wan_qiu (College of Computer and Information Technology, Northern Jiaotong University, Beijing 100044,China);Data Integration in A Data Warehouse[J];Journal of Northern Jiaotong University;2002-02
5 RUAN Liang(Dept.of Investment Management,No.58 Research Institute of China Ordnance Industries,Mianyang 621000,China);Data Warehouse Model of Fixed Assets Investment Management[J];Ordnance Industry Automation;2008-10
6 LI Jin-jun1, CONG Rong 1,2 , LIU Chi3, XIONG Ji-guang1(1.Dalian Naval Academy, Dalian, Liaoning 116018, China; 2.School of Electronic and Information Engineering, DaLian University of Technology, Dalian, Liaoning 116000, China;3.Liaoning Entry-Exit Inspection and Quarantine Bureau, Dalian, Liaoning 116018, China);An Attack Direction Differentiating Model of Anti-ship Aerial Targets Based on the Integrated Clustering Method[J];Acta Armamentarii;2005-05
7 LI De-yong, ZHAI Dong-sheng( College of Economics and Management, Beijing Polytechnic University, Beijing 100022, China );Study of Data Bank System Based on Analysis of Stocks[J];Journal of Beijing Polytechnic University;2002-02
8 LU Luo-wen, ZHANG Shu-jie, YU Yan-feng, ZHAI Dong-sheng (College of Computer Science, Beijing University of Technology, Beijing 100022, China);Study of Personal Credit System Based on Data Warehouse Model[J];Journal of Beijing Polytechnic University;2005-04
9 FAN Chunxiao,LIU Jie(Electronic Engineering School, Beijing University of Posts and Telecommunications, Beijing 100876, China);Research for a Database Mapping Platform Based on Multi-Job Step[J];Journal of Beijing University of Posts and Telecommunications;2003-03
10 SUN Jing-zhong,CHEN Shi-quan(Management School,Wuyi University,Jiangmen,Guangdong 529020,China);Intelligent Management System of Network Organization Based on Multi-agents[J];Commercial Research;2005-18
【Co-references】
Chinese Journal Full-text Database 10 Hits
1 QIU Wen-jiao,PAN Xiao-hui(Dean’s Office,Southesat University,Nanjing 210096,Jiangsu,China);The Application of Data Mining in Educational Administration[J];Journal of Anhui University of Technology(Sociel Sciences);2005-03
2 ZHANG Xiao ping MA Yuan YU Miao (SchoolofComputerScienceandEngineering,AnshanUniversityofScienceandTechnology,AnshanLiaoning114002,China);The Research on Applying Data Warehouse to Educational Administration in Institutions of Higher Learning[J];Journal of Anshan Normal University;2003-02
3 Li Jinhong Yan Peng Cao Danyang Su Zhitong Hu Jian Xiong Wei (College of Eng., North China Univ. of Tech., 100041,Beijing, China);Multi-dimensional Analytical System of Data of Aluminium Electrolyte Pots[J];Journal of North China University of Technology;2002-01
4 LI Xiao\|lin\+1,HE Xiang\|dong\+2, LI Wen\|yin\+1 (1.College of Computer Science and Technology, Jilin University, Changchun 130012, China; 2.Institute of Mathematics, Jilin University, Changchun 130012, China);Design and implementation of population statistics and forecasting system based on data warehousing and OLAP techniques[J];Journal of Changchun Post and Telecommunication Institute;2003-03
5 Wei Luoxia (Dongguan Institute of Technology);DATA WAREHOUSE AND OLAP[J];Journal of Dongguan Institute of Technology;2000-02
6 YANG Jun-feng, DONG Pi-ming (Dept. of Transportation Engineering, Dalian Railway Institute, Dalian 116028, China; 2. Dept. of Electrical Information Engineering, Dalian Railway Institute, Dalian 116028, China);Design and Development of Business Inteligence System[J];Journal of Dalian Railway Institute;2002-01
7 ;Study on A Metadata Management Model of Data Warehouse[J];Computer Development & Applications;2002-04
8 ;基于数据仓库的OLAP技术的研究[J];Computer Knowledge and Technology;2005-02
9 ;基于SQLServer数据仓库的研究与实现[J];Computer Knowledge and Technology;2005-14
10 ;Module and class module's application in design Visual Basic MIS[J];Computer Knowledge and Technology;2005-17
【Secondary References】
Chinese Journal Full-text Database 2 Hits
1 Hu Jia-kun,Li Yue-yu(Business School of Sichuan University,Chengdu 610064,China);Study on the Application of OEE to Multidimensional Data Analysis System[J];Industrial Engineering Journal;2009-06
2 ZHANG Mei-hu1,ZHANG Jian-ming2(1.Yangzhou Polytechnic College,Yangzhou Jiangsu 225009,China;2.Jiangsu University,Zhenjiang Jiangsu 212013,China);Application of OLAP Software in Enterprise Decision Support System[J];Journal of Huaiyin Institute of Technology;2009-01
©2006 Tsinghua Tongfang Knowledge Network Technology Co., Ltd.(Beijing)(TTKN) All rights reserved