< Oracle Database

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 Medicine[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

  1. ↑ "Managing Oracle Multimedia Installations". http://www.comp.dit.ie/btierney/Oracle11gDoc/appdev.111/b28415/ap_instl_upgrd.htm.
  2. ↑ "Gestion avancée d'image sous Oracle avec Java" (in French). http://fildz.developpez.com/tutoriel/oracle-java/ordimage/.
  3. ↑ "Common Methods and Notes for Oracle Multimedia Object Types". https://docs.oracle.com/cd/E11882_01/appdev.112/e10776/ch_comref.htm#AIVUG3000.
  4. ↑ "Common Methods and Notes for Oracle Multimedia Object Types". https://docs.oracle.com/html/A67296_01/im_mmref.htm#998184.
  5. ↑ Lynne Dunckley, Larry Guros (8 avril 2011). Digital Press. ed. Oracle 10g Developing Media Rich Applications. https://books.google.fr/books?id=-dbeFbCswAYC&pg=PA60&dq=ORDSYS++ORDAudio+ORDDoc+ORDImage+ORDVideo+ORDSource&hl=fr&sa=X&ved=0ahUKEwj7z9jC5OPKAhVHMhoKHXsYCr8Q6AEIJjAB#v=onepage&q=ORDSYS%20%20ORDAudio%20ORDDoc%20ORDImage%20ORDVideo%20ORDSource&f=false.
  6. ↑ "Medical Imaging and Communication". https://docs.oracle.com/database/121/IMDCM/ch_intro.htm#IMDCM1100.
  7. ↑ "ORDAudio". https://docs.oracle.com/cd/B19306_01/appdev.102/b14297/ch_audref.htm.
  8. ↑ "ORDDoc". https://docs.oracle.com/cd/B28359_01/appdev.111/b28414/ch_docref.htm.
  9. ↑ "ORDImage". https://docs.oracle.com/cd/B28359_01/appdev.111/b28414/ch_imgref.htm.
  10. ↑ "ORDVideo". https://docs.oracle.com/cd/B28359_01/appdev.111/b28414/ch_vidref.htm.
This article is issued from Wikibooks. The text is licensed under Creative Commons - Attribution - Sharealike. Additional terms may apply for the media files.