{"id":7445,"date":"2018-04-18T12:36:48","date_gmt":"2018-04-18T03:36:48","guid":{"rendered":"http:\/\/ocw.tsukuba.ac.jp\/en\/?page_id=7445"},"modified":"2022-11-04T14:56:45","modified_gmt":"2022-11-04T05:56:45","slug":"database-systems-i","status":"publish","type":"page","link":"https:\/\/ocw.tsukuba.ac.jp\/en\/course\/systeminformation\/database-systems-i\/","title":{"rendered":"Database Systems I"},"content":{"rendered":"","protected":false},"excerpt":{"rendered":"","protected":false},"author":2,"featured_media":0,"parent":3565,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"page-lectop.php","meta":{"footnotes":""},"class_list":["post-7445","page","type-page","status-publish","hentry"],"acf":[],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 4.9.8 - aioseo.com -->\n\t<meta name=\"description\" content=\"Introduction to database systems. Lectures on basic concepts of database systems, data modeling, relational data model, database language SQL, relational database design theory, physical data organization, and query processing.| Hiroyuki Kitagawa\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<link rel=\"canonical\" href=\"https:\/\/ocw.tsukuba.ac.jp\/en\/course\/systeminformation\/database-systems-i\/\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 4.9.8\" \/>\n\t\t<meta property=\"og:locale\" content=\"ja_JP\" \/>\n\t\t<meta property=\"og:site_name\" content=\"TSUKUBA OCW | University of Tsukuba | TSUKUBA OCW (Opencourseware) is a platform to establish a new interface between the university and society.\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"Database Systems I | TSUKUBA OCW | University of Tsukuba |\" \/>\n\t\t<meta property=\"og:description\" content=\"Introduction to database systems. Lectures on basic concepts of database systems, data modeling, relational data model, database language SQL, relational database design theory, physical data organization, and query processing.| Hiroyuki Kitagawa\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/ocw.tsukuba.ac.jp\/en\/course\/systeminformation\/database-systems-i\/\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/ocw.tsukuba.ac.jp\/en\/wp-content\/uploads\/2018\/04\/d45351da65f4e707c46f44c029d1be9f.png\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/ocw.tsukuba.ac.jp\/en\/wp-content\/uploads\/2018\/04\/d45351da65f4e707c46f44c029d1be9f.png\" \/>\n\t\t<meta property=\"og:image:width\" content=\"503\" \/>\n\t\t<meta property=\"og:image:height\" content=\"533\" \/>\n\t\t<meta property=\"article:tag\" content=\"hiroyuki kitagawa\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2018-04-18T03:36:48+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2022-11-04T05:56:45+00:00\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary\" \/>\n\t\t<meta name=\"twitter:title\" content=\"Database Systems I | TSUKUBA OCW | University of Tsukuba |\" \/>\n\t\t<meta name=\"twitter:description\" content=\"Introduction to database systems. Lectures on basic concepts of database systems, data modeling, relational data model, database language SQL, relational database design theory, physical data organization, and query processing.| Hiroyuki Kitagawa\" \/>\n\t\t<meta name=\"twitter:image\" content=\"https:\/\/ocw.tsukuba.ac.jp\/en\/wp-content\/uploads\/2018\/04\/d45351da65f4e707c46f44c029d1be9f.png\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/ocw.tsukuba.ac.jp\\\/en\\\/course\\\/systeminformation\\\/database-systems-i\\\/#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/ocw.tsukuba.ac.jp\\\/en#listItem\",\"position\":1,\"name\":\"\\u30db\\u30fc\\u30e0\",\"item\":\"https:\\\/\\\/ocw.tsukuba.ac.jp\\\/en\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/ocw.tsukuba.ac.jp\\\/en\\\/course\\\/#listItem\",\"name\":\"Courses\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/ocw.tsukuba.ac.jp\\\/en\\\/course\\\/#listItem\",\"position\":2,\"name\":\"Courses\",\"item\":\"https:\\\/\\\/ocw.tsukuba.ac.jp\\\/en\\\/course\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/ocw.tsukuba.ac.jp\\\/en\\\/course\\\/systeminformation\\\/#listItem\",\"name\":\"Information Science\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/ocw.tsukuba.ac.jp\\\/en#listItem\",\"name\":\"\\u30db\\u30fc\\u30e0\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/ocw.tsukuba.ac.jp\\\/en\\\/course\\\/systeminformation\\\/#listItem\",\"position\":3,\"name\":\"Information Science\",\"item\":\"https:\\\/\\\/ocw.tsukuba.ac.jp\\\/en\\\/course\\\/systeminformation\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/ocw.tsukuba.ac.jp\\\/en\\\/course\\\/systeminformation\\\/database-systems-i\\\/#listItem\",\"name\":\"Database Systems I\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/ocw.tsukuba.ac.jp\\\/en\\\/course\\\/#listItem\",\"name\":\"Courses\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/ocw.tsukuba.ac.jp\\\/en\\\/course\\\/systeminformation\\\/database-systems-i\\\/#listItem\",\"position\":4,\"name\":\"Database Systems I\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/ocw.tsukuba.ac.jp\\\/en\\\/course\\\/systeminformation\\\/#listItem\",\"name\":\"Information Science\"}}]},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/ocw.tsukuba.ac.jp\\\/en\\\/#organization\",\"name\":\"TSUKUBA OCW | University of Tsukuba\",\"description\":\"TSUKUBA OCW (Opencourseware) is a platform to establish a new interface between the university and society.\",\"url\":\"https:\\\/\\\/ocw.tsukuba.ac.jp\\\/en\\\/\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/ocw.tsukuba.ac.jp\\\/en\\\/course\\\/systeminformation\\\/database-systems-i\\\/#webpage\",\"url\":\"https:\\\/\\\/ocw.tsukuba.ac.jp\\\/en\\\/course\\\/systeminformation\\\/database-systems-i\\\/\",\"name\":\"Database Systems I | TSUKUBA OCW | University of Tsukuba |\",\"description\":\"Introduction to database systems. Lectures on basic concepts of database systems, data modeling, relational data model, database language SQL, relational database design theory, physical data organization, and query processing.| Hiroyuki Kitagawa\",\"inLanguage\":\"ja\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/ocw.tsukuba.ac.jp\\\/en\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/ocw.tsukuba.ac.jp\\\/en\\\/course\\\/systeminformation\\\/database-systems-i\\\/#breadcrumblist\"},\"datePublished\":\"2018-04-18T12:36:48+09:00\",\"dateModified\":\"2022-11-04T14:56:45+09:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/ocw.tsukuba.ac.jp\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/ocw.tsukuba.ac.jp\\\/en\\\/\",\"name\":\"TSUKUBA OCW | University of Tsukuba\",\"description\":\"TSUKUBA OCW (Opencourseware) is a platform to establish a new interface between the university and society.\",\"inLanguage\":\"ja\",\"publisher\":{\"@id\":\"https:\\\/\\\/ocw.tsukuba.ac.jp\\\/en\\\/#organization\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"Database Systems I | TSUKUBA OCW | University of Tsukuba |","description":"Introduction to database systems. Lectures on basic concepts of database systems, data modeling, relational data model, database language SQL, relational database design theory, physical data organization, and query processing.| Hiroyuki Kitagawa","canonical_url":"https:\/\/ocw.tsukuba.ac.jp\/en\/course\/systeminformation\/database-systems-i\/","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"BreadcrumbList","@id":"https:\/\/ocw.tsukuba.ac.jp\/en\/course\/systeminformation\/database-systems-i\/#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/ocw.tsukuba.ac.jp\/en#listItem","position":1,"name":"\u30db\u30fc\u30e0","item":"https:\/\/ocw.tsukuba.ac.jp\/en","nextItem":{"@type":"ListItem","@id":"https:\/\/ocw.tsukuba.ac.jp\/en\/course\/#listItem","name":"Courses"}},{"@type":"ListItem","@id":"https:\/\/ocw.tsukuba.ac.jp\/en\/course\/#listItem","position":2,"name":"Courses","item":"https:\/\/ocw.tsukuba.ac.jp\/en\/course\/","nextItem":{"@type":"ListItem","@id":"https:\/\/ocw.tsukuba.ac.jp\/en\/course\/systeminformation\/#listItem","name":"Information Science"},"previousItem":{"@type":"ListItem","@id":"https:\/\/ocw.tsukuba.ac.jp\/en#listItem","name":"\u30db\u30fc\u30e0"}},{"@type":"ListItem","@id":"https:\/\/ocw.tsukuba.ac.jp\/en\/course\/systeminformation\/#listItem","position":3,"name":"Information Science","item":"https:\/\/ocw.tsukuba.ac.jp\/en\/course\/systeminformation\/","nextItem":{"@type":"ListItem","@id":"https:\/\/ocw.tsukuba.ac.jp\/en\/course\/systeminformation\/database-systems-i\/#listItem","name":"Database Systems I"},"previousItem":{"@type":"ListItem","@id":"https:\/\/ocw.tsukuba.ac.jp\/en\/course\/#listItem","name":"Courses"}},{"@type":"ListItem","@id":"https:\/\/ocw.tsukuba.ac.jp\/en\/course\/systeminformation\/database-systems-i\/#listItem","position":4,"name":"Database Systems I","previousItem":{"@type":"ListItem","@id":"https:\/\/ocw.tsukuba.ac.jp\/en\/course\/systeminformation\/#listItem","name":"Information Science"}}]},{"@type":"Organization","@id":"https:\/\/ocw.tsukuba.ac.jp\/en\/#organization","name":"TSUKUBA OCW | University of Tsukuba","description":"TSUKUBA OCW (Opencourseware) is a platform to establish a new interface between the university and society.","url":"https:\/\/ocw.tsukuba.ac.jp\/en\/"},{"@type":"WebPage","@id":"https:\/\/ocw.tsukuba.ac.jp\/en\/course\/systeminformation\/database-systems-i\/#webpage","url":"https:\/\/ocw.tsukuba.ac.jp\/en\/course\/systeminformation\/database-systems-i\/","name":"Database Systems I | TSUKUBA OCW | University of Tsukuba |","description":"Introduction to database systems. Lectures on basic concepts of database systems, data modeling, relational data model, database language SQL, relational database design theory, physical data organization, and query processing.| Hiroyuki Kitagawa","inLanguage":"ja","isPartOf":{"@id":"https:\/\/ocw.tsukuba.ac.jp\/en\/#website"},"breadcrumb":{"@id":"https:\/\/ocw.tsukuba.ac.jp\/en\/course\/systeminformation\/database-systems-i\/#breadcrumblist"},"datePublished":"2018-04-18T12:36:48+09:00","dateModified":"2022-11-04T14:56:45+09:00"},{"@type":"WebSite","@id":"https:\/\/ocw.tsukuba.ac.jp\/en\/#website","url":"https:\/\/ocw.tsukuba.ac.jp\/en\/","name":"TSUKUBA OCW | University of Tsukuba","description":"TSUKUBA OCW (Opencourseware) is a platform to establish a new interface between the university and society.","inLanguage":"ja","publisher":{"@id":"https:\/\/ocw.tsukuba.ac.jp\/en\/#organization"}}]},"og:locale":"ja_JP","og:site_name":"TSUKUBA OCW | University of Tsukuba | TSUKUBA OCW (Opencourseware) is a platform to establish a new interface between the university and society.","og:type":"article","og:title":"Database Systems I | TSUKUBA OCW | University of Tsukuba |","og:description":"Introduction to database systems. Lectures on basic concepts of database systems, data modeling, relational data model, database language SQL, relational database design theory, physical data organization, and query processing.| Hiroyuki Kitagawa","og:url":"https:\/\/ocw.tsukuba.ac.jp\/en\/course\/systeminformation\/database-systems-i\/","og:image":"https:\/\/ocw.tsukuba.ac.jp\/en\/wp-content\/uploads\/2018\/04\/d45351da65f4e707c46f44c029d1be9f.png","og:image:secure_url":"https:\/\/ocw.tsukuba.ac.jp\/en\/wp-content\/uploads\/2018\/04\/d45351da65f4e707c46f44c029d1be9f.png","og:image:width":503,"og:image:height":533,"article:tag":["hiroyuki kitagawa"],"article:published_time":"2018-04-18T03:36:48+00:00","article:modified_time":"2022-11-04T05:56:45+00:00","twitter:card":"summary","twitter:title":"Database Systems I | TSUKUBA OCW | University of Tsukuba |","twitter:description":"Introduction to database systems. Lectures on basic concepts of database systems, data modeling, relational data model, database language SQL, relational database design theory, physical data organization, and query processing.| Hiroyuki Kitagawa","twitter:image":"https:\/\/ocw.tsukuba.ac.jp\/en\/wp-content\/uploads\/2018\/04\/d45351da65f4e707c46f44c029d1be9f.png"},"aioseo_meta_data":{"post_id":"7445","title":"#post_title | #site_title #separator_sa","description":"Introduction to database systems. Lectures on basic concepts of database systems, data modeling, relational data model, database language SQL, relational database design theory, physical data organization, and query processing.#separator_sa Hiroyuki Kitagawa","keywords":[],"keyphrases":{"focus":{"keyphrase":"Hiroyuki Kitagawa","score":69,"analysis":{"keyphraseInTitle":{"title":"Focus keyphrase in SEO title","description":"Focus keyphrase not found in SEO title.","score":3,"maxScore":9,"error":1},"keyphraseInDescription":{"title":"Focus keyphrase in meta description","description":"Focus keyphrase found in meta description.","score":9,"maxScore":9,"error":0},"keyphraseLength":{"title":"Focus keyphrase length","description":"Good job!","score":9,"maxScore":9,"error":0,"length":2},"keyphraseInURL":{"title":"Focus keyphrase in URL","description":"Focus keyphrase not found in the URL.","score":1,"maxScore":5,"error":1}}},"additional":[]},"primary_term":null,"canonical_url":null,"og_title":null,"og_description":"Introduction to database systems. Lectures on basic concepts of database systems, data modeling, relational data model, database language SQL, relational database design theory, physical data organization, and query processing.#separator_sa Hiroyuki Kitagawa","og_object_type":"default","og_image_type":"custom_image","og_image_url":"http:\/\/ocw.tsukuba.ac.jp\/en\/wp-content\/uploads\/2018\/04\/d45351da65f4e707c46f44c029d1be9f.png","og_image_width":"503","og_image_height":"533","og_image_custom_url":"http:\/\/ocw.tsukuba.ac.jp\/en\/wp-content\/uploads\/2018\/04\/d45351da65f4e707c46f44c029d1be9f.png","og_image_custom_fields":null,"og_video":"","og_custom_url":null,"og_article_section":null,"og_article_tags":[{"label":"Hiroyuki Kitagawa","value":"Hiroyuki Kitagawa"}],"twitter_use_og":true,"twitter_card":"summary","twitter_image_type":"custom_image","twitter_image_url":null,"twitter_image_custom_url":"http:\/\/ocw.tsukuba.ac.jp\/en\/wp-content\/uploads\/2018\/04\/d45351da65f4e707c46f44c029d1be9f.png","twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"WebPage","isEnabled":true},"graphs":[]},"schema_type":null,"schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":"-1","robots_max_videopreview":"-1","robots_max_imagepreview":"large","priority":null,"frequency":"default","local_seo":null,"breadcrumb_settings":null,"limit_modified_date":false,"ai":null,"created":"2021-06-29 00:52:58","updated":"2025-06-17 08:30:41","seo_analyzer_scan_date":null},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/ocw.tsukuba.ac.jp\/en\" title=\"\u30db\u30fc\u30e0\">\u30db\u30fc\u30e0<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/ocw.tsukuba.ac.jp\/en\/course\/\" title=\"Courses\">Courses<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/ocw.tsukuba.ac.jp\/en\/course\/systeminformation\/\" title=\"Information Science\">Information Science<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tDatabase Systems I\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"\u30db\u30fc\u30e0","link":"https:\/\/ocw.tsukuba.ac.jp\/en"},{"label":"Courses","link":"https:\/\/ocw.tsukuba.ac.jp\/en\/course\/"},{"label":"Information Science","link":"https:\/\/ocw.tsukuba.ac.jp\/en\/course\/systeminformation\/"},{"label":"Database Systems I","link":"https:\/\/ocw.tsukuba.ac.jp\/en\/course\/systeminformation\/database-systems-i\/"}],"_links":{"self":[{"href":"https:\/\/ocw.tsukuba.ac.jp\/en\/wp-json\/wp\/v2\/pages\/7445","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ocw.tsukuba.ac.jp\/en\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/ocw.tsukuba.ac.jp\/en\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/ocw.tsukuba.ac.jp\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/ocw.tsukuba.ac.jp\/en\/wp-json\/wp\/v2\/comments?post=7445"}],"version-history":[{"count":9,"href":"https:\/\/ocw.tsukuba.ac.jp\/en\/wp-json\/wp\/v2\/pages\/7445\/revisions"}],"predecessor-version":[{"id":7797,"href":"https:\/\/ocw.tsukuba.ac.jp\/en\/wp-json\/wp\/v2\/pages\/7445\/revisions\/7797"}],"up":[{"embeddable":true,"href":"https:\/\/ocw.tsukuba.ac.jp\/en\/wp-json\/wp\/v2\/pages\/3565"}],"wp:attachment":[{"href":"https:\/\/ocw.tsukuba.ac.jp\/en\/wp-json\/wp\/v2\/media?parent=7445"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}