Database for Image

Database for Image

Post by Big Ca » Thu, 11 Apr 2002 23:42:18



Hi there,

I need to start the physical design for a database.  The database need to
store a lot of image in blob and the total db size will be 40G.  In turns of
performance and maintenance, where should I pay more attention ? thanks.

Regards
Ken

 
 
 

Database for Image

Post by Daniel Morga » Fri, 12 Apr 2002 00:26:12


You have provided insufficient information from which to formulate any kind of
response.

What hardware (RAM, DASD)? What operating system (name and version), what
version of Oracle, how many simultaneous connections? how many transactions
(INSERT, UPDATE, DELETE, QUERY)? And other than one table with a single BLOB
field to hold the images what other requirements are there?

My first thought, though not one that will please you, is that hopefully you
will put more effort into the design than you put into asking for help. Give us
some information and perhaps we can give you some pointers.

Daniel Morgan


> Hi there,

> I need to start the physical design for a database.  The database need to
> store a lot of image in blob and the total db size will be 40G.  In turns of
> performance and maintenance, where should I pay more attention ? thanks.

> Regards
> Ken


 
 
 

1. Database Design (image/txt)

Hello,

I have hundreds of "rich" (doc/rtf/ppt/xls/pdf) and html documents.
using a special tool, "rich" documents are marked by us and html documents
are parsed and stripped (to textual content, without tags or code).

After the tool has finished, we plan to insert each file content into the
database.

I'm wondering what is the best database design for this?
should I use two columns (text and image) to store textual (parsed) content
and the rich files seperatlly? or can I use a text field for the "rich"
files as well?

I have no plan to use ms-sql full text search, just store the "rich" files
AS IS in the database for further processing.

Thanks!

2. US - QUALIFIED PEOPLESOFT CONSULTANTS NEEDED - NO RELOCATION NECESSARY

3. Database design (image/text)

4. ReadOnly connection allows Update?

5. database with images

6. ??Distributor must be running in Per Seat (Named User) licensing mode to use this replication??

7. Databases and images

8. AS400 Client Access Using ADO and VB6.0 - Data Type Problem

9. 10000 records in access database with images

10. Database and Images

11. Databases with Image Retrieval functions?

12. Database for Images?

13. Storing Image into a Database image field