Oracle > Case Studies > Oracle University Streamlines Operations with Autonomous Database

Oracle University Streamlines Operations with Autonomous Database

Oracle Logo
 Oracle University Streamlines Operations with Autonomous Database - IoT ONE Case Study
Technology Category
  • Application Infrastructure & Middleware - Database Management & Storage
  • Infrastructure as a Service (IaaS) - Cloud Databases
Applicable Industries
  • Cement
  • Education
Applicable Functions
  • Maintenance
  • Product Research & Development
Use Cases
  • Autonomous Transport Systems
  • Smart Campus
Services
  • Cloud Planning, Design & Implementation Services
  • Training
The Challenge
Oracle University, a platform that provides proficiency training on Oracle Cloud Infrastructure (OCI) and SaaS applications, faced significant challenges with its underlying database system. The system, which was initially based on AWS and used PostgreSQL, was migrated to OCI in 2018. However, the PostgreSQL system had several shortcomings. Performance optimization was subpar, and building a high-availability (HA) setup required substantial expertise. The system also required additional compute resources, which led to downtime and necessitated the management of the underlying block storage that PostgreSQL used. This resulted in high administrative overhead and required expertise, making the system inefficient and costly to maintain.
The Customer

Oracle University 

About The Customer
Oracle University is a platform that helps customers build proficiency with Oracle Cloud Infrastructure (OCI) and SaaS applications. It offers Oracle Guided Learning, which is integrated with Oracle Cloud Applications, providing up-to-date guidance and knowledge in the user’s workflow. Oracle MyLearn, another offering from Oracle University, provides subscription-based, personalized training on a range of Oracle solutions, including OCI, Oracle Cloud Applications, and database and industry solutions. Oracle University incorporated technology that was acquired by Oracle in 2018 and migrated from AWS to OCI.
The Solution
To address these challenges, the Oracle University development team chose Oracle Autonomous Database for transaction processing to replace PostgreSQL for Oracle Guided Learning. This solution supports developers in creating new guides and end users in interacting with those guides from host applications. Autonomous Database for analytics and data warehousing was also implemented to support administrative users in understanding the usage of the entire learning environment. Oracle MyLearn, a new application, was built on Autonomous Database for transaction processing and mixed workloads. The Autonomous Database automatically manages storage and allows additional storage or compute resources on demand without needing specialized expertise or taking the database down. It also handles backups, performance tuning, patching, and updates automatically, reducing operational costs. The database comes with pre-set security policies and settings, reducing the work needed to keep data secure and decreasing the risk of errors. It also simplified the process of integrating with object storage, a crucial part of the overall solution.
Operational Impact
  • The implementation of Oracle Autonomous Database has significantly streamlined operations at Oracle University. The process of setting up a high-availability configuration, which used to be a two-week operation, now takes just a few minutes with Autonomous Data Guard. This can be done by employees without database expertise, eliminating the need for ongoing maintenance and further saving costs. The addition of storage capacity is now a simple API call, requiring no downtime, no manual storage management, and no special expertise. The built-in security capabilities of the Autonomous Database have saved the development team many hours in developing scripts to secure the database, and there is no ongoing work needed to maintain the scripts and configuration information. The Autonomous Database also offers simple, direct access to object storage, enabling the team to automate database refreshes, which now take only 2 to 3 hours, rather than a whole week. Overall, the administration of the Autonomous Database requires significantly less time and expertise, leading to more efficient operations.
Quantitative Benefit
  • Reduced overall administration costs by at least 30%
  • Setting up a high-availability configuration, which used to take two weeks, now takes just a few minutes
  • Adding storage capacity now requires no downtime, no manual storage management, and no special expertise

Case Study missing?

Start adding your own!

Register with your work email and create a new case study profile for your business.

Add New Record

Related Case Studies.

Contact us

Let's talk!
* Required
* Required
* Required
* Invalid email address
By submitting this form, you agree that IoT ONE may contact you with insights and marketing messaging.
No thanks, I don't want to receive any marketing emails from IoT ONE.
Submit

Thank you for your message!
We will contact you soon.