DB2 LOBs: the teenage years

Author

Lehman, T.J. ; Gainer, P.J.

Author_Institution

Almaden Res. Center, IBM Corp., San Jose, CA, USA

fYear

1996

fDate

26 Feb-1 Mar 1996

Firstpage

192

Lastpage

199

Abstract

Previous versions of DB2 Common Server had large objects (LOBs) that were neither large nor functional. Their size was limited to 32,700 bytes and, until recently when support for SUBSTR and CONCAT was added, there was no function available on these objects at all. DB2 LOBs were infants. However, with the latest release of DB2 Common Server, Version 2.1, LOBs have matured considerably supporting significantly larger sizes and many new language features. To give the reader a feeling for the extent of this new language support, we compare our new SQL LOB language features with that of three other major relational database competitors: Sybase, Informix and Oracle. Users will find the new DB2 LOBS easy to load and store, easy to search, and easy to integrate into the DB2 user-defined functions (UDFs) and user-defined types (UDTs). In addition, when used in serial mode, the performance of LOB I/O rivals that of file systems and, when used in parallel mode, is a clear winner. DB2 LOBs have now entered the teenage years

Keywords

SQL; file servers; input-output programs; query languages; relational databases; CONCAT; DB2 Common Server Version 2.1; DB2 I/O; DB2 large objects; DB2 user-defined functions; DB2 user-defined types; Informix; Oracle; SQL language features; SUBSTR; Sybase; language support; parallel mode; relational database; serial mode; File systems; Internet; Pediatrics; Relational databases; Search engines; Sorting; Spatial databases; Sun; Web server; Web sites;

fLanguage

English

Publisher

ieee

Conference_Titel

Data Engineering, 1996. Proceedings of the Twelfth International Conference on

Conference_Location

New Orleans, LA

ISSN

1063-6382

Print_ISBN

0-8186-7240-4

Type

conf

DOI

10.1109/ICDE.1996.492106

Filename

492106