Research on the data warehouse testing method in database design process based on the shared nothing frame

Research on the data warehouse testing method in database design process based on the shared nothing frame

Keming Chen

COMPUTER MODELLING & NEW TECHNOLOGIES 2013 17(5B) 23-27

School of Continuing Education, XinYu University,XinYu University, JiangXi, 338004, China

This paper firstly introduces the recent research on data warehouse and describes the technology of data warehouse in process of design of database in detail. Data warehouse is a new technology in data management and information, and is mainly used to raise efficiency of data querying and to support decision. We use the theory of data warehouse to design database application system and to organize the database system in order to overcome the shortcomings of the database application system, such as low efficiency when there is a large number of data or in a new work, the data is difficult to transfer into useful information, and it can’t satisfy the needs of long time analysis and prediction. According to the actual situation in a certain company, a concrete design of such a system is put forward in the paper. After the infrastructure of database products was briefly introduced, the performance of cloud computing database under the workload of business type, testing technology standard of cloud computing database was especially analyzed, and the evaluate and assessment methods of capacity of cloud computing database was expatiated.