Schema of Enhancing User Authentication and Encrypting Lob Data in ODBC Driver for Database

Abstract:

For commercial database management system is not suitable for storing sensitive data, the data is often encrypted in application before keeping into database. Using UDF (User Defined Function) can simplify the encrypting procedure, but it can't handle Lob (Long object) data. A schema of enhancing user authentication and encrypting Lob data in ODBC (Open Database Connection) driver for database is prosed. By adding necessary attributes of user authentication and cipher algorithm to encrypt Lob data in ODBC driver, the security of data stored in database is improved. Experiments show that the schema is transparent, efficient, easy to implement and reliable.

• Periodical: Applied Mechanics and Materials (Volumes 543-547)
• Pages: 3688-3691
• DOI: https://doi.org/10.4028/www.scientific.net/AMM.543-547.3688
• Online since: March 2014
• Authors: Bao Hua Huang*, Tian Jing Wang, Yan Ma, Feng Jiang
• Keywords: Authentication, Database, Encrypting, LOB, Odbc

References

[1] M. Gertz and S. Jajodia: Handbook of Database Security (Springer, Heidelberg Germany 2007).

[2] Information on http: /en. wikipedia. org/wiki/User-defined_function.

[3] Information on http: /dev. mysql. com/doc/refman/5. 7/en.

[4] B. Huang, T. Wang, Y. Ma, F. Jiang: submitted to the 3rd International Conference on Information Technology and Computer Applications (2014).

[5] Information on http: /en. wikipedia. org/wiki/ODBC.

[6] Information on http: /www. minisoft. com/pages/middleware/middleware. html.