How to Generate True Random IDs? 
Author Message
 How to Generate True Random IDs?

How do I generate true random ids.

Thanks.

ZD



Sat, 28 Oct 2000 03:00:00 GMT
 How to Generate True Random IDs?

Quote:

> How do I generate true random ids.

There's an article on russian web server specially about subj:
http://www.osp.ru/dbms/1995/01/source/uni_id.html

Yeah, it's in Russian, except some SQL samples. If the author speaks

1. Increment ID (by yourself or by using identity/autonumber columns)
2. Some DBMSs support timestamp data type -> copy the value of that column
   into ID column.
3. Use some random number generator, e.c. linear congruential generator.
   If the ID is already in database, generate next random ID and so on.
4. ID heap. Beforehand make a set of IDs you will use in future, i.e. heap
of IDs.
   When you use some ID from ID heap, delete it from ID heap.
   If you discontinue using some ID in your database, you delete the
according
   record from that database and return ID back to heap.

-----
Origin: I want to ride it where I like!



Sun, 29 Oct 2000 03:00:00 GMT
 How to Generate True Random IDs?

Could try passing the Russian text URL to the translation option at
http://altavista.digital.com/



Quote:

>> How do I generate true random ids.

>There's an article on russian web server specially about subj:
>http://www.osp.ru/dbms/1995/01/source/uni_id.html

>Yeah, it's in Russian, except some SQL samples. If the author speaks

>1. Increment ID (by yourself or by using identity/autonumber columns)
>2. Some DBMSs support timestamp data type -> copy the value of that column
>   into ID column.
>3. Use some random number generator, e.c. linear congruential generator.
>   If the ID is already in database, generate next random ID and so on.
>4. ID heap. Beforehand make a set of IDs you will use in future, i.e. heap
>of IDs.
>   When you use some ID from ID heap, delete it from ID heap.
>   If you discontinue using some ID in your database, you delete the
>according
>   record from that database and return ID back to heap.

>-----
>Origin: I want to ride it where I like!



Mon, 30 Oct 2000 03:00:00 GMT
 How to Generate True Random IDs?

Quote:

> Could try passing the Russian text URL to the translation option at
> http://altavista.digital.com/

> >There's an article on russian web server specially about subj:
> >http://www.osp.ru/dbms/1995/01/source/uni_id.html

> >Yeah, it's in Russian, except some SQL samples. If the author speaks


AFAIK AltaVista does not support Russian to English translation.
In my previous letter I simply listed methods described in that article.

-----
Origin:  2147483648 lemmings cannot be wrong!



Tue, 31 Oct 2000 03:00:00 GMT
 
 [ 5 post ] 

 Relevant Pages 

1. HOWTO: Generate Random Column ID as the Default

2. Need to generate a random ID

3. generate random unique object id

4. EASY: SQL to generate a simple random number?

5. generating a random number

6. How to generate random numbers!

7. Generating random string in a table

8. Generate random password as default value

9. Generating Random Numbers

10. Generating Random Passwords

11. generating random records

12. generating random records


 
Powered by phpBB® Forum Software