O'Reilly logo

Managing Multimedia and Unstructured Data in the Oracle Database by Marcelle Kratochvil

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Data types

All metadata is text-based; in that, it is composed of characters from a well-defined character set or sets. To ensure consistency when copying or moving data, the same international standard as used for XML, which is UTF-8, should be used minimally. There is UTF-16 and other supersets of UTF-8 that can also be used.

As was covered in Chapter 1, What is Unstructured Data?, data that is stored as raw text is in effect, unstructured. This is due to the fact that there are no rules or controls that govern it. Though text-only metadata is flexible in its entry, it is easy to introduce errors. A good example that most museums encounter is representing the date in a text field.

In the following list, determine the actual dates:

  • 12-Dec-01
  • 10/11/12 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required