Design an architecture to house a set of Oracle Databases having the following server features:
1 x SSD Drive (64 GB)
1 x mirrored drive x 1 TB
1 x 3 TB drive
1 x external 2 TB drive
1 Server CPU with 8 cores
The server has to use the following:
To run vSphere (or equivalent virtualization kernel)
Be able to run three Linux operating systems with one Oracle 11g installation on each
Each Linux install is to run Oracle and provide full redundancy
Be able to store 2 TB of multimedia digital objects across all the three Oracle installs, with one install storing a max of 500 GB of multimedia.
You are a software architect and have been tasked to design a new multimedia centric database from scratch. Your goal is to design a storage structure for a database factoring in the following conditions:
There can be no restriction on the length of a row stored or the number of columns in a table. It should be possible to create a table with more than 100 columns, with each one of unlimited length.
The length...
Managing Multimedia and Unstructured Data in the Oracle Database
By :
Managing Multimedia and Unstructured Data in the Oracle Database
By:
Overview of this book
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.
Table of Contents (22 chapters)
Managing Multimedia and Unstructured Data in the Oracle Database
Credits
About the Author
Acknowledgement
About the Reviewers
www.PacktPub.com
Preface
Free Chapter
What is Unstructured Data?
Understanding Digital Objects
The Multimedia Warehouse
Searching the Multimedia Warehouse
Loading Techniques
Delivery Techniques
Techniques for Creating a Multimedia Database
Tuning
Understanding the Limitations of Oracle Products
Working with the Operating System
The Circa Data Type
Multimedia Case Studies
Proactive Database Tuning
Chapter References
Index
Customer Reviews