Oracle Case Studies Oracle University Streamlines Operations with Autonomous Database

Edit This Case Study Record

	Oracle University Streamlines Operations with Autonomous Database Oracle

Oracle University Streamlines Operations with Autonomous Database

Oracle

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
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. Read More
About 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. Read More
Customer Name	Oracle University Read More
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. Read More Log in to view content
Contents

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

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.

About 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.

Customer Name

Oracle University

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.

Impact #1	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.

Impact #1

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.

Benefit #1	Reduced overall administration costs by at least 30%
Benefit #2	Setting up a high-availability configuration, which used to take two weeks, now takes just a few minutes
Benefit #3	Adding storage capacity now requires no downtime, no manual storage management, and no special expertise

Benefit #1

Reduced overall administration costs by at least 30%

Benefit #2

Setting up a high-availability configuration, which used to take two weeks, now takes just a few minutes

Benefit #3

Adding storage capacity now requires no downtime, no manual storage management, and no special expertise

Download PDF Version

Overview

Oracle University Streamlines Operations with Autonomous Database

Operational Impact

Quantitative Benefit