I’m not very interested in paranormal things. However, I think I don’t need such interest in order to say that it would be good to create an “Automotive X-Files unit”. Actually, last time I wrote that there is a need for an “Indiana Jones of motoring” or an “Automotive Lara Croft”, although I’m not crazy enough to believe that such person would ever see any of the deadly traps faced by those popular culture archaeologists.
What I really believe is that the greatest puzzles of the automotive history deserve being disputed and solved. And while we don’t need any paranormal investigations in the motoring world, we need people who will approach every mystery from the car and motorbike history without fear that the case is too complicated.
In Poland, where I live, “Archiwum X” is a common metaphorical name for police units which handle “unsolvable” cases. What is typical for those units, is that they use new scientific discoveries and the information technology to analyze affairs from the past. This leads us straight to the usage of computer databases in the Bugatti history research.
It’s hard to say how many Bugatti databases are there. However, from what is written in books and on forums, most databases use chassis numbers as the main key. On the BugattiBuilder forum (http://www.bugattibuilder.com/forum/viewtopic.php?f=29&t=2414&start=0) X-Filer asks “What do we need a chassis number database for?” and Herman responds “Because that is all we have. Although the real experts have lists with frame numbers, but are hesitant to release these lists, as they fear this might:
-help con-artists perform their art
-shake the Bugatti community too much
-will cause tremendous financial losses”.
Nevertheless, the question posed by X-Filer may inspire an another, more general question:
“What should be used as the key identifier in the Bugatti database?”
First two candidates have already been mentioned. The quote above indicates that the frame number seems to be the best option. But it’s easy to see its biggest shortcomings:
- • these numbers are known only to owners and to the most renowned Bugatti historians
which results from another problem i.e.
- • to get to know the frame number, an access to the physical car is needed. At first it seems that it is not a problem for a true expert but … let’s ask if frame numbers of Aérolithe (Aérolithes?) or of La Voiture Noire are known. Sounds like a rhetorical question.
So, is the chassis number the best option? Well, not exactly. It would be nice to find something else, because:
- • chassis numbers were reassigned, especially between factory owned vehicles like prototypes or race cars
This issue is solved by adding another digits to a chassis number 57456-1 and 57456-2 (http://www.bugattibuilder.com/forum/viewtopic.php?f=1&t=308) but…
- • there are two kinds of operations that a good Bugatti register should keep trace of. These are chassis number reassignments and car transformations, as, for example, the Aérolithe (or Aérolithes) is (are) believed to have been converted into Aéro Coupé (or Aéro Coupés, i.e. both 57374 and 57453).
Someone may feel tempted to try engine numbers, but it would be naive to believe that all the cars kept their original engines.
So, is the conclusion that every choice has it pitfalls, but the database designers must stick to one of those numbers? No, I don’t think so. In my opinion, the base should include chassis numbers, engine numbers and frame numbers when they are available but the common name of the car should be used as the main identifier. Such base could handle three things that cause confusion i.e.:
- • reassigned chassis numbers
- • car transformations i.e. cases when one car was rebuilt into another
- • multiple names for one vehicle- for example, the car mentioned in factory documents as “Belg. Coupé” is either “La Voiture Noire” or “Coach spécial Type 64”.
In the proposed database “a vehicle” is a recognized example of the Bugatti car-building art. Such example may be treated as a separate entity even if its evolution into an another vehicle is proven. Therefore the most popular name of such example is selected as the “common name”.
To sum up, I think that tables could look like that:
(The “NULL” value is used when the actual value doesn’t exist or is unknown)
|31 Sep 1936||276|
|7994||La Voiture Noire||03 Oct 1936||NULL|
Where “ID” is a number generated from a sequence. The “ID” serves as so called “foreign key” in other tables.
Table: Frame Numbers
Table: Chassis Numbers
(I think, that there is also a need for a table with chassis models i.e. 35, 41, 57, 57S and so on. However, I would like to present just the tables that would be the most useful for documenting each car’s timeline)
|7991||57453||19 C.V||11 may 2011||TRUE|
Table: Chassis Number Assignments
|7992||7994||7991||03 Oct 1936||NULL||NULL|
Table: License plates
|7897||5800 NV 3||7991||7994||03 Oct 1936||NULL||NULL|
A car name is considered “an alias”, if there is strong conviction that the car is known under another name.
Table: Engine models
(Like others, this table is also simplified, I show it just to mention that it should be a separate entity)
Table: Engines by vehicles
“The Bugatti Type 57 S:
dr Bernard Simon
Table: Transformations by documents
(to be used if a transformation is confirmed by one or more factory documents)
May be used both for clients and employees. Of course there should also be “Employee Positions” table, but to shorten the article, I omit it.
|5682||301||29 Sep 1939||2|
|1||The Molsheim Factory|
|2||Cite d’Automobile- Collection Schlumpf|
I think that such database would be a good tool for recreating the Bugatti car timelines. It could also provide information for some hypothesis-verifying software.