Book Image

Managing Multimedia and Unstructured Data in the Oracle Database

By : MARCEL KRATOCHVIL
Book Image

Managing Multimedia and Unstructured Data in the Oracle Database

By: MARCEL KRATOCHVIL

Overview of this book

Multimedia is the new digital frontier. Managers, software architects, administrators and developers need to fully comprehend this exciting new technology as its widespread use and acceptance cannot be ignored any longer."Managing Multimedia and Unstructured Data in the Oracle Database" will give you a complete understanding of how to manage all data, especially multimedia. You will learn all the latest terminology, how to set up a database, load digital objects, search on them and even how to sell them. Whether you are a manager or database administrator, this book will give you the knowledge you need to take control of this rapidly growing and industry- changing technology. Technology which is transforming our lives.Starting with the basic principles of unstructured data and detailing the concepts behind multimedia warehouses and digital asset management systems, this book will describe how to load this data, search against it, display it intelligently, and deliver it to customers and users. Learn how all these concepts work within the Oracle 11g R2 database environment and how to tune the database effectively to manage it.Begin to learn about this new and exciting field and use it to give your business a competitive edge or give yourself the ability to take a leadership role in this exciting new computing genre.

Related Content you might be interested in

Current Title:

Small book image
Managing Multimedia and Unstructured Data in the Oracle Database
MARCEL KRATOCHVIL
Mar, 2013 | 504 pages
No titles found
Table of Contents (22 chapters)
Managing Multimedia and Unstructured Data in the Oracle Database
Managing Multimedia and Unstructured Data in the Oracle Database
Credits
Credits
About the Author
About the Author
Acknowledgement
Acknowledgement
About the Reviewers
About the Reviewers
www.PacktPub.com
www.PacktPub.com
Preface
Preface
Free Chapter
1
What is Unstructured Data?
What is Unstructured Data?
Digital data
Defining unstructured data
Defining multimedia in the Oracle database
Why store unstructured data in a database?
Why not store the multimedia in the filesystem?
Why use Oracle multimedia and not a blob?
Summary
Exercises
Unstructured data conversion table
2
Understanding Digital Objects
Understanding Digital Objects
Definitions
Understanding each image type
Digital object composition
Summary
Exercises
3
The Multimedia Warehouse
The Multimedia Warehouse
Comparing
Structures
Metadata standards
Image tagging
Data types
Summary
Exercises
4
Searching the Multimedia Warehouse
Searching the Multimedia Warehouse
Multilingual data
Security
Searching
Summary
Exercises
5
Loading Techniques
Loading Techniques
Loading methods
Finding the images
Loading method
Matching existing data to images
Data cleansing
Loading decisions
Loading step-by-step
Summary
Exercises
6
Delivery Techniques
Delivery Techniques
Securing an image
Electronic commerce
Summary
Exercises
7
Techniques for Creating a Multimedia Database
Techniques for Creating a Multimedia Database
Tier architecture
Basic database configuration concepts
Oracle Securefile architecture
Where does Oracle Multimedia fit in?
Understanding the ORDSYS data types
Creating a schema
Oracle HTTP servers
Configuring the Oracle embedded gateway
Configuring Apache
HTTPD.CONF file
External locations and security
Discussing Raid, SSD, SANs, and NAS
Setting up Oracle XE to run Oracle Multimedia
Summary
Exercises
8
Tuning
Tuning
Introduction to tuning
Tuning methodologies
Tuning trend
Scalability
Object-oriented development
Basic tuning operations
Summary
Exercises
9
Understanding the Limitations of Oracle Products
Understanding the Limitations of Oracle Products
The basic requirements
A comparison
Oracle products
Summary
10
Working with the Operating System
Working with the Operating System
Why shell out?
Unload and load digital objects
How to shell out
Challenges when shelling out
Windows
Unix
Summary
Exercises
The Circa Data Type
The Circa Data Type
Railroad diagram
EBNF Syntax
Multimedia Case Studies
Multimedia Case Studies
Museum A
Department B
Museum C
Museum D
Whole of government E
Department F
Museum H
Photo laboratory G
Proactive Database Tuning
Proactive Database Tuning
The environment and the DBA
Cyclic maintenance
Database review
Forecasting
Data recovery
Chapter References
Chapter References
Chapter 1
Chapter 2
Chapter 3
Chapter 4
Chapter 8
Chapter 9
Chapter 10
Index
Index

Unstructured data conversion table

From

→ To

Photo

Document

Audio

Video

Blueprint

Relational

Neural Network

Photo

 

OCR. Read textual data from an image. Can be a fax or data on an existing image.

Audio commentary is attached to image.

Multiple photos are combined into a video or animation like a slideshow.

3D imaging such as VRML

Metadata is extracted about the photo (EXIF, IPTC).

Network visualizes and understands the photo.

Document

Pages are scanned in or converted to an image.

 

Text to speech conversion.

The closest equivalent is animation.

Pages are transformed into 3D virtual book

Metadata is extracted about the document (header).

Network reads and understands the document contents.

Audio

Waveforms of audio turned into an image.

Speech is converted to text.

 

Audio is streamed as per video.

3D visualization of the audio is created

Metadata is extracted about the audio (ID3).

Network listens and understands the audio file.

Video

A frame is extracted from the video.

Metadata about the video is extracted.

Audio stream is extracted from the video stream.

 

An animated 3D version of the video is created

Metadata is extracted about the video.

Network views and understands the video.

Blueprint

A scene, icon or screen shot is extracted from the program.

Instructions, manual, code is extracted.

Audio is extracted from the visual structure.

Animation is extracted from the visual structure.

 

Metadata is extracted.

Network looks at and can interpret the 3D view.

Relational

Data is converted into graphical (see Excel, Reports).

Report is generated.

Data is converted to speech as per document.

Data mining analysis converts to video.

Instructions (similar to SVG) is converted to visual

 

Network interprets and understands the data.

Neural network

A visual representation of the network is displayed.

Report / documentation about the simulation is produced.

Commentary is given on the simulation.

The simulation is animated.

A VRML representation of the network

Metadata is extracted.

 
Previous Section
End of Chapter 1
Next Chapter