Home - scotas/pc GitHub Wiki

Welcome to the Scotas Push wiki!

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: