Managing multimedia and unstructured data in the Oracle database / Marcelle Kratochvil.

Format:

Book

Author/Creator:

Kratochvil, Marcelle.

Language:

English

Subjects (All):

Oracle (Computer file).

Database management.

Multimedia systems.

Physical Description:

1 online resource (504 p.)

Edition:

1st ed.

Place of Publication:

Birmingham : Packt Publishing, 2013.

Language Note:

English

Biography/History:

KRATOCHVIL MARCEL: 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.

Summary:

This book is written in simple, easy to understand format with lots of screenshots and step-by-step explanations. 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.

Contents:

Cover; Copyright; Credits; About the Author; Acknowledgement; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; 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 file system?; 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

Notes:

Includes index.

ISBN:

9781299394964

1299394965

9781849686938

1849686939

OCLC:

836406032