Reader small image

You're reading from  Managing Multimedia and Unstructured Data in the Oracle Database

Product typeBook
Published inMar 2013
PublisherPackt
ISBN-139781849686921
Edition1st Edition
Right arrow
Author (1)
MARCEL KRATOCHVIL
MARCEL KRATOCHVIL
author image
MARCEL KRATOCHVIL

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.
Read more about MARCEL KRATOCHVIL

Right arrow

Museum D


This museum has three separate environments. There is a public server on which copies of the digital objects are stored. A subset of metadata is included with these public images. Some of the public images are watermarked, and most are transformed and cropped into a postcard format to make them easier to view by the general public.

The key functions include:

  • Metadata is loaded into the internal server from a collection management system residing on a separate system. An ODBC based database link is used to transfer the metadata over.

  • Digital objects that reside on a SAN are loaded in and where possible matched to the loaded metadata. Multiple versions of the same digital object are merged together and then one is marked as the master.

  • A weekly job pushes selected digital objects to the demilitarized zone (DMZ) site for public access. The firewall is one-way enabling the internal server to push data to the DMZ. The DMZ site cannot access the internal server.

  • Internal users can use a number of web-based interfaces for querying the digital objects, as well as editing metadata values.

  • Public users have a JavaScript GUI frontend, which uses web services to access and display the digital objects from the DMZ frontend.

  • The public database has been tuned and configured for read-only that is of high speed.

  • A separate server running inside the museum contains a tighter subset of digital objects along with a subset of metadata. This server is designed for customer usage within the museum and is used within the exhibitions themselves to compliment the displays of the digital objects.

  • Data on this public internal server is pulled, rather than pushed. Database links are used to retrieve all metadata and digital objects from the internal server.

  • All access to the digital objects and associated metadata is done via web services.

lock icon
The rest of the page is locked
Previous PageNext Page
You have been reading a chapter from
Managing Multimedia and Unstructured Data in the Oracle Database
Published in: Mar 2013Publisher: PacktISBN-13: 9781849686921

Author (1)

author image
MARCEL KRATOCHVIL

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.
Read more about MARCEL KRATOCHVIL