Managing Multimedia and Unstructured Data in the Oracle Database


Managing Multimedia and Unstructured Data in the Oracle Database
eBook: $35.99
Formats: PDF, PacktLib, ePub and Mobi formats
$30.59
save 15%!
Print + free eBook + free PacktLib access to the book: $95.98    Print cover: $59.99
$59.99
save 37%!
Free Shipping!
UK, US, Europe and selected countries in Asia.
Also available on:
Overview
Table of Contents
Author
Support
Sample Chapters
  • Full of illustrations, diagrams, and tips with clear step-by-step instructions and real time examples
  • Get up to speed on all the aspects of this new technology
  • Learn how to work with rich multimedia and control it

Book Details

Language : English
Paperback : 504 pages [ 235mm x 191mm ]
Release Date : March 2013
ISBN : 1849686920
ISBN 13 : 9781849686921
Author(s) : Marcelle Kratochvil
Topics and Technologies : All Books, Enterprise Products and Platforms, Enterprise, Oracle

Table of Contents

Preface
Chapter 1: What is Unstructured Data?
Chapter 2: Understanding Digital Objects
Chapter 3: The Multimedia Warehouse
Chapter 4: Searching the Multimedia Warehouse
Chapter 5: Loading Techniques
Chapter 6: Delivery Techniques
Chapter 7: Techniques for Creating a Multimedia Database
Chapter 8: Tuning
Chapter 9: Understanding the Limitations of Oracle Products
Chapter 10: Working with the Operating System
Appendix A: The Circa Data Type
Appendix B: Multimedia Case Studies
Appendix C: Proactive Database Tuning
Appendix D: Chapter References
Index
  • Chapter 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
    • Chapter 2: Understanding Digital Objects
      • Definitions
        • Raw format
        • Compression
        • Lossy data compression
        • Lossless data compression
        • Codec
        • Container
      • Understanding each image type
        • Photo
          • Icon
          • Color space
          • Little endian and big endian
          • Digital image storage formats
          • Vector graphics
        • Audio
          • Bit rate
          • Encoding
          • Channels
        • Video
          • Frame
          • Frame resolution
        • Documents
          • Terminology
          • 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
      • Chapter 3: The Multimedia Warehouse
        • Comparing
          • The data warehouse
            • 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
        • Chapter 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
            • 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
              • Stem search
              • Ranking
              • Mandatory and other terms
              • Word frequency
              • Autosuggest
              • Search engine scalability
            • Federated search
            • Fuzzy searching
            • Collaboration search
          • Summary
          • Exercises
          • Chapter 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
            • Chapter 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
              • Understanding the business rules
                • Tax rule
                • Download rule
                • Pricing rule
                • User fees rule (pricing calculator)
                • Postage rule
                • Payment rule
                • Customer information rule
                • Customer trigger rule
                • Discount rule
                • Refund rule
                • Ticketing rule
                • Integrated stock management
                • Post-purchase workflow
            • Summary
            • Exercises
              • Chapter 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
                • Chapter 8: Tuning
                  • Introduction to tuning
                  • Tuning methodologies
                    • Reactive versus proactive (for the novice administrator)
                    • What is the role of the DBA?
                      • History
                  • Tuning trend
                  • Scalability
                    • Scalability is bidirectional
                    • Database breakpoints
                      • Locking
                      • CPU limits
                      • Memory limits
                      • Hardware limits
                      • Database limits
                      • Database management
                      • Backup/recovery
                    • Multimedia scalability
                      • Dimension 1 – loading a large number of multimedia files
                      • Dimension 2 – storing a large number of multimedia files
                      • Dimension 3 – loading a very large multimedia file
                      • Dimension 4 – retrieving a large number of multimedia files
                      • Dimension 5 – database management
                    • General considerations
                      • Loading in parallel
                      • Insert/delete performance
                      • Extreme scalability
                  • Object-oriented development
                    • PC mentality
                    • The three tier – ignore the database mentality
                    • Our application should be able to run against any database
                • Basic tuning operations
                  • Network
                    • HTTPS
                    • VPN
                    • Efficiency in sending
                    • XML and web services
                    • Back to three tier and scalability
                  • Memory
                  • CPU
                  • I/O
                  • Parallelism
                    • Image loading
                    • Horizontal versus vertical parallelism
                  • Locking
                  • Database parameters
                    • plsql_code_type
                    • optimizer_mode
                    • Hints
                  • Backups
                  • Oracle partitioning
                    • Manual partitioning
                  • Indexing
                    • Photo
                    • Video
                    • Audio
                    • Documents
                  • Scalability using Oracle XE
                    • Breaking the rules with XE
                    • VM vSphere
                • Summary
                • Exercises
                  • Chapter 9: Understanding the Limitations of Oracle Products
                    • The basic requirements
                      • Acting as more than a filesystem
                        • Full backup/recovery
                        • Long term archival
                        • Data distribution and network balancing
                        • High speed and scalable image loading and processing
                        • Storage scalability to petabytes of data
                        • Flexible image delivery
                        • Security, auditing, and protection from user error (versioning)
                        • Supporting for most image types
                        • Litmus test
                    • A comparison
                    • Oracle products
                      • Development
                        • SQL Developer (v3.1)
                        • SQL*Plus
                        • PL/SQL
                        • Supplied packages
                        • PL/SQL Web Toolkit
                        • SQL
                        • Java
                        • XML
                        • Edition-Based Redefinition
                        • Apex (Oracle Application Express)
                      • Storage
                        • Tablespaces and datafiles
                        • Storage parameters
                        • Partitioning
                        • ASM
                        • DBFS Filesystem
                      • Monitoring
                        • Enterprise Manager
                        • Resource management
                      • Database
                        • Data types
                        • Advanced compression
                        • OLAP
                        • Indexes
                        • Embedded gateway
                        • Data dictionary
                        • Heterogeneous gateway
                      • Tuning
                        • Automatic memory management
                        • Optimizer
                        • Networking
                      • Backup/Recovery
                        • Total recall (flashback)
                        • Redo logs and archives
                        • Data guard
                        • RMAN
                        • Utilities
                        • Streams
                        • Advanced replication
                      • Options
                        • Multimedia
                        • Spatial
                        • Text
                        • Semantics
                        • Warehouse
                        • Data Mining
                      • Security
                        • Encryption
                        • Data vault
                        • Oracle label security
                      • High availability
                        • RAC
                        • Exadata
                        • ZFS
                    • Summary
                    • Chapter 10: Working with the Operating System
                      • Why shell out?
                      • Unload and load digital objects
                      • How to shell out
                        • Java
                        • Scheduler
                        • Advanced queueing or pipes
                        • UTL_TCP
                      • Challenges when shelling out
                        • Synchronous or asynchronous?
                        • Hidden Ctrl + M characters on Unix
                        • Capturing output
                        • Parameters
                        • Dynamic shell scripts
                        • Windows program on processing, calls an actual window?
                        • Filesystem limitations
                    • Windows
                      • Powershell versus DOS
                      • LUN
                    • The variety of versions
                      • The Windows Services interface
                      • Windows 2012 and Windows 8
                      • Windows 2008 R2 and Windows 7
                      • Windows 2008 and Windows Vista
                      • Windows 2003
                      • Windows XP
                      • Windows 2000
                    • Unix
                      • How Unix differs from Windows
                      • The variety of versions
                        • Linux
                        • Ubuntu Linux
                        • Solaris
                        • IBM AIX
                        • HP-UX
                    • Summary
                    • Exercises

                              Marcelle Kratochvil

                              Marcelle Kratochvil is an accomplished Oracle database administrator and developer. She is CTO of Piction and has designed and developed industry leading software for the management and selling of digital assets. She has also developed an award winning shipping and freight management system, designed and built a booking system, a sport management system, a e-commerce system, social network engine, a reporting engine and numerous search engines. She has been an Oracle beta tester since the original introduction of Oracle Multimedia. She is also a well known presenter at Oracle Conferences and has produced numerous technical podcasts. Born in Australia, she is living in Canberra. She is actively working as a database administrator on supporting a large number of customer sites internationally. She is also campaigning with Oracle to promote the use of storing all data and any data in a database. In her spare time she plays field hockey and does core research in artificial intelligence in database systems. Marcelle has a Bachelor of Science Degree from the Australian National University and majored in computing and mathematics.
                              Sorry, we don't have any reviews for this title yet.

                              Submit Errata

                              Please let us know if you have found any errors not listed on this list by completing our errata submission form. Our editors will check them and add them to this list. Thank you.

                              Sample chapters

                              You can view our sample chapters and prefaces of this title on PacktLib or download sample chapters in PDF format.

                              Frequently bought together

                              Managing Multimedia and Unstructured Data in the Oracle Database +    IBM Cognos TM1 Developer's Certification guide =
                              50% Off
                              the second eBook
                              Price for both: $51.15

                              Buy both these recommended eBooks together and get 50% off the cheapest eBook.

                              What you will learn from this book

                              • 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

                              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.

                              Code Download and Errata
                              Packt Anytime, Anywhere
                              Register Books
                              Print Upgrades
                              eBook Downloads
                              Video Support
                              Contact Us
                              Awards Voting Nominations Previous Winners
                              Judges Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software
                              Resources
                              Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software