Название: Resilient Oracle PL/SQL: Building Resilient Database Solutions for Continuous Operation (Early Release)
Автор: Stephen B. Morris
Издательство: O’Reilly Media, Inc.
Год: 2022-10-05
Страниц: 153
Язык: английский
Формат: epub (true), mobi
Размер: 11.2 MB

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.

Relational databases remain as perhaps one of the most successful technologies of all time. There have been numerous challenges to relational databases over the years. For example, object oriented databases came along in the late nineties and were anticipated to supplant the existing dominant relational model. Nearly a quarter century later, relational systems are in as strong a position as ever. There are many reasons for the continued success of relational databases.

Pretty much every developer job I’ve done has required at least some knowledge of SQL. Some jobs have also required knowledge of stored procedure languages, such as, PL/SQL. As we’ll see in the book, there is often a great deal of confusion about the role of SQL and PL/SQL in the context of high level languages, such as, Java, C#, jаvascript, and so on. We discuss some of the more common antipatterns that can arise in these multi-language domains.

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