Lottery Program: Dev Plan, Version 1.1

Version 1

June 26, 2004

 

Project Title: Diyinside Lottery System for the Activity in July 10, Nanjing
Dev Codename: Rosaria
Intending Runtime & Environment Required: Microsoft Windows NT 5.0 or higher with Microsoft .NET Framework 1.1 installed, Microsoft Access 2000 ODBC, Simplified Chinese language support, Windows Installer 2.0 or higher, Microsoft Data Access Component 2.6 or higher(must be included in the installation deployment)

 

Intending Algorithm:

    The estimated record number is in ten thousands. It is unrealistic to read all the columns in the data table to the memory and operate there. The only appropriate way is to number all the records, i.e. give every record a unique and consecutive number. Thus, the program only randomly picks the unique numbers during the lottery process. The corresponding data will then be read out and displayed when the lucky number are generated in those consecutive. If required, the program can be modified to temporarily load each time a limited set of complete records in memory, which is also randomly chosen in the tens of thousands of records, and pick some lucky number(s) in the generated data set. This won't lose the equity to each record in the entire database.

Knowledge Base Required: Database development in Microsoft .NET Framework, algorithm about lottery system