My Oracle Experience
October 30, 2017

My Oracle Experience

Michael Benton | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User

Overall Satisfaction with Oracle Database 12c

Currently DMC is using Oracle for storing and maintaining transaction information. There are 2 departments that have access to the data in that particular database, where one part of the business does more data extraction than maintenance. Oracle DB is the current enterprise solution for DMC's booth sales and reservation records.
  • The simplicity of the application.
  • It seamlessly allow for large data storage.
  • The pricing in some cases are better than most data storage products.
  • Using the back button. Oracle responds properly to the back button in the application than the browser. Its for good reason but, annoying.
  • Upgrading isn't user friendly unless you a Oracle prodigy. I'd ask them for a guide that allows unfamiliar users to upgrade with confidence
  • In terms of cost, Oracle is a strong data storage tool that doesn't blow your departmental budget.
  • SQL Server
Oracle has more flexibility than SQL Server in terms of data migration and data security. Oracle (for me) is also easier to use in terms of ad hoc table creation and views. With SQL Server the amount of restriction in place make it hard for me to do the kind of data migration and table creation I need to get my job done efficiently.
I create tons of financial reports that show the highs and lows of sales year over year as well as predictive analysis. Oracle is the tool used for me to get that data I need to create those reports. I also partner Oracle with R for create more granular views of the data I'm presenting.