Creating the oracle database
Oracle Database 10g Express Edition was chosen as the sgbd for this tutorial, this version is free, and you can download it at Download Oracle Database 10g Express Edition
Also, there is a nice tool that helps using oracle. It is called toad, its free version can be downloaded here
Download toad
After installing oracle, you need a user that java will use to access the database. You can do that by logging in the database homepage with the system user.
After you created the user log in with toad using that user.
To create the table, type and execute the following code:
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