| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> comp.databases.theory -> Re: Newbie question
Paul wrote:
> Gene Wirchenko wrote:
>
>>>And to check that the key is valid (i.e. in the database) and not just >>>well-formed, you do need a trip to the server. But hopefully not many >>>entries will manage to get to that stage. >> >> Say what? I hope that all entries get to that stage. That would >>mean that all of the data entered is well-formed. Now, that that is >>known, hit the server to see if the entry is valid.
One practical low-redundancy check is the eleven-proof on dutch (postbank did not join) bank-accounts, position from right to left:
( (sum(position * digit)) mod 11 = 0
with 10 digits or less, this garantuees malformed numbers whenever:
1 digit is mistyped
1 digit is inserted
2 digits changed places,
all very common typos.
When 2 or more digits are mistyped, there is a chance of 1/11 that the
string is well-formed.
Received on Wed Jun 22 2005 - 18:00:21 CDT
![]() |
![]() |