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...
You're reading from Managing Multimedia and Unstructured Data in the Oracle Database
The rest of the page is locked
You have been reading a chapter from
Managing Multimedia and Unstructured Data in the Oracle DatabasePublished in: Mar 2013Publisher: PacktISBN-13: 9781849686921
© 2013 Packt Publishing Limited All Rights Reserved