本文已被:浏览 2958次 下载 4319次
Received:September 16, 2009 Revised:October 21, 2009
Received:September 16, 2009 Revised:October 21, 2009
中文摘要: 为了改善传统的数据仓库只能分析历史数据,数据抽取周期过长以及无法满足实时分析的要求等缺点,提出了一种实时数据仓库的装载方法,该方法将采取复制表结构、设置查询限制等条件实现在数据仓库中数据持续高效的装载,并且阐述了如何使用数据仓库架构以及客户终端OLTP查询来实现实时数据的整合。
Abstract:Traditional warehouse systems cannot do real-time analysis due to its relatively long data extraction period. In order to improve it, this paper puts forward a real-time data warehouse implementation method. This method adopts copying table structure and setting limitation on querying to loading data in data warehouse consistently and effectively. It also demonstrates how to integrate the real-time data by using the data warehouse architecture and OLTP queries in client.
keywords: real-time data warehouse implement method OLTP ETL
文章编号: 中图分类号: 文献标志码:
基金项目:
| Author Name | Affiliation |
| LONG Xiao-Quan | 湖南大学 软件学院 湖南 长沙 410082 |
| DAI Mu-Hong | |
| LI Peng | |
| LI He-Qing |
| Author Name | Affiliation |
| LONG Xiao-Quan | 湖南大学 软件学院 湖南 长沙 410082 |
| DAI Mu-Hong | |
| LI Peng | |
| LI He-Qing |
引用文本:
龙晓泉,戴牡红,李 鹏,李河清.实时数据仓库的一种实现方法①.计算机系统应用,2010,19(6):178-182
LONG Xiao-Quan,DAI Mu-Hong,LI Peng,LI He-Qing.Implementaction of Real-Time Data Warehouse.COMPUTER SYSTEMS APPLICATIONS,2010,19(6):178-182
龙晓泉,戴牡红,李 鹏,李河清.实时数据仓库的一种实现方法①.计算机系统应用,2010,19(6):178-182
LONG Xiao-Quan,DAI Mu-Hong,LI Peng,LI He-Qing.Implementaction of Real-Time Data Warehouse.COMPUTER SYSTEMS APPLICATIONS,2010,19(6):178-182

