Advanced data indexing and retrieving in Oracle system

Krzysztof Czajkowski, Dominik Ziajka


The article discusses the issues of advanced indexing and retrieving data in database environments. The issues are presented on the example of Oracle solutions: Oracle Text, Oracle Ultra Search and Oracle Secure Enterprise Search. The article presents examples which showing implementations of these technologies in various applications. The paper also contains results of experiments carried out on the prepared applications.


advanced indexing; advanced retrieving; Oracle Text; Oracle Ultra Search; Oracle Secure Enterprise Search

Full Text:

PDF (Polski)


Lane P., Shea C: Oracle Text. Application Developer's Guide. Oracle 11g. 2010.

Apache Fundation. Apache lucene - overview,

PostgreSQL Global Development Group. Postgresql 8.4: Full text search,

Oracle Secure Enterprise Search Group. Oracle Ultra Search vs Oracle Secure Enterprise Search Frequently Asked Questions. OSESG, 2010.

Mysql 4.1 reference manual,

Oracle Secure Enterprise Search 11 g - Data Sheet. Oracle, 2010.

Oracle Secure Enterprise Search 11 g - Version 11.1.2- White Paper. Oracle, 2010.

Secure Searching with Oracle Secure Enterprise Search - White Paper. Oracle, 2010.

idevelopment - how oracle text (oracle 9i) relates to intermedia text (oracle 8i),

Tf-idf weighting. 2009,

Zend developer zone - using mysql full-text searching,