Managing Multimedia and Unstructured Data in the Oracle Database
eBook - ePub

Managing Multimedia and Unstructured Data in the Oracle Database

  1. 504 pages
  2. English
  3. ePUB (mobile friendly)
  4. Available on iOS & Android
eBook - ePub

Managing Multimedia and Unstructured Data in the Oracle Database

Book details
Book preview
Table of contents
Citations

About This Book

In Detail

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.

Approach

This book is written in simple, easy to understand format with lots of screenshots and step-by-step explanations.

Who this book is for

If you are an Oracle database administrator, Museum curator, IT manager, Developer, Photographer, Intelligence team member, Warehouse or Software Architect then this book is for you. It covers the basics and then moves to advanced concepts. This will challenge and increase your knowledge enabling all those who read it to gain a greater understanding of multimedia and how all unstructured data is managed.

Frequently asked questions

Simply head over to the account section in settings and click on ā€œCancel Subscriptionā€ - itā€™s as simple as that. After you cancel, your membership will stay active for the remainder of the time youā€™ve paid for. Learn more here.
At the moment all of our mobile-responsive ePub books are available to download via the app. Most of our PDFs are also available to download and we're working on making the final remaining ones downloadable now. Learn more here.
Both plans give you full access to the library and all of Perlegoā€™s features. The only differences are the price and subscription period: With the annual plan youā€™ll save around 30% compared to 12 months on the monthly plan.
We are an online textbook subscription service, where you can get access to an entire online library for less than the price of a single book per month. With over 1 million books across 1000+ topics, weā€™ve got you covered! Learn more here.
Look out for the read-aloud symbol on your next book to see if you can listen to it. The read-aloud tool reads text aloud for you, highlighting the text as it is being read. You can pause it, speed it up and slow it down. Learn more here.
Yes, you can access Managing Multimedia and Unstructured Data in the Oracle Database by Marcelle Kratochvil in PDF and/or ePUB format, as well as other popular books in Computer Science & Entreprise Applications. We have over one million books available in our catalogue for you to explore.

Information

Year
2013
ISBN
9781849686921
Edition
1

Managing Multimedia and Unstructured Data in the Oracle Database


Table of Contents

Managing Multimedia and Unstructured Data in the Oracle Database
Credits
About the Author
Acknowledgement
About the Reviewers
www.PacktPub.com
Support files, eBooks, discount offers and more
Why Subscribe?
Free Access for Packt account holders
Instant Updates on New Packt Books
Preface
What this book covers
Who this book is for
Conventions
Chapter References
Reader feedback
Customer support
Errata
Piracy
Questions
1. What is Unstructured Data?
Digital data
Metadata
Defining unstructured data
Terminology
Image
Digital file
Digital image
Digital object
Digital content
Digital asset
Digital material
Digital library
Analyzing the digital object
Digital object types
Core types
Subtypes
Picture
Audio
Model
Creating new base types
Document
Video
Multimedia (Rich Media)
Data
Simulation
Genealogy
Virtual digital object
Digital object delivery
Manipulating digital objects
Conversion
Transformation
Extraction
Compression
Image comparison
Badly compressed
Thumbnail
Transposition
Searching
Product group
Location
Defining multimedia in the Oracle database
Photograph
Video
Audio
Document
Text
Artifact
Additional multimedia types
Composite types
Container
ZIP files
Metadata
The NULL case
Why store unstructured data in a database?
Manageability
Security
Backup/recovery
Integration
Extensibility
Flexibility
Features
Why not store the multimedia in the filesystem?
Why use Oracle multimedia and not a blob?
Addressing the concerns
Performance
Database size
Complexity
Summary
Exercises
Unstructured data conversion table
2. Understanding Digital Objects
Definitions
Raw format
Compression
Lossy data compression
Lossless data compression
Codec
Container
Understanding each image type
Photo
Icon
Color space
Color calibration
The RGB color model family
Viewing colors
Printing using the CMYK colorspace
Other color spaces
Little endian and big endian
Digital image storage formats
Raster graphics formats
Raw
Vector graphics
Audio
Bit rate
Encoding
Channels
Video
Frame
Frame resolution
Frame aspect ratio
Frame rate
Progressive scan versus interlaced
Codecs/containers
Issues when converting
Documents
Terminology
PDF
DOC/DOCX
ODT
TXT
Transformation
Digital object composition
The starting base ā€“ NULL object
The original image
Indexed digital object
Pyramid index
Derivatives
Masters
Components
Version hierarchies
Relationships
Unstructured data business cases
Sporting club
Charity
Neighborhood watch
News
Food
Government
Summary
Exercises
3. The Multimedia Warehouse
Comparing
The data warehouse
Data consistency
Logical Data Consistency
Dilapidated warehouse
Security
Performance
Information overload
Types of multimedia warehouses
Traditional
Image bank
Data mart
Public
eSales
Intelligence (security/defence)
Structures
Collections
Groups
Categories
Lightbox
Relationships
Thesaurus
Taxonomy
Metadata standards
Digital images
IPTC
EXIF
XMP
Audio
ID3
Relational
CDWA Lite
The Dublin CoreĀ® metadata Initiative
Darwin Core
Media Art Notation System
Image tagging
Crowdsourcing
Gaming techniques
Data types
Text
Date
Interval
Time
Season
Circa
Boolean
Number
Metric and imperial
Accession number
Name
Address
Filename
Spatial co-ordinate
Summary
Exercises
4. Searching the Multimedia Warehouse
Multilingual data
Storing
Diacritic
Multiple languages
Translating
Security
Searching
Indexing performance
Metadata based
Image structure
Electronic commerce
False positives
Stop words
The living search
Data mining
Big O notation
Representing the results
Interface
Visualize the results
Tag cloud
Infinite zoom
Complex social network
Tree map
Lightbox
VRML and SVG
Synchronized Multimedia Integration Language (SMIL)
HTML 5
Adobe Flash
Voice XML
Other devices
Braille devices
Audio
Search features
Summary groups
Workarea
Non discriminatory search
Result notification
Restrict the results
Control the output
Audit search
Designing a search language
Search context
Set theory primer
Order of precedence
Specialized query terms
Spelling mistakes
Sounds like
Stem search
Ranking
Mandatory and other terms
Word frequency
The trouble with documents
Autosuggest
Search engine scalability
Federated search
Fuzzy searching
Collaboration search
Summary
Exercises
5. Loading Techniques
Loading methods
Finding the images
Pull method
Vertical parallelism
Horizontal parallelism
Push method
Cartridge method
Loading method
Metadata matches to digital object
Digital object matches to metadata
Mixed digital object and metadata
Digital object no metadata
Many masters
Derivatives
Matching existing data to images
Filename encoding
Data cleansing
Loading decisions
Types of loading
Batch
Hot folder
Integration API
Manual
Loading step-by-step
Error handling
Logical errors
Loading via a workflow
Summary
Exercises
6. Delivery Techniques
Securing an image
Protection from theft
Is it really theft?
Modification
Disruption
Copying
Theft
Forgery
Destruction
Plagiarism
Illegal access
Replace
Accidental
Harvesting
Other
Protection methods
Visible
Preventive
Bookmarking
Reactive
Auditable
Self destruction
Accept
Legal proof
A look at different business situations
Copyright
Greeting card
Music
Electronic commerce
Not all browsers are the same
IP address country tracking
Order lifecycle
Payment methods
A comprehensive audit trail
Locking down the price
Post processing issue
What are you buying?
Price books
Pricing options
Understanding the business rules
Tax rule
Download rule
Pricing rule
User fees rule (pricing calculator)
Postage rule
Mixed orders
Split orders
Combining items
Free postage
Pick up
Negotiated
Delayed
Monitoring
Payment rule
Customer information rule
Customer trigger rule
Discount rule
Refund rule
Ticketing rule
Integrated stock management
Post-purchase workflow
Summary
Exercises
7. Techniques for Creating a Multimedia Database
Tier architecture
Traditional no tier
Two tier
Three tier
Virtualized architecture
Mobile applications architecture
Basic database configuration concepts
ASMā€”Automated Storage Management
Block size
UNIFORM extent size and AUTOALLOCATE
Locally managed tablespace UNIFORM extent size
Temporary tablespace
UNDO tablespace
SYSTEM tablespace
Redo logs
Analysis
Oracle Securefile architecture
Enabling storage in row
CHUNK
Logging
Cache
Managing duplicate images
Retention
Lob compression
Encryption
Read-only tablespace
Where does Oracle Multimedia fit in?
Understanding the ORDSYS data types
Creating a table
How to query?
Multimedia methods
Creating a schema
Oracle HTTP servers
Configuring the Oracle embedded gateway
Configuring Apache
Basic diagnostics
Windows
Unix
HTTPD.CONF file
Virtual hosts
Apache rewrites
External locations and security
Oracle directory
Granting access to a directory
UTL_FILE
UTL_TCP
Java
Discussing Raid, SSD, SANs, and NAS
Solid State Disk
Raid 0: stripe across both disks
Raid 1: mirror
Raid 0+1: stripe then mirror
Raid 1+0: mirrors then stripe
Raid 5: parity check
Raid 6: double parity check
NAS
SAN
Setting up Oracle XE to run Oracle Multimedia
Summary
Exercises...

Table of contents

  1. Managing Multimedia and Unstructured Data in the Oracle Database