Komprise is the database development and management solution from the company of the same name in Campbell, California.
N/A
Oracle Autonomous Database
Score 8.9 out of 10
N/A
Oracle Autonomous Database provides a self-driving, self-securing, self-repairing cloud service that eliminate the overhead and human errors associated with traditional database administration. Oracle Autonomous Database takes care of configuration, tuning, backup, patching, encryption, scaling, and more.
As any other archiving solution, it is very well suited for environments with a large footprint of unstructured data (CIFS / NFS shares for user data) with a large amount of unused/old files and a need to keep those unused files for long term. In our scenario, due to some legal and contractual constraints we need to keep these files for 15 years. Archiving is a good choice to move the unused files to a cheaper storage tier, both on-prem or cloud.
Pro - Stability. Does everything anyone could need. If it's not there it will be on the next update. There is plenty of support for it. It's been around for a long time and it's reliable. The support is well documented and has a great reputation. Cons - Errors have been found in the documentation provided by Oracle with guidelines, etc. Oracles salespeople have a reputation of being obnoxious and condescending.
There is no access to the physical host of the DB. This is expected from a managed DB. Everything must be done through the console or via API calls. This is a new learning curve for the DBAs.
Due to the lack of physical host access, certain features are not supported, such as Transportable tablespaces and Oracle LogMiner.
Certain special data types, (such as XMLType) are not allowed; be sure the app vendor certifies their product on this platform.
Because it does exactly what we need: it enables us to manage our development and testing database environments in a quick and simple way without requiring support from a database administrators team.
The product is continuously evolving and new features are added frequently. Management options through the OCI (Oracle Cloud Infrastructure) console and through the command line and API are being enhanced frequently.
We have used Veritas Enterprise Vault in the past, and besides its being a well-known player on the data archiving market, their tool is far more complex to implement, to manage and to keep working. Komprise is very robust and also very easy to implement, as most part of the job is done on Komprise side. The management console is delivered through a public URL as a SaaS platform. You only need to deploy a few VMs for scan/archiving/user access, which they call "Observer VMs." Komprise also doesn't uses Stub files, which is a poor implementation adopted by the competitor for file access. We had a lot of issues in the past with stub files. Komprise has implemented 'bread crumbs', which are CIFS symlinks to the files on the Observer. It is a very good implementation and it works really well.
I found Oracle Autonomous Database very secure to store data and private information.I always feel secure with Oracle Autonomous Databases disaster recovery features.It is very effective to build applications for mobile and desktop devices lesser code using a low code development framework namely Oracle Application Express (ApEx).
