Full-Text Search:
Home|Journal Papers|About CNKI|User Service|FAQ|Contact Us|中文
《Journal of Changchun Post and Telecommunication Institute》 2005-04
Add to Favorite Get Latest Update

Design and Realization of Data Warehouse Based on Economic Climate Analysis

WANG En-de~1, LIU Guo-bin~2(1.Department of Economic Iinformation,Dongbei University,Finance and Economy, Dalian 160025,China; 2.Office of Financial Affairs,Jilin University, Changchun 130012,China)  
The analysis and forecast of macroeconomics need a great deal of data information about macroeconomics, industrial economics and financial statistics. In order to adapt to the feature of the variety in economic indicator and the huge quantity in data, this paper introduced an idiographic process of data warehouse designing used in the domain of the forecasting and monitoring of business climate analysis. This paper realized the designing of logistic model of data ware house, according to the technical principle of data warehouse and demand for the forecasting and monitoring of business climate analysis, through confirming topic, defining dimension, analyzing granularity and partitioning data; constructed the physical structure of data warehouse using Microsoft Access; exploited data warehouse management system by VC++.NET language tool. The function of the system is safe, reliable, and it can deal with the data accurately and rapidly. For example, the loading function of the panel data can rapidly store nearly 40 000 data of 565 enterprises to the corresponding position of the corresponding index array in the warehouse in 3 minutes though Excel file. All of these functions provide favorable data conditions for supporting system of economic analysis in decision-making. The rationality in designing and reliability in function of this data warehouse are verified through the practical applying by the State Council Bureau of Performance Assessment of State-owned Assets Supervision and Administration Commission, State Information Center etc.
【Fund】: 国家自然科学基金资助项目(70171019);; 国家社会科学基金资助项目(05BJY013);; 吉林大学创新工程基金资助项目(2004CX116)
【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 5 Hits
1 WANG En-de(Department of Economic Information,Dongbei University of Finance and Economy,Dalian 160025,China);Developing Novel Enterprise Management Information Systems Based on SOA[J];Journal of Jilin University(Information Science Edition);2006-03
2 Li Huan;Design of Macro-Economic Monitoring and Early Warning System based on Data Warehouse[J];Computer Development & Applications;2008-06
3 WANG En-de~1,LIANG Yun-fang~2,KONG Xian-li~2,GAO Tie-mei~2(1.Department of Economic Infomation,Dongbei University of Finance & Economics,Dalian 116025,China;2.Department of Quantitative Economics,Dongbei University of Finance & Economics,Dalian 116025,China);The Development and Application of Monitoring and Early-Warning System of Small and Medium-Sized Industry Enterprises in China[J];Jilin University Journal Social Sciences Edition;2006-05
4 LI Ke(School of Management,Wuhan University of Tech.,Wuhan 430070,China);Civil Aviation Decision Support System for Early Warning of Disasters Based on Data Warehouse and Online Analytical Processing[J];Journal of Southwest Jiaotong University;2007-04
5 WEN Bo,ZHENG Gui-huan,XU Shan-ying,YANG Xiao-guang,WANG Shou-yang(Academy of Mathematics and Systems Science,Chinese Academy of Sciences,Beijing 100190,China);A Study on the Macroeconomic Monitoring System for Enhancing Decision Support Functions[J];Operations Research and Management Science;2009-02
【Citations】
Chinese Journal Full-text Database 6 Hits
1 ;Data Preprocessing in Data Mining[J];Computer Science;2000-04
2 ;The Research and Development of a Unified Framework for OLAP and Data Mining[J];Computer Science;2000-05
3 TAO Zaiping, CHEN Qi, YU Ruizhao (Artificial Intelligence Research Institute of Zhejiang University, Hangzhou 310027 );The Research of Data Warehouse and Its Application in Modern Companies[J];COMPUTER ENGINEERING;2000-07
4 ZHAO Rui-feng,MENG Xiang-wu (School of Computer Science & Technology,Beijing University of Posts & Telecommunications,Beijing 100876,China);Data Warehouse Technology and Its Application on Telecom Anti-fraud[J];Application Research of Computers;2004-02
5 NIE Ru,ZHANG Hong (School of Computer Science & Technology, China University of Mining & Technology, Xuzhou Jiangsu 221008,China);Comparison Research of Metadata Management Module in Data Warehouse[J];Application Research of Computers;2005-02
6 LI Yu-hai 1,2,ZHANG Da-bin2,LV Shao-peng3 (1.Pattern Information Process & Intelligence Control Laboratory of Ministrory of Education, Huazhong University of Science & Technology, Wuhan Hubei 430074, China;2. Dept. of Information Management, Central China Normal University, Wuhan Hubei 430079,China;3.Compute Center of Xiamen Telecom Co., Xiamen Fujian 361006, China);Discussion about DSS of Telecom Service Based on Data Warehouse Technology[J];Application Research of Computers;2005-06
【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 CHEN Jian_hua 1,JIA Zhe 2 (1.Anshan Waste Disposal Center,Anshan 114001,China; 2.Anshan Committee of the Communist Youth League,Anshan 114002,China);Analysis of China's Economic Cycle[J];Journal of Anshan Institute of Iron and Steel Technology;2002-01
5 ZHAO Yu-hai, LI Qiu-ju(Department of Mathematics,Anshan Normal University,Anshan Liaoning 114005,China);Design and Implementation of OLAP System Based on Relational Database[J];Journal of Anshan Normal University;2005-04
6 MA Ye-jiang,HU Si-ji,WU Xu (School of Traffic and Transportation,Beijing Jiaotong University,Beijing 100044,China);The Spectral Analysis of Transportation Economy Cycle Fluctuation[J];Journal of Beijing Jiaotong University(Social Sciences Edition);2008-02
7 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
8 Zhang Guohua Hu Siji Zhang Penghui (College of Traffic and Transport, Northern Jiaotong University, Beijing 100044) Zhang Yueling Wang Cunzhi (Ministry of Railways, Beijing 100844);Research on Prosperous Warning Indices of Railway Transportation[J];JOURNAL OF NORTHERN JIAOTONG UNIVERSITY;1999-03
9 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
10 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
China Proceedings of conference Full-text Database 7 Hits
1 Yang Zhen Li Yebai Ji Zhibing Chang Yifan (College of Information Engineering,North China University of Technology,Beijing,100041);Data Analysis Applications in Sales[A];[C];2008
2 Wang Wei China University of Petroleum (East China) 257061;GIS Model in Data Warehouse[A];[C];2008
3 ;未来会计模式的趋势研究[A];[C];2006
4 Liu Zhen-yu, Guo Bao-long, Yang Ling-Yao Department of Measurement Control Engineering, XiDian University, Xi'An 710071;Technologies for Data Warehouse and the Relationship between Data Warehouse and Data Mining[A];[C];2001
5 SHANG Wei YANG Xiao-guang XU Shan-ying ZHANG Xun (Academy of Mathomatics and Systems Suience,Chinese Academy of Sciences Beijing 100190);Research on a Macroeconomic and Industry Early Warning System[A];[C];2009
6 Wang Hao Cao YongFeng Sun Hong (Laboratory of Signal Processing and Modern Communication,Wuhan University,430079,Wuhan,China);Clustering Analysis Based on Watershed Transform[A];[C];2005
7 ;基于粗集理论的归纳依赖关系的研究[A];[C];2000
【Co-references】
Chinese Journal Full-text Database 10 Hits
1 ZHANG Zhi\|qiang\+\{1, 2\},\ CHENG Guo\|dong\+2,\ XU Zhong\|min\+2 (1. Scientific Information Center for Resources and Environment, CAS, Lanzhou Gansu 730000, China; 2. State Key Laboratory of Frozen Soil Engineering, CAREERI, CAS, Lanzhou Gansu 730000;Review of Indicators and Methodologies for Measuring Sustainable Development and Their Applications[J];Journal of Glaciolgy and Geocryology;2002-04
2 Zhang Guohua Hu Siji Zhang Penghui (College of Traffic and Transport, Northern Jiaotong University, Beijing 100044) Zhang Yueling Wang Cunzhi (Ministry of Railways, Beijing 100844);Research on Prosperous Warning Indices of Railway Transportation[J];JOURNAL OF NORTHERN JIAOTONG UNIVERSITY;1999-03
3 Wang Yanjie;Zheng Xiaoxian.College of Resources and Environment, Beijing For. Univ.,100083, P.R.China.;Reviews of studies on index system of sustainable development.[J];Journal of Beijing Forestry University;2001-03
4 WANG Zi-wei1,LIU Tie-zhong2(1.School of Economics,Renmin University of China,Beijing 100872;2.School of Management and Economics,Beijing Institute of Technology,Beijing 100081);The Crowding in or out Effect of FDI Invested in China’s Automobile Manufacturing Industry——Empirical Analysis Based on Industry Security[J];Journal of Beijing Institute of Technology(Social Sciences Edition);2009-02
5 HE Wei-da1,WU Yu-ping1,LIU Rui-hua2(1.School of Management,Beijing University of Science and Technology,Beijing 10083,China;2.Jiangxi Province Shengta Group,Ganzhou 341600,China);Evaluation Model and Empirical Research on Coal Industrial Security[J];Commercial Research;2007-09
6 WANG Fa-ming (School of Public Administration,Shangdong Institute of Business and Technology,Yantai 264005,China);Theory Review of Foreign Industrial Security[J];Journal of Chongqing University(Social Science Edition);2008-06
7 YANG Gong pu, WANG Yu, ZHU Zhou, WANG Qiang, Li Tai yong (School of International Business Management Shanghai University of Finance and Economics, Shanghai,China,200433);Industry Security Research for China's Automobile Industry[J];THE STUDY OF FINANCE AND ECONOMICS;2000-01
8 LI Chaoxian (Beijing University of Technology and Business,Beijing 100037,China);The Characteristic and Classification of the Retail Business Fluctuation in China[J];Finance and Trade Research;2004-01
9 LIU Yao-bin (School of Business,Hubei University, Wuhan,Hubei 430062);The assessment of Wuhan city sustainable development capability[J];Urban Studies;2002-02
10 WANG De; HUANG Wanshu;HEDONIC HOUSE PRICING METHOD AND ITS APPLICATION IN URBAN STUDIES[J];City Planning Review;2005-03
【Secondary References】
Chinese Journal Full-text Database 10 Hits
1 ;Application of Data Warehouse in Data Center Construction of Oil-Field[J];Industrial Control Computer;2008-06
2 LI Mei - long1,HUANG Yi - dong2 (1. Department of Computer,Minxi Vocational and Technical College,Lonyan,Fujian 364000,China) (2. China Telcom Quanzhou Branch,Quanzhou,Fujian 362000,China);The design and implementation of telecom business analysis system based on data warehouse[J];Journal of Fuzhou University(Natural Science Edition);2009-06
3 Wang Hongxia et al;Research and Application of Data Mining based on Experts-knowledge in the Filed[J];Computer Development & Applications;2010-01
4 Yin Jianzhang;Functional Requirements of SOA Architecture[J];Computer Study;2010-06
5 SUN Jian-fang1,2,ZHU Fan2,XIE Xiao-peng1;Application of OLAP technology on decision-making of multi-variety discrete production and Manufacture[J];Manufacturing Automation;2009-05
6 Li Yong;Jiang Kesheng(School of Economics and Management,Nanjing University of Aeronautics and Astronautics,Nanjing 210016,China);The Classifying Method on the Early-Warning Indicators of the Financial Prosperity Monitoring and Its Applying[J];Value Engineering;2009-08
7 Xue Junbo1 Sun Yi1 Wu Jing1 Wang Zheng1,2(1 Institute of Policy and Management,CAS 100190 Beijing)(2 Key Laboratory of Geographic Information Science,East China Normal University 200062 Shanghai);The Development and Application of Simulation System of Macro-economic Policies in China[J];Bulletin of Chinese Academy of Sciences;2010-04
8 ZHAO Yipeng1,2 WANG Caizhi1 HUANG Tingyu1 (1.PetroChina Exploration and Development Research Institute,Beijing 100083,China;2.Logging & Testing Services Company,Daqing Oilfield Limited Company,Daqing 163453,China);Design of SOA-based middle ware for logging interpretation platform[J];Acta Petrolei Sinica;2008-05
9 YANG Qiu-ping,XIE Xin-lian,XU Hao,ZHANG Liang(Transportation Management College,Dalian Maritime University,Dalian Liaoning 116026,China);Intelligent Decision Support System for Shipping Operation Based on Data Warehouse[J];Ship & Ocean Engineering;2009-03
10 WEN Bo,ZHENG Gui-huan,XU Shan-ying,YANG Xiao-guang,WANG Shou-yang(Academy of Mathematics and Systems Science,Chinese Academy of Sciences,Beijing 100190,China);A Study on the Macroeconomic Monitoring System for Enhancing Decision Support Functions[J];Operations Research and Management Science;2009-02
【Secondary Citations】
Chinese Journal Full-text Database 9 Hits
1 LIAO Li YU Ying ze WU Yu NIE Neng (Institute of Computer Science and Technology,Chongqing University of Posts and Telecommunications,Chongqing 400065);Data Mining and Data Warehouse with Their Application in Telecommunications[J];Journal of Chongqing University of Posts and Telecommunications;2000-04
2 Xu Jisheng1,Li Zhan1,Wang Daoheng2,Liu Peng2 (1.College of Electronic Informatics , Wuhan University , Wuhan 430072;2. Zhuhai Branch , Guangdong Mobile Communication Corp. , Zhuhai 519015);An Approach to the Forecast and Evaluation of the Credits for Mobile Clients[J];Telecommunications Science;2002-08
3 Dai Chaofan Chen Wenwei Deng Su Lu Changhui Tang Jiuyang (Department of Management Science and Engineering,National University of Defence Technology, Changsha 410073 );Research on Technique of MetaData of Data Warehouse[J];Computer Engineering and Applications;2001-14
4 XU HaoWEN GuihuaDING Yuehua(Research Inst. of Computer Application, South China Univ. of Tech., Guangzhou 510640) <author>;SS7 Interconnect Billing System Based on Signalling No.7[J];Computer Engineering;2002-05
5 DAI Chaofan, LIU Qingbao, HUANG Hongbin, DENG Su (School of Humanity and Management,National University of Defense Technology,Changsha 410073,China);Metadata Management in Data Warehouses[J];Computer Engineering & Science;2003-04
6 Zhang Yufang Xiong Zhongyang College of Computer Science and Engineering , Chongqing University, Chongqing 400044;DESIGNING THE DATA WAREHOUSE[J];COMPUTER APPLICATIONS;1999-09
7 HU Ying feng,LU Mei lian,CHENG Shi duan (National Laboratory of Switching Technology & Telecommunication Networks,Beijing University of Post & Telecommunication,Beijing 100876,China);Interoperation and Standardization of the Metadata in Data Warehouse[J];Application Research of Computers;2002-11
8 ZHAO Rui-feng,MENG Xiang-wu (School of Computer Science & Technology,Beijing University of Posts & Telecommunications,Beijing 100876,China);Data Warehouse Technology and Its Application on Telecom Anti-fraud[J];Application Research of Computers;2004-02
9 WANG HongBing(Nanjing College of Communication,Nanjing Jiangsu,210032) [;Metadata of the Data Warehouse[J];MICROCOMPUTER DEVELOPMENT;1999-05
©2006 Tsinghua Tongfang Knowledge Network Technology Co., Ltd.(Beijing)(TTKN) All rights reserved