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

This practical guide provides system administrators, DevSecOps engineers, and cloud architects with an overview of how to use PL/SQL to develop resilient database solutions. It helps them understand the language, build a toolkit, and collect reusable components and patterns. It also teaches them how to synthesize the toolkit with a requirements-driven, feature-oriented approach and produce resilient solutions by synthesizing the PL/SQL toolkit with a scale of resilience.

Format: Paperback / softback
Length: 301 pages
Publication date: 25 May 2023
Publisher: O'Reilly Media

As legacy and other critical systems continue to migrate online, the demand for continuous operation becomes increasingly crucial. In today's digital landscape, code must not only handle data-related challenges but also address hard external problems such as network outages, storage system failures, power disruptions, and ancillary system failures. To address these challenges effectively, system administrators, DevSecOps engineers, and cloud architects require a comprehensive understanding of PL/SQL, a powerful programming language used for developing database solutions.

This practical guide offers a concise yet comprehensive overview of how to leverage PL/SQL to create resilient database solutions. Integration specialist Stephen B. Morris guides readers through the language, helping them build a comprehensive PL/SQL toolkit. By integrating the toolkit with a requirements-driven, feature-oriented approach, readers will learn how to develop robust solutions that can withstand various disruptions.

The guide delves into the benefits of synthesizing the toolkit with a scale of resilience, enabling readers to build solid PL/SQL solutions while avoiding common antipatterns. It also highlights the pitfalls of embedding complex business logic directly in SQL, emphasizing the need for a more modular and flexible approach. Readers will gain insights into recognizing and improving weak PL/SQL code, as well as the importance of conducting data-driven, in-database tests to verify the integrity and reliability of their PL/SQL solutions.

Furthermore, the guide explores the safe operation, maintenance, and modification of complex PL/SQL systems, emphasizing the importance of proper documentation, version control, and change management practices. Readers will learn about best practices for designing and implementing PL/SQL code, as well as the benefits of thinking about features rather than just use cases. Additionally, the guide provides valuable insights into defining good requirements for PL/SQL and hybrid solutions involving PL/SQL and high-level languages.

By leveraging the power of PL/SQL and adopting a resilient development approach, system administrators, DevSecOps engineers, and cloud architects can ensure the continuous operation of their critical systems in the ever-evolving digital landscape. This practical guide provides the necessary tools and knowledge to build and maintain reliable and resilient database solutions, enabling organizations to thrive in the face of adversity.

Dimension: 233 x 178 (mm)
ISBN-13: 9781098134112