How do multimedia database work?

Posted on 2009-04-20
Medium Priority
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

dportas earned 1000 total points
ID: 24191366
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 48

Assisted Solution

schwertner earned 1000 total points
ID: 24197436
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

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
Creating a Cordova application which allow user to save to/load from his Dropbox account the application database.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses

809 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