{"id":3138,"date":"2002-12-01T10:46:32","date_gmt":"2002-12-01T10:46:32","guid":{"rendered":"http:\/\/www.istratech.hr\/?p=3138"},"modified":"2021-07-09T11:47:02","modified_gmt":"2021-07-09T11:47:02","slug":"resolving-commit-business-rules-on-the-oracle-database","status":"publish","type":"post","link":"https:\/\/www.istratech.hr\/en\/resolving-commit-business-rules-on-the-oracle-database\/","title":{"rendered":"Resolving &#8220;Commit business rules&#8221; on the Oracle database"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\" style=\"text-align:center\"><strong>ABSTRACT<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">There are two approaches concerning the physical implementation of the business rules layer: on the application server or on the database server.<br>The first approach is probably better if the application needs to access different databases. If the application accesses only one database, however, (like Oracle), then it would probably be better to implement business rules on the database.<br>But there are some business rules that before Oracle version 8.0 are not entirely supported by the database. Probably the simplest example of that type of rule is: &#8220;Instance of Master must have at least one depending instance of Detail.&#8221; Those rules could be called &#8220;COMMIT rules&#8221;, because they can be evaluated only before committing the transaction, and not at the execution of some DML command.<\/p>\n\n\n<div class=\"more\"><a href=\"http:\/\/www.istratech.hr\/wp-content\/uploads\/2002\/12\/case2002.pdf\" target=\"_blank\" rel=\"noopener noreferrer\">VIEW LECTURE<\/a><\/div>\n","protected":false},"excerpt":{"rendered":"<p>In recent years, software development has begun focusing on three-tier applications, mainly by separating the business rules layer from the presentation and data layer&#8230;<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_exactmetrics_skip_tracking":false,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"_themeisle_gutenberg_block_has_review":false,"footnotes":"","_links_to":"","_links_to_target":""},"categories":[172,329,330],"tags":[],"class_list":["post-3138","post","type-post","status-publish","format-standard","hentry","category-blog-en","category-case-en","category-conferences"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Resolving &quot;Commit business rules&quot; on the Oracle database &#8211; Istra Tech<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.istratech.hr\/en\/resolving-commit-business-rules-on-the-oracle-database\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Resolving &quot;Commit business rules&quot; on the Oracle database &#8211; Istra Tech\" \/>\n<meta property=\"og:description\" content=\"In recent years, software development has begun focusing on three-tier applications, mainly by separating the business rules layer from the presentation and data layer...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.istratech.hr\/en\/resolving-commit-business-rules-on-the-oracle-database\/\" \/>\n<meta property=\"og:site_name\" content=\"Istra Tech\" \/>\n<meta property=\"article:published_time\" content=\"2002-12-01T10:46:32+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-07-09T11:47:02+00:00\" \/>\n<meta name=\"author\" content=\"Istratech Admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Istratech Admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/resolving-commit-business-rules-on-the-oracle-database\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/resolving-commit-business-rules-on-the-oracle-database\\\/\"},\"author\":{\"name\":\"Istratech Admin\",\"@id\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/#\\\/schema\\\/person\\\/e56f98c854e5f471a7f577bd59ad397d\"},\"headline\":\"Resolving &#8220;Commit business rules&#8221; on the Oracle database\",\"datePublished\":\"2002-12-01T10:46:32+00:00\",\"dateModified\":\"2021-07-09T11:47:02+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/resolving-commit-business-rules-on-the-oracle-database\\\/\"},\"wordCount\":137,\"commentCount\":0,\"articleSection\":[\"Blog\",\"CASE\",\"Conferences\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.istratech.hr\\\/en\\\/resolving-commit-business-rules-on-the-oracle-database\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/resolving-commit-business-rules-on-the-oracle-database\\\/\",\"url\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/resolving-commit-business-rules-on-the-oracle-database\\\/\",\"name\":\"Resolving \\\"Commit business rules\\\" on the Oracle database &#8211; Istra Tech\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/#website\"},\"datePublished\":\"2002-12-01T10:46:32+00:00\",\"dateModified\":\"2021-07-09T11:47:02+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/#\\\/schema\\\/person\\\/e56f98c854e5f471a7f577bd59ad397d\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/resolving-commit-business-rules-on-the-oracle-database\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.istratech.hr\\\/en\\\/resolving-commit-business-rules-on-the-oracle-database\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/resolving-commit-business-rules-on-the-oracle-database\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Po\u010detna stranica\",\"item\":\"https:\\\/\\\/www.istratech.hr\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Resolving &#8220;Commit business rules&#8221; on the Oracle database\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/\",\"name\":\"Istra Tech\",\"description\":\"Digitalizacija sustava u turizmu, hotelijerstvu i ugostiteljstvu\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/#\\\/schema\\\/person\\\/e56f98c854e5f471a7f577bd59ad397d\",\"name\":\"Istratech Admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/08879edf0fbdb4c56d3bb4908200f600e0bcbb50c215e720817e00946f6b4822?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/08879edf0fbdb4c56d3bb4908200f600e0bcbb50c215e720817e00946f6b4822?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/08879edf0fbdb4c56d3bb4908200f600e0bcbb50c215e720817e00946f6b4822?s=96&d=mm&r=g\",\"caption\":\"Istratech Admin\"},\"url\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/author\\\/istratech_admin\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Resolving \"Commit business rules\" on the Oracle database &#8211; Istra Tech","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.istratech.hr\/en\/resolving-commit-business-rules-on-the-oracle-database\/","og_locale":"en_US","og_type":"article","og_title":"Resolving \"Commit business rules\" on the Oracle database &#8211; Istra Tech","og_description":"In recent years, software development has begun focusing on three-tier applications, mainly by separating the business rules layer from the presentation and data layer...","og_url":"https:\/\/www.istratech.hr\/en\/resolving-commit-business-rules-on-the-oracle-database\/","og_site_name":"Istra Tech","article_published_time":"2002-12-01T10:46:32+00:00","article_modified_time":"2021-07-09T11:47:02+00:00","author":"Istratech Admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Istratech Admin","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.istratech.hr\/en\/resolving-commit-business-rules-on-the-oracle-database\/#article","isPartOf":{"@id":"https:\/\/www.istratech.hr\/en\/resolving-commit-business-rules-on-the-oracle-database\/"},"author":{"name":"Istratech Admin","@id":"https:\/\/www.istratech.hr\/en\/#\/schema\/person\/e56f98c854e5f471a7f577bd59ad397d"},"headline":"Resolving &#8220;Commit business rules&#8221; on the Oracle database","datePublished":"2002-12-01T10:46:32+00:00","dateModified":"2021-07-09T11:47:02+00:00","mainEntityOfPage":{"@id":"https:\/\/www.istratech.hr\/en\/resolving-commit-business-rules-on-the-oracle-database\/"},"wordCount":137,"commentCount":0,"articleSection":["Blog","CASE","Conferences"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.istratech.hr\/en\/resolving-commit-business-rules-on-the-oracle-database\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.istratech.hr\/en\/resolving-commit-business-rules-on-the-oracle-database\/","url":"https:\/\/www.istratech.hr\/en\/resolving-commit-business-rules-on-the-oracle-database\/","name":"Resolving \"Commit business rules\" on the Oracle database &#8211; Istra Tech","isPartOf":{"@id":"https:\/\/www.istratech.hr\/en\/#website"},"datePublished":"2002-12-01T10:46:32+00:00","dateModified":"2021-07-09T11:47:02+00:00","author":{"@id":"https:\/\/www.istratech.hr\/en\/#\/schema\/person\/e56f98c854e5f471a7f577bd59ad397d"},"breadcrumb":{"@id":"https:\/\/www.istratech.hr\/en\/resolving-commit-business-rules-on-the-oracle-database\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.istratech.hr\/en\/resolving-commit-business-rules-on-the-oracle-database\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.istratech.hr\/en\/resolving-commit-business-rules-on-the-oracle-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Po\u010detna stranica","item":"https:\/\/www.istratech.hr\/"},{"@type":"ListItem","position":2,"name":"Resolving &#8220;Commit business rules&#8221; on the Oracle database"}]},{"@type":"WebSite","@id":"https:\/\/www.istratech.hr\/en\/#website","url":"https:\/\/www.istratech.hr\/en\/","name":"Istra Tech","description":"Digitalizacija sustava u turizmu, hotelijerstvu i ugostiteljstvu","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.istratech.hr\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.istratech.hr\/en\/#\/schema\/person\/e56f98c854e5f471a7f577bd59ad397d","name":"Istratech Admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/08879edf0fbdb4c56d3bb4908200f600e0bcbb50c215e720817e00946f6b4822?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/08879edf0fbdb4c56d3bb4908200f600e0bcbb50c215e720817e00946f6b4822?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/08879edf0fbdb4c56d3bb4908200f600e0bcbb50c215e720817e00946f6b4822?s=96&d=mm&r=g","caption":"Istratech Admin"},"url":"https:\/\/www.istratech.hr\/en\/author\/istratech_admin\/"}]}},"_links":{"self":[{"href":"https:\/\/www.istratech.hr\/en\/wp-json\/wp\/v2\/posts\/3138","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.istratech.hr\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.istratech.hr\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.istratech.hr\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.istratech.hr\/en\/wp-json\/wp\/v2\/comments?post=3138"}],"version-history":[{"count":0,"href":"https:\/\/www.istratech.hr\/en\/wp-json\/wp\/v2\/posts\/3138\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.istratech.hr\/en\/wp-json\/wp\/v2\/media?parent=3138"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.istratech.hr\/en\/wp-json\/wp\/v2\/categories?post=3138"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.istratech.hr\/en\/wp-json\/wp\/v2\/tags?post=3138"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}