tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Swapneel Dange" <>
Subject Re: JDBC & ORACLE implementation !
Date Thu, 20 Feb 2003 04:12:05 GMT
hey peter !

ur right, that there is no transaction involved in this process here. only 
thing i will be doing is receiving files on the server using the servlets. 
now may be it was too much thinking on my part to say that i will use 
ORAVCLE. what do u say that for atleast 7200 files a day of size max 1MB, 
shouldnt i use ORACLE ? should i try some other options and if YES then what 
kind of database can i implement.

right now i have the FILE SYSTEM implemented here. but i think it has 
limited my ability to do pattern searching and data mining, thats why i was 
trying to move to something more stable and robust such as a database which 
can support TOUGHER queries.

awaiting reaply !

Swapneel Dange

>From: Peter Lin <>
>Reply-To: "Tomcat Users List" <>
>To: Tomcat Users List <>
>Subject: Re: JDBC & ORACLE implementation !
>Date: Wed, 19 Feb 2003 18:09:36 -0800 (PST)
>First off, you probably should be use Oracle enterprise edition, unless 
>you're on a box with less than 128meg of memory.
>Oracle personal edition for 8i and 9i is really designed for simple uses. 
>The scenario you've described will probably mean storing the text as a clob 
>or in multiple columns. keep in mind if you store it as a clob, it limits 
>your ability to search performance. breaking the text into columns will 
>allow you to index the content easier. If query time is important, you may 
>want to generate summaries of the text and use that for your indexes 
>as far as connecting to oracle, it's fairly straight forward. databases are 
>handy, but take care with how you implement the application. If you don't 
>need to index the content, or do not need transaction capabilities, you're 
>better off using file system to store the text. RDBMS are designed 
>specifically to handle relational data. If your data isn't relational, 
>using Oracle is a bit over kill.  Using the right tool will make your life 
>easier in the long run.

Help STOP SPAM with the new MSN 8 and get 2 months FREE*

To unsubscribe, e-mail:
For additional commands, e-mail:

View raw message