The invention provides a subsystem of a TDS
dynamic data warehouse, which comprises a
data warehouse detailing subsystem used for reprocessing the
transaction data provided by ETL and storing the
transaction data in the form of the
transaction data, the renewal is frequently executed, so that the consistency or synchronization between the warehouse and the data of a transaction
system is retained, so as to achieve real time, the complexity and the
working capacity of the data are processed through simplifying the frequent renewal link, so that the load of the
data processing is backwards transferred to a multi-dimensional
data warehouse, the
system structure is simplified, and the level of the
system equipment is reduced. The subsystem of the TDS
dynamic data warehouse further comprises an accessing subsystem used for excavating the access of terminals to the detailed warehouse; and a
processing subsystem used for
processing the generation and storage process of managing and dispatching the
batch processing multi-dimensional data. The invention provides an entire TDS
dynamic data warehouse subsystem, so that the requirements of terminal users excavated through the
data analysis for the detailed and real-
time data are met, and the TDS dynamic
data warehouse subsystem is particularly suitable for the occasion on which the moderate-scale dynamic data warehouse needs to be independently established.