Multimedia data support in commercial DBMS

There are three kinds of DBMS that is available Commercially:

1.      Relational DMBS (RDBMS)

Oracle support three large object types that are used to store multimedia data types with Oracle InterMedia:

a.       BLOB (Binary Large Objects):

                                                              i.      Stores unstructured binary data in database

                                                            ii.      Can store up to 4 GB

b.      CLOB (Character Large Objects)

                                                              i.      Single-byte character set data

                                                            ii.      Sores up to 4GB

c.       NCLOB (National character set Character Large Objects)

                                                              i.      Fixed-width and varying width multi-byte national character set data

                                                            ii.      Stores up to 4 GB

Relational databases are efficient for numeric and textual data store, but do not conventionally support content based searches for multimedia content.

Example:

CREATE TABLE image_blob_table (

id NUMBER  PRIMARY KEY,
image_blob BLOB

);

INSERT INTO image_blob_table (id, image_blob)

VALUES (1, “<path_of_image>”);

2.      Object-Oriented DBMS (OODBMS)

Jasmine is an Object-Oriented database that stores the data in form of built in classes and objects. It comes with built in classes to include four multimedia classes:

a.       Picture

b.      Image

c.       Video

d.      Audio

These comes with manipulation and compression facilities. They also have been made to fit will with Java Media Framework

3.      Object-Relational DBMS (ORDMBS)

The BFILE data type in Oracle provides access to BLOB files up to 4 GB that are stored in file systems outside an Oracle database. The BFILE datatype allows read-only support of large binary files, you cannot modify a file through Oracle. Oracle provides APIs to access file data.