Re: integer sequence randomization



"tomas.kejzlar@xxxxxxxxx" <tomas.kejzlar@xxxxxxxxx> writes:

Hi,

I am facing the following problem: I have a database filled with
thousands of records (tickets) distinguished by ther ID. I need to
find a way to generate unique but random integers, preferably based on
IDs of the records and these will work as barcodes (they have to be
"random" so that anyone having one ticket could not guess what is the
other barcode). We've tried generating random numbers and then
checking them against the ones we already have in our database, but
this (obviously) is getting slower and slower as the database is
getting bigger.

I've tried to investigate some possibilities of "randomizing" IDs
according to given rules (1 becomes 3,...), but the resulting sequence
is not "random" enough. Can anyone point me to a possible solution?

You do not say anything about the length, but simply encrypting the IDs
would work (with a secret key) Of course with say DES, this would result in
numbers of length about 19 digits for the bar codes. Is that OK?

Note that searching the database is not the best procedure. Sort the
database and store that in doing your search. Then the search takes log
time.


Thanks very much, Tom.
.



Relevant Pages

  • Re: integer sequence randomization
    ... I am facing the following problem: I have a database filled with ... thousands of records (tickets) distinguished by ther ID. ... IDs of the records and these will work as barcodes (they have to be ... this is getting slower and slower as the database is ...
    (sci.crypt)
  • integer sequence randomization
    ... I am facing the following problem: I have a database filled with ... thousands of records (tickets) distinguished by ther ID. ... IDs of the records and these will work as barcodes (they have to be ... this is getting slower and slower as the database is ...
    (sci.crypt)
  • Re: New IDS Server: 32 or 64bit?
    ... we've been running IDS 7.31 engine on a Linux machine for over ... to IDS 10 on a newmachine and have to decide whether to stay at 32bit ... platform supports both 32bit and 64bit versions of SuSE SLES 10. ... for the database chunks. ...
    (comp.databases.informix)
  • Problems reverting IDS 10 to 9.4
    ... production database servers. ... After make a go at IDS 10 we have found at least one ... fault BTW (I don't want anyone thinking that Informix ... This reversion proved to be a difficult task since ALL ...
    (comp.databases.informix)
  • VBA Codes for User IDs and Passwords
    ... permissions. ... All of the six users have Windows User IDs. ... Dim dbs As Database, rs As Recordset, tdfAccess As TableDef ...
    (microsoft.public.access.forms)

Quantcast