Oracle Tips by Burleson

Oracle 10g Text Mining

In Oracle 10g, you can apply data mining functions to text documents to determine the key words and themes.  Those key words and themes are used as the basis for classifying and categorizing documents.  You can also use a combination of text and non-text columns of data for clustering and classification.

To classify incoming documents automatically, you need to provide a set of documents with known categorization information.  Here are the steps to classify documents:

1. Create the training document table containing the document content.
    

2. Create the category table containing the category assignments for the training document.
    

3. Generate classification rules based on the training set.
    

4. Use the rules to classify new documents.

Get the complete Oracle10g story:

The above text is an excerpt from "Oracle Database 10g New Features: Oracle10g Reference for Advanced Tuning and Administration", by Rampant TechPress.  Written by top Oracle experts, this book has a complete online code deport with ready to use scripts. 

To get the code instantly, click here:

http://rampant-books.com/book_2003_2_oracle10g.htm

Need an Oracle Mentor?

BEI is now offering personal mentors for Oracle DBAs where you can have an Oracle expert right at your fingertips, anytime day or night. We work with hundreds of Oracle databases every year, so we know exactly how to quickly assist you with any Oracle question.

Why risk an unplanned outage? You can now get telephone access to Don Burleson or any of his Oracle Certified DBAs with more than 20 years of full-time IT experience. Click here for details:

http://www.dba-oracle.com/service_oracle_backup.htm