Design and implementation of real-time ETL based on ESB
Haihui Zhang · Journal of Computer Applications · 2008
Data warehouse technology and its applications develop promptly,accompanying which are the demands by enterprises for shorter data processing delay and real-time requirements.It is a regrettable fact that most existing systems actually fail to deliver such needed features.An Enterprise Service Bus(ESB)based real-time Extract,Transform,and Load(ETL)solution was proposed.The functionalities of ETL were realized as components running on the ESB platform.Real-time partition was created to load real-time records.Experimental results reveal that this design scheme successfully delivers the real time property and meanwhile maintains good versatility and extensibility.