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

Understanding the ORDSYS data types

This section covers methods for creating and working with tables using the Oracle Multimedia data types. Further information on each of the types can be found in Appendix E, Loading and Reading.

Creating a table

As the ORDSYS Multimedia types reference ORDSYS.ORDSOURCE, which in turn references a BLOB, the database administrator has the option of specifying all the storage parameters for each of the columns. For example, the table created looks like the following:

create table myimage(
 pk number,
 myphoto ORDSYS.ORDIMAGE,
 myvideo ORDSYS.ORDVIDEO
)

The resulting storage parameters would like like the following:

create table myimage
(
 pk number,
 myphoto ORDSYS.ORDIMAGE,
 myvideo ORDSYS.ORDVIDEO
)
tablespace relational_tbls pctfree 5 storage( pctincrease 0 maxextents unlimited)
   LOB (myphoto.source.localdata) 
    STORE AS SECUREFILE l_myphoto
      (TABLESPACE image_tbls
       disable storage in row
       RETENTION AUTO
       NOCOMPRESS
       KEEP_DUPLICATES...
Previous Section
End of Section 6
Next Section