{"id":20468,"date":"2023-02-01T02:58:47","date_gmt":"2023-02-01T02:58:47","guid":{"rendered":"https:\/\/www.booksofall.com\/es\/?post_type=product&#038;p=20468"},"modified":"2023-02-01T02:59:40","modified_gmt":"2023-02-01T02:59:40","slug":"database-design-2nd-edition-2","status":"publish","type":"product","link":"https:\/\/www.booksofall.com\/es\/database-design-2nd-edition-2\/","title":{"rendered":"Database Design \u2013 2nd Edition"},"content":{"rendered":"<h2>Chapter 1 &#8211; Before the Advent of Database Systems<\/h2>\n<p><b>ADRIENNE WATT<\/b><\/p>\n<p>The way in which <a href=\"https:\/\/www.techtarget.com\/searchdatamanagement\/definition\/data-management\">computers manage data<\/a> has come a long way over the last few decades. Today\u2019s users take for granted the many benefits found in a database system. However, it wasn\u2019t that long ago that computers relied on a much less elegant and costly approach to data management called the file-based system.<\/p>\n<h3>File-based System<\/h3>\n<p>One way to keep information on a computer is to store it in permanent files. A company system has a number of application programs; each of them is designed to manipulate data files. These application programs have been written at the request of the users in the organization. New applications are added to the system as the need arises. The system just described is called the\u00a0<i>file-based system<\/i>.<\/p>\n<p>Consider a traditional <a href=\"https:\/\/study.com\/academy\/lesson\/banking-system-definition-types.html\">banking system<\/a> that uses the <a href=\"https:\/\/www.webopedia.com\/definitions\/file-management-system\/\">file-based system<\/a> to manage the organization\u2019s data shown in Figure 1.1. As we can see, there are different departments in the bank. Each has its own applications that manage and manipulate different data files. For banking systems, the programs may be used to debit or credit an account, find the balance of an account, add a new mortgage loan and generate monthly statements.<\/p>\n<p><i>Figure 1.1. Example of a file-based system used by banks to manage data.<\/i><\/p>\n<p><strong>Disadvantages of the file-based approach<\/strong><\/p>\n<p>Using the file-based system to keep organizational information has a number of disadvantages. Listed below are five examples.<\/p>\n<p><a href=\"https:\/\/www.techopedia.com\/definition\/18707\/data-redundancy\"><i>Data redundancy<\/i><\/a><\/p>\n<p>Often, within an organization, files and applications are created by different programmers from various departments over long periods of time. This can lead to\u00a0<i>data redundancy,\u00a0<\/i>a situation that occurs in a database when a field needs to be updated in more than one table. This practice can lead to several problems such as:<\/p>\n<ul>\n<li>Inconsistency in data format<\/li>\n<li>The same information being kept in several different places (files)<\/li>\n<li><i>Data inconsistency<\/i>, a situation where various copies of the same data are conflicting, wastes storage space and duplicates effort<\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.cohesity.com\/glossary\/data-isolation\/\"><i>Data isolation<\/i><\/a><\/p>\n<p><i>Data isolation\u00a0<\/i>is a property that determines when and how changes made by one operation become visible to other concurrent users and systems. This issue occurs in a concurrency situation. This is a problem because:<\/p>\n<ul>\n<li>It is difficult for new applications to retrieve the appropriate data, which might be stored in various files.<\/li>\n<\/ul>\n<p><i>Integrity problems<\/i><\/p>\n<p>Problems with\u00a0<i><a href=\"https:\/\/www.talend.com\/resources\/what-is-data-integrity\/\">data integrity<\/a>\u00a0<\/i>is another disadvantage of using a file-based system. It refers to the maintenance and assurance that the data in a database are correct and consistent. Factors to consider when addressing this issue are:<\/p>\n<ul>\n<li>Data values must satisfy certain consistency constraints that are specified in the application programs.<\/li>\n<li>It is difficult to make changes to the application programs in order to enforce new constraints.<\/li>\n<\/ul>\n<p><i>Security problems<\/i><\/p>\n<p>Security can be a problem with a file-based approach because:<\/p>\n<ul>\n<li>There are constraints regarding accessing privileges.<\/li>\n<li>Application requirements are added to the system in an ad-hoc manner so it is difficult to enforce constraints.<\/li>\n<\/ul>\n<p><i>Concurrency access<\/i><\/p>\n<p><i>Concurrency\u00a0<\/i>is the ability of the database to allow multiple users access to the same record without adversely affecting transaction processing. A file-based system must manage, or prevent, concurrency by the application programs. Typically, in a file-based system, when an application opens a file, that file is locked. This means that no one else has access to the file at the same time.<\/p>\n<p>In database systems, concurrency is managed thus allowing multiple users access to the same record. This is an important difference between database and file-based systems.<\/p>\n<p><b>Database Approach<\/b><\/p>\n<p>The difficulties that arise from using the file-based system have prompted the development of a new approach in managing large amounts of organizational information called the\u00a0<i>database approach<\/i>.<\/p>\n<p>Databases and database technology play an important role in most areas where computers are used, including business, education and medicine. To understand the fundamentals of database systems, we will start by introducing some basic concepts in this area.<\/p>\n","protected":false},"excerpt":{"rendered":"<p><iframe style=\"width: 100%; height: 750px; border: none;\" src=\"https:\/\/online.visual-paradigm.com\/share\/book\/database-design-2nd-edition-18qz0c0zvo?p=1\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\n","protected":false},"featured_media":20473,"template":"","meta":{"_yoast_wpseo_title":"","_yoast_wpseo_metadesc":"Database system affect the way of data management a lot. Learn more about how it develops and how it works in this book now!"},"product_brand":[],"product_cat":[269],"product_tag":[],"class_list":{"0":"post-20468","1":"product","2":"type-product","3":"status-publish","4":"has-post-thumbnail","6":"product_cat-database","8":"first","9":"instock","10":"shipping-taxable","11":"product-type-simple"},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.1.1 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Database Design \u2013 2nd Edition - BooksOfAll Spanish<\/title>\n<meta name=\"description\" content=\"Database system affect the way of data management a lot. Learn more about how it develops and how it works in this book now!\" \/>\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.booksofall.com\/es\/database-design-2nd-edition-2\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Database Design \u2013 2nd Edition - BooksOfAll Spanish\" \/>\n<meta property=\"og:description\" content=\"Database system affect the way of data management a lot. Learn more about how it develops and how it works in this book now!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.booksofall.com\/es\/database-design-2nd-edition-2\/\" \/>\n<meta property=\"og:site_name\" content=\"BooksOfAll Spanish\" \/>\n<meta property=\"article:modified_time\" content=\"2023-02-01T02:59:40+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.booksofall.com\/es\/wp-content\/uploads\/sites\/5\/2023\/02\/006.jpg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:image\" content=\"https:\/\/www.booksofall.com\/es\/wp-content\/uploads\/sites\/5\/2023\/02\/006.jpg\" \/>\n<meta name=\"twitter:label1\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data1\" content=\"3 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.booksofall.com\/es\/database-design-2nd-edition-2\/\",\"url\":\"https:\/\/www.booksofall.com\/es\/database-design-2nd-edition-2\/\",\"name\":\"Database Design \u2013 2nd Edition - BooksOfAll Spanish\",\"isPartOf\":{\"@id\":\"https:\/\/www.booksofall.com\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.booksofall.com\/es\/database-design-2nd-edition-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.booksofall.com\/es\/database-design-2nd-edition-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.booksofall.com\/es\/wp-content\/uploads\/sites\/5\/2023\/02\/006.jpg\",\"datePublished\":\"2023-02-01T02:58:47+00:00\",\"dateModified\":\"2023-02-01T02:59:40+00:00\",\"description\":\"Database system affect the way of data management a lot. Learn more about how it develops and how it works in this book now!\",\"breadcrumb\":{\"@id\":\"https:\/\/www.booksofall.com\/es\/database-design-2nd-edition-2\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.booksofall.com\/es\/database-design-2nd-edition-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/www.booksofall.com\/es\/database-design-2nd-edition-2\/#primaryimage\",\"url\":\"https:\/\/www.booksofall.com\/es\/wp-content\/uploads\/sites\/5\/2023\/02\/006.jpg\",\"contentUrl\":\"https:\/\/www.booksofall.com\/es\/wp-content\/uploads\/sites\/5\/2023\/02\/006.jpg\",\"width\":\"595\",\"height\":\"842\",\"caption\":\"Database Design \u2013 2nd Edition\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.booksofall.com\/es\/database-design-2nd-edition-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.booksofall.com\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Categories\",\"item\":\"https:\/\/www.booksofall.com\/es\/categories\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Database Design \u2013 2nd Edition\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.booksofall.com\/es\/#website\",\"url\":\"https:\/\/www.booksofall.com\/es\/\",\"name\":\"BooksOfAll Spanish\",\"description\":\"Biggest IT eBooks library and learning resources - Free eBooks for programming, computing, artificial intelligence and more.\",\"publisher\":{\"@id\":\"https:\/\/www.booksofall.com\/es\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.booksofall.com\/es\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.booksofall.com\/es\/#organization\",\"name\":\"BooksOfAll Spanish\",\"url\":\"https:\/\/www.booksofall.com\/es\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/www.booksofall.com\/es\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.booksofall.com\/es\/wp-content\/uploads\/sites\/5\/2022\/06\/booksofall-logo-2.png\",\"contentUrl\":\"https:\/\/www.booksofall.com\/es\/wp-content\/uploads\/sites\/5\/2022\/06\/booksofall-logo-2.png\",\"width\":166,\"height\":30,\"caption\":\"BooksOfAll Spanish\"},\"image\":{\"@id\":\"https:\/\/www.booksofall.com\/es\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Database Design \u2013 2nd Edition - BooksOfAll Spanish","description":"Database system affect the way of data management a lot. Learn more about how it develops and how it works in this book now!","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.booksofall.com\/es\/database-design-2nd-edition-2\/","og_locale":"es_ES","og_type":"article","og_title":"Database Design \u2013 2nd Edition - BooksOfAll Spanish","og_description":"Database system affect the way of data management a lot. Learn more about how it develops and how it works in this book now!","og_url":"https:\/\/www.booksofall.com\/es\/database-design-2nd-edition-2\/","og_site_name":"BooksOfAll Spanish","article_modified_time":"2023-02-01T02:59:40+00:00","og_image":[{"url":"https:\/\/www.booksofall.com\/es\/wp-content\/uploads\/sites\/5\/2023\/02\/006.jpg","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_image":"https:\/\/www.booksofall.com\/es\/wp-content\/uploads\/sites\/5\/2023\/02\/006.jpg","twitter_misc":{"Tiempo de lectura":"3 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.booksofall.com\/es\/database-design-2nd-edition-2\/","url":"https:\/\/www.booksofall.com\/es\/database-design-2nd-edition-2\/","name":"Database Design \u2013 2nd Edition - BooksOfAll Spanish","isPartOf":{"@id":"https:\/\/www.booksofall.com\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.booksofall.com\/es\/database-design-2nd-edition-2\/#primaryimage"},"image":{"@id":"https:\/\/www.booksofall.com\/es\/database-design-2nd-edition-2\/#primaryimage"},"thumbnailUrl":"https:\/\/www.booksofall.com\/es\/wp-content\/uploads\/sites\/5\/2023\/02\/006.jpg","datePublished":"2023-02-01T02:58:47+00:00","dateModified":"2023-02-01T02:59:40+00:00","description":"Database system affect the way of data management a lot. Learn more about how it develops and how it works in this book now!","breadcrumb":{"@id":"https:\/\/www.booksofall.com\/es\/database-design-2nd-edition-2\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.booksofall.com\/es\/database-design-2nd-edition-2\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/www.booksofall.com\/es\/database-design-2nd-edition-2\/#primaryimage","url":"https:\/\/www.booksofall.com\/es\/wp-content\/uploads\/sites\/5\/2023\/02\/006.jpg","contentUrl":"https:\/\/www.booksofall.com\/es\/wp-content\/uploads\/sites\/5\/2023\/02\/006.jpg","width":"595","height":"842","caption":"Database Design \u2013 2nd Edition"},{"@type":"BreadcrumbList","@id":"https:\/\/www.booksofall.com\/es\/database-design-2nd-edition-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.booksofall.com\/es\/"},{"@type":"ListItem","position":2,"name":"Categories","item":"https:\/\/www.booksofall.com\/es\/categories\/"},{"@type":"ListItem","position":3,"name":"Database Design \u2013 2nd Edition"}]},{"@type":"WebSite","@id":"https:\/\/www.booksofall.com\/es\/#website","url":"https:\/\/www.booksofall.com\/es\/","name":"BooksOfAll Spanish","description":"Biggest IT eBooks library and learning resources - Free eBooks for programming, computing, artificial intelligence and more.","publisher":{"@id":"https:\/\/www.booksofall.com\/es\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.booksofall.com\/es\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/www.booksofall.com\/es\/#organization","name":"BooksOfAll Spanish","url":"https:\/\/www.booksofall.com\/es\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/www.booksofall.com\/es\/#\/schema\/logo\/image\/","url":"https:\/\/www.booksofall.com\/es\/wp-content\/uploads\/sites\/5\/2022\/06\/booksofall-logo-2.png","contentUrl":"https:\/\/www.booksofall.com\/es\/wp-content\/uploads\/sites\/5\/2022\/06\/booksofall-logo-2.png","width":166,"height":30,"caption":"BooksOfAll Spanish"},"image":{"@id":"https:\/\/www.booksofall.com\/es\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/www.booksofall.com\/es\/wp-json\/wp\/v2\/product\/20468","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.booksofall.com\/es\/wp-json\/wp\/v2\/product"}],"about":[{"href":"https:\/\/www.booksofall.com\/es\/wp-json\/wp\/v2\/types\/product"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.booksofall.com\/es\/wp-json\/wp\/v2\/media\/20473"}],"wp:attachment":[{"href":"https:\/\/www.booksofall.com\/es\/wp-json\/wp\/v2\/media?parent=20468"}],"wp:term":[{"taxonomy":"product_brand","embeddable":true,"href":"https:\/\/www.booksofall.com\/es\/wp-json\/wp\/v2\/product_brand?post=20468"},{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/www.booksofall.com\/es\/wp-json\/wp\/v2\/product_cat?post=20468"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/www.booksofall.com\/es\/wp-json\/wp\/v2\/product_tag?post=20468"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}