Oracle Database/Multimedia Databases

From Wikibooks, open books for an open world
Jump to: navigation, search

Description[edit]

Oracle Multimedia is a services suite provided with Oracle Database (excluding the Express version where it can't be added[1]) since the version 8 (in 1997), to manage the multimedia databases.

It's composed by the package ORDSYS ("ORD" for object-relational data) allowing the multimedia objects management into the database[2]. This package includes several classes[3]:

  • ORDMultimedia: abstract superclass storage the common attributes and methods to the classes ORDAudio, ORDImage, and ORDVideo[4].
  • ORDAudio: sound properties storage.
  • ORDDoc: heterogeneous properties storage.
  • ORDImage: images properties storage.
  • ORDVideo: videos properties storage.
  • ORDSource: multimedia BLOB or BFILE (accessible in HTTP) properties storage[5].
  • DICOM (Digital Imaging and Communications in Medicine[6]).
Attributes
ORDAudio[7] ORDDoc[8] ORDImage[9] ORDVideo[10]
description source source description
source format height source
format mimeType width format
mimeType contentLength contentLength mimeType
comments comments fileFormat comments
encoding contentFormat width
numberOfChannels compressionFormat height
sampleSize mimeType frameResolution
compressionType frameRate
audioDuration videoDuration
numberOfFrames
compressionType
numberOfColors
bitRate

Utilization[edit]

CREATE TABLE MyImages (
	id	INTEGER PRIMARY KEY,
	image	ORDSYS.ORDImage
);

Oracle HTTP Server[edit]

Oracle HTTP ServerDownload (OHS) allows to execute PL/SQL requests from a navigator. It's a Web Tier component of the Oracle Fusion Middleware, based on Apache 2.

References[edit]