A chronological history of research, tool evaluations, papers and presentations written for the Oracle, Postgres, and Data Architecture communities.
Email me if a link is dead.
Articles, Tool Reviews, and Comparisons
Embarcadero’s RapidSQL (2001)
Allround Automation’s PL/SQL Developer (2005)
KeepTool’s Hora (from 2007)
All the known Oracle Tools and IDEs (2007)
PL/SQL IDE Comparison Matrix (2007)
All the PL/SQL Frameworks and Libraries (2008)
Findings of Text Comparison/Difference Tools (2011)
Data Modeling Tools Comparison Matrix (2011)
DDL Script to check modeling tool reverse engineering compatibility with well-known Oracle features (2011)
Data Modeling Tools Comparison Matrix (2019)
Data Modeling Tools Comparison (Medium – 2025)
Data Modeling Tools Comparison – Part 1 (dataSherpa.blog – 2025)
Data Modeling Tools Comparison – Part 2 (dataSherpa.blog – 2025)
Doing Data Right by Shifting Left (dataSherpa.blog – 2025)
Fix Data at the Source: Why Shifting Left Saves Time and Money (Medium – 2025)
The Lost Art and Science of Data Modeling (Medium – 2025)
The Lost Art and Science of Data Modeling (dataSherpa.blog – 2025)
Presentations
Note on th elink convention in the matrix below:
doc/docx = Microsoft Word white paper
gslides = Google Slides presentation
ppt/pptx = Microsoft PowerPoint slide presentation. Some of the slides have details notes.
pdf = Adobe Portable Document Format white paper (pre-2011). May be a PowerPoint or Prezi converted to PDF as well.
prezi = Interactive, Flash-based presentation. A user-controlled fly-through of slides.
| Year | Group/Event | Title | Links |
| 2001 | Online | Using LDAP as an Oracle Professional | [doc][pdf] |
| 2002 | NGT | SQL and SQL Tuning | [ppt] |
| 2003 | RMOUG | Oracle 8i and 9i PL/SQL Collections and Records | [doc][pdf][ppt] |
| 2008 | IOUG | PL/SQL Application Frameworks for Custom Systems | [docx][pdf][pptx] |
| 2008 | RMOUG | PL/SQL Application Frameworks for Custom Systems | [doc][ppt] |
| 2008 | UTOUG | PL/SQL Frameworks | [ppt] |
| 2009 | RMOUG | Hidden Gems of Oracle Text Engine | [docx][pptx] |
| 2010 | IOUG | Lazy Application Architecture (Frameworks) | [docx][pdf][pptx] |
| 2010 | SORT | Reusable Models and Frameworks | [pptx] |
| 2010 | UTOUG (Dev SIG) | Dynamic Debugging | [pptx] |
| 2010 | UTOUG | Lazy Application Architecture (Frameworks) | [pptx] |
| 2011 | RMOUG | Oracle Streams AQ: Lessons from the Trenches | [doc][pptx] |
| 2011 | SORT | Dynamic Debugging | [pptx] |
| 2012 | IOUG | Dynamic Debugging & Instrumentation of Production PL/SQL | [docx][pdf][pptx][prezi] |
| 2012 | RMOUG | Dynamic Debugging & Instrumentation of Production PL/SQL | [docx][pptx] |
| 2012 | SORT | Writing Great PL/SQL for Database Applications | [prezi] |
| 2012 | UTOUG | Dynamic Debugging & Instrumentation of Production PL/SQL | [pptx][prezi] |
| 2012 | UTOUG | Writing Great PL/SQL for Database Applications | [pptx][prezi] |
| 2013 | RMOUG | Writing Sweet PL/SQL! | [pdf][prezi] |
| 2014 | RMOUG | How to Write Awesome PL/SQL | [pdf][prezi] |
| 2014 | SORT | Data Layer Decisions | [pptx] |
| 2014 | UofU | Data Modeling: Lessons from the Trenches | [prezi] |
| 2014 | UTOUG | How to Write Awesome PL/SQL | [prezi] |
| 2014 | UTOUG (Dev SIG) | Mastering PL/SQL Programming | [pptx] |
| 2015 | UofU | Data Modeling: Lessons from the Trenches (repeat) | [prezi] |
| 2015 | UTOUG | Data Layer Decisions | [pdf][pptx] |
| 2016 | RMOUG | PL/SQL: From Newbie to Knowledgeable (8 hr course) | [pptx][gslides] |
| 2016 | UTOUG | PL/SQL: From Newbie to Knowledgeable (8 hr course) | [pptx][gslides] |
| 2016 | UTOUG | Stateful to Stateless: Modernizing with JSON and PL/SQL | [pdf][pptx][gslides] |
| 2016 | UTOUG | Doh! How Do I Get My Data Back? (Oracle Data Recovery options) | [pptx][gslides] |
| 2016 | ODTUG | Stateful to Stateless: Modernizing with JSON and PL/SQL | [pdf][pptx] |
| 2017 | UTOUG | Save the Company by Modeling Data Right | [pdf] |
| 2018 | UTOUG | Enterprise-Grade PL/SQL | [pdf][pptx] |
| 2023 | UTOUG | Document Modeling for Relational Modelers | [pdf][pptx] |
| 2024 | UTOUG | Data Modeling for Beginners | [pptx] |
| 2024 | UTOUG | Tour of Postgres for Oracle Devotees | [pptx] |