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[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 MedicineCategory:Articles containing explicitly cited English-language text[6]).
Attributes
ORDAudio[7] ORDDoc[8] ORDImage[9] ORDVideo[10]
descriptionsourcesourcedescription
sourceformatheightsource
formatmimeTypewidthformat
mimeTypecontentLengthcontentLengthmimeType
commentscommentsfileFormatcomments
encodingcontentFormatwidth
numberOfChannelscompressionFormatheight
sampleSizemimeTypeframeResolution
compressionTypeframeRate
audioDurationvideoDuration
numberOfFrames
compressionType
numberOfColors
bitRate

Utilization

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

Oracle HTTP Server

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

Category:Book:Oracle Database#Multimedia%20Databases%20
Category:Articles containing explicitly cited English-language text Category:Book:Oracle Database Category:CS1 French-language sources (fr) Category:CS1 errors: dates Category:CS1 errors: unsupported parameter Category:CS1 maint: uses authors parameter