Managing Multimedia and Unstructured Data in the Oracle Database

A revolutionary approach to understanding, managing, and delivering digital objects, assets, and all types of data

Managing Multimedia and Unstructured Data in the Oracle Database

Marcelle Kratochvil

A revolutionary approach to understanding, managing, and delivering digital objects, assets, and all types of data
Mapt Subscription
FREE
$29.99/m after trial
eBook
$25.20
RRP $35.99
Save 29%
Print + eBook
$59.99
RRP $59.99
What do I get with a Mapt Pro subscription?
  • Unlimited access to all Packt’s 5,000+ eBooks and Videos
  • Early Access content, Progress Tracking, and Assessments
  • 1 Free eBook or Video to download and keep every month after trial
What do I get with an eBook?
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with Print & eBook?
  • Get a paperback copy of the book delivered to you
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with a Video?
  • Download this Video course in MP4 format
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
$0.00
$25.20
$59.99
$29.99p/m after trial
RRP $35.99
RRP $59.99
Subscription
eBook
Print + eBook
Start 30 Day Trial
Subscribe and access every Packt eBook & Video.
 
  • 5,000+ eBooks & Videos
  • 50+ New titles a month
  • 1 Free eBook/Video to keep every month
Start Free Trial
 
Code Files
Preview in Mapt

Book Details

ISBN 139781849686921
Paperback504 pages

Book Description

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.

Table of Contents

Chapter 1: 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
Chapter 2: Understanding Digital Objects
Definitions
Understanding each image type
Digital object composition
Summary
Exercises
Chapter 3: The Multimedia Warehouse
Comparing
Structures
Metadata standards
Image tagging
Data types
Summary
Exercises
Chapter 4: Searching the Multimedia Warehouse
Multilingual data
Security
Searching
Summary
Exercises
Chapter 5: Loading Techniques
Loading methods
Finding the images
Loading method
Matching existing data to images
Data cleansing
Loading decisions
Loading step-by-step
Summary
Exercises
Chapter 6: Delivery Techniques
Securing an image
Electronic commerce
Summary
Exercises
Chapter 7: 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
Chapter 8: Tuning
Introduction to tuning
Tuning methodologies
Tuning trend
Scalability
Object-oriented development
Basic tuning operations
Summary
Exercises
Chapter 9: Understanding the Limitations of Oracle Products
The basic requirements
A comparison
Oracle products
Summary
Chapter 10: 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

What You Will Learn

  • Discover a whole new world beyond relational databases
  • Understand what is involved in selling a digital image
  • Learn about the different types of multimedia warehouses
  • Uncover the truth behind searching for digital objects
  • Understand the complete picture for tuning an Oracle database with multimedia
  • Get to grips with all the issues in setting up a digital asset e-commerce system
  • Understand what multimedia and unstructured data really is
  • Realise how the Oracle database can work with multimedia
  • Get to grips with digital image processing and transformation techniques
  • Expand your database knowledge to include complex data
  • Add credibility to your resume by adopting this new and visually exciting technological direction

Authors

Table of Contents

Chapter 1: 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
Chapter 2: Understanding Digital Objects
Definitions
Understanding each image type
Digital object composition
Summary
Exercises
Chapter 3: The Multimedia Warehouse
Comparing
Structures
Metadata standards
Image tagging
Data types
Summary
Exercises
Chapter 4: Searching the Multimedia Warehouse
Multilingual data
Security
Searching
Summary
Exercises
Chapter 5: Loading Techniques
Loading methods
Finding the images
Loading method
Matching existing data to images
Data cleansing
Loading decisions
Loading step-by-step
Summary
Exercises
Chapter 6: Delivery Techniques
Securing an image
Electronic commerce
Summary
Exercises
Chapter 7: 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
Chapter 8: Tuning
Introduction to tuning
Tuning methodologies
Tuning trend
Scalability
Object-oriented development
Basic tuning operations
Summary
Exercises
Chapter 9: Understanding the Limitations of Oracle Products
The basic requirements
A comparison
Oracle products
Summary
Chapter 10: 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

Book Details

ISBN 139781849686921
Paperback504 pages
Read More

Read More Reviews

Recommended for You

Oracle Advanced PL/SQL Developer Professional Guide Book Cover
Oracle Advanced PL/SQL Developer Professional Guide
$ 35.99
$ 25.20
Hadoop Beginner's Guide Book Cover
Hadoop Beginner's Guide
$ 29.99
$ 21.00
Big Data Analytics with R and Hadoop Book Cover
Big Data Analytics with R and Hadoop
$ 29.99
$ 21.00
Oracle Database 11gR2 Performance Tuning Cookbook Book Cover
Oracle Database 11gR2 Performance Tuning Cookbook
$ 32.99
$ 23.10
Oracle Enterprise Manager Cloud Control 12c: Managing Data Center Chaos Book Cover
Oracle Enterprise Manager Cloud Control 12c: Managing Data Center Chaos
$ 38.99
$ 27.30
Oracle 11g Anti-hacker's Cookbook Book Cover
Oracle 11g Anti-hacker's Cookbook
$ 32.99
$ 23.10