一种测试数据生成方法

A Testing Data Generating Method

三防决策指挥系统的开发需要大量符合水利规律的测试数据。在三防决策指挥系统开发的各个阶段 ,根据对测试数据的要求以及得到真实数据的数量的不同 ,需要采取不同的方法来生成测试数据。在开发初期 ,对测试数据要求不高 ,同时几乎没有得到任何真实数据 ,所以采用了程序随机生成测试数据的方法 ;在开发后期 ,要求测试数据尽可能符合水利规律 ,同时得到了一些真实数据 ,所以采用了根据一个完整月的数据 ,利用SQL语句改变时间和数据值以得到其他月的数据。对于开发过程中所需要的统计数据 ,可以根据上面生成的标准数据用SQL语句统计生成。

The development of 3-defense Decision-making and Command System requires lots of testing data which accord with water conservancy rules. In the different stages of the development, according to the different demands for the testing data and different amount of real data, it is necessary to take different measures to produce testing data. In the early stage of development, because of the low demand for the testing data and the few amount of real data, the only method to produce testing data is making use of programs which can produce random data. In the latter stage of development, the testing data must follow with the water conservancy rules as well as possible and more real data can act as reference now, so we can take out data of a whole month which are complete in some extent, then use SQL scripts to modify the value of data and its time to get data in other months. As for the statistical data, we can use SQL statistical script to get them.