DATABASE FORUM: Pluggable Databases for DevOps – Making Individual Developer Databases a Reality (7/25)

Please join us at the DOUG (DALLAS ORACLE USERS GROUP) Oracle Database Forum meeting on Thursday, July 25, 2019 from 5 – 7:15 pm.  

Presentation Overview 

Pluggable Databases for DevOps – Making Individual Developer Databases a Reality,” presented by Duane Dieterich, Senior Application Developer – PL/SQL, Electronic Transaction Consultants Corporation (ETCC). 


Location/Directions 

University of Dallas, Gorman Lecture Center, 1845 East Northgate Drive, Irving, Texas.  For directions to the campus, see http://udallas.edu/visitors/directions.php. For a campus map, see https://udallas.edu/visitors/documents/Campus-Map_8-18a.pdf. (A good starting place would be to park near the bell tower.)   

Presentation Overview

In a DevOps world, database development presents some unique challenges. Using individual development databases is a big change from the shared development database. Determining how to build and test these databases can be a complex challenge. How to manage the possibility of databases and database software scattered across a large development environment can be daunting.

In this presentation, we identify our solution to some of these issues. We modified our existing continuous-integration process for java to make possible the creation of stand-alone version-controlled database builds. We utilized several key technologies to make our implementation as practical as possible. All of this was made possible because the Oracle pluggable database is manageable in size and quick to load. We will also uncover some problems we encountered with this implementation.

Objective 1: Identify problem with development databases

Objective 2: Show a solution using a build server and pluggable databases

Objective 3: Identify lessons learned from implementation

Mary Elizabeth McNeely / Dennise Wagner

DOUG Oracle Database Forum Chair / Co-Chair

214 349 9994