Query SQL Database For Facial Match

[Tyler_C_1]

I am not sure if this is possible but I am writing my facial recognition info as a type binary and the ID to a SQL database with some other info I want to return based on a facial match. It seems to be writing the information correctly but now I want the camera to be able to query this database for the user ID if he/she is a facial match based on the binary data.  Is it possible to query a database other than the one that the SDK creates?  I have been using this tutorial as a starting point https://software.intel.com/en-us/articles/code-sample-facial-recognition-using-intel-realsense-sdk.  Any help is appreciated, thanks. 

[Bryan_B_Intel1]

Hi Tyler,

I’m trying to understand your application better. Are you storing the ID and binary data (i.e., the Byte array representing the recognition database) as fields belonging to the same record in your SQL database? Will the Byte arrays belonging to each record contain recognition information for different people, or will each register multiple faces (in different poses) of the same user?

Perhaps you could save and load a separate global recognition database (i.e., Byte array) for all registered users, and use the returned ID to query the additional user information in the SQL database? This might simplify the overall design of your app, but I don’t know enough about it yet to say this would be a good approach.

-Bryan

[Tyler_C_1]

Bryan B. (Intel) wrote:

Hi Tyler,

I’m trying to understand your application better. Are you storing the ID and binary data (i.e., the Byte array representing the recognition database) as fields belonging to the same record in your SQL database? Will the Byte arrays belonging to each record contain recognition information for different people, or will each register multiple faces (in different poses) of the same user?

Perhaps you could save and load a separate global recognition database (i.e., Byte array) for all registered users, and use the returned ID to query the additional user information in the SQL database? This might simplify the overall design of your app, but I don’t know enough about it yet to say this would be a good approach.

-Bryan

Sorry I did not explain better but yes, in my SQL database I have the ID and binary data as fields belonging to an individual user record.  My plan in theory was to store the binary data for each user and be able to register multiple faces as you said in different poses.  Then I wanted to have the camera search for and make a match on the users binary data and allowing me to return the information related to that user.  The idea of the application is creating a clock in and out system for registered people entering and leaving the building. Maybe someone has a better idea to go about this than I am.

I did mess around with the second method you mentioned with using the returned ID to query additional user information and that seemed to work but from my understanding the current global recognition database only can hold 20 users and I am estimating I will be over that number.  That's why I was thinking of storing the facial recognition for each user in SQL I would be able to work around that.  Again I am a beginner working in this environment and I am not sure if it is possible for the SDK to work in that way.  Any help would be appreciated.  Thanks!