Oracle Standard Edition - Priced correctly for a small company
November 07, 2017

Oracle Standard Edition - Priced correctly for a small company

Anonymous | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User

Overall Satisfaction with Oracle Database

We use a third-party solution called Dotmatics which runs on top of Oracle. Dotmatics has developed a chemical cartridge against Oracle which helps the end users to run chemically aware queries against the database. This solution is being used by the entire scientific community within the company. The chemists use it to register new compounds, the compound management team uses it to fulfill compound requests and the biologists use it to screen experiments and upload experiment data run against various compounds. This then helps the upper management to get a 360-degree view of the compound properties and the associated experiment results.

The biologists also plan to use a Dotmatics module called BioRegister that will help them to maintain Biology data for enzymes, mice, rabbit etc.
  • Backup and restore using various methods
  • Performance tuning
  • You can incrementally add options that you need (like Spatial, Partitioning, Compression, Security, RAT etc)
  • Oracle Support (some support engineers are very good and some are not very good)
  • Licensing cost for Enterprise Edition needs to be brought down so that more startups can use the product
  • The entire company has been running as one unit now, as the data is now in one place. Earlier the entire company was running using Excel.
  • Query performance is great and the scientists are happy.
  • From a support perspective, I do not have to rely on Google and find answers for any problems I have. Instead, rely on Oracle support.
The third-party solution that we chose (Dotmatics in this case) has developed the chemical cartridge only against Oracle. So there was no need for us to evaluate any other database alternatives.
1. Online Transaction Processing - it's perfect considering all the additional options that Oracle provides
2. E-commerce where we need to maintain different attributes of the product - JSON datatype has been introduced but the functionality cannot come close to document data-stores like Mongo and Couchbase
3. Data warehouse - Oracle supports columnar storage but there are many cheaper alternatives now