Warning: Undefined array key "global_protection_id" in /home/wikitechy/public_html/interview-questions/wp-content/plugins/content-protector/inc/class-ps-rest-handler.php on line 51
{"id":4394,"date":"2022-06-03T09:41:49","date_gmt":"2022-06-03T09:41:49","guid":{"rendered":"https:\/\/www.wikitechy.com\/interview-questions\/?p=4394"},"modified":"2022-06-03T09:42:00","modified_gmt":"2022-06-03T09:42:00","slug":"what-is-the-concept-of-acid-properties-in-dbms","status":"publish","type":"post","link":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-the-concept-of-acid-properties-in-dbms\/","title":{"rendered":"What is the concept of ACID properties in DBMS ?"},"content":{"rendered":"

\"\"<\/p>\n

ACID stands for Atomicity, Consisency, Isolation, and Durbility property. Multiple users can share data in a safe and secure way using these properties.<\/p>\n

\u00a0Atomicity<\/strong>:<\/strong><\/h3>\n
    \n
  • Atomicity is based on the principle of \u201ceither all or nothing\u201d which means that if any updates\u00a0 happens inside the database then that updates should be available for others beyond user and application.<\/li>\n
  • If any updates happens inside the database then that updates should not be available for others beyond user and application.<\/li>\n<\/ul>\n

    Consistency<\/strong>: <\/strong><\/h3>\n
      \n
    • Inside a database before or after any transaction takes place this ensures that consistency is maintained.<\/li>\n<\/ul>\n

      Isolation<\/strong>:<\/h3>\n
        \n
      • This property states that happens in isolation with other which means that any transactions that has started but not yet completed should be in isolation with others so that the other transactions are not affected by this transaction.<\/li>\n<\/ul>\n

        Durability<\/strong>:<\/h3>\n
          \n
        • This property states that the data should always be in a durable state i.e. any data which is in the committed state should be available in the same state even if any failure or restart occurs in the system<\/li>\n<\/ul>\n

          Transaction States in DBMS<\/h3>\n

          \"\"<\/p>\n","protected":false},"excerpt":{"rendered":"

          ACID stands for Atomicity, Consisency, Isolation, and Durbility property. Multiple users can share data in a safe and secure way using these properties. \u00a0Atomicity: Atomicity is based on the principle of \u201ceither all or nothing\u201d which means that if any updates\u00a0 happens inside the database then that updates should be available for others beyond user […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"passster_activate_protection":false,"passster_protect_child_pages":"","passster_protection_type":"password","passster_password":"","passster_activate_overwrite_defaults":"","passster_headline":"","passster_instruction":"","passster_placeholder":"","passster_button":"","passster_id":"","passster_activate_misc_settings":"","passster_redirect_url":"","passster_hide":"no","passster_area_shortcode":"","gtb_hide_title":false,"gtb_wrap_title":false,"gtb_class_title":"","gtb_remove_headerfooter":false,"footnotes":""},"categories":[7157],"tags":[17404,17403,17398,17399,17401,17400,17402,7226,17405],"class_list":["post-4394","post","type-post","status-publish","format-standard","hentry","category-dbms","tag-acid-in-dbms","tag-acid-properties-in-database","tag-acid-properties-in-dbms","tag-acid-properties-in-dbms-with-examples","tag-acid-properties-in-rdbms","tag-acid-properties-of-transaction","tag-acid-properties-of-transaction-in-dbms","tag-transaction-in-dbms","tag-transaction-management-in-dbms"],"yoast_head":"\nWhat is the concept of ACID properties in DBMS ?<\/title>\n<meta name=\"description\" content=\"ACID Properties in DBMS - Inside a database before or after any transaction takes place this ensures that consistency is maintained\" \/>\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.wikitechy.com\/interview-questions\/dbms\/what-is-the-concept-of-acid-properties-in-dbms\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"What is the concept of ACID properties in DBMS ?\" \/>\n<meta property=\"og:description\" content=\"ACID Properties in DBMS - Inside a database before or after any transaction takes place this ensures that consistency is maintained\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-the-concept-of-acid-properties-in-dbms\/\" \/>\n<meta property=\"og:site_name\" content=\"Wikitechy\" \/>\n<meta property=\"article:published_time\" content=\"2022-06-03T09:41:49+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-06-03T09:42:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/05\/Explain-the-concept-of-ACID-Properties-in-DBMS..jpg\" \/>\n<meta name=\"author\" content=\"webmaster\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"webmaster\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-the-concept-of-acid-properties-in-dbms\/\",\"url\":\"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-the-concept-of-acid-properties-in-dbms\/\",\"name\":\"What is the concept of ACID properties in DBMS ?\",\"isPartOf\":{\"@id\":\"https:\/\/www.wikitechy.com\/interview-questions\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-the-concept-of-acid-properties-in-dbms\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-the-concept-of-acid-properties-in-dbms\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/05\/Explain-the-concept-of-ACID-Properties-in-DBMS..jpg\",\"datePublished\":\"2022-06-03T09:41:49+00:00\",\"dateModified\":\"2022-06-03T09:42:00+00:00\",\"author\":{\"@id\":\"https:\/\/www.wikitechy.com\/interview-questions\/#\/schema\/person\/f785ba3ecc599133e65ab6138042a3e4\"},\"description\":\"ACID Properties in DBMS - Inside a database before or after any transaction takes place this ensures that consistency is maintained\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-the-concept-of-acid-properties-in-dbms\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-the-concept-of-acid-properties-in-dbms\/#primaryimage\",\"url\":\"https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/05\/Explain-the-concept-of-ACID-Properties-in-DBMS..jpg\",\"contentUrl\":\"https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/05\/Explain-the-concept-of-ACID-Properties-in-DBMS..jpg\",\"width\":802,\"height\":436},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.wikitechy.com\/interview-questions\/#website\",\"url\":\"https:\/\/www.wikitechy.com\/interview-questions\/\",\"name\":\"Wikitechy\",\"description\":\"Interview Questions\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.wikitechy.com\/interview-questions\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.wikitechy.com\/interview-questions\/#\/schema\/person\/f785ba3ecc599133e65ab6138042a3e4\",\"name\":\"webmaster\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.wikitechy.com\/interview-questions\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/155b77fd8cdda3d0913fcb7e7ee63543b0c345d2d8f6dcebda5b0583ab61f967?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/155b77fd8cdda3d0913fcb7e7ee63543b0c345d2d8f6dcebda5b0583ab61f967?s=96&d=mm&r=g\",\"caption\":\"webmaster\"},\"sameAs\":[\"https:\/\/www.wikitechy.com\/interview-questions\"],\"url\":\"https:\/\/www.wikitechy.com\/interview-questions\/author\/webmaster\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"What is the concept of ACID properties in DBMS ?","description":"ACID Properties in DBMS - Inside a database before or after any transaction takes place this ensures that consistency is maintained","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.wikitechy.com\/interview-questions\/dbms\/what-is-the-concept-of-acid-properties-in-dbms\/","og_locale":"en_US","og_type":"article","og_title":"What is the concept of ACID properties in DBMS ?","og_description":"ACID Properties in DBMS - Inside a database before or after any transaction takes place this ensures that consistency is maintained","og_url":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-the-concept-of-acid-properties-in-dbms\/","og_site_name":"Wikitechy","article_published_time":"2022-06-03T09:41:49+00:00","article_modified_time":"2022-06-03T09:42:00+00:00","og_image":[{"url":"https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/05\/Explain-the-concept-of-ACID-Properties-in-DBMS..jpg"}],"author":"webmaster","twitter_card":"summary_large_image","twitter_misc":{"Written by":"webmaster","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-the-concept-of-acid-properties-in-dbms\/","url":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-the-concept-of-acid-properties-in-dbms\/","name":"What is the concept of ACID properties in DBMS ?","isPartOf":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-the-concept-of-acid-properties-in-dbms\/#primaryimage"},"image":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-the-concept-of-acid-properties-in-dbms\/#primaryimage"},"thumbnailUrl":"https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/05\/Explain-the-concept-of-ACID-Properties-in-DBMS..jpg","datePublished":"2022-06-03T09:41:49+00:00","dateModified":"2022-06-03T09:42:00+00:00","author":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/#\/schema\/person\/f785ba3ecc599133e65ab6138042a3e4"},"description":"ACID Properties in DBMS - Inside a database before or after any transaction takes place this ensures that consistency is maintained","inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-the-concept-of-acid-properties-in-dbms\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-the-concept-of-acid-properties-in-dbms\/#primaryimage","url":"https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/05\/Explain-the-concept-of-ACID-Properties-in-DBMS..jpg","contentUrl":"https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/05\/Explain-the-concept-of-ACID-Properties-in-DBMS..jpg","width":802,"height":436},{"@type":"WebSite","@id":"https:\/\/www.wikitechy.com\/interview-questions\/#website","url":"https:\/\/www.wikitechy.com\/interview-questions\/","name":"Wikitechy","description":"Interview Questions","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.wikitechy.com\/interview-questions\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.wikitechy.com\/interview-questions\/#\/schema\/person\/f785ba3ecc599133e65ab6138042a3e4","name":"webmaster","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.wikitechy.com\/interview-questions\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/155b77fd8cdda3d0913fcb7e7ee63543b0c345d2d8f6dcebda5b0583ab61f967?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/155b77fd8cdda3d0913fcb7e7ee63543b0c345d2d8f6dcebda5b0583ab61f967?s=96&d=mm&r=g","caption":"webmaster"},"sameAs":["https:\/\/www.wikitechy.com\/interview-questions"],"url":"https:\/\/www.wikitechy.com\/interview-questions\/author\/webmaster\/"}]}},"_links":{"self":[{"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/posts\/4394","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/comments?post=4394"}],"version-history":[{"count":2,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/posts\/4394\/revisions"}],"predecessor-version":[{"id":4442,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/posts\/4394\/revisions\/4442"}],"wp:attachment":[{"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/media?parent=4394"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/categories?post=4394"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/tags?post=4394"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}