Название: Resilient Oracle PL/SQL: Building Resilient Database Solutions for Continuous Operation (Final Release)
Автор: Stephen B. Morris
Издательство: O’Reilly Media, Inc.
Год: 2023
Страниц: 305
Язык: английский
Формат: epub (true)
Размер: 10.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.

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.

A solid knowledge of relational databases such as, those from Oracle, IBM, Microsoft and others remains a good addition to the IT skillset. The same is true for the open source relational databases, such as, MySQL. 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 you’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. I discuss some of the more common antipatterns that can arise in these multi-language domains.

For a variety of reasons, there is often a strong motivation for adopting solutions based exclusively on embedded SQL and object relational mapping solutions rather than using PL/SQL. This may, in turn, result in the inadvertent use of antipatterns and consequently brittle code. I look closely at Oracle PL/SQL with a view to helping lay the foundations for creating resilient database solutions. The need for resilient systems has never been greater in our increasingly data-driven and data-centric world.

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

Who This Book Is For:
If you’re interested in learning something about databases and PL/SQL, this book is a good place to start. It takes a first-principles approach, so not much foundational knowledge is required. The focus is on a good practice in PL/SQL, and the use of requirements analysis and metrics should be helpful to readers of all technical levels.