Creating the SQL Server database
SQL Server 2005 express was chosen as the sgbd for this tutorial, this version is free, and you can download it at
Download SQL SERVER don't forget choosing to download "sql server management" also, it will be necessary for creating the database.
There should be no issued during installing, just remember choosing to authenticate via sql, not windows authentication.
After installing, open SQL Server Configuration manager, and start the sql server browser, if you don't do that, java will not be able to connect to the database.
Your configuration should look like this:
Now open the "sql server management", you should see a screen like that:
you should user the password you chose during installation.
Now that you are logged, on object explorer click with right mouse button at database folder and choose new database.
All the configurations can be left as default, just choose a proper database name.
Now we are going to create the table, which will store the information we need. Right click your recently created database folder choose new query and type the following code and execute it, note that you could also create the table though graphical interface.
CREATE TABLE tabela( ID int NOT NULL, Name varchar(30) NOT NULL, Template1 varbinary(max) NOT NULL, Template2 varbinary(max) NOT NULL, Template3 varbinary(max) 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