Resilient Oracle Pl/SQL: Building Resilient Database Solutions for Continuous Operation

As legacy and other critical systems continue to migrate online, the need for continuous operation is imperative. Code has to handle data issues as well as hard external problems today, including outages of networks, storage systems, power, and ancillary systems. This practical guide provides system administrators, DevSecOps engineers, and cloud architects with a concise yet comprehensive overview on how to use PL/SQL to develop resilient database solutions.

Integration specialist Stephen B Morris helps you understand the language, build a PL/SQL toolkit, and collect a suite of reusable components and patterns. You'll dive into the benefits of synthesizing the toolkit with a requirements-driven, feature-oriented approach and learn how to produce resilient solutions by synthesizing the PL/SQL toolkit in conjunction with a scale of resilience.

• Build solid PL/SQL solutions while avoiding common PL/SQL antipatterns
• Learn why embedding complex business logic in SQL is often a brittle proposition
• Learn how to recognize and improve weak PL/SQL code
• Verify PL/SQL code by running data-driven, in-database tests
• Understand the safe operation, maintenance, and modification of complex PL/SQL systems
• Learn the benefits of thinking about features rather than just use cases
• Define good requirements for PL/SQL and hybrid solutions involving PL/SQL and high level languages

隨著遺留系統和其他關鍵系統繼續遷移到線上，持續運作的需求變得迫切。程式碼必須處理當今的資料問題，包括網路、儲存系統、電力和其他相關系統的故障。這本實用指南為系統管理員、DevSecOps 工程師和雲架構師提供了簡潔而全面的概述，介紹如何使用 PL/SQL 開發具有彈性的資料庫解決方案。

整合專家 Stephen B Morris 幫助您了解這個語言，建立一個 PL/SQL 工具包，並收集一套可重複使用的元件和模式。您將深入研究將工具包與需求驅動、以功能為導向的方法相結合的好處，並學習如何通過將 PL/SQL 工具包與彈性規模相結合來產生具有彈性的解決方案。

- 在避免常見的 PL/SQL 反模式的同時，建立堅固的 PL/SQL 解決方案。
- 了解將複雜的業務邏輯嵌入 SQL 中通常是一個脆弱的方案的原因。
- 學習如何識別和改進弱的 PL/SQL 程式碼。
- 通過執行資料驅動的、在資料庫中運行的測試來驗證 PL/SQL 程式碼。
- 理解複雜 PL/SQL 系統的安全操作、維護和修改。
- 學習思考功能而不僅僅是使用案例的好處。
- 為 PL/SQL 和涉及 PL/SQL 和高階語言的混合解決方案定義良好的需求。