Method and system of dynamic data base based on TDS transition data storage technology

Abstract

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.

Description

technical field [0001] The invention relates to the field of business intelligence and data warehouse, in particular to a dynamic data warehouse system based on TDS transitional data storage technology. Background technique [0002] Business intelligence is a means of digging out the regular characteristics reflected in the data from business data. These laws and characteristics also reflect the internal characteristics and operation and development laws of the data generating subject. Mastering these laws can be used as current or future decision-making. It is also called a decision support system, because the data is objective, so the rules excavated are real and objective, and the decisions made based on this are generally correct, so it is also called a scientific decision-making system, because the data it faces is Complex, huge, and hidden laws, so it is very difficult to realize this method. It is necessary to establish a complete set of theoretical technology system....

AI Technical Summary

Problems solved by technology

[0012] The technical problem to be solved by the present invention is to provide a new dynamic data warehouse technology, which is used to overcome the defects of low efficiency of ODS dynamic data warehouse, complex system, high equipment requirements, large cost investment, inability to rebuild, and high implementation capability requirements. This technology is especially suitable for establishing small and medium-sized dynamic data warehouses

Images