Storing wave files in database

Hi,

in my current project I need to record audio data
analyse them and store everything in some sort of database.

I have not much experience with databases except for
some small tests with ADO and MS Access, MySql
and Paradox.

The goal is to record sample files for test speakers
and store the audio data, name and gender of the speaker
and finally some analysis results. All this would happen on
a local computer Win2K/XP. Network access, if needed
at all, would be limited to a few users.

My questions:

1) Can anyone give some advice as to whether it is reasonable
to store large amounts of binary data in a database, wave files
in my case? Or should I store file paths to external wave files?

2) In case I use an MS Access database: is there a limit on how
many data I can store in it? The number of records wouldn't be
that large but the total amount of data could be well beyond 2 GB.

3) Are there any performance issues in reading/storing large amounts of
binary data from a database compared to file access for external referenced
files? How about MS Access in particular?

4) If all of the above is absolutely nonsense, does anyone have any
experience what a good solution would be for this task?

thanks for any comment,
Nicolas


.

Relevant Pages

  • Re: public and private mailboxes randomly dismounting
    ... When posting logs an important piece is the Event ID and Source. ... Information Store First Storage Group: An attempt to move the file ... An error occurred while writing to the database log file of storage group ...
    (microsoft.public.windows.server.sbs)
  • Re: cant mount information store
    ... I then reinstalled exchange and then installed exchange 2003 ... Information Store First Storage Group: Database recovery failed ... Microsoft Exchange Information Store. ...
    (microsoft.public.windows.server.sbs)
  • Re: Many Exchange errors!
    ... Event Source: ESE ... Information Store First Storage Group: An attempt to move the file ... An error occurred while writing to the database log file of storage group ...
    (microsoft.public.windows.server.sbs)
  • Re: Many Exchange errors!
    ... Event Source: ESE ... Information Store First Storage Group: An attempt to move the file ... An error occurred while writing to the database log file of storage group ...
    (microsoft.public.windows.server.sbs)
  • Re: Many Exchange errors!
    ... Event Source: ESE ... Information Store First Storage Group: ... An error occurred while writing to the database log file of storage ...
    (microsoft.public.windows.server.sbs)
Loading