I have to agree with Peter on this. Try to keep your application as simple as possible. Don't use a database (especially NOT Oracle, if you are new to databases) if you can help it, because things can get very, very complicated very quickly. I think your main problem will not be connecting to Oracle via JDBC, but rather :
- how to install and tune Oracle
- how to handle BLOBs/CLOBs
- how to do text indexing in a database
My suggestion is the same as Peter's : write to the filesystem. This way, you only need to learn one skill - how to read/write files in Java - rather than learning how to handle JDBC, install and administer Oracle (which took me almost a month the last time I did it, and this was with Oracle Consulting staff!) and learning how the text indexer in Oracle works.
Hate to say this, but you may be reaching a little too far on this one.
Regards,
pascal chong
Peter Lin wrote:
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
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
