Oracle Database/Multimedia Databases

Description

Oracle Multimedia is a services suite provided with Oracle Database (excluding the Express version where it can't be added) 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. This package includes several classes:

• ORDMultimedia: abstract superclass storage the common attributes and methods to the classes ORDAudio, ORDImage, and ORDVideo.
• 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.
• DICOM (Digital Imaging and Communications in Medicine).

Attributes

ORDAudio	ORDDoc	ORDImage	ORDVideo
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

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

Oracle HTTP Server

Oracle HTTP Server^Download (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

• "Multimedia User's Guide". {{cite web}}: Unknown parameter |site= ignored (help)