{"id":61,"date":"2018-12-04T17:59:44","date_gmt":"2018-12-04T17:59:44","guid":{"rendered":"https:\/\/barkhane.com\/sql\/2018\/12\/04\/what-is-database\/"},"modified":"2024-03-03T18:07:05","modified_gmt":"2024-03-03T18:07:05","slug":"what-is-database","status":"publish","type":"post","link":"https:\/\/barkhane.com\/sql\/what-is-database\/","title":{"rendered":"What is Database"},"content":{"rendered":"<p>What is Database ? A <strong>database<\/strong>\u00a0is\u00a0<em>an organised\u00a0collection of data<\/em>. The\u00a0<strong>main purpose<\/strong>\u00a0of database is to operate large amount of information by storing, retrieving and managing. There are many\u00a0<strong>database available<\/strong>\u00a0like MySQL, Oracle, Mango DB, Informix, Postgre, SQL Server etc.<\/p>\n<p><a href=\"https:\/\/barkhane.com\/sql\/\"><strong>SQL<\/strong>\u00a0<\/a>or Structured Query Language is used to perform operation on the data stored in a database. SQL depends on relational algebra and tuple relational calculus.<\/p>\n<p>The\u00a0database management system\u00a0(DBMS) is the\u00a0software\u00a0that interacts with\u00a0end users, applications, and the database itself to capture and analyse the data. The DBMS software additionally encompasses the core facilities provided to administer the database. The sum total of the database, the DBMS and the associated applications can be referred to as a \\&#8221;database system\\&#8221;. Often the term \\&#8221;database\\&#8221; is also used to loosely refer to any of the DBMS, the database system or an application associated with the database.<\/p>\n<p>in other words\u00a0Database<\/p>\n<ul>\n<li>is a systematic collection of data.<\/li>\n<li>support storage and \u00a0manipulation of data.<\/li>\n<li>make data management easy.<\/li>\n<\/ul>\n<p>An online telephone directory would definitely use database to store data pertaining to people, phone numbers, other contact details, etc.<\/p>\n<p>Your electricity service provider is obviously using a database to manage billing , client related issues, to handle fault data, etc.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>What is Database ? A database\u00a0is\u00a0an organised\u00a0collection of data. The\u00a0main purpose\u00a0of database is to operate large amount of information by [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[2],"tags":[],"class_list":["post-61","post","type-post","status-publish","format-standard","hentry","category-sql"],"_links":{"self":[{"href":"https:\/\/barkhane.com\/sql\/wp-json\/wp\/v2\/posts\/61","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/barkhane.com\/sql\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/barkhane.com\/sql\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/barkhane.com\/sql\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/barkhane.com\/sql\/wp-json\/wp\/v2\/comments?post=61"}],"version-history":[{"count":0,"href":"https:\/\/barkhane.com\/sql\/wp-json\/wp\/v2\/posts\/61\/revisions"}],"wp:attachment":[{"href":"https:\/\/barkhane.com\/sql\/wp-json\/wp\/v2\/media?parent=61"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/barkhane.com\/sql\/wp-json\/wp\/v2\/categories?post=61"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/barkhane.com\/sql\/wp-json\/wp\/v2\/tags?post=61"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}