Login | Register   
RSS Feed
Download our iPhone app
Browse DevX
Sign up for e-mail newsletters from DevX

By submitting your information, you agree that devx.com may send you DevX offers via email, phone and text message, as well as email offers about other products and services that DevX believes may be of interest to you. DevX will process your information in accordance with the Quinstreet Privacy Policy.


Create a Robust Document Management System with Oracle Text : Page 4

Oracle Text has a powerful text-search engine that allows users to search and manage documents and URLs as quickly and easily as any other data. Learn to use these features to deliver a robust content management search engine.




Building the Right Environment to Support AI, Machine Learning and Deep Learning

Step 3: Index Content (with Oracle Text)
Now comes the really exciting part. You will instruct Oracle to crawl your documents and index them. To index the binary documents you just loaded with your PL/SQL routine, execute the following code using Oracle Text's BASIC_LEXER:

begin ctx_ddl.create_preference('doc_lexer', 'BASIC_LEXER'); ctx_ddl.set_attribute('doc_lexer', 'printjoins', '_-'); end; / create index idxContentMgmtBinary on CMDEMO.CONTENT_INVENTORY(TEXT) indextype is ctxsys.context parameters ('lexer doc_lexer sync (on commit)');

Depending on your system's speed, the preceding statement may take a minute to process. The new transactional parameter "sync (on commit)" in Oracle 10g enables you to have your index immediately refresh when changes occur to your base table. Previously, you most likely would have done this periodically via a DBMS_JOB.

To index your URLs, both internal and external sites, you use a different statement and different preferences:

drop index idxContentMgmtURL; create index idxContentMgmtURL on content_inventory(url) indextype is ctxsys.context;

That does it. You have now indexed the content in each of these files and the content from your internal and external Web sites.

Comment and Contribute






(Maximum characters: 1200). You have 1200 characters left.



Thanks for your registration, follow us on our social networks to keep up-to-date