How do multimedia database work?

Posted on 2009-04-20
Last Modified: 2013-11-11
I record music and have a huge library of audio files (.wav) files that I want to be able to store, index, and extract information from. I am also learning programming and was thinking about trying c# as a front end and using a multimedia database management system for the storage of the raw audio files. I want to be able to do comparisons with all of the audio information so I can match similarities between songs or riffs that have created. I know that I could find a product to handle this, but I want to learn it.

I am familiar with RDBMS's and OOP but I am having a hard time finding information on MMDBMs. Is a MMBMS just a OODBMS with some extra extensions to handle the specific types.

What I need to know is:
-Schema and how it differs from a RDBMS
-Indexing structure
-Logical and Physical Storage
-Any additional information would be great

Question by:CSharpNewbie
    LVL 22

    Accepted Solution

    Media is very often stored in SQL databases as LOB values or on a file system linked to a SQL database. If it's in the database then LOB (large object) data is treated much like any other binary value, although the DBMS usually has special physical storage structures for LOB data.

    I don't think multimedia has anything special to do with OODBMS. There is no adequate definition of what "OODBMS" actually means anyway.
    LVL 47

    Assisted Solution

    Oracle 11g is a real multimedia database.
    They made in this version significant changes to the storage and to the LOBS.
    1. Significant faster
    2. Option to compress the data
    3. Embeded technology to avoid duplicate pieces (LOBs)

    Featured Post

    Courses: Start Training Online With Pros, Today

    Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

    Join & Write a Comment

    Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
    Shadow IT is coming out of the shadows as more businesses are choosing cloud-based applications. It is now a multi-cloud world for most organizations. Simultaneously, most businesses have yet to consolidate with one cloud provider or define an offic…
    This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
    This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now