{"id":6728,"date":"2019-03-19T09:42:12","date_gmt":"2019-03-19T09:42:12","guid":{"rendered":"https:\/\/ittutorial.org\/?p=6728"},"modified":"2019-11-28T06:59:18","modified_gmt":"2019-11-28T06:59:18","slug":"what-is-the-database-why-database","status":"publish","type":"post","link":"https:\/\/ittutorial.org\/what-is-the-database-why-database\/","title":{"rendered":"What is the Database, Why Database ?"},"content":{"rendered":"<p>Hi,<\/p>\n<p>In this article I will tell you the Database concept and clarify what is the database and why database ?<\/p>\n<p><a href=\"http:\/\/mehmetsalihdeveci.net\/2012\/07\/20\/veritabani-kavrami-ve-veritabani-yonetim-sistemleri\/veritabani\/\" rel=\"attachment wp-att-2676\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2676\" title=\"veritabani\" src=\"http:\/\/salihdeveci.files.wordpress.com\/2012\/07\/veritabani.png\" alt=\"\" width=\"256\" height=\"256\" srcset=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2012\/07\/veritabani.png 256w, https:\/\/ittutorial.org\/wp-content\/uploads\/2012\/07\/veritabani-150x150.png 150w\" sizes=\"auto, (max-width: 256px) 100vw, 256px\" \/><\/a><\/p>\n<p><!--more--><\/p>\n\n<p>&nbsp;<\/p>\n<p>Database is a software that allows large amounts of data to be kept together in an order.<\/p>\n<p>Database systems that establish the connection between the data related to each other and keep them in a regular manner and eliminate the security problem are called Database Management Systems.\u00a0An example scenario that will reveal the importance of a database management system can be as follows.<\/p>\n<div class=\"tlid-input input\">\n<div class=\"source-wrap\">\n<div class=\"input-full-height-wrapper tlid-input-full-height-wrapper\">\n<div class=\"source-input\">\n<div class=\"source-footer-wrap source-or-target-footer\">\n<div class=\"character-count tlid-character-count\"><\/div>\n<div class=\"source-footer\">\n<div class=\"src-tts left-positioned ttsbutton jfk-button-flat source-or-target-footer-button jfk-button\" tabindex=\"0\" role=\"button\" aria-label=\"Listen\" data-tooltip=\"Listen\" aria-pressed=\"false\" data-tooltip-align=\"t,c\" aria-hidden=\"false\" aria-disabled=\"false\">\n<div class=\"jfk-button-img\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"tlid-results-container results-container\">\n<div class=\"tlid-result result-dict-wrapper\">\n<div class=\"result tlid-copy-target\">\n<div class=\"text-wrap tlid-copy-target\">\n<div class=\"result-shield-container tlid-copy-target\" tabindex=\"0\"><span class=\"tlid-translation translation\" lang=\"en\"><span class=\"\" title=\"\">For example,\u00a0<\/span><\/span>\u00a0Student is going to the library wants\u00a0to borrow one or more books. There are 1000-10.000 different categories and mostly independent books from each other in the library .<\/div>\n<div tabindex=\"0\"><\/div>\n<div tabindex=\"0\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p>If these books are not arranged according to a specific Logic, the person who is looking for books on the shelves is probably looking for the book until night.<\/p>\n<p>This is not possible in real life and is an undesirable situation.\u00a0That is why there are many ways to facilitate searching in libraries.\u00a0For example: Sort books in alphabetical order. In this way, when we search for a book, we will find the book in such a short time as to be comparable to other amateur methods.<\/p>\n\n<p>&nbsp;<\/p>\n<p>The main reason I tell the above scenario is the main reason for the need for Database and Database management systems.\u00a0As can be seen here, the Database management system and the Database will always be an indispensable part of the increasing information technologies in the developing world.<\/p>\n\n<p>Here are the places where real life database is used<\/p>\n<ul>\n<li>Airlines: Reservations and Ticket Sales<\/li>\n<li>Banks: Banking transactions and transactions<\/li>\n<li>Universities: Student Tracking system and Note entries<\/li>\n<li>Online Sales: Customer and Product information<\/li>\n<li>Online Perakende: Sipari\u015f Kay\u0131tlar\u0131 ve sonu\u00e7lar\u0131<\/li>\n<li>Human Resources: Employee Profiles and Salaries<\/li>\n<li>Production: Stocks and tracking of manufactured products<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p>We say Database management systems are indispensable now let&#8217;s look at them what are the most fundamental benefits of Database management systems .<\/p>\n\n<div class=\"tlid-input input\">\n<div class=\"source-wrap\">\n<div class=\"input-full-height-wrapper tlid-input-full-height-wrapper\">\n<div class=\"source-input\">\n<div class=\"source-footer-wrap source-or-target-footer\">\n<div class=\"character-count tlid-character-count\">\n<div class=\"cc-ctr normal\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"tlid-results-container results-container\">\n<div class=\"tlid-result result-dict-wrapper\">\n<div class=\"result tlid-copy-target\">\n<div class=\"text-wrap tlid-copy-target\">\n<div class=\"result-shield-container tlid-copy-target\" tabindex=\"0\"><span class=\"tlid-translation translation\" lang=\"en\"><span title=\"\"><strong>Data Consistency:<\/strong> The data is seen the most current to users when multiple users have access.<\/span> <span class=\"\" title=\"\">Ex: You want to buy the ticket from the internet page of the airline, and someone else was doing the same procedure on the same system as you did 1-2 seconds before you bought the ticket.<\/span> <span class=\"\" title=\"\">In this case, a second customer can buy that ticket if there is not a Database Management System.<\/span> <span class=\"\" title=\"\">This will cause inconsistency of the data.<\/span> <span class=\"\" title=\"\">Therefore, Database Management Systems guarantee data consistency in database where multiple users are connected.<\/span><\/span><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p><strong>Data Redundancy:<\/strong> Enables a common data repository used by many people to be managed in a unique place. Otherwise, there will be many repetitions or copies of the data, and the consistency of the data will not be ensured.<\/p>\n<p><strong>Data Concurrency:<\/strong>\u00a0 Database management system provides\u00a0concurrent access multiple users\u00a0 to the same data. Otherwise, if the file was used instead of database, users would have access to the same data in turn.<\/p>\n<p><strong>Data Integrity:<\/strong> When a user in the system is deleted in this method, all data of related user must be deleted.<\/p>\n<p><strong>Data Security:<\/strong> Prevents data from being unintentionally destroyed and corrupted. It also provides Security by allowing users to access only the schemes or tables on which it is permitted.<\/p>\n\n<p><strong>Data Independence:<\/strong> The structure of the data stored in the database, regardless of the matter does not matter Database management system solves this complexity itself.<\/p>\n<div class=\"tlid-input input\">\n<div class=\"source-wrap\">\n<div class=\"input-full-height-wrapper tlid-input-full-height-wrapper\">\n<div class=\"source-input\">\n<div class=\"source-footer-wrap source-or-target-footer\">\n<div class=\"character-count tlid-character-count\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"tlid-results-container results-container\">\n<div class=\"tlid-result result-dict-wrapper\">\n<div class=\"result tlid-copy-target\">\n<div class=\"result-header\">\n<div class=\"starbutton jfk-button-flat jfk-button unstarred\" tabindex=\"0\" role=\"button\" aria-label=\"Star translation\" data-tooltip=\"Star translation\" data-tooltip-align=\"t,c\">\n<div class=\"jfk-button-img\"><\/div>\n<\/div>\n<\/div>\n<div class=\"text-wrap tlid-copy-target\">\n<div class=\"result-shield-container tlid-copy-target\" tabindex=\"0\"><span class=\"tlid-translation translation\" lang=\"en\"><span title=\"\">What is the most popular database management used in the world?<\/span> <span class=\"\" title=\"\">The list is as follows .<\/span><\/span><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<ol>\n<li>Oracle<\/li>\n<li>SQL Server<\/li>\n<li>MySQL<\/li>\n<li>PostgreSQL<\/li>\n<li>Sybase<\/li>\n<li>DB2<\/li>\n<li>FileMaker<\/li>\n<li>Ingress<\/li>\n<li>Informix<\/li>\n<li>MS-Access<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<h5><span style=\"color: #ff0000;\">Do you want to learn Oracle Database for Beginners, then read the following articles.<\/span><\/h5>\n<p><a href=\"https:\/\/ittutorial.org\/oracle-database-19c-tutorials-for-beginners\/\">https:\/\/ittutorial.org\/oracle-database-19c-tutorials-for-beginners\/<\/a><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<h5><span style=\"color: #ff0000;\">Do you want to learn Microsoft SQL Server DBA, then read the following articles.<\/span><\/h5>\n<p>https:\/\/ittutorial.org\/sql-server-tutorials-microsoft-database-for-beginners\/<\/p>\n<p>&nbsp;<\/p>\n<h4><span style=\"color: #ff0000;\">Do you want to learn Microsoft SQL Server DBA Tutorials for Beginners, then read the following articles.<\/span><\/h4>\n<p><a href=\"https:\/\/ittutorial.org\/sql-server-tutorials-microsoft-database-for-beginners\/\">https:\/\/ittutorial.org\/sql-server-tutorials-microsoft-database-for-beginners\/<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Hi, In this article I will tell you the Database concept and clarify what is the database and why database ?<\/p>\n","protected":false},"author":1,"featured_media":3228,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[1994,2227],"tags":[2609,2599,2598,1031,2602,2603,2607,1120,1207,2611,2612,2606,1577,2608,2600,2601,2605,2596,2597,2604,2610],"class_list":["post-6728","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-oracle","category-sql-server-2","tag-database-documents","tag-database-tut","tag-database-tuttorial","tag-mehmet-salih-deveci","tag-most-popular-database","tag-most-popular-rdbms","tag-mysql","tag-oracle","tag-oracle-database","tag-oracle-rdbms","tag-oracle-sql-server","tag-postgresql","tag-sql-server","tag-sybase","tag-tutorial-of-database","tag-what-is-database","tag-what-is-oracle","tag-what-is-the-database","tag-why-database","tag-why-oracle","tag-why-using-database"],"aioseo_notices":[],"jetpack_featured_media_url":"https:\/\/ittutorial.org\/wp-content\/uploads\/2013\/10\/oracle_database.jpg","jetpack_sharing_enabled":true,"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/6728","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/comments?post=6728"}],"version-history":[{"count":5,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/6728\/revisions"}],"predecessor-version":[{"id":12945,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/6728\/revisions\/12945"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/media\/3228"}],"wp:attachment":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/media?parent=6728"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/categories?post=6728"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/tags?post=6728"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}