Extending SQL CLI for Large Object Caching 


Vol. 8,  No. 1, pp. 1-9, Feb.  2001
10.3745/KIPSTD.2001.8.1.1


PDF
  Abstract

The SQL CLI (Call Level Interface) is a database application programming interface (API) that fits the client-server environment, and its de facto standards such as ODBC and JDBC are widely employed in various applications. The current SQL CLI standards, however, do not specify enough features for efficient retrieval of large objects (LOBs) that constitute the multimedia data. In this paper, we propose the LOB caching through the SQL CLI and describe the extension of the SQL CLI to achieve such a goal. We implement our proposal by extending the SQL CLI library for BADA-II DBMS developed at ETRI, and evaluate the performance of LOB retrieval through the cache compared to that of LOB retrieval conducted solely with the functions specified in the current SQL CLI standards.

  Statistics


  Cite this article

[IEEE Style]

J. M. Lee and H. C. Kang, "Extending SQL CLI for Large Object Caching," The KIPS Transactions:PartD, vol. 8, no. 1, pp. 1-9, 2001. DOI: 10.3745/KIPSTD.2001.8.1.1.

[ACM Style]

Jong Min Lee and Hyun Chul Kang. 2001. Extending SQL CLI for Large Object Caching. The KIPS Transactions:PartD, 8, 1, (2001), 1-9. DOI: 10.3745/KIPSTD.2001.8.1.1.