Oracle Database/Multimedia Databases
Jump to navigation
Jump to search
Description[edit | edit source]
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]).
| 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 | edit source]
CREATE TABLE MyImages (
id INTEGER PRIMARY KEY,
image ORDSYS.ORDImage
);
Oracle HTTP Server[edit | edit source]
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 | edit source]
- ↑ "Managing Oracle Multimedia Installations".
- ↑ "Gestion avancée d'image sous Oracle avec Java" (in French).
- ↑ "Common Methods and Notes for Oracle Multimedia Object Types".
{{cite web}}: Unknown parameter|site=ignored (help) - ↑ "Common Methods and Notes for Oracle Multimedia Object Types".
{{cite web}}: Unknown parameter|site=ignored (help) - ↑
Lynne Dunckley, Larry Guros (8 avril 2011). Digital Press (ed.). Oracle 10g Developing Media Rich Applications.
{{cite book}}: Check date values in:|date=(help)CS1 maint: uses authors parameter (link) - ↑ "Medical Imaging and Communication".
{{cite web}}: Unknown parameter|site=ignored (help) - ↑ "ORDAudio".
{{cite web}}: Unknown parameter|site=ignored (help) - ↑ "ORDDoc".
{{cite web}}: Unknown parameter|site=ignored (help) - ↑ "ORDImage".
{{cite web}}: Unknown parameter|site=ignored (help) - ↑ "ORDVideo".
{{cite web}}: Unknown parameter|site=ignored (help)
- "Multimedia User's Guide".
{{cite web}}: Unknown parameter|site=ignored (help)