Table of Contents; 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; 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 dataTerminology; Image; Digital file; Digital image; Digital object; 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; Digital content; Digital asset; Digital material; Digital library.

Defining multimedia in the Oracle databasePhotograph; 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.

CompressionLossy 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.

TransformationDigital 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.