Unanswered: Using Large Object Data Types with Daffodil DB
As new technologies are evolving, the importance of large data storage is growing. The storage requirements of applications are also on an upward trend because the requirement to represent real life situations in databases has resulted in the need for Large object data types.
Multimedia entities like images, video, and audio clips were rarely used outside of specialty software. Today, many Web-based applications require their databases to manage such data. Other software's need to store bulk data concerned with routine diagrams, maps, or business models. In order to cater these needs, Daffodil DB supports the concept of large object data types. The large object data types are
* Character Large Objects (CLOB): A character string comprising of single-byte characters with an allied code page. This data type is best suited for storing text-oriented information where the size of data could grow beyond the limits of a regular VARCHAR data type.
* Binary Large Objects (BLOB): A BLOB is a binary large object that can hold a variable amount of data. This data type may be the most useful because it can store binary data, making it a perfect source type for use by User-defined Distinct Types. Blob columns can be used to store image, voice, graphical, and other types of business or application specific data.
An external location in the database stores all large object values outside their records in the table. There is a large object descriptor for each large object in each row of a table. The large object descriptor contains control information used to access the large object data stored elsewhere on disk. It is the storing of large object data outside their records that allows large objects to store up to 2 GB in size. Accessing the large object descriptor causes a small amount of overhead when manipulating large objects.
The maximum size for each large object column is part of the declaration of the large object type in the CREATE TABLE statement. The maximum size of a large object column determines the maximum size of any large object descriptor in that column. As a result, it also determines how many columns of all data types can fit in a single row.