-
Notifications
You must be signed in to change notification settings - Fork 1
Home
Scotas Real-Time Search Solutions edited this page Nov 27, 2020
·
15 revisions
Welcome to the Scotas OLS wiki!
Install instructions
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 |
| Multiple tables/columns def. | Yes | Yes | No | Yes | User Data Store for selecting multiples col. |
| Complex data types | Yes | Yes | No | Yes | Integer, TrieRange, GeoPoint, etc. |
| Parallel Indexing | Yes | Yes | Yes | Yes | Multiple Oracle process indexing in parallel |
| Rich Composite Domain Index | Yes | Yes | No | N/A | Domain Index Sort, Domain Index Filter |
| Transactional storage | Yes | No | Yes | No | Secure commit/rollback on index storage |
| Auditing facilities | Yes | No | Yes | No | SAS-70 or ISO 27001 among others federal reg |
| Row level filtering | Yes | Yes | Yes | No | SAS-70 or ISO 27001 among others federal reg |
| On-line backup | Yes | No | Yes | No | Backup the inverted index storage on-line |
| NRT Updates/ RT deletes | Yes | Yes | Yes | No | Inserts, updates with near 0 time waits |
| Highlighting without storage | No | No | Yes | No | row information to return highlight text |
| Per index isolated storage | Yes | No | Yes | No | Each SQL index has his own index storage |
| Lucene/Solr version update | No | Yes | N/A | Yes | Simple upgrade Solr/Lucene version |
Notes: