Search icon
Arrow left icon
All Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Newsletters
Free Learning
Arrow right icon
Managing Multimedia and Unstructured Data in the Oracle Database

You're reading from  Managing Multimedia and Unstructured Data in the Oracle Database

Product type Book
Published in Mar 2013
Publisher Packt
ISBN-13 9781849686921
Pages 504 pages
Edition 1st Edition
Languages
Author (1):
MARCEL KRATOCHVIL MARCEL KRATOCHVIL
Profile icon MARCEL KRATOCHVIL

Table of Contents (22) Chapters

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? Understanding Digital Objects The Multimedia Warehouse Searching the Multimedia Warehouse Loading Techniques Delivery Techniques Techniques for Creating a Multimedia Database Tuning Understanding the Limitations of Oracle Products Working with the Operating System The Circa Data Type Multimedia Case Studies Proactive Database Tuning Chapter References Index

Unload and load digital objects


When it comes to shelling out of the database and processing a digital object, it becomes apparent that the digital object needs to be unloaded and saved into the filesystem for processing. This is an additional process and can take time if the digital object is quite large. By using Oracle Securefiles, this step is much faster to perform, but it still is an additional step. Though there are many disadvantages to storing a digital object outside the database, the one advantage in doing it can be seen when it comes to external processing. By storing, it externally needs to unload and reload the processed digital object that is removed. This simplifies the process.

As has been covered in previous chapters, one of the exciting features in the latest 11gR2 release is the Oracle Database File System. This removes the need to unload the digital object when it's stored in the database. This is because the filesystem is integrated with the database. In this case, all...

lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at $15.99/month. Cancel anytime}