Home

Welcome to the Scotas OLS wiki!

What is Scotas OLS

Install instructions

• Installing on Oracle 19c EE R3
• Installing on Oracle 18c XE R4

Apache Solr tutorial in a relational way

Build from source, follow this post for more explanation Using Docker for Java server-side development at the Oracle embedded JVM

Comparison Matrix. Compare and find which is the product you need for your specific request

Feature	OLS	Push	Context	Solr	Comments
OJVM Integrated	Yes	No	No	No	Java inside the Oracle Database integration
Partitioning support	Yes	Yes	Yes	No	Local partitioning tables
Encrypted/Compressed Storage	Yes	No	Yes	No	Implemented using Oracle TDE / Compression
SOX / HIPAA / PCI	Yes	No	Yes	No	HIPAA and PCI data security standards
IOT Tables	Yes	Yes	No	N/A	Index Organized Tables
Solr Query Syntax	Yes	Yes	No	Yes	Extended Lucene Query Syntax with math f.
Sensitive info. over the net	No	Yes	No	Yes	User sensitive information transmitted
Highlighting, faceting, etc	Yes	Yes	No	Yes	Easy to use with ancillary operators

Notes:

• OLS: Oracle® Solr/Lucene integration (Scotas)
• Push: Solr Push connector (Scotas)
• Context: Oracle® ConText product (from Oracle® Database 11g Release 2)
• Solr: Apache Solr stand-alone