Managing Multimedia and Unstructured Data in the Oracle Database

Managing Multimedia and Unstructured Data in the Oracle Database

Language: English

Pages: 504

ISBN: 1849686920

Format: PDF / Kindle (mobi) / ePub

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


  • 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

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.

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


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

Who this book is written 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.














for the environment, because it's the most cost-effective. Justified from a pure business case, these decisions can be hard to refute, as they make a strong and logical case. Making the business decision to switch databases might be met with resistance with the claim that the application will need to be rewritten. The logical step that management will take is that the application should be written to work against any database. As covered further later, this decision can result in a worst case

is to outsource their database administration team and then put up a change management wall between them. A manager, who is reactive might see that the database administrators and developers are in constant conflict. Each claiming the other group has no experience or idea about how to do their job. The manager might outsource one group or put up strict change management procedures between them to try and keep the peace. Rather than recognizing that the better solution is to get the two groups to

developer then creates a view called table Y on top of table D and table E. Another developer comes in and wants information from table C and sees table X. They then create a new view on table X and table C, not knowing that table X is a view and already accesses table C. They then create a new view called table Z on top of table Y and table B. Another developer sees table Z but realizes not all the columns they want for display are there, so they create a new view on table Z and table C.

change over time. HTML5 is attempting to define a set of supported video standards. This is covered further in Chapter 3, The Multimedia Warehouse. Digital object delivery One goal in this book is to describe how to deliver a digital object. This is covered in great detail in Chapter 6, Delivery Techniques. At the moment we have classified what a digital object is, but have not defined what it is to actually deliver it. We expand on the original definition and add the following: Only

compression. The data can be stored as characters, bytes, or instructions. There are a number of standards that exist for each digital object type, and for each type, there are numerous formats available, each with their own characteristics, making them well-suited for their own environment. Chapter 3, The Multimedia Warehouse covers the concepts of what a multimedia data warehouse is and how a business can load and manage the large number of digital assets that might acquire. Exercises

Download sample