Skip to Main Content
  • Questions
  • Resources on Business Logic Architecture in Oracle Database

Breadcrumb

Question and Answer

Chris Saxon

Thanks for the question, Gerardo.

Asked: September 17, 2024 - 9:03 pm UTC

Last updated: September 19, 2024 - 9:39 am UTC

Version: Oracle Database 19

Viewed 50K+ times! This question is

You Asked

Hi,
Can you recommend any resources or books focused on business logic architecture specifically for Oracle Database? I am looking to understand best practices for implementing business logic, whether in the database layer through PL/SQL or through application design strategies. Any guidance or recommended reading would be greatly appreciated.

and Chris said...

This presentation by Toon Koppelaars covers the differences between using Oracle Database as just a persistent layer (NoPLSQL) and a processing engine (SmartDB):

https://www.slideshare.net/ToonKoppelaars/odtugnoplsqlvssmartdbpart1and2pptx

Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Version Control

Gerardo Lopez, September 18, 2024 - 7:01 pm UTC

Hello,
Thank you very much for your prompt response and the attention given to our inquiry. We greatly appreciate your time and dedication.

We would like to ask for your advice regarding some strategies to effectively manage version control when the business logic is implemented directly within the database. We understand that handling version control in these cases can be challenging, especially when dealing with complex SQL code and internal dependencies.

Additionally, we sometimes encounter situations where compiling one object causes others to break due to dependencies within the database. Could you please share any recommendations or approaches to mitigate these issues? Are there best practices or tools that you would suggest to avoid these conflicts during the development and deployment cycle?

Once again, we sincerely appreciate your cooperation and look forward to your valuable insights.
Chris Saxon
September 19, 2024 - 9:39 am UTC

Edition-based redefinition is what to look at here. This enables you to change database objects with zero downtime. This is by having multiple copies of editionable objects (PL/SQL, views, etc.) in separate editions. Using these allows you to deploy & validate changes in a private edition while customers use the public edition(s).

https://www.oracle.com/database/technologies/high-availability/ebr.html