{"id":16,"date":"2007-05-23T06:04:16","date_gmt":"2007-05-23T06:04:16","guid":{"rendered":"http:\/\/apollo89.com\/wordpress\/?p=16"},"modified":"2013-02-21T12:16:40","modified_gmt":"2013-02-21T03:16:40","slug":"%e2%97%88-materialized-view%eb%9e%80","status":"publish","type":"post","link":"https:\/\/apollo89.com\/wordpress\/?p=16","title":{"rendered":"Materialized View\ub780"},"content":{"rendered":"<p>&nbsp;<\/p>\n<p>Materialized View\ub780<\/p>\n<p>Materialized View(\uc774\ud558 MView\ub85c \ud45c\uc2dc) \uc774\uac83\uc740 \uc81c\ubaa9 \uadf8\ub300\ub85c View \uc785\ub2c8\ub2e4.<\/p>\n<p>\ud558\uc9c0\ub9cc \uc77c\ubc18 View\ub294 \ub17c\ub9ac\uc801\uc778 \ud14c\uc774\ube14\uc774\uace0, MView\ub294 \ubb3c\ub9ac\uc801\uc73c\ub85c \uc874\uc7ac\ud558\ub294 \ud14c\uc774\ube14 \uc785\ub2c8\ub2e4.<br \/>\n\ubb3c\ub9ac\uc801\uc73c\ub85c \uc874\uc7ac\ud55c\ub2e4\ub294 \uac83\uc740 Data\uac00 \uc77c\uc815 \uacf5\uac04\uc744 \ucc28\uc9c0\ud558\uace0 \uc788\ub2e4\ub294 \uac70\uc8e0..<\/p>\n<p>MView\ub294 \uc5b4\ub5a4 \uacb0\uacfc\ub97c \ubf51\uc544 \ub0b4\ub294 \ucffc\ub9ac\uac00 \ub108\ubb34\ub098\ub3c4 \ube48\ubc88\ud788 \uc0ac\uc6a9 \ub420 \uacbd\uc6b0, Query \uc2e4\ud589 \uc2dc\uac04\uc758 \uc218\ud589\uc18d\ub3c4 \ud5a5\uc0c1\uc744\uc704\ud558\uc5ec , \uc5ec\ub7ec \uac00\uc9c0\uc758 Aggregate View\ub97c \ub450\uc5b4, \ubbf8\ub9ac \ube44\uc6a9\uc774 \ub9ce\uc774 \ub4dc\ub294 \uc870\uc778\uc774\ub098, Aggregate Operation \uc744 \ucc98\ub9ac\ud558\uc5ec\uc57c \ud558\ub294 SQL\uc744 \uc704\ud574, \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \ud55c \ud14c\uc774\ube14\ub85c \uc800\uc7a5 \ud558\uba70, \uadf8 \ud14c\uc774\ube14\uc744 \uc870\ud68c \ud558\ub3c4\ub85d \ud558\ub294 \uac83 \uc785\ub2c8\ub2e4.<\/p>\n<p>\uac04\ub2e8\ud558\uac8c \uc124\uba85\ud558\uba74 \ub300\uc6a9\ub7c9\uc758 \ub370\uc774\ud130\ub97c SUM, MIN, MAX, AVG, COUNT(*)\uc774\ub7f0 \uba85\ub839\uc5b4\ub97c \uc0ac\uc6a9\ud574 \ub108\ubb34\ub098\ub3c4 \uc790\uc8fc \uc870\ud68c\ud558\ub294 Query\ub97c \uc218\ud589\uc18d\ub3c4\ub97c \ud5a5\uc0c1\uc744 \uc704\ud574\uc11c, Query\uc758 \uacb0\uacfc \ub9cc\ud07c\uc758 \uc0c8\ub85c\uc6b4 \ud14c\uc774\ube14\uc744 \uc0dd\uc131\ud574 \ub193\ub294 \ubc99\ubc95 \uc785\ub2c8\ub2e4.<\/p>\n<p>\uc790\uc8fc\uc0ac\uc6a9\ub418\ub294 View\uc758 \uacb0\uacfc\ub97c \ub514\uc2a4\ud06c\uc5d0 \uc800\uc7a5\ud574\uc11c Query \uc18d\ub3c4\ub97c \ud5a5\uc0c1\uc2dc\ud0a4\ub294 \uac1c\ub150 \uc774\uc8e0.<\/p>\n<p>Materialized View\uc758 \ud2b9\uc9d5<br \/>\n&#8211; MView\ub97c \ub9cc\ub4e4\uc5b4\ub450\uba74 QUERY\uc758 \uc218\ud589\uc18d\ub3c4\ub97c \uc99d\uac00 \uc2dc\ud0ac \uc218 \uc788\uc2b5\ub2c8\ub2e4.<br \/>\n&#8211; SQL \uc751\uc6a9\ud504\ub85c\uadf8\ub7a8\uc5d0\uc11c MView \uc0ac\uc6a9\uc2dc DBA\ub294 \ud504\ub85c\uadf8\ub7a8\uc5d0 \uc601\ud5a5\uc744 \ub07c\uce58\uc9c0 \uc54a\uace0 \uc5b8\uc81c\ub4e0\uc9c0 \uc0dd\uc131 \ubc0f \uc81c\uac70\uac00 \uac00\ub2a5 \ud569\ub2c8\ub2e4.<br \/>\n&#8211; MView\ub294 \uc2e4\ud589\uc758 \uacb0\uacfc \ud589\uacfc \ubdf0 \uc815\uc758 \ubaa8\ub450 \uc800\uc7a5\uc774 \ub418\uace0, \uc2e4\ud589 \uacb0\uacfc \ud589\uc73c\ub85c \ub9cc\ub4e4\uc5b4\uc9c4 \ud14c\uc774\ube14\uc740 \uc77c\uc815 \uacf5\uac04\uc744 \ucc28\uc9c0 \ud569\ub2c8\ub2e4.<br \/>\n&#8211; MView\uad00\ub828 \uae30\ucd08 \ud14c\uc774\ube14\uc744 \ubcc0\uacbd\ud558\uba74, MView\ub85c \uc0dd\uc131\ub41c Summary \ud14c\uc774\ube14\ub3c4 \ubcc0\uacbd \ub418\uc5b4 \uc9d1\ub2c8\ub2e4.<\/p>\n<p>Materialized View\uc640 \uc77c\ubc18 View\uc758 \ucc28\uc774\uc810<br \/>\n&#8211; \uac00\uc7a5 \ud070 \ucc28\uc774\uc810\uc740 MView\uc758 \uacb0\uacfc\uac12\uc740 \ubb3c\ub9ac\uc801\uc73c\ub85c \uc874\uc7ac\ud558\ub294 \uac83\uc774\uace0, \uc77c\ubc18 View\uc758 \uacb0\uacfc\uac12\uc740 \ubb3c\ub9ac\uc801\uc73c\ub85c \uc874\uc7ac\ud558\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.<br \/>\n  \uc989 SELECT * FROM USER_SEGMENTS \ud558\uba74 MView\ub294 \ub098\uc624\uc9c0\ub9cc \uc77c\ubc18 View\ub294 \ub098\uc624\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.<br \/>\n&#8211; MView\ub294 MView\ub97c \uc0dd\uc131\ud560\ub54c\uc758 Query\ub85c \ubb3c\ub9ac\uc801\uc73c\ub85c \uc774\ubbf8 \ub370\uc774\ud0c0\uac00 \uc0dd\uc131\ub418\uc5b4 \uc788\uae30 \ub54c\ubb38\uc5d0 \uc870\ud68c \uc18d\ub3c4\uac00 \ube60\ub985\ub2c8\ub2e4.<br \/>\n  \ud558\uc9c0\ub9cc View\ub294 \ub2e8\uc9c0 \ucffc\ub9ac\uc815\ubcf4\uac00 \ub515\uc154\ub108\ub9ac\uc5d0 \uc800\uc7a5\ub418\uc5b4 \uc788\uace0 \uc0ac\uc6a9\ub420\ub54c \uadf8 SQL\uc774 \ub2e4\uc2dc \uc2e4\ud589\ub418\ub294 \uac83\uc774\uae30 \ub54c\ubb38\uc5d0 MView\ubcf4\ub2e4 \ub290\ub9bd\ub2c8\ub2e4.<\/p>\n<p>MView\ub85c \uc0dd\uc131\ub41c \uacb0\uacfc\uac12\uc774 \uc77c\ubc18 View\ub85c \uc870\ud68c\ud558\ub294 Data\uc758 \uacb0\uacfc\uac12 \ubcf4\ub2e4 \ud6e8\uc52c \uc801\uc740 Row\ub97c \uc870\ud68c\ud558\uac8c \ub418\uc8e0.<\/p>\n<p>MView \uad00\ub828 \ud30c\ub77c\ubbf8\ud130<br \/>\n&#8211; OPTIMIZER_MODE<br \/>\n  MView\ub97c \uc0ac\uc6a9\ud558\uae30 \uc704\ud574\uc11c\ub294 Cost-Based \uc635\ud2f0\ub9c8\uc774\uc838 \uc5ec\uc57c \ud558\ubbc0\ub85c ALL_ROWS, CHOOSE, \ud639\uc740 FIRST_ROWS \uc911\uc758 \uc5b4\ub290 \ud558\ub098\ub97c \uc0ac\uc6a9 \ud569\ub2c8\ub2e4.<br \/>\n  &#8220;CHOOSE&#8221;\uc778 \uc0c1\ud0dc\uc5d0\uc11c\ub294 \ubaa8\ub4e0 \ud14c\uc774\ube14\uc744 ANALYZE \uc2dc\ucf1c \uc918\uc57c \ud569\ub2c8\ub2e4.<br \/>\n&#8211; QUERY_REWRITE_ENABLED : Query Rewrite \uc0ac\uc6a9\uc744 \uc704\ud574\uc11c\ub294 TRUE\ub85c \uc124\uc815\ud558\uba74 \ub429\ub2c8\ub2e4.<br \/>\n&#8211; QUERY_REWRITE_INTEGRITY : \uc624\ub77c\ud074\uc774 Query Rewrite\uc758 \uc815\ud655\uc131\uc744 \uc81c\uc5b4\ud558\ub294 \ud30c\ub77c\ubbf8\ud130\ub85c, &#8220;STALE_TOLERATED&#8221;, &#8220;TRUSTED&#8221;, &#8220;ENFORCED&#8221; \ub85c \uc9c0\uc815\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<br \/>\n  * STALE_TOLERATED : \uc0ac\uc6a9\ub418\uc5b4\uc9c4 \uae30\ucd08\ud14c\uc774\ube14\uacfc Consistent \ud558\uc9c0 \uc54a\uc740 View\ub97c \uc774\uc6a9\ud55c Query Rewrite\ub97c \ud5c8\uc6a9 \ud569\ub2c8\ub2e4<br \/>\n  * TRUSTED : Optimizer\uc5d0\uc11c MView\uc758 \ub370\uc774\ud130\uac00 \uc815\ud655\ud558\ub2e4\uace0 \uac04\uc8fc\ud558\uace0 \uc9c8\uc758 \uc218\ud589. Integrity \ud655\uc778\uc744 \ud558\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.<br \/>\n  * ENFORCED: QUERY_REWRITE_INTEGRITY \uc758 \uae30\ubcf8\uac12\uc73c\ub85c, \uc0ac\uc6a9\uc790\uac00 Integrity Constraint\ub97c \ud655\uc778\ud558\uc5ec\uc57c \ud569\ub2c8\ub2e4.<br \/>\n&#8211; COMPATIBLE : \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 \uc624\ub77c\ud074 \ud568\uc218\ub4e4\uc758 Compatibility\ub97c \uacb0\uc815\ud558\ub294 \uac12\uc73c\ub85c 8.1.0 \ub610\ub294 \uadf8 \uc774\uc0c1\uc73c\ub85c \uc124\uc815 \ud574\uc57c \ud569\ub2c8\ub2e4.<\/p>\n<p>\ucc38\uace0<br \/>\n&#8211; Oracle Technical Note Materialized View \uae00 \/ \ubc15\uacbd\ud76c<br \/>\n&#8211; Oracle Technical Bulletins No.12181 MATERIALIZED VIEW \ud65c\uc6a9\ubc29\ubc95<br \/>\n&#8211; Oracle 8i Tuning \uc815\uc2dd \uad50\uc7ac<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; Materialized View\ub780 Materialized View(\uc774\ud558 MView\ub85c \ud45c\uc2dc) \uc774\uac83\uc740 \uc81c\ubaa9 \uadf8\ub300\ub85c View \uc785\ub2c8\ub2e4. \ud558\uc9c0\ub9cc \uc77c\ubc18 View\ub294 \ub17c\ub9ac\uc801\uc778 \ud14c\uc774\ube14\uc774\uace0, MView\ub294 \ubb3c\ub9ac\uc801\uc73c\ub85c \uc874\uc7ac\ud558\ub294 \ud14c\uc774\ube14 \uc785\ub2c8\ub2e4. \ubb3c\ub9ac\uc801\uc73c\ub85c \uc874\uc7ac\ud55c\ub2e4\ub294 \uac83\uc740 Data\uac00 \uc77c\uc815 \uacf5\uac04\uc744 \ucc28\uc9c0\ud558\uace0 \uc788\ub2e4\ub294 \uac70\uc8e0.. MView\ub294 \uc5b4\ub5a4 \uacb0\uacfc\ub97c \ubf51\uc544 \ub0b4\ub294 \ucffc\ub9ac\uac00 \ub108\ubb34\ub098\ub3c4 \ube48\ubc88\ud788 \uc0ac\uc6a9 &hellip; <a href=\"https:\/\/apollo89.com\/wordpress\/?p=16\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[685],"tags":[24,63],"class_list":["post-16","post","type-post","status-publish","format-standard","hentry","category-database-","tag-materialized-view","tag-oracle"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Materialized View\ub780 - Apollo89.com<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/apollo89.com\/wordpress\/?p=16\" \/>\n<meta property=\"og:locale\" content=\"ko_KR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Materialized View\ub780 - Apollo89.com\" \/>\n<meta property=\"og:description\" content=\"&nbsp; Materialized View\ub780 Materialized View(\uc774\ud558 MView\ub85c \ud45c\uc2dc) \uc774\uac83\uc740 \uc81c\ubaa9 \uadf8\ub300\ub85c View \uc785\ub2c8\ub2e4. \ud558\uc9c0\ub9cc \uc77c\ubc18 View\ub294 \ub17c\ub9ac\uc801\uc778 \ud14c\uc774\ube14\uc774\uace0, MView\ub294 \ubb3c\ub9ac\uc801\uc73c\ub85c \uc874\uc7ac\ud558\ub294 \ud14c\uc774\ube14 \uc785\ub2c8\ub2e4. \ubb3c\ub9ac\uc801\uc73c\ub85c \uc874\uc7ac\ud55c\ub2e4\ub294 \uac83\uc740 Data\uac00 \uc77c\uc815 \uacf5\uac04\uc744 \ucc28\uc9c0\ud558\uace0 \uc788\ub2e4\ub294 \uac70\uc8e0.. MView\ub294 \uc5b4\ub5a4 \uacb0\uacfc\ub97c \ubf51\uc544 \ub0b4\ub294 \ucffc\ub9ac\uac00 \ub108\ubb34\ub098\ub3c4 \ube48\ubc88\ud788 \uc0ac\uc6a9 &hellip; Continue reading &rarr;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/apollo89.com\/wordpress\/?p=16\" \/>\n<meta property=\"og:site_name\" content=\"Apollo89.com\" \/>\n<meta property=\"article:published_time\" content=\"2007-05-23T06:04:16+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2013-02-21T03:16:40+00:00\" \/>\n<meta name=\"author\" content=\"apollo89\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\uae00\uc4f4\uc774\" \/>\n\t<meta name=\"twitter:data1\" content=\"apollo89\" \/>\n\t<meta name=\"twitter:label2\" content=\"\uc608\uc0c1 \ub418\ub294 \ud310\ub3c5 \uc2dc\uac04\" \/>\n\t<meta name=\"twitter:data2\" content=\"1\ubd84\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/apollo89.com\\\/wordpress\\\/?p=16#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/apollo89.com\\\/wordpress\\\/?p=16\"},\"author\":{\"name\":\"apollo89\",\"@id\":\"https:\\\/\\\/apollo89.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/93f56825cac3b2f18e5f107995066c82\"},\"headline\":\"Materialized View\ub780\",\"datePublished\":\"2007-05-23T06:04:16+00:00\",\"dateModified\":\"2013-02-21T03:16:40+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/apollo89.com\\\/wordpress\\\/?p=16\"},\"wordCount\":133,\"commentCount\":0,\"keywords\":[\"Materialized View\",\"\uc624\ub77c\ud074\"],\"articleSection\":[\"Database\"],\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/apollo89.com\\\/wordpress\\\/?p=16#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/apollo89.com\\\/wordpress\\\/?p=16\",\"url\":\"https:\\\/\\\/apollo89.com\\\/wordpress\\\/?p=16\",\"name\":\"Materialized View\ub780 - Apollo89.com\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/apollo89.com\\\/wordpress\\\/#website\"},\"datePublished\":\"2007-05-23T06:04:16+00:00\",\"dateModified\":\"2013-02-21T03:16:40+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/apollo89.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/93f56825cac3b2f18e5f107995066c82\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/apollo89.com\\\/wordpress\\\/?p=16#breadcrumb\"},\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/apollo89.com\\\/wordpress\\\/?p=16\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/apollo89.com\\\/wordpress\\\/?p=16#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\ud648\",\"item\":\"https:\\\/\\\/apollo89.com\\\/wordpress\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Materialized View\ub780\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/apollo89.com\\\/wordpress\\\/#website\",\"url\":\"https:\\\/\\\/apollo89.com\\\/wordpress\\\/\",\"name\":\"Apollo89.com\",\"description\":\"\uc544\ud3f4\ub85c\uc528\uc758 \uc7a1\ub2e4\ud55c \uacbd\ud5d8\ub4e4..\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/apollo89.com\\\/wordpress\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ko-KR\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/apollo89.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/93f56825cac3b2f18e5f107995066c82\",\"name\":\"apollo89\",\"description\":\"\uc544\ud3f4\ub85c89 \uc785\ub2c8\ub2e4.\",\"url\":\"https:\\\/\\\/apollo89.com\\\/wordpress\\\/?author=1\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Materialized View\ub780 - Apollo89.com","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:\/\/apollo89.com\/wordpress\/?p=16","og_locale":"ko_KR","og_type":"article","og_title":"Materialized View\ub780 - Apollo89.com","og_description":"&nbsp; Materialized View\ub780 Materialized View(\uc774\ud558 MView\ub85c \ud45c\uc2dc) \uc774\uac83\uc740 \uc81c\ubaa9 \uadf8\ub300\ub85c View \uc785\ub2c8\ub2e4. \ud558\uc9c0\ub9cc \uc77c\ubc18 View\ub294 \ub17c\ub9ac\uc801\uc778 \ud14c\uc774\ube14\uc774\uace0, MView\ub294 \ubb3c\ub9ac\uc801\uc73c\ub85c \uc874\uc7ac\ud558\ub294 \ud14c\uc774\ube14 \uc785\ub2c8\ub2e4. \ubb3c\ub9ac\uc801\uc73c\ub85c \uc874\uc7ac\ud55c\ub2e4\ub294 \uac83\uc740 Data\uac00 \uc77c\uc815 \uacf5\uac04\uc744 \ucc28\uc9c0\ud558\uace0 \uc788\ub2e4\ub294 \uac70\uc8e0.. MView\ub294 \uc5b4\ub5a4 \uacb0\uacfc\ub97c \ubf51\uc544 \ub0b4\ub294 \ucffc\ub9ac\uac00 \ub108\ubb34\ub098\ub3c4 \ube48\ubc88\ud788 \uc0ac\uc6a9 &hellip; Continue reading &rarr;","og_url":"https:\/\/apollo89.com\/wordpress\/?p=16","og_site_name":"Apollo89.com","article_published_time":"2007-05-23T06:04:16+00:00","article_modified_time":"2013-02-21T03:16:40+00:00","author":"apollo89","twitter_card":"summary_large_image","twitter_misc":{"\uae00\uc4f4\uc774":"apollo89","\uc608\uc0c1 \ub418\ub294 \ud310\ub3c5 \uc2dc\uac04":"1\ubd84"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/apollo89.com\/wordpress\/?p=16#article","isPartOf":{"@id":"https:\/\/apollo89.com\/wordpress\/?p=16"},"author":{"name":"apollo89","@id":"https:\/\/apollo89.com\/wordpress\/#\/schema\/person\/93f56825cac3b2f18e5f107995066c82"},"headline":"Materialized View\ub780","datePublished":"2007-05-23T06:04:16+00:00","dateModified":"2013-02-21T03:16:40+00:00","mainEntityOfPage":{"@id":"https:\/\/apollo89.com\/wordpress\/?p=16"},"wordCount":133,"commentCount":0,"keywords":["Materialized View","\uc624\ub77c\ud074"],"articleSection":["Database"],"inLanguage":"ko-KR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/apollo89.com\/wordpress\/?p=16#respond"]}]},{"@type":"WebPage","@id":"https:\/\/apollo89.com\/wordpress\/?p=16","url":"https:\/\/apollo89.com\/wordpress\/?p=16","name":"Materialized View\ub780 - Apollo89.com","isPartOf":{"@id":"https:\/\/apollo89.com\/wordpress\/#website"},"datePublished":"2007-05-23T06:04:16+00:00","dateModified":"2013-02-21T03:16:40+00:00","author":{"@id":"https:\/\/apollo89.com\/wordpress\/#\/schema\/person\/93f56825cac3b2f18e5f107995066c82"},"breadcrumb":{"@id":"https:\/\/apollo89.com\/wordpress\/?p=16#breadcrumb"},"inLanguage":"ko-KR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/apollo89.com\/wordpress\/?p=16"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/apollo89.com\/wordpress\/?p=16#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\ud648","item":"https:\/\/apollo89.com\/wordpress"},{"@type":"ListItem","position":2,"name":"Materialized View\ub780"}]},{"@type":"WebSite","@id":"https:\/\/apollo89.com\/wordpress\/#website","url":"https:\/\/apollo89.com\/wordpress\/","name":"Apollo89.com","description":"\uc544\ud3f4\ub85c\uc528\uc758 \uc7a1\ub2e4\ud55c \uacbd\ud5d8\ub4e4..","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/apollo89.com\/wordpress\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ko-KR"},{"@type":"Person","@id":"https:\/\/apollo89.com\/wordpress\/#\/schema\/person\/93f56825cac3b2f18e5f107995066c82","name":"apollo89","description":"\uc544\ud3f4\ub85c89 \uc785\ub2c8\ub2e4.","url":"https:\/\/apollo89.com\/wordpress\/?author=1"}]}},"_links":{"self":[{"href":"https:\/\/apollo89.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/16","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/apollo89.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/apollo89.com\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/apollo89.com\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/apollo89.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=16"}],"version-history":[{"count":0,"href":"https:\/\/apollo89.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/16\/revisions"}],"wp:attachment":[{"href":"https:\/\/apollo89.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=16"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/apollo89.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=16"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/apollo89.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=16"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}