Re: What happens after 2^32 autonum keys are exhausted?


Please stop top posting!

On Aug 14, 2:55 am, "Tony Rogerson" <tonyroger...@xxxxxxxxxx> wrote:
If VIN is so wonderful then why don't they use it for registration numbers
(license plate)?

http://en.wikipedia.org/wiki/Registration_plate#Europe

I tell you why, VIN is too long, too complex and not easily remembered; one
of the main reasons why people use a stock number and not the VIN.

--
Tony Rogerson, SQL Server MVPhttp://sqlblogcasts.com/blogs/tonyrogerson
[Ramblings from the field from a SQL consultant]http://sqlserverfaq.com
[UK SQL User Community]

"Ed Prochak" <edproc...@xxxxxxxxx> wrote in message

news:1187053384.390678.325340@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx



On Aug 6, 1:19 am, "Tony Rogerson" <tonyroger...@xxxxxxxxxx> wrote:
Come on don't be so obnoxious. There are lots of places to look them
up.

"look them up"

Exactly - looking at the VIN number alone does not tell you anything
unless
you have memorised the company codes, the region codes, the year code
etc...
But, the VIN does not contain all you need to verify that the car in
front
of you is what you are expecting; it does not contain colour for a start,
it
does not contain mileage and other attributes like petrol/diesel; engine
CC
etc...

It identifies the car I get is the car advertized. It is INDEPENDENT
of the car dealer. Whether I can, in my head validate the codes, I
merely have to match the VIN from the ad to the VIN on the car.

By using the VIN alone without looking up you are simply validating that
the
VIN in front of you is the same VIN on the car in front of you; that is a
lot of trust you put in just the VIN alone; you don't seem to conceive of
stolen cars; VIN modifiction on the car etc... Thankfully you agree it
happens; so how can you use VIN if you know that there are cases where
VIN
forging happens?

You try to beat me up about VIN forgery even when you saw I
specifically mentioned VIN plate switching. If forgery is the problem
you wish to solve, please explain how a dealer stock number is going
to help. I really don't see it.

Short answer is - you still have to look the VIN up against the issuing
source to get ALL the attributes like make, model, colour, petrol/diesel,
has it been in a crash, mileage at last time you taxed the beast.

And using the VIN it is possible to get all that information. It is
NOT possible to do the same with the dealer stock number. You are just
adding more support FOR using a VIN. Thanks.

The whole point I'm making is that using VIN alone you cannot verify that
the car in front of you is the car you think it is; you need to take the
VIN
and look it up against another computer system to do the verification;
so -
not hard; but why is that so different to stock number; frankly it isn't;

It is vastly different.

you take the stock number, look it up against the dealer's database when
you
have chosen your car, that gives you the VIN, you can then use the VIN
from
the car to physically look it up against the central issuing database.

Yes, outside the Dealer's database,
the VIN can be verified, while
the Stock number MEANS NOTHING and is USELESS.
Even in the dealership, the stock number does not necessarily
identify a single vehicle.

--
Tony Rogerson, SQL Server MVPhttp://sqlblogcasts.com/blogs/tonyrogerson
[Ramblings from the field from a SQL consultant]http://sqlserverfaq.com
[UK SQL User Community]

Should I throw in a dig about "Ramblings" at this point?
Nah, it is left as an exercise for the reader.

ed

So let me summarize what seems to be the justification for using an
autoNumber ID as a PK:

1. it's convenient.

2. it's ... oh there isn't any other justification.


As I have said in this forum many times before in various ways:

an autoNumber ID as a PK should be a LAST choice.

With that I will let you ramble on.
ed

.

Relevant Pages

  • Re: What happens after 2^32 autonum keys are exhausted?
    ... that car he sells you is the car advertized? ... items to verify that VIN number against, those other things in case of VIN are a) the car, b) the registration paper work and confirmation with the central government body that the registration paper is not fake. ... The Stock Number is the same, in itself does not contain any information, you need other items to verify that Stock Number against, those other things in case of Stock Number are a) the car and b) the dealers stock list and then you can verify the car is legit by taking the registration paper work etc... ...
    (comp.databases)
  • Re: What happens after 2^32 autonum keys are exhausted?
    ... some confusion in the VIN encoding I think. ... using the same dealership stock number? ... if you see a car advertised at a specific dealer in New York would ...
    (comp.databases)
  • Re: What happens after 2^32 autonum keys are exhausted?
    ... some confusion in the VIN encoding I think. ... using the same dealership stock number? ... I will ask the question; if you see a car advertised at a specific dealer in New York would you really go to a completely different dealer in LA? ...
    (comp.databases)
  • Re: What happens after 2^32 autonum keys are exhausted?
    ... My eye sight is fine - thanks for the concern Matthias; I was looking in the NEW cars section... ... Where is the VIN? ... Tony Rogerson, SQL Server MVP ... Also, your example on New York Times adverts, they also use a STOCK ...
    (comp.databases)
  • Re: modeling either/or relationship...
    ... > vehicle_type and a door count, and vin is a primary key for every car. ... Given that every vehicle has both a vehicle type and a door count, ...
    (comp.databases.theory)