Skip to Content
0
Former Member
Oct 31, 2012 at 08:14 AM

Face Recognition using HANA

118 Views

Hi,

I am trying to gauge if HANA can be used to store bitmap images for faster face recognition as compared to RDBMS like Oracle or PostGRES. The requirement is to run a number of SQL queries against the bitmaps stored in HANA to detect a pattern match with the images being captured live via cameras. This application is intended as a security solution for public spaces. Current RDBMS is struggling with these queries and performance bottleneck needs to be removed.

Are there any metrics or case studies where HANA has been show to have an advantage for such queries, as compared to RDBMS?

Any use cases where bitmap queries have been used on HANA? I believe the data type would be BLOB.

Any help would be highly appreciated.

Binary Types

Binary types are used to store bytes of binary data.

  • VARBINARY
    The VARBINARY(n) data type is used to store binary data of a specified maximum length in bytes, where n indicates the maximum length and is an integer between 1 and 5000.

Large Object (LOB) Types

LOB (large objects) data types, CLOB, NCLOB and BLOB, are used to store a large amount of data such as text documents and images. The maximum size of an LOB is 2 GB.

  • BLOB
    The BLOB data type is used to store large binary data.