{"id":3174,"date":"2008-11-14T11:20:25","date_gmt":"2008-11-14T11:20:25","guid":{"rendered":"http:\/\/www.istratech.hr\/?p=3174"},"modified":"2021-07-12T12:04:57","modified_gmt":"2021-07-12T12:04:57","slug":"how-to-prevent-the-vicious-circle-solving-a-certain-type-of-business-rules-in-the-oracle-database","status":"publish","type":"post","link":"https:\/\/www.istratech.hr\/en\/how-to-prevent-the-vicious-circle-solving-a-certain-type-of-business-rules-in-the-oracle-database\/","title":{"rendered":"HOW TO PREVENT THE “VICIOUS CIRCLE”"},"content":{"rendered":"\n

ABSTRACT<\/strong><\/p>\n\n\n\n

In this article, it is shown how to avoid the problem of a so-called “vicious cycle” (closed loop) in data with tree structure by doing that completely on the data base side, without writing any client software or application server software.
Single user and multi user solution is given. In multi user solution, our simulation of “ROLLBACK TO SAVEPOINT feature” is used in data base trigger, which involve quasi-remote procedures (it means that local procedures has been called like they are from some other data base).<\/p>\n\n\n

VIEW LECTURE<\/a><\/div>\n","protected":false},"excerpt":{"rendered":"

Solving a certain type of business rules in the Oracle database<\/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-3174","post","type-post","status-publish","format-standard","hentry","category-blog-en","category-case-en","category-conferences"],"acf":[],"yoast_head":"\nHOW TO PREVENT THE "VICIOUS CIRCLE" – 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\/how-to-prevent-the-vicious-circle-solving-a-certain-type-of-business-rules-in-the-oracle-database\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"HOW TO PREVENT THE "VICIOUS CIRCLE" – Istra Tech\" \/>\n<meta property=\"og:description\" content=\"Solving a certain type of business rules in the Oracle database\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.istratech.hr\/en\/how-to-prevent-the-vicious-circle-solving-a-certain-type-of-business-rules-in-the-oracle-database\/\" \/>\n<meta property=\"og:site_name\" content=\"Istra Tech\" \/>\n<meta property=\"article:published_time\" content=\"2008-11-14T11:20:25+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-07-12T12:04:57+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<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/how-to-prevent-the-vicious-circle-solving-a-certain-type-of-business-rules-in-the-oracle-database\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/how-to-prevent-the-vicious-circle-solving-a-certain-type-of-business-rules-in-the-oracle-database\\\/\"},\"author\":{\"name\":\"Istratech Admin\",\"@id\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/#\\\/schema\\\/person\\\/e56f98c854e5f471a7f577bd59ad397d\"},\"headline\":\"HOW TO PREVENT THE “VICIOUS CIRCLE”\",\"datePublished\":\"2008-11-14T11:20:25+00:00\",\"dateModified\":\"2021-07-12T12:04:57+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/how-to-prevent-the-vicious-circle-solving-a-certain-type-of-business-rules-in-the-oracle-database\\\/\"},\"wordCount\":97,\"commentCount\":0,\"articleSection\":[\"Blog\",\"CASE\",\"Conferences\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.istratech.hr\\\/en\\\/how-to-prevent-the-vicious-circle-solving-a-certain-type-of-business-rules-in-the-oracle-database\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/how-to-prevent-the-vicious-circle-solving-a-certain-type-of-business-rules-in-the-oracle-database\\\/\",\"url\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/how-to-prevent-the-vicious-circle-solving-a-certain-type-of-business-rules-in-the-oracle-database\\\/\",\"name\":\"HOW TO PREVENT THE \\\"VICIOUS CIRCLE\\\" – Istra Tech\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/#website\"},\"datePublished\":\"2008-11-14T11:20:25+00:00\",\"dateModified\":\"2021-07-12T12:04:57+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/#\\\/schema\\\/person\\\/e56f98c854e5f471a7f577bd59ad397d\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/how-to-prevent-the-vicious-circle-solving-a-certain-type-of-business-rules-in-the-oracle-database\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.istratech.hr\\\/en\\\/how-to-prevent-the-vicious-circle-solving-a-certain-type-of-business-rules-in-the-oracle-database\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/how-to-prevent-the-vicious-circle-solving-a-certain-type-of-business-rules-in-the-oracle-database\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Po\u010detna stranica\",\"item\":\"https:\\\/\\\/www.istratech.hr\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"HOW TO PREVENT THE “VICIOUS CIRCLE”\"}]},{\"@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":"HOW TO PREVENT THE \"VICIOUS CIRCLE\" – 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\/how-to-prevent-the-vicious-circle-solving-a-certain-type-of-business-rules-in-the-oracle-database\/","og_locale":"en_US","og_type":"article","og_title":"HOW TO PREVENT THE \"VICIOUS CIRCLE\" – Istra Tech","og_description":"Solving a certain type of business rules in the Oracle database","og_url":"https:\/\/www.istratech.hr\/en\/how-to-prevent-the-vicious-circle-solving-a-certain-type-of-business-rules-in-the-oracle-database\/","og_site_name":"Istra Tech","article_published_time":"2008-11-14T11:20:25+00:00","article_modified_time":"2021-07-12T12:04:57+00:00","author":"Istratech Admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Istratech Admin"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.istratech.hr\/en\/how-to-prevent-the-vicious-circle-solving-a-certain-type-of-business-rules-in-the-oracle-database\/#article","isPartOf":{"@id":"https:\/\/www.istratech.hr\/en\/how-to-prevent-the-vicious-circle-solving-a-certain-type-of-business-rules-in-the-oracle-database\/"},"author":{"name":"Istratech Admin","@id":"https:\/\/www.istratech.hr\/en\/#\/schema\/person\/e56f98c854e5f471a7f577bd59ad397d"},"headline":"HOW TO PREVENT THE “VICIOUS CIRCLE”","datePublished":"2008-11-14T11:20:25+00:00","dateModified":"2021-07-12T12:04:57+00:00","mainEntityOfPage":{"@id":"https:\/\/www.istratech.hr\/en\/how-to-prevent-the-vicious-circle-solving-a-certain-type-of-business-rules-in-the-oracle-database\/"},"wordCount":97,"commentCount":0,"articleSection":["Blog","CASE","Conferences"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.istratech.hr\/en\/how-to-prevent-the-vicious-circle-solving-a-certain-type-of-business-rules-in-the-oracle-database\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.istratech.hr\/en\/how-to-prevent-the-vicious-circle-solving-a-certain-type-of-business-rules-in-the-oracle-database\/","url":"https:\/\/www.istratech.hr\/en\/how-to-prevent-the-vicious-circle-solving-a-certain-type-of-business-rules-in-the-oracle-database\/","name":"HOW TO PREVENT THE \"VICIOUS CIRCLE\" – Istra Tech","isPartOf":{"@id":"https:\/\/www.istratech.hr\/en\/#website"},"datePublished":"2008-11-14T11:20:25+00:00","dateModified":"2021-07-12T12:04:57+00:00","author":{"@id":"https:\/\/www.istratech.hr\/en\/#\/schema\/person\/e56f98c854e5f471a7f577bd59ad397d"},"breadcrumb":{"@id":"https:\/\/www.istratech.hr\/en\/how-to-prevent-the-vicious-circle-solving-a-certain-type-of-business-rules-in-the-oracle-database\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.istratech.hr\/en\/how-to-prevent-the-vicious-circle-solving-a-certain-type-of-business-rules-in-the-oracle-database\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.istratech.hr\/en\/how-to-prevent-the-vicious-circle-solving-a-certain-type-of-business-rules-in-the-oracle-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Po\u010detna stranica","item":"https:\/\/www.istratech.hr\/"},{"@type":"ListItem","position":2,"name":"HOW TO PREVENT THE “VICIOUS CIRCLE”"}]},{"@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\/3174","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=3174"}],"version-history":[{"count":0,"href":"https:\/\/www.istratech.hr\/en\/wp-json\/wp\/v2\/posts\/3174\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.istratech.hr\/en\/wp-json\/wp\/v2\/media?parent=3174"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.istratech.hr\/en\/wp-json\/wp\/v2\/categories?post=3174"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.istratech.hr\/en\/wp-json\/wp\/v2\/tags?post=3174"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}