PacktLib: Managing Multimedia and Unstructured Data in the Oracle Database

Managing Multimedia and Unstructured Data in the Oracle Database

Credits

About the Author

Acknowledgement

About the Reviewers

www.PacktPub.com

Preface

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

Understanding Digital Objects

Definitions

Understanding each image type

Digital object composition

Summary

Exercises

The Multimedia Warehouse

Comparing

Structures

Metadata standards

Image tagging

Data types

Summary

Exercises

Searching the Multimedia Warehouse

Multilingual data

Security

Searching

Summary

Exercises

Loading Techniques

Loading methods

Finding the images

Loading method

Matching existing data to images

Data cleansing

Loading decisions

Loading step-by-step

Summary

Exercises

Delivery Techniques

Securing an image

Electronic commerce

Summary

Exercises

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

Tuning

Introduction to tuning

Tuning methodologies

Tuning trend

Scalability

Object-oriented development

Basic tuning operations

Summary

Exercises

Understanding the Limitations of Oracle Products

The basic requirements

A comparison

Oracle products

Summary

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

The Circa Data Type

Multimedia Case Studies

Multimedia Case Studies

Multimedia Case Studies

Multimedia Case Studies

Multimedia Case Studies

Multimedia Case Studies

Multimedia Case Studies

Multimedia Case Studies

Multimedia Case Studies

Proactive Database Tuning

Proactive Database Tuning

Proactive Database Tuning

Proactive Database Tuning

Proactive Database Tuning

Proactive Database Tuning

Chapter References

Chapter References

Chapter References

Chapter References

Chapter References

Chapter References

Chapter References

Chapter References

Index