Server side sampling of databases

Claim 2

A computer implemented method of identifying a subset of records within a database for purposes of representing the database comprising: choosing a selection attribute from one of a plurality of attributes contained in records within the database; scanning records in the database and applying a RAND function to the selection attribute of each record to create a randomized record value; and applying a selection criteria to identify records for inclusion within a subset of records by comparing the randomized record value of each record with the selection criteria “criteria”, wherein the selection attribute contains a numeric value and additionally comprising scaling the numeric value with a factor before applying the RAND function.

Claim 3

The method of claim 1 wherein the selection attribute contains a text string that is used as an input parameter to the RAND function.

Claim 4

The method of claim 1 wherein the scanning of records and applying the selection criteria is implemented by an SQL statement that includes a RAND function.

Claim 5

The method of claim 1 wherein the subset of records that represent the database are transmitted from a server computer to a client computer by means of a network.

Claim 6

The method of claim 4 additionally the client performs a data mining analysis on the subset of data that is transmitted to the client by means of the network.

Claim 7

Client/Server computer apparatus comprising: one or more client computers coupled to a network and including communications instructions for requesting a data set by means of the network; and a server computer coupled to the network and having access to a database having a number of records, the server computer including instructions for sending the data set made up of a subset of the records in the database to a client computer via the network; the server computer including instructions for scanning records in the database, applying a RAND function to a specified record attribute of each record in the database to produce a randomized record value, wherein the specified record attribute contains a numeric value and additionally comprising scaling the numeric value with a factor before applying the RAND function and comparing the randomized record value with a selection criteria to determine whether to include the specified record in the subset of records from the database for transmission via the network to the client; and an SQL language interpreter for converting requests from a client to an SQL statement including a RAND function.

Claim 8

Client/Server computer apparatus comprising: one or more client computers coupled to a network and including communications instructions for requesting a data set by means of the network; and a server computer coupled to the network and having access to a database having a number of records, the server computer including instructions for sending the data set made up of a subset of the records in the database to a client computer via the network; the server computer including instructions for scanning records in the database, applying a RAND function to a specified record attribute of each record in the database to produce a randomized record value, wherein the specified record attribute contains a numeric value and additionally comprising scaling the numeric value with a factor before applying the RAND function and comparing the randomized record value with a selection criteria to determine whether to include the specified record in the subset of records from the database for transmission via the network to the client; and an SQL language interpreter for converting requests from a client to an SQL statement including a RAND function.

Claim 9

The Client/Server computer apparatus of claim 6 wherein the client determines the selection criteria and transmits the selection criteria to the server for use in building the subset of records from the database.

Claim 10

A computer readable medium including instructions for identifying a subset of records within a database for purposes of representing the database, the computer readable medium comprising instructions for: choosing a selection attribute from one of a plurality of attributes contained by records with the database; scanning records in the database and applying a RAND function to the selection attribute of each record to create a randomized record value; and applying a selection criteria to identify records for inclusion within a subset of records by comparing the randomized record value of each record with the selection criteria wherein the selection attribute contains a numeric value and additionally comprising instructions for scaling the numeric value with a factor before applying the RAND function.

Claim 11

A computer readable medium including instructions for identifying a subset of records within a database for purposes of representing the database, the computer readable medium comprising instructions for: choosing a selection attribute from one of a plurality of attributes contained by records with the database; scanning records in the database and applying a RAND function to the selection attribute of each record to create a randomized record value; and applying a selection criteria to identify records for inclusion within a subset of records by comparing the randomized record value of each record with the selection criteria wherein the selection attribute contains a numeric value and additionally comprising instructions for scaling the numeric value with a factor before applying the RAND function.

Claim 12

The computer readable medium of claim 8 wherein the selection attribute contains a text string that is used by the instructions as an input parameter to the RAND function.

Claim 13

The computer readable medium of claim 8 wherein the scanning of records and applying the selection criteria are performed by instructions that implement an SQL statement that includes a RAND function.

Claim 14

The computer readable medium of claim 8 wherein the instructions transmit a subset of records that represent the database from a server computer to a client computer by means of a network.

Claim 15

The computer readable medium of claim 8 additionally comprising instructions for performing a data mining analysis on the subset of data that is transmitted to the client by means of the network.