{"id":2707,"date":"2017-06-01T10:48:53","date_gmt":"2017-06-01T17:48:53","guid":{"rendered":"https:\/\/www.couchbase.com\/blog\/?p=2707"},"modified":"2025-06-13T23:43:24","modified_gmt":"2025-06-14T06:43:24","slug":"find-pii-in-your-database","status":"publish","type":"post","link":"https:\/\/www.couchbase.com\/blog\/ko\/find-pii-in-your-database\/","title":{"rendered":"\ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc800\uc7a5\ub41c PII\ub97c \uc2dd\ubcc4\ud558\ub294 \uac00\uc7a5 \ube60\ub978 \ubc29\ubc95: N1QL, Nodejs \ubc0f Docker\ub97c \uc0ac\uc6a9\ud55c \uac04\ub2e8\ud55c \uc608\uc81c"},"content":{"rendered":"<p>\uace0\uac1d\ub4e4\uc774 \uc790\uc8fc \uc694\uccad\ud558\ub294 \uac83\uc740 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ub0b4\uc5d0\uc11c PII\ub97c \uc2dd\ubcc4\ud558\ub294 \ubc29\ubc95\uc785\ub2c8\ub2e4.   \uc774\ub97c \uc218\ud589\ud558\ub294 \ubc29\ubc95\uc744 \uac04\ub2e8\ud55c \uc608\ub85c \ubcf4\uc5ec\ub4dc\ub9ac\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n<p><b>\uc0ac\uc6a9\uc790 \uc2a4\ud1a0\ub9ac<\/b>: \"\ubb38\uc11c \ub0b4\uc5d0\uc11c \uc554\ud638\ud654\ub418\uc9c0 \uc54a\uc740 \uc2e0\uc6a9\uce74\ub4dc \ubc88\ud638\uc640 \uc8fc\ubbfc\ub4f1\ub85d\ubc88\ud638\ub97c \uc2dd\ubcc4\ud558\uc5ec \uac1c\ubc1c\uc790\uac00 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc800\uc7a5\ud574\uc11c\ub294 \uc548 \ub418\ub294 \uc815\ubcf4\ub97c \uc800\uc7a5\ud558\uc9c0 \uc54a\ub3c4\ub85d \ud558\uace0 \uc2f6\uc2b5\ub2c8\ub2e4.\"<\/p>\n<p><b>\ubc30\uacbd:\u00a0\u00a0<\/b>N1QL\uc5d0\ub294 \"<a href=\"https:\/\/docs.couchbase.com\/server\/current\/n1ql\/n1ql-language-reference\/stringfun.html\">\ud1a0\ud070\ud654<\/a>\" \uae30\ub2a5\uc744 4.6\ubd80\ud130 \uc9c0\uc6d0\ud569\ub2c8\ub2e4.  \uc774 \uae30\ub2a5\uc744\u00a0<a href=\"https:\/\/developer.couchbase.com\/documentation\/server\/4.5\/n1ql\/n1ql-language-reference\/patternmatchingfun.html\">\uc815\uaddc\uc2dd \ud568\uc218<\/a>\u00a0\uc758 \ud2b9\uc815 \ubcf4\uc870 \uc778\ub371\uc2a4\uc640 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ub0b4\uc758 \ud328\ud134\uc744 \uc2dd\ubcc4\ud560 \uc218 \uc788\ub294 \uac15\ub825\ud55c \ub3c4\uad6c \uc138\ud2b8\uac00 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p><b>\uc194\ub8e8\uc158 \uc608\uc2dc: \u00a0<\/b>\ubc84\ud0b7(\uc774 \uacbd\uc6b0\uc5d0\ub294 '\uae30\ubcf8' \ubc84\ud0b7) \ub0b4\uc5d0 \uc800\uc7a5\ub41c \uc554\ud638\ud654\ub418\uc9c0 \uc54a\uc740 \uc8fc\ubbfc\ub4f1\ub85d\ubc88\ud638\ub97c \uc2dd\ubcc4\ud558\ub294 \ucffc\ub9ac\ub97c \ub9cc\ub4e4\uc5c8\uc2b5\ub2c8\ub2e4.  xxx-xx-xxxx \ub610\ub294 xxxxxxxxx\uc640 \uc77c\uce58\ud558\ub294 \ubaa8\ub4e0 \uc22b\uc790 \ud328\ud134\uc744 \ucc3e\uace0 \uc788\uc2b5\ub2c8\ub2e4. TOKENS \ud568\uc218\ub97c \uc0ac\uc6a9\ud558\uba74 \ubb38\uc11c\ub97c \ubb38\uc790\uc5f4 \ubc30\uc5f4\ub85c \ucde8\uae09\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.  \uc800\ub294 \"specials\" \ud50c\ub798\uadf8\ub97c \uc0ac\uc6a9\ud558\uc5ec N1QL\uc774 \uc774\ub7ec\ud55c \ubb38\uc790\uc5f4\uc744 \uadf8\ub300\ub85c \uc720\uc9c0\ud558\ub3c4\ub85d \uc9c0\uc2dc\ud588\uc2b5\ub2c8\ub2e4.  \uc774 \ud50c\ub798\uadf8\ub97c \uc0ac\uc6a9\ud558\uc9c0 \uc54a\uc73c\uba74 \uacf5\ubc31\uacfc \ub300\uc2dc\ub97c \uc81c\uac70\ud558\uace0 \ud574\ub2f9 \ubb38\uc790 \ub4a4\uc5d0 \uc624\ub294 \ud56d\ubaa9\uc744 \ubb34\uc2dc\ud569\ub2c8\ub2e4.   \uadf8\ub7f0 \ub2e4\uc74c \ud1a0\ud070 \ubc30\uc5f4 \ub0b4\uc758 \uc694\uc18c\uc640 \uc77c\uce58\ud558\ub294 \uc815\uaddc\uc2dd\uc744 \ucc3e\uc2b5\ub2c8\ub2e4.<\/p>\n<pre class=\"\">SELECT * FROM default\r\n WHERE ANY v IN\r\n TOKENS(default, {\"specials\":true}) SATISFIES\r\n REGEXP_LIKE(TOSTRING(v),'(\\\\d{3}-\\\\d{2}-\\\\d{4})|(\\\\b\\\\d{9}\\\\b)')\r\nEND<\/pre>\n<p>\ubc84\ud0b7\uc5d0 \uc800\uc7a5\ub41c \uc554\ud638\ud654\ub418\uc9c0 \uc54a\uc740 \uc2e0\uc6a9\uce74\ub4dc \ubc88\ud638\ub97c \uc2dd\ubcc4\ud560 \ub54c\ub3c4 \ub3d9\uc77c\ud55c \uc811\uadfc \ubc29\uc2dd\uc744 \uc0ac\uc6a9\ud569\ub2c8\ub2e4:<\/p>\n<pre class=\"\">SELECT * FROM default\r\n WHERE ANY v IN\r\n TOKENS(default, {\"specials\":true}) SATISFIES\r\n REGEXP_LIKE(TOSTRING(v),'(\\\\d{4}-\\\\d{4}-\\\\d{4}-\\\\d{4}))|(\\\\b\\\\d{16}\\\\b)')\r\nEND<\/pre>\n<p>\ucc98\ub9ac \uc2dc\uac04\uc744 \ub2e8\ucd95\ud558\uae30 \uc704\ud574 \uc704\uc758 \ucffc\ub9ac\uc5d0 \uba54\ubaa8\ub9ac \ucd5c\uc801\ud654\ub41c \ubcf4\uc870 \uc778\ub371\uc2a4(MOI)\ub97c \uc0ac\uc6a9\ud569\ub2c8\ub2e4.  Couchbase\uc758 \ubaa8\ub4e0 \ubcc0\uc774\ub294 \ube44\ub3d9\uae30\uc801\uc73c\ub85c \uc778\ub371\uc2a4 \ud504\ub85c\uc81d\ud130\ub85c \uc804\uc1a1\ub429\ub2c8\ub2e4.   MOI\ub294 \uc778\ub371\uc2a4\uc5d0 \ud3ec\ud568\ub41c \uc815\ubcf4\ub97c 20ms\ub9c8\ub2e4 \uc5c5\ub370\uc774\ud2b8\ud55c\ub2e4\ub294 \ucd94\uac00\uc801\uc778 \uc774\uc810\uc774 \uc788\uc2b5\ub2c8\ub2e4. \uc778\ub371\uc2a4\ub294 \ub610\ud55c \ud1a0\ud070\ud654\ub97c \ud65c\uc6a9\ud569\ub2c8\ub2e4.<\/p>\n<pre class=\"\">CREATE INDEX `find_pii_ssn` ON `default`(\r\n (DISTINCT (ARRAY `v` FOR `v` IN\r\n TOKENS(self, {\"specials\": true}) END)))\r\n WHERE ANY `v` IN\r\n TOKENS(self, {\"specials\": true}) SATISFIES REGEXP_LIKE(TO_STRING(`v`), \"(\\\\d{3}-\\\\d{2}-\\\\d{4})|(\\\\b\\\\d{9}\\\\b)\")\r\n END<\/pre>\n<p>...\uadf8\ub9ac\uace0 \uc554\ud638\ud654\ub418\uc9c0 \uc54a\uc740 \uc2e0\uc6a9 \uce74\ub4dc\uc758 \uacbd\uc6b0<\/p>\n<pre class=\"\">CREATE INDEX `find_pii_ccn` ON `default`(\r\n (DISTINCT (ARRAY `v` FOR `v` IN\r\n TOKENS(self, {\"specials\": true}) END)))\r\n WHERE any `v` IN\r\n TOKENS(self, {\"specials\": true}) SATISFIES REGEXP_LIKE(TO_STRING(`v`), \"(\\\\d{4}-\\\\d{4}-\\\\d{4}-\\\\d{4}))|(\\\\b\\\\d{16}\\\\b)\")\r\n END\r\n<\/pre>\n<p class=\"\"><strong>\uc0ac\uc6a9\ud574 \ubcf4\uc138\uc694:<\/strong>\u00a0Docker\ub294 \uc81c\uac00 \uac1c\ubc1c \ud658\uacbd\uc744 \uc2dc\uc791\ud558\ub294 \ub370 \uac00\uc7a5 \uc88b\uc544\ud558\ub294 \ubc29\ubc95\uc785\ub2c8\ub2e4.   \uc704\uc758 \uc608\uc81c\uc5d0 \ub300\ud55c \uc0ac\uc6a9\ud558\uae30 \uc26c\uc6b4 \ub9ac\ud3ec\uc9c0\ud1a0\ub9ac\ub294 github\uc5d0 \uc788\uc2b5\ub2c8\ub2e4: <a href=\"https:\/\/github.com\/ToddGreenstein\/n1ql-query-nodejs\">n1ql-query-nodejs <\/a>.  \ub3c4\ucee4 \ucef4\ud3ec\uc988\ub97c \uc0ac\uc6a9\ud558\uc5ec \ub450 \uac1c\uc758 \uc11c\ube44\uc2a4\ub97c \ube4c\ub4dc\ud569\ub2c8\ub2e4:<\/p>\n<ol>\n<li>\ub2e8\uc77c \ub178\ub4dc \uce74\uc6b0\uce58\ubca0\uc774\uc2a4 \ud074\ub7ec\uc2a4\ud130 \uc11c\ube44\uc2a4\uc785\ub2c8\ub2e4.<\/li>\n<li>\uc554\ud638\ud654\ub418\uc9c0 \uc54a\uc740 PII\ub97c \ucc3e\ub294 \ub4f1 \uba87 \uac00\uc9c0 \uc608\uc81c\ub97c \uc704\ud574 250,000\uac1c\uc758 \uc0ac\uc6a9\uc790 \ud504\ub85c\ud544\uacfc \uc778\ub371\uc2a4\ub85c Couchbase \ud074\ub7ec\uc2a4\ud130\ub97c \ud504\ub85c\ube44\uc800\ub2dd\ud558\ub294 nodejs \uc11c\ube44\uc2a4\uc785\ub2c8\ub2e4.<\/li>\n<\/ol>","protected":false},"excerpt":{"rendered":"<p>A frequent request from customers is a way to identify PII within their databases.\u00a0\u00a0 I thought I\u2019d show a brief example how this can be done. User Story: &#8220;I want to identify unencrypted credit card numbers and social security numbers [&hellip;]<\/p>","protected":false},"author":20,"featured_media":13873,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[1822,1812],"tags":[1519,1896],"ppma_author":[9019],"class_list":["post-2707","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-node-js","category-n1ql-query","tag-docker","tag-docker-compose"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v26.1 (Yoast SEO v26.1.1) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>The Fastest Way to Identify PII Stored in your Database: A Simple Example Using N1QL, Nodejs and Docker - The Couchbase Blog<\/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\/find-pii-in-your-database\/\" \/>\n<meta property=\"og:locale\" content=\"ko_KR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"The Fastest Way to Identify PII Stored in your Database: A Simple Example Using N1QL, Nodejs and Docker\" \/>\n<meta property=\"og:description\" content=\"A frequent request from customers is a way to identify PII within their databases.\u00a0\u00a0 I thought I\u2019d show a brief example how this can be done. User Story: &#8220;I want to identify unencrypted credit card numbers and social security numbers [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.couchbase.com\/blog\/ko\/find-pii-in-your-database\/\" \/>\n<meta property=\"og:site_name\" content=\"The Couchbase Blog\" \/>\n<meta property=\"article:published_time\" content=\"2017-06-01T17:48:53+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-14T06:43:24+00:00\" \/>\n<meta name=\"author\" content=\"Todd Greenstein\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@todd_greenstein\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Todd Greenstein\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2\ubd84\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/find-pii-in-your-database\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/find-pii-in-your-database\/\"},\"author\":{\"name\":\"Todd Greenstein\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/64b5d1e5969768c5d63c11c696951ed3\"},\"headline\":\"The Fastest Way to Identify PII Stored in your Database: A Simple Example Using N1QL, Nodejs and Docker\",\"datePublished\":\"2017-06-01T17:48:53+00:00\",\"dateModified\":\"2025-06-14T06:43:24+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/find-pii-in-your-database\/\"},\"wordCount\":338,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/find-pii-in-your-database\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png\",\"keywords\":[\"docker\",\"docker-compose\"],\"articleSection\":[\"Node.js\",\"SQL++ \/ N1QL Query\"],\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.couchbase.com\/blog\/find-pii-in-your-database\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/find-pii-in-your-database\/\",\"url\":\"https:\/\/www.couchbase.com\/blog\/find-pii-in-your-database\/\",\"name\":\"The Fastest Way to Identify PII Stored in your Database: A Simple Example Using N1QL, Nodejs and Docker - The Couchbase Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/find-pii-in-your-database\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/find-pii-in-your-database\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png\",\"datePublished\":\"2017-06-01T17:48:53+00:00\",\"dateModified\":\"2025-06-14T06:43:24+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/find-pii-in-your-database\/#breadcrumb\"},\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.couchbase.com\/blog\/find-pii-in-your-database\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/find-pii-in-your-database\/#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\/find-pii-in-your-database\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.couchbase.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"The Fastest Way to Identify PII Stored in your Database: A Simple Example Using N1QL, Nodejs and Docker\"}]},{\"@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\/64b5d1e5969768c5d63c11c696951ed3\",\"name\":\"Todd Greenstein\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/image\/abfbe093983052aa28595343c19888ce\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f230045f7f6e636cf01abbd35f1cbf66a1206fbe149a0d4f0bbdd992c646257d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f230045f7f6e636cf01abbd35f1cbf66a1206fbe149a0d4f0bbdd992c646257d?s=96&d=mm&r=g\",\"caption\":\"Todd Greenstein\"},\"description\":\"Todd Greenstein is a Solution Architect at Couchbase. Todd is specialize in API design, architecture, data modeling, nodejs and golang development.\",\"sameAs\":[\"https:\/\/x.com\/todd_greenstein\"],\"url\":\"https:\/\/www.couchbase.com\/blog\/ko\/author\/todd-greenstein\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"The Fastest Way to Identify PII Stored in your Database: A Simple Example Using N1QL, Nodejs and Docker - The Couchbase Blog","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\/find-pii-in-your-database\/","og_locale":"ko_KR","og_type":"article","og_title":"The Fastest Way to Identify PII Stored in your Database: A Simple Example Using N1QL, Nodejs and Docker","og_description":"A frequent request from customers is a way to identify PII within their databases.\u00a0\u00a0 I thought I\u2019d show a brief example how this can be done. User Story: &#8220;I want to identify unencrypted credit card numbers and social security numbers [&hellip;]","og_url":"https:\/\/www.couchbase.com\/blog\/ko\/find-pii-in-your-database\/","og_site_name":"The Couchbase Blog","article_published_time":"2017-06-01T17:48:53+00:00","article_modified_time":"2025-06-14T06:43:24+00:00","author":"Todd Greenstein","twitter_card":"summary_large_image","twitter_creator":"@todd_greenstein","twitter_misc":{"Written by":"Todd Greenstein","Est. reading time":"2\ubd84"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.couchbase.com\/blog\/find-pii-in-your-database\/#article","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/find-pii-in-your-database\/"},"author":{"name":"Todd Greenstein","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/64b5d1e5969768c5d63c11c696951ed3"},"headline":"The Fastest Way to Identify PII Stored in your Database: A Simple Example Using N1QL, Nodejs and Docker","datePublished":"2017-06-01T17:48:53+00:00","dateModified":"2025-06-14T06:43:24+00:00","mainEntityOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/find-pii-in-your-database\/"},"wordCount":338,"commentCount":0,"publisher":{"@id":"https:\/\/www.couchbase.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/find-pii-in-your-database\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png","keywords":["docker","docker-compose"],"articleSection":["Node.js","SQL++ \/ N1QL Query"],"inLanguage":"ko-KR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.couchbase.com\/blog\/find-pii-in-your-database\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.couchbase.com\/blog\/find-pii-in-your-database\/","url":"https:\/\/www.couchbase.com\/blog\/find-pii-in-your-database\/","name":"The Fastest Way to Identify PII Stored in your Database: A Simple Example Using N1QL, Nodejs and Docker - The Couchbase Blog","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/find-pii-in-your-database\/#primaryimage"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/find-pii-in-your-database\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png","datePublished":"2017-06-01T17:48:53+00:00","dateModified":"2025-06-14T06:43:24+00:00","breadcrumb":{"@id":"https:\/\/www.couchbase.com\/blog\/find-pii-in-your-database\/#breadcrumb"},"inLanguage":"ko-KR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.couchbase.com\/blog\/find-pii-in-your-database\/"]}]},{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.couchbase.com\/blog\/find-pii-in-your-database\/#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\/find-pii-in-your-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.couchbase.com\/blog\/"},{"@type":"ListItem","position":2,"name":"The Fastest Way to Identify PII Stored in your Database: A Simple Example Using N1QL, Nodejs and Docker"}]},{"@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\/64b5d1e5969768c5d63c11c696951ed3","name":"\ud1a0\ub4dc \uadf8\ub9b0\uc2a4\ud0c0\uc778","image":{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/image\/abfbe093983052aa28595343c19888ce","url":"https:\/\/secure.gravatar.com\/avatar\/f230045f7f6e636cf01abbd35f1cbf66a1206fbe149a0d4f0bbdd992c646257d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f230045f7f6e636cf01abbd35f1cbf66a1206fbe149a0d4f0bbdd992c646257d?s=96&d=mm&r=g","caption":"Todd Greenstein"},"description":"Todd Greenstein is a Solution Architect at Couchbase. Todd is specialize in API design, architecture, data modeling, nodejs and golang development.","sameAs":["https:\/\/x.com\/todd_greenstein"],"url":"https:\/\/www.couchbase.com\/blog\/ko\/author\/todd-greenstein\/"}]}},"authors":[{"term_id":9019,"user_id":20,"is_guest":0,"slug":"todd-greenstein","display_name":"Todd Greenstein","avatar_url":"https:\/\/secure.gravatar.com\/avatar\/f230045f7f6e636cf01abbd35f1cbf66a1206fbe149a0d4f0bbdd992c646257d?s=96&d=mm&r=g","author_category":"","last_name":"Greenstein","first_name":"Todd","job_title":"","user_url":"","description":"\ud1a0\ub4dc \uadf8\ub9b0\uc2a4\ud0c0\uc778\uc740 \uce74\uc6b0\uce58\ubca0\uc774\uc2a4\uc758 \uc194\ub8e8\uc158 \uc544\ud0a4\ud14d\ud2b8\uc785\ub2c8\ub2e4. Todd\ub294 API \uc124\uacc4, \uc544\ud0a4\ud14d\ucc98, \ub370\uc774\ud130 \ubaa8\ub378\ub9c1, nodejs \ubc0f \uace8\ub791 \uac1c\ubc1c\uc744 \uc804\ubb38\uc73c\ub85c \ud569\ub2c8\ub2e4."}],"_links":{"self":[{"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/posts\/2707","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\/20"}],"replies":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/comments?post=2707"}],"version-history":[{"count":0,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/posts\/2707\/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=2707"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/categories?post=2707"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/tags?post=2707"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/ppma_author?post=2707"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}