LARGE OBJECT CACHING FOR DISTRIBUTED MULTIMEDIA INFORMATION SYSTEMS
Hyunchul Kang, Jong Min Lee · Journal of the Association for Information Systems · 2001
The large object(LOB) such as text, image, audio, video, etc. has become one of the typically encountered data type in today's internet/intranet-based distributed multimedia information system for business and other applications, and thus, needs to be efficiently retrieved from the remote databases.As such, its underlying database management system(DBMS) is required to efficiently support LOBs through its application programming interface(API).In this paper, we propose LOB caching through the SQL Call Level Interface, a widely employed API for database access, whereby the frequently accessed LOBs could be retrieved locally.The proposed extension was implemented on a DBMS, and the performance assessment of LOB retrieval with and without caching is reported.