BLOB Size 1

[THoey]

Someone has come to me requesting a table that will store a 20 KB .WAV file in the database and they are wanting to store it in a BLOB data type. First, does this sound like a good use of the BLOB type?

Second, I am trying to estimate the size of the records that will be in the table. When estimating a BLOB, is there some standard way, like file size + some percentage for overhead?

Thanks in advance...

Terry
**************************
* General Disclaimer - Please read *
**************************
Please make sure your post is in the CORRECT forum, has a descriptive title, gives as much detail to the problem as possible, and has examples of expected results. This will enable me and others to help you faster...

 

[SantaMufasa]

Terry,

Yes, BLOB (Binary Large OBject) exists specifically to store digital sound and/or images. 20KB is certainly not a very large .wav file. (You would use 20KB to store someone saying "Hello there".) Oracle does not require much overhead for rows and columns: column overhead (even for BLOBs) is only a few bytes.

Mufasa
(aka Dave of Sandy, Utah, USA)
[

http://www.dasages.com:

Providing low-cost remote Database Admin services]
Click here to join Utah Oracle Users Group on Tek-Tips if you use Oracle in Utah USA.

 

[THoey]

Thanks Dave. Yeah, these are going to be very small wave files. Just a background. These are going to be recorded responses a customer make during a phone call lead by an IVR (Interactive Voice Response) System. So, this table will hold approximately 20 records per call from a customer with each record having a response to one of the questions asked.

So, just as an example, if the rest of the record is made up of 1K of data tracking which call, which customer, which question, etc, plus the 20K wave file, we are talking a record size of ~21K?

Terry
**************************
* General Disclaimer - Please read *
**************************
Please make sure your post is in the CORRECT forum, has a descriptive title, gives as much detail to the problem as possible, and has examples of expected results. This will enable me and others to help you faster...

 

[SantaMufasa]

Your presumption is correct, Terry.

Mufasa
(aka Dave of Sandy, Utah, USA)
[

http://www.dasages.com:

Providing low-cost remote Database Admin services]
Click here to join Utah Oracle Users Group on Tek-Tips if you use Oracle in Utah USA.

 

[THoey]

Thanks again Dave...

Terry
**************************
* General Disclaimer - Please read *
**************************
Please make sure your post is in the CORRECT forum, has a descriptive title, gives as much detail to the problem as possible, and has examples of expected results. This will enable me and others to help you faster...