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
505-642-4126
http://www.cs.nmsu.edu/~sdange
From: Peter Lin <[EMAIL PROTECTED]>
Reply-To: "Tomcat Users List" <[EMAIL PROTECTED]>
To: Tomcat Users List <[EMAIL PROTECTED]>
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 instead.
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.
peter
_________________________________________________________________
Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
