{"id":2214,"date":"2016-04-07T01:59:43","date_gmt":"2016-04-07T01:59:42","guid":{"rendered":"https:\/\/www.couchbase.com\/blog\/?p=2214"},"modified":"2023-03-21T15:53:18","modified_gmt":"2023-03-21T22:53:18","slug":"detecting-expirations-of-documents-with-couchbase-server-and-n1ql","status":"publish","type":"post","link":"https:\/\/www.couchbase.com\/blog\/ko\/detecting-expirations-of-documents-with-couchbase-server-and-n1ql\/","title":{"rendered":"\uce74\uc6b0\uce58\ubca0\uc774\uc2a4 \uc11c\ubc84 \ubc0f N1QL\ub85c \ub9cc\ub8cc\uac00 \ubc1c\uc0dd\ud558\uae30 \uc804\uc5d0 \uac10\uc9c0\ud558\uae30"},"content":{"rendered":"<table border=\"0\" cellspacing=\"1\" cellpadding=\"1\">\n<tbody>\n<tr>\n<td>\ubb38\uc11c \uc790\ub3d9 \ub9cc\ub8cc \uae30\ub2a5\uc774 \uc644\ubcbd\ud558\uac8c \uc791\ub3d9\ud558\ub294 \uc0ac\uc6a9 \uc0ac\ub840\ub294 \ub9ce\uc2b5\ub2c8\ub2e4. \uc138\uc158 \uc0c1\ud0dc, \uc7a5\ubc14\uad6c\ub2c8, \uc5ec\ud589 \uac00\uaca9 \uacac\uc801 \ub4f1\uc744 \uc720\uc9c0 \uad00\ub9ac\ud569\ub2c8\ub2e4. \uc774\ub7ec\ud55c \ubaa8\ub4e0 \uacbd\uc6b0\uc5d0 Couchbase Server\ub97c \uc0ac\uc6a9\ud558\ub294 \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc740 \ub9cc\ub8cc \uc2dc\uac04\uc744 \ucd08, \ubd84 \ub610\ub294 \uc2dc\uac04\uc73c\ub85c \uc124\uc815\ud558\uc5ec \uc0ac\uc6a9\uc790 \ud589\ub3d9\uc744 \uad00\ub9ac\ud569\ub2c8\ub2e4.<\/p>\n<p>\ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \ub9cc\ub8cc\uc77c\uc774 \uc788\ub294 \ud56d\ubaa9\uc758 \uacbd\uc6b0, Couchbase Server\uc5d0\ub294 \uc9c0\uc815\ub41c \ub9cc\ub8cc \uc2dc\uac04\uc5d0 \ub370\uc774\ud130\uac00 \uc0ac\ub77c\uc9c0\ub3c4\ub85d \ud558\ub294 \uc778\ud154\ub9ac\uc804\uc2a4\uac00 \ub0b4\uc7a5\ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4. \ub2e4\uc74c\uc5d0 \ub300\ud55c \ubaa8\ub4e0 \uc815\ubcf4\ub97c \ucc3e\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4.\u00a0<a href=\"https:\/\/www.couchbase.com\/blog\/ko\/how-to-manage-ttl-with-couchbase-n1ql\/\">TTL<\/a> \ubc0f \ub9cc\ub8cc\ub294 Couchbase Server \ubb38\uc11c\uc5d0\uc11c \ud655\uc778\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\ub9cc\ub8cc\uac00 \uc788\ub294 \ub300\ubd80\ubd84\uc758 \uc2dc\uc2a4\ud15c\uc5d0\ub294 \ub9cc\ub8cc\ub418\ub294 \ub370\uc774\ud130\ub97c \uac31\uc2e0\ud558\uac70\ub098 \uc77c\ub828\uc758 \ubb38\uc11c\uac00 \uace7 \ub9cc\ub8cc\ub420 \uac83\uc784\uc744 \ub2e4\uc6b4\uc2a4\ud2b8\ub9bc \uc2dc\uc2a4\ud15c\uc5d0 \uc54c\ub9ac\ub824\ub294 \uc0ac\uc6a9 \uc0ac\ub840\ub3c4 \ud568\uaed8 \uc81c\uacf5\ub429\ub2c8\ub2e4. \ub9cc\ub8cc\ub418\ub294 \ub370\uc774\ud130\uc758 \uac31\uc2e0 \ub610\ub294 \uc54c\ub9bc\uc5d0\ub294 \uc77c\ubc18\uc801\uc73c\ub85c \uc608\uc815\ub41c \ubb38\uc11c \ub9cc\ub8cc\ub97c \ud655\uc778\ud558\ub294 \ud504\ub85c\uc138\uc2a4\uac00 \ud3ec\ud568\ub429\ub2c8\ub2e4. \uae00\ub85c\ubc8c \uc778\ub371\uc2a4\uc640 N1QL\uc774 \ucd94\uac00\ub418\uba74\uc11c \uc774 \uc815\ubcf4\ub97c \ucffc\ub9ac\ud558\ub294 \uc18d\ub3c4\uac00 \ud6e8\uc52c \ube68\ub77c\uc84c\uc2b5\ub2c8\ub2e4.<\/td>\n<td style=\"width: 233px\">\n<p style=\"text-align: center\"><img loading=\"lazy\" decoding=\"async\" src=\"\/wp-content\/original-assets\/2016\/april\/detecting-expirations-of-documents-with-couchbase-server-and-n1ql\/clock-expired-time-300x253.jpg\" width=\"193\" height=\"162\" \/><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\uacfc\uac70\uc5d0\ub294 \uc774 \uc815\ubcf4\ub97c \ub9f5\/\ucd95\uc18c \ubcf4\uae30\uc5d0\uc11c \uc778\ub371\uc2f1\ud560 \uc218 \uc788\uc5c8\uc2b5\ub2c8\ub2e4. \ub9f5\/\ucd95\uc18c \ubcf4\uae30\uac00 \uac15\ub825\ud55c \uc778\ub371\uc2f1\uc744 \uc81c\uacf5\ud560 \uc218 \uc788\uc9c0\ub9cc, \ubd84\uc0b0 \uc218\uc9d1\uc73c\ub85c \uc778\ud574 \uae00\ub85c\ubc8c \uc778\ub371\uc2a4\uac00 \uc720\ub9ac\ud569\ub2c8\ub2e4.<\/p>\n<p style=\"margin-left: 40px\"><em>\uadf8 \uc774\uc720\ub294 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4: \uae00\ub85c\ubc8c \uc778\ub371\uc2a4\ub294 \ub370\uc774\ud130\uc640 \ub3c5\ub9bd\uc801\uc73c\ub85c \ud30c\ud2f0\uc158\uc744 \ubd84\ud560\ud569\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, \ub370\uc774\ud130\uac00 20\uac1c\uc758 \ub178\ub4dc\uc5d0 \ubd84\uc0b0\ub418\uc5b4 \uc788\ub354\ub77c\ub3c4 \uc778\ub371\uc2a4\uac00 \ub2e8\uc77c \ub178\ub4dc\uc5d0 \ub9de\ub294\ub2e4\uba74 \uae00\ub85c\ubc8c \uc778\ub371\uc2a4\ub294 \ub2e8\uc77c \ub178\ub4dc\uc5d0 \uc0c1\uc8fc\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub610\ud55c \uce74\uc6b0\uce58\ubca0\uc774\uc2a4 \uc11c\ubc84\uc5d0\uc11c \uc778\ub371\uc2a4\uc640 \ub370\uc774\ud130 \ub178\ub4dc\uc5d0 \ub3d9\uc77c\ud55c HW\ub97c \uc120\ud0dd\ud560 \ud544\uc694\ub3c4 \uc5c6\uc2b5\ub2c8\ub2e4. \uc989, \uc778\ub371\uc2a4\uc5d0 \ub9de\ub3c4\ub85d \ucda9\ubd84\ud788 \"\ud0a4\uac00 \ud070\" \uc778\ub371\uc2a4 \ub178\ub4dc\ub97c \uc5bb\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub9f5\/\ucd95\uc18c \ubcf4\uae30\uc640 \uae00\ub85c\ubc8c \ubcf4\uc870 \uc778\ub371\uc2a4\uc758 \ucc28\uc774\uc810\uc5d0 \ub300\ud574 \uc790\uc138\ud788 \uc54c\uc544\ubcf4\uc138\uc694. <a href=\"https:\/\/developer.couchbase.com\/documentation\/server\/4.1\/architecture\/gsi-versus-views.html\">\uc5ec\uae30<\/a>.<\/em><\/p>\n<p>\ub9cc\ub8cc \uc815\ubcf4\ub97c \uc0c9\uc778\ud558\uace0 \ucffc\ub9ac\ud558\uc5ec \ub9cc\ub8cc\ub418\ub294 \ub370\uc774\ud130\ub97c \uac10\uc9c0\ud558\ub294 \ubc29\ubc95\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4: \uc0d8\ud50c\uc5d0\uc11c\ub294 .Net\uc744 \uc0ac\uc6a9\ud558\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n<p><strong>1\ub2e8\uacc4- <\/strong>\ubb38\uc11c \ubcf8\ubb38\uc5d0 \ub9cc\ub8cc\uc77c \ud3ec\ud568: \uc55e\uc73c\ub85c\ub294 \uc774 \uc791\uc5c5\uc744 \uc218\ud589\ud560 \ud544\uc694\uac00 \uc5c6\uc9c0\ub9cc \ud604\uc7ac META()\ub294 \uc544\uc9c1 \ub9cc\ub8cc\uc77c\uc744 \ub178\ucd9c\ud558\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. \uc544\ub798 \ucf54\ub4dc\uc5d0\uc11c \ubb38\uc11c\uac00 \ub9cc\ub8cc\ub420 \ub300\ub7b5\uc801\uc778 \uc2dc\uac04\uc744 \uacc4\uc0b0\ud558\ub294 exp_datetime \uc18d\uc131\uc744 JSON\uc5d0 \ucd94\uac00\ud569\ub2c8\ub2e4. (\uc774\uac83\uc740 \ubd84\uc0b0 \uc2dc\uc2a4\ud15c\uc774\uba70 \uc911\uc559 \uc2dc\uac04\uc774 \uc5c6\ub2e4\ub294 \uc810\uc744 \uae30\uc5b5\ud558\uc138\uc694. \ud074\ub77c\uc774\uc5b8\ud2b8 \ubc0f \uc11c\ubc84 \ub178\ub4dc\ub9c8\ub2e4 \uc2dc\uacc4\uac00 \uc57d\uac04\uc529 \ub2e4\ub974\ubbc0\ub85c \uc815\ud655\ud55c \ub9cc\ub8cc \uc2dc\uac04\uc744 \uac10\uc9c0\ud558\uae30 \uc5b4\ub835\uc2b5\ub2c8\ub2e4.)<\/p>\n<pre><code class=\"language-cs\">...\r\ncbDoc = new Document\r\n{\r\n  Id = _key,\r\n  Content = new\r\n  {\r\n    a1 = _a1,\r\n    ...\r\n    exp_datetime = DateTime.UtcNow.AddMilliseconds(30000)\r\n  }\r\n};\r\n\r\n\/\/UPSERT\r\ncbDoc.Expiry = 30000;\r\nvar upsert = cbBucket.Upsert(cbDoc);\r\n...<\/code><\/pre>\n<p><strong>2\ub2e8\uacc4 - <\/strong>\ub9cc\ub8cc \uc2dc\uac04\uc5d0 \ub300\ud55c \uc778\ub371\uc2a4\ub97c \ub9cc\ub4ed\ub2c8\ub2e4.<\/p>\n<pre><code class=\"language-sql\">CREATE INDEX iExpiration ON default(exp_datetime) USING GSI;<\/code><\/pre>\n<p><strong>3\ub2e8\uacc4 -<\/strong> \ub2e4\uc74c 30\ucd08 \ud6c4\uc5d0 \ub9cc\ub8cc\ub418\ub294 \ub370\uc774\ud130\ub97c \ucffc\ub9ac\ud569\ub2c8\ub2e4. \ub2e4\uc74c \ucffc\ub9ac\ub294 \ubb38\uc11c ID\uc640 \uc804\uccb4 \ubb38\uc11c \uac12\uc744 \ubc18\ud658\ud569\ub2c8\ub2e4.<\/p>\n<pre><code class=\"language-sql\">SELECT META(default).id, *\r\nFROM default \r\nWHERE DATE_DIFF_STR(STR_TO_UTC(exp_datetime),MILLIS_TO_UTC(DATE_ADD_MILLIS(NOW_MILLIS(),30,\"second\")),\"second\") &lt; 30 \r\n  AND STR_TO_UTC(exp_datetime) IS NOT MISSING;<\/code><\/pre>\n<p>\ucd9c\ub825\uc5d0\ub294 \ud5a5\ud6c4 30\ucd08 \ub0b4\uc5d0 \ub9cc\ub8cc\ub418\ub294 \ubaa8\ub4e0 \ubb38\uc11c\uac00 \ud3ec\ud568\ub429\ub2c8\ub2e4.<\/p>\n<p style=\"text-align: center\"><img decoding=\"async\" src=\"\/wp-content\/original-assets\/2016\/april\/detecting-expirations-of-documents-with-couchbase-server-and-n1ql\/untitled4.jpg\" \/><\/p>\n<p>\ud589\ubcf5\ud55c \ud574\ud0b9<\/p>","protected":false},"excerpt":{"rendered":"<p>There are many use cases where auto expiry of documents work perfectly. Maintaining session state, shopping carts, price quotes for travel and more. In all these cases, applications using Couchbase Server, set the expiry time to seconds, minutes or hours [&hellip;]<\/p>","protected":false},"author":7,"featured_media":13873,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[1812],"tags":[],"ppma_author":[8978],"class_list":["post-2214","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-n1ql-query"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v25.8 (Yoast SEO v25.8) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Detect Expiry Before it Happen with Couchbase Server &amp; N1QL<\/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:\/\/www.couchbase.com\/blog\/ko\/detecting-expirations-of-documents-with-couchbase-server-and-n1ql\/\" \/>\n<meta property=\"og:locale\" content=\"ko_KR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Detecting Expirations Before They Happen with Couchbase Server &amp; N1QL\" \/>\n<meta property=\"og:description\" content=\"There are many use cases where auto expiry of documents work perfectly. Maintaining session state, shopping carts, price quotes for travel and more. In all these cases, applications using Couchbase Server, set the expiry time to seconds, minutes or hours [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.couchbase.com\/blog\/ko\/detecting-expirations-of-documents-with-couchbase-server-and-n1ql\/\" \/>\n<meta property=\"og:site_name\" content=\"The Couchbase Blog\" \/>\n<meta property=\"article:published_time\" content=\"2016-04-07T01:59:42+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-03-21T22:53:18+00:00\" \/>\n<meta name=\"author\" content=\"Cihan Biyikoglu, Director of Product Management, Couchbase\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Cihan Biyikoglu, Director of Product Management, Couchbase\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3\ubd84\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/detecting-expirations-of-documents-with-couchbase-server-and-n1ql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/detecting-expirations-of-documents-with-couchbase-server-and-n1ql\/\"},\"author\":{\"name\":\"Cihan Biyikoglu, Director of Product Management, Couchbase\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/3d8c60500ca29254fcdb2f76f29fb088\"},\"headline\":\"Detecting Expirations Before They Happen with Couchbase Server &amp; N1QL\",\"datePublished\":\"2016-04-07T01:59:42+00:00\",\"dateModified\":\"2023-03-21T22:53:18+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/detecting-expirations-of-documents-with-couchbase-server-and-n1ql\/\"},\"wordCount\":424,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/detecting-expirations-of-documents-with-couchbase-server-and-n1ql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png\",\"articleSection\":[\"SQL++ \/ N1QL Query\"],\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.couchbase.com\/blog\/detecting-expirations-of-documents-with-couchbase-server-and-n1ql\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/detecting-expirations-of-documents-with-couchbase-server-and-n1ql\/\",\"url\":\"https:\/\/www.couchbase.com\/blog\/detecting-expirations-of-documents-with-couchbase-server-and-n1ql\/\",\"name\":\"Detect Expiry Before it Happen with Couchbase Server & N1QL\",\"isPartOf\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/detecting-expirations-of-documents-with-couchbase-server-and-n1ql\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/detecting-expirations-of-documents-with-couchbase-server-and-n1ql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png\",\"datePublished\":\"2016-04-07T01:59:42+00:00\",\"dateModified\":\"2023-03-21T22:53:18+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/detecting-expirations-of-documents-with-couchbase-server-and-n1ql\/#breadcrumb\"},\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.couchbase.com\/blog\/detecting-expirations-of-documents-with-couchbase-server-and-n1ql\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/detecting-expirations-of-documents-with-couchbase-server-and-n1ql\/#primaryimage\",\"url\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png\",\"contentUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png\",\"width\":1800,\"height\":630},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/detecting-expirations-of-documents-with-couchbase-server-and-n1ql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.couchbase.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Detecting Expirations Before They Happen with Couchbase Server &amp; N1QL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#website\",\"url\":\"https:\/\/www.couchbase.com\/blog\/\",\"name\":\"The Couchbase Blog\",\"description\":\"Couchbase, the NoSQL Database\",\"publisher\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.couchbase.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ko-KR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\",\"name\":\"The Couchbase Blog\",\"url\":\"https:\/\/www.couchbase.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png\",\"contentUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png\",\"width\":218,\"height\":34,\"caption\":\"The Couchbase Blog\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/3d8c60500ca29254fcdb2f76f29fb088\",\"name\":\"Cihan Biyikoglu, Director of Product Management, Couchbase\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/image\/a878e65cb37ac2419416d3289816abd5\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/3e1ac58dd480dd8a6e93d700a58d329bb81df928061de04395055a45274b8702?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/3e1ac58dd480dd8a6e93d700a58d329bb81df928061de04395055a45274b8702?s=96&d=mm&r=g\",\"caption\":\"Cihan Biyikoglu, Director of Product Management, Couchbase\"},\"description\":\"Cihan Biyikoglu is a director of product management at Couchbase, responsible for the Couchbase Server product. Cihan is a big data enthusiast who brings over twenty years of experience to Redis Labs\u2019 product team. Cihan started his career as a C\/C++ developer.\",\"url\":\"https:\/\/www.couchbase.com\/blog\/ko\/author\/cihan-biyikoglu\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Detect Expiry Before it Happen with Couchbase Server & N1QL","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.couchbase.com\/blog\/ko\/detecting-expirations-of-documents-with-couchbase-server-and-n1ql\/","og_locale":"ko_KR","og_type":"article","og_title":"Detecting Expirations Before They Happen with Couchbase Server &amp; N1QL","og_description":"There are many use cases where auto expiry of documents work perfectly. Maintaining session state, shopping carts, price quotes for travel and more. In all these cases, applications using Couchbase Server, set the expiry time to seconds, minutes or hours [&hellip;]","og_url":"https:\/\/www.couchbase.com\/blog\/ko\/detecting-expirations-of-documents-with-couchbase-server-and-n1ql\/","og_site_name":"The Couchbase Blog","article_published_time":"2016-04-07T01:59:42+00:00","article_modified_time":"2023-03-21T22:53:18+00:00","author":"Cihan Biyikoglu, Director of Product Management, Couchbase","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Cihan Biyikoglu, Director of Product Management, Couchbase","Est. reading time":"3\ubd84"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.couchbase.com\/blog\/detecting-expirations-of-documents-with-couchbase-server-and-n1ql\/#article","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/detecting-expirations-of-documents-with-couchbase-server-and-n1ql\/"},"author":{"name":"Cihan Biyikoglu, Director of Product Management, Couchbase","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/3d8c60500ca29254fcdb2f76f29fb088"},"headline":"Detecting Expirations Before They Happen with Couchbase Server &amp; N1QL","datePublished":"2016-04-07T01:59:42+00:00","dateModified":"2023-03-21T22:53:18+00:00","mainEntityOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/detecting-expirations-of-documents-with-couchbase-server-and-n1ql\/"},"wordCount":424,"commentCount":0,"publisher":{"@id":"https:\/\/www.couchbase.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/detecting-expirations-of-documents-with-couchbase-server-and-n1ql\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png","articleSection":["SQL++ \/ N1QL Query"],"inLanguage":"ko-KR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.couchbase.com\/blog\/detecting-expirations-of-documents-with-couchbase-server-and-n1ql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.couchbase.com\/blog\/detecting-expirations-of-documents-with-couchbase-server-and-n1ql\/","url":"https:\/\/www.couchbase.com\/blog\/detecting-expirations-of-documents-with-couchbase-server-and-n1ql\/","name":"Detect Expiry Before it Happen with Couchbase Server & N1QL","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/detecting-expirations-of-documents-with-couchbase-server-and-n1ql\/#primaryimage"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/detecting-expirations-of-documents-with-couchbase-server-and-n1ql\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png","datePublished":"2016-04-07T01:59:42+00:00","dateModified":"2023-03-21T22:53:18+00:00","breadcrumb":{"@id":"https:\/\/www.couchbase.com\/blog\/detecting-expirations-of-documents-with-couchbase-server-and-n1ql\/#breadcrumb"},"inLanguage":"ko-KR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.couchbase.com\/blog\/detecting-expirations-of-documents-with-couchbase-server-and-n1ql\/"]}]},{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.couchbase.com\/blog\/detecting-expirations-of-documents-with-couchbase-server-and-n1ql\/#primaryimage","url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png","contentUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png","width":1800,"height":630},{"@type":"BreadcrumbList","@id":"https:\/\/www.couchbase.com\/blog\/detecting-expirations-of-documents-with-couchbase-server-and-n1ql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.couchbase.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Detecting Expirations Before They Happen with Couchbase Server &amp; N1QL"}]},{"@type":"WebSite","@id":"https:\/\/www.couchbase.com\/blog\/#website","url":"https:\/\/www.couchbase.com\/blog\/","name":"\uce74\uc6b0\uce58\ubca0\uc774\uc2a4 \ube14\ub85c\uadf8","description":"NoSQL \ub370\uc774\ud130\ubca0\uc774\uc2a4, Couchbase","publisher":{"@id":"https:\/\/www.couchbase.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.couchbase.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ko-KR"},{"@type":"Organization","@id":"https:\/\/www.couchbase.com\/blog\/#organization","name":"\uce74\uc6b0\uce58\ubca0\uc774\uc2a4 \ube14\ub85c\uadf8","url":"https:\/\/www.couchbase.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png","contentUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png","width":218,"height":34,"caption":"The Couchbase Blog"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/3d8c60500ca29254fcdb2f76f29fb088","name":"Cihan Biyikoglu, \uc81c\ud488 \uad00\ub9ac \uc774\uc0ac, Couchbase","image":{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/image\/a878e65cb37ac2419416d3289816abd5","url":"https:\/\/secure.gravatar.com\/avatar\/3e1ac58dd480dd8a6e93d700a58d329bb81df928061de04395055a45274b8702?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/3e1ac58dd480dd8a6e93d700a58d329bb81df928061de04395055a45274b8702?s=96&d=mm&r=g","caption":"Cihan Biyikoglu, Director of Product Management, Couchbase"},"description":"Cihan Biyikoglu\ub294 Couchbase\uc758 \uc81c\ud488 \uad00\ub9ac \ub514\ub809\ud130\ub85c, Couchbase Server \uc81c\ud488\uc744 \ub2f4\ub2f9\ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4. Cihan\uc740 \ube45 \ub370\uc774\ud130 \uc560\ud638\uac00\ub85c\uc11c 20\ub144 \uc774\uc0c1\uc758 \uacbd\ud5d8\uc744 Redis Labs\uc758 \uc81c\ud488 \ud300\uc5d0 \uc81c\uacf5\ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4. Cihan\uc740 C\/C++ \uac1c\ubc1c\uc790\ub85c \uacbd\ub825\uc744 \uc2dc\uc791\ud588\uc2b5\ub2c8\ub2e4.","url":"https:\/\/www.couchbase.com\/blog\/ko\/author\/cihan-biyikoglu\/"}]}},"authors":[{"term_id":8978,"user_id":7,"is_guest":0,"slug":"cihan-biyikoglu","display_name":"Cihan Biyikoglu, Director of Product Management, Couchbase","avatar_url":"https:\/\/secure.gravatar.com\/avatar\/3e1ac58dd480dd8a6e93d700a58d329bb81df928061de04395055a45274b8702?s=96&d=mm&r=g","author_category":"","last_name":"Biyikoglu","first_name":"Cihan","job_title":"","user_url":"","description":"Cihan Biyikoglu\ub294 Couchbase\uc758 \uc81c\ud488 \uad00\ub9ac \ub514\ub809\ud130\ub85c, Couchbase Server \uc81c\ud488\uc744 \ub2f4\ub2f9\ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4. Cihan\uc740 \ube45 \ub370\uc774\ud130 \uc560\ud638\uac00\ub85c\uc11c 20\ub144 \uc774\uc0c1\uc758 \uacbd\ud5d8\uc744 Redis Labs\uc758 \uc81c\ud488 \ud300\uc5d0 \uc81c\uacf5\ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4. Cihan\uc740 C\/C++ \uac1c\ubc1c\uc790\ub85c \uacbd\ub825\uc744 \uc2dc\uc791\ud588\uc2b5\ub2c8\ub2e4."}],"_links":{"self":[{"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/posts\/2214","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/comments?post=2214"}],"version-history":[{"count":0,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/posts\/2214\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/media\/13873"}],"wp:attachment":[{"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/media?parent=2214"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/categories?post=2214"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/tags?post=2214"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/ppma_author?post=2214"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}