Basics

Definitions

  • Multimedia database
    • Database containing coherent multimedia objects
    • Important operations of the multimedia database management system MMDBMS:
      • Data storage
      • Retrieval (IR system)
  • Basic data type
    • Text
    • Image (raster graphic, vector graphic)
    • Audio (e.g., speech, music, MIDI)
    • Video
  • Documents
    • Media object/type
      • Document of only one basic type (e.g., image)
    • Multimedia object
      • Document composed of different media objects
      • Integration of different media types
      • Example: Book (text and image)
  • Medium
    • Information carrier in communication connection
    • Medium transfers multimedia data
    • Independent of information
    • Interchangeable
    • Example:
      • Book (author-to-reader)
      • Voice (speaker-to-listener)
  • Medium classification
    • Receiver type
      • Optical/visual
      • Acoustic
      • Haptical
      • Olfactory (smell)
      • Gustatory (taste)
    • Time
      • Static
      • Dynamic
  • Metadata
    • Task: Describe content
    • Standardized by MPEG-7/MPEG-21
    • Advantage
      • Good quality
      • Existing techniques
    • Disadvantage
      • Manual annotation (expensive)
      • Retrieval effectiveness relies on metadata quality
      • Hard to describe images
  • Low-level feature
    • Describe object with information loss
  • High-level feature
    • Transform object into another domain
    • Object can be completely reconstructed

Applications

  • YouTube
  • Surveillance
  • Face recognition
  • Image search
  • Legal issues (copyright infringement)

History

  • 1960/70: Retrieval for text documents (IR)
  • 1970/80: Relational databases + SEQUEL
  • 1980/90: Increasing presence of multimedia objects
  • 1990/2000:
    • SQL-92 introduces BLOBs
    • First multimedia databases

Requirements of an MMDBMS

  • By Christodoulakis, 1985
  • Requirements
    • Classical database functionality
    • Maintenance of unformatted data (binary data)
    • Special storage and presentation devices
  • Aspects to comply with requirements:
    • Software architecture (extension, e.g., build on top of RDBMS, or new software)
    • Content addressing (identification of objects, i.e., through content-based features)
    • Performance (indexes, optimization, etc.)
    • User interface (query interface, UI)
    • Information extraction (generate content-based features (automatically))
    • Storage device (capacity, redundancy control, compression)
    • Information retrieval (extended search functionality)

Storage

  • Storage should be persistent
  • Storage model
    • Stand-alone (file system)
    • Database storage (provide advantages of databases)
      • Declarative query language
      • Orthogonal combination of query functionality (???)
      • Query optimization
      • Index structures
      • Transaction system
      • Recovery
  • Commercial systems
    • Relational extension: BLOB
      • Binary large object (not interpreted)
      • Special field type
      • Retrieval using metadata added next to BLOB
    • Object-relational extension
      • Feature to enhance retrieval functionality
      • Add object-oriented model to relational DB
      • Add semantic search
      • e.g., IBM DB2 Extender
      • Add UDFs, UDTs

Retrieval

  • Types:
    • Exact match (not practical for IR)
    • Best match (similarity)
  • Options:
    • Metadata-based (classic, e.g. MPEG-7)
      • Relational metadata (e.g., author, size, location)
      • Content-descriptive (not content itself)
      • Pro:
        • Good quality
        • Automatic generation (e.g., by camera: location, time)
        • Use existing techniques
        • Efficient
      • Contra:
        • Annotation is expensive (e.g., author, content)
        • Content description not accurate enough (Granularity of details, e.g., spider vs. insect)
        • Number of details (is everything described?)
    • Content-based
      • Use content of media objects
      • Text: Standard IR methods
      • Audio/video/image (complex multimedia objects)
  • Goal: Content-based retrieval
  • Key questions:
    • What carries semantic information?
    • What are meaningful features?
    • What describes the object?
    • What are meaningful similarity/distance measures?
  • Search functionality
    • Semantic
      • Focus on perception
      • Use meaningful/semantic features
      • Use meaningful similarity/distance measures
    • Orthogonal integration of classical/extended functionality
      • Classical: Metadata
      • Extended: Content-based
    • No direct access to media objects (use features)
    • Use content-based features (extraction, normalization, indexing)
    • Efficiency

Workflow

  1. Preprocess content
    1. Extract features
    2. Extract metadata
  2. Receive query
    1. Preprocess query
    2. Extract features
  3. Compute similarity between query and database objects using features
  4. Rank results
  5. Return results (user-friendly presentation of results)

../_images/query-high-level.png ../_images/query-middle-level.png ../_images/query-low-level.png

Queries

  • Example types
    • Keywords
    • Query by example
    • Video query
    • Heterogeneous (e.g. people photographed with X)
  • Dimensions for classification
    • Static/dynamic
    • Passive/active
    • Standard/content-based retrieval
  • Types:
    • Static: High read rate
    • Dynamic: High modification rate
    • Passive: DB reacts on queries
    • Active: DB acts, triggers application level
    • Standard search: Metadata search
    • Retrieval functionality: Content-based search

Feature Selection

  • Feature selection:
    • Usually, evaluate a combination of different features
      • not a single, too weak as description
      • not all, i.e., only use sufficient features
    • Requirements for features:
      • Significance:
        • Feature(s) should have certain meaning
        • Significance of color/loudness/…
      • Differentiation:
        • Feature(s) should allow us to differentiate between the objects
    • Low-level-features may not provide good differentiation (e.g., sunrise vs. sunset)
  • Important: Multimedia objects are (often) interpreted as signals

Evaluation

  • Efficiency (query-independent)
    • System resources (Memory, CPU, I/O operations, Response time)
    • Depends on hardware
    • Scalability
    • Goal: Efficient enough
  • Effectivity (query-dependent)
    • see below
  • Focus is application-dependent

Effectivity

  • Query-dependent evaluation
  • Result quality (with objective metrics)
    • Important for the Usage of system
    • Important: Relevance (here: binary concept)
    • Requires implicit information need
      • Usefulness
      • Usability
      • User-friendliness
    • Usage of gold standards/ground truths (created by experts)
    • Not in focus of this course
  • Result sets
    • False positives/False alarms
      • Increase result set
    • False negatives/False dismissals
      • Not contained in result set
      • Problem, because not identified by user
    • Correct alarms/True positives
    • Correct dismissals/True negatives
  • Confusion matrix: Matrix with four fields (TP, TN, FP, FN)
  • Metrics:
    • Precision (\( 1 \) is best)
      • \( P=\frac{TP}{TP+FP} \)
    • Recall (\( 1 \) is best)
      • \( R=\frac{TP}{TP+FN} \)
  • Consider both metrics at same time
    • Precision-Recall-curve
    • Use multiple queries to compute the average (e.g., mean-average precision)