Lucene Domain Index (LDI)
Lucene Domain Index (LDI for short) is free open source integration of the Apache free text search library Lucene and Oracle by using a new domain index.
What is Lucene Domain Index?
- An Embedded version of Lucene IR library running inside Oracle OracleJVM
- 42 new Java Classes and several new PLSQL Object Types
- A new domain index for Oracle Databases using Data Cartridge API (ODCI)
- A new Store implementation for Lucene (OJVMDirectory) which replaces a traditional filesystem by Secure BLOB
- Three new SQL operators lcontains(), lscore() and lhighlight()
- An orthogonal/up-to-date Lucene solution for any programming language, especially Java, Ruby, Python, PHP and .Net, currently latest production version – 3.2.1.
Benefits
Benefits added to Oracle Applications
- No network round trip for indexing Oracle tables
- A fault tolerant, transactional and scalable storage for Lucene inverted index
- Small Lucene index structure
- Support for IOT
- Support for indexing joined tables using default User Data Store
- Support for indexing virtual columns
- Support for order by, filter by and in-line pagination operations at Index level layer
- Support padding/formatting for Text/Date/Time/Number
- Support for highlighting
- Support for faceting, more like this, dictionaries, and others common applications needs wrapped as SQL functions or pipeline tables
But more important than above is
- Easily to adapt for a new functionality, you can do whatever you want adding your classes and a simple procedure or function for wrapping the functionality in SQL.
Latest stable release is 3.5.0.1.0 follow this link to download from SF.net.
Follow these presentations to see more information (Note: please do not use the links at the ends of the presentation the project was moved to SF.net hosting http://sourceforge.net/projects/ldi/):