Creating the mysql database
Mysql was chosen as the sgbd for this tutorial, it is an open source software, and you can download it at
Download mysql
Also, there is a nice tool that helps using mysql. It is called toad, its free version can be downloaded here
Download toad
After having mysql and toad installed, open toad , click file->new->connection and log in
If you don't have a database yet , click create->database just fill the name field and click ok.
Now you need to create the table. First switch to your recently created database, then click file->new->editor and type and execute the following
CREATE TABLE tabela( ID int NOT NULL, Name varchar(30) NOT NULL, Template1 blob NOT NULL, Template2 blob NOT NULL, Template3 blob NOT NULL )
Note that we are using a very simple database, just one ID and one name related to the user, and the 3 fingerprints. The fingerprints are stored as a mathematical representation knows as template. In order to store those binaries in the database , the best choice in sqlserver is the type varbinary.
But you must be wondering, why 3 fingerprints? The answer is, because we want to avoid false rejections due to bad quality readings, 3 Templates are kept to reduce problems related to failed comparison due to bad quality fingerprints, if any of the 3 fingerprints in the database is compatible with the user's read fingerprint , he is authenticated