The Design and Implementation of a Pseudo Random Number Generation Algorithm

This paper analyzes the generation of pseudorandom number theory, gives a brief description of the pseudorandom number generation mechanisms in SQL Server 2000, and then proposes a new method to generate pseudo random number in database system. This method converts a GUID code into a random plastic number through hash function,generates a random sequence composed by 0 and 1 according to the parity of the plastic number, and then take further operation to the 0-1 random sequence, in order to enhance its randomness, and ultimately generates the required random number according to the 0-1 sequence. At the end, tests the randomness of the 0-1 sequence with a run test.