Extending SQL CLI for Large Object Caching


The KIPS Transactions:PartD, Vol. 8, No. 1, pp. 1-9, Feb. 2001
10.3745/KIPSTD.2001.8.1.1,   PDF Download:

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
Show / Hide Statistics

Statistics (Cumulative Counts from September 1st, 2017)
Multiple requests among the same browser session are counted as one view.
If you mouse over a chart, the values of data points will be shown.


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.