{"id":8475,"date":"2020-04-25T21:40:43","date_gmt":"2020-04-26T04:40:43","guid":{"rendered":"https:\/\/www.couchbase.com\/blog\/?p=8475"},"modified":"2025-06-13T23:42:42","modified_gmt":"2025-06-14T06:42:42","slug":"fhir-data-model-with-couchbase-n1ql","status":"publish","type":"post","link":"https:\/\/www.couchbase.com\/blog\/ko\/fhir-data-model-with-couchbase-n1ql\/","title":{"rendered":"\uce74\uc6b0\uce58\ubca0\uc774\uc2a4 N1QL\uc744 \uc0ac\uc6a9\ud55c FHIR \ub370\uc774\ud130 \ubaa8\ub378"},"content":{"rendered":"

Couchbase\ub294 \uc774\uc81c \uae30\uc874 RDBMS\uc758 \ub300\uc548\uc774 \ub41c JSON \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc785\ub2c8\ub2e4. \uc5c5\uacc4 \ucd5c\uace0\uc758 \ud0a4-\uac12 \uc800\uc7a5\uc18c\uc640 \uc870\uc9c1\uc5d0\uc11c \uae30\ub300\ud558\ub294 \uac83\uacfc \ub3d9\uc77c\ud55c \ucffc\ub9ac \ubc0f ACID \ubcc0\ud658 \uae30\ub2a5\uc744 \uc81c\uacf5\ud560 \ubfd0\ub9cc \uc544\ub2c8\ub77c \uae30\ubcf8\uc801\uc73c\ub85c \ub370\uc774\ud130\ub97c JSON \ud615\uc2dd\uc73c\ub85c \uc800\uc7a5\ud558\ub294 \uc720\uc5f0\uc131\uc744 \uc81c\uacf5\ud568\uc73c\ub85c\uc368 \uc774\ub97c \ub2ec\uc131\ud588\uc2b5\ub2c8\ub2e4. \ub610\ud55c Couchbase\uc5d0\ub294 \ubd84\uc0b0 \uc2a4\ud1a0\ub9ac\uc9c0, \ub2e4\ucc28\uc6d0 \ud655\uc7a5\uc131, \uace0\uac00\uc6a9\uc131, \ub370\uc774\ud130\uc13c\ud130 \uac04 \ubcf5\uc81c(XDCR) \uae30\ub2a5\ub3c4 \ud3ec\ud568\ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4. \uc774 \ubaa8\ub4e0 \uae30\ub2a5\uc744 Couchbase Mobile\uc744 \ud1b5\ud574 \uc5e3\uc9c0\uae4c\uc9c0 \ud655\uc7a5\ud560 \uc218 \uc788\ub294 \ub2e8\uc77c Couchbase \ub370\uc774\ud130 \ud50c\ub7ab\ud3fc\uc5d0\uc11c \uc81c\uacf5\ud569\ub2c8\ub2e4.<\/span><\/p>\n

\uce74\uc6b0\uce58\ubca0\uc774\uc2a4\ub294 \ub610\ud55c \uae30\uc874 RDBMS \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc5d0 \ud544\uc694\ud55c \uae30\ub2a5\uc744 \ud6e8\uc52c \ub354 \ud655\uc7a5\ud558\uae30 \uc704\ud574 \ucd5c\uc120\uc744 \ub2e4\ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4. \ubaa8\ub4e0 \uac83\uc774 \uc644\ubcbd\ud558\uac8c \uad00\ub9ac\ub418\uace0 \uc790\ub3d9\ud654\ub418\ub294 Couchbase Cloud\ub294 \ud074\ub9ad \uba87 \ubc88\uc73c\ub85c \uba40\ud2f0 \ud074\ub77c\uc6b0\ub4dc \ud658\uacbd\uc5d0\uc11c Couchbase Server\ub97c \ubc30\ud3ec, \uad00\ub9ac \ubc0f \uc6b4\uc601\ud558\uc5ec FHIR \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc2a4\ud0a4\ub9c8 \uad00\ub9ac\ub97c \uac04\uc18c\ud654\ud558\ub294 \uc548\uc804\ud55c \uc11c\ube44\uc2a4\ud615 \ub370\uc774\ud130\ubca0\uc774\uc2a4(DBaaS)\ub97c \uc81c\uacf5\ud569\ub2c8\ub2e4. Couchbase Cloud\ub294 \uc720\uc5f0\ud558\uace0 \uac00\uc6a9\uc131\uc774 \ub192\uc73c\uba70, \uac00\uc7a5 \uac15\ub825\ud55c NoSQL \uae30\uc220\uc744 \ud65c\uc6a9\ud558\uba74\uc11c \uc6b4\uc601 \uc791\uc5c5\uc744 \uc904\uc774\uace0\uc790 \ud558\ub294 \uae30\uc5c5\uc5d0\uac8c \ucc28\ubcc4\ud654\ub41c \uacbd\uc81c\uc801\uc778 \uc635\uc158\uc744 \uc81c\uacf5\ud569\ub2c8\ub2e4. <\/span><\/p>\n

\ub610\ud55c \ub2e4\uc591\ud55c \uc0b0\uc5c5 \ubd84\uc57c\uc758 \ub9ce\uc740 \uace0\uac1d\uacfc \ud611\ub825\ud558\uc5ec \uace0\uac1d\uc758 \ube44\uc988\ub2c8\uc2a4 \uc694\uad6c \uc0ac\ud56d\uacfc \uc774\ub7ec\ud55c \ubb38\uc81c\ub97c Couchbase\uac00 \uc5b4\ub5bb\uac8c \ub3c4\uc6b8 \uc218 \uc788\ub294\uc9c0 \ud30c\uc545\ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4. \uc774\ub7ec\ud55c \uc0b0\uc5c5\uc740 \uc18c\ub9e4 \ubc0f \uc774\ucee4\uba38\uc2a4, \uc5ec\ud589 \ubc0f \uc219\ubc15\uc5c5, \uae08\uc735 \uc11c\ube44\uc2a4, \uc5d0\ub108\uc9c0 \ubc0f \uc720\ud2f8\ub9ac\ud2f0, \ud558\uc774\ud14c\ud06c \ubc0f \uac8c\uc784\uc5d0 \uc774\ub974\uae30\uae4c\uc9c0 \ub2e4\uc591\ud569\ub2c8\ub2e4.<\/span><\/p>\n

\uc774 \ube14\ub85c\uadf8\uc5d0\uc11c\ub294 \uc758\ub8cc \uc5c5\uacc4\uc5d0\uc11c Couchbase \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc5b4\ub5bb\uac8c \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294\uc9c0\uc5d0 \ub300\ud574 \uc9d1\uc911\uc801\uc73c\ub85c \uc0b4\ud3b4\ubcf4\uace0\uc790 \ud569\ub2c8\ub2e4. \ud2b9\ud788, \ub2e4\uc74c\uc5d0\uc11c \uc815\uc758\ud558\ub294 \uace0\uc18d \uc758\ub8cc \uc0c1\ud638 \uc6b4\uc6a9\uc131 \ub9ac\uc18c\uc2a4(FHIR) \uc0ac\uc591\uc5d0 \ucd08\uc810\uc744 \ub9de\ucd9c \uac83\uc785\ub2c8\ub2e4. <\/span>HL7 FHIR<\/span><\/a>. \uc774 \ube14\ub85c\uadf8\ub97c \uac1c\uc124\ud55c \uc774\uc720\ub294 \ud604\uc7ac Couchbase \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc0ac\uc6a9\ud558\uc5ec FHIR \ud638\ud658 \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc744 \uacc4\ud68d\ud558\uac70\ub098 \uad6c\ud604\ud558\uace0 \uc788\ub294 \ub9ce\uc740 \uace0\uac1d\ub4e4\uc758 \uad00\uc2ec \ub54c\ubb38\uc785\ub2c8\ub2e4.<\/span><\/p>\n

\uce74\uc6b0\uce58\ubca0\uc774\uc2a4\uc758 FHIR\uc5d0 \uad00\uc2ec\uc774 \uc788\ub294 \uc774\uc720\ub294 \ubb34\uc5c7\uc778\uac00\uc694?<\/h3>\n
    \n
  1. FHIR \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc744 \uac1c\ubc1c\ud558\uac70\ub098 \ubd84\uc0b0, \uace0\uac00\uc6a9\uc131, XDCR, \ub2e4\ucc28\uc6d0 \ud655\uc7a5\uc131 \ub4f1 NoSQL \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \ub2e4\uc591\ud55c \uc774\uc810\uc744 \ud65c\uc6a9\ud558\uace0\uc790 \ud558\ub294 \uc870\uc9c1\uc774 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n
  2. \uc124\uacc4\uc790\ub098 \uac1c\ubc1c\uc790\ub294 Couchbase JSON \ub370\uc774\ud130\ubca0\uc774\uc2a4\uac00 \ubcf5\uc7a1\ud55c FHIR \uac80\uc0c9\uc744 \ub300\uccb4\ud558\uc5ec \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc758 \ubcf5\uc7a1\uc131\uc744 \ud06c\uac8c \uc904\uc77c \uc218 \uc788\ub294 \ubc29\ubc95\uc744 \uc774\ud574\ud574\uc57c \ud569\ub2c8\ub2e4.https:\/\/www.hl7.org\/fhir\/searchparameter-registry.html<\/a>] \ucc98\ub9ac\ub97c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc11c\ubc84 \uacc4\uce35\uc73c\ub85c \uc804\uc1a1\ud569\ub2c8\ub2e4.<\/li>\n
  3. \ub370\uc774\ud130 \ubd84\uc11d\uac00\ub294 SQL \uc9c0\uc2dd\uc744 \ud65c\uc6a9\ud558\uc5ec \ub2e4\uc74c\uc744 \uc0ac\uc6a9\ud558\uc5ec FHIR \ub370\uc774\ud130\ub97c \uc9c1\uc811 \ucffc\ub9ac\ud558\ub294 \ubc29\ubc95\uc744 \uc774\ud574\ud574\uc57c \ud569\ub2c8\ub2e4. \uce74\uc6b0\uce58\ubca0\uc774\uc2a4 N1Q<\/a>L \ubc0f \uc804\uccb4 \ud14d\uc2a4\ud2b8 \uac80\uc0c9.<\/a><\/li>\n
  4. JSON\uc6a9 SQL\uc778 Couchbase N1QL\uc774 \uc5b4\ub5bb\uac8c FHIR \ud504\ub85c\ud1a0\ucf5c\uc5d0 \uc815\uc758\ub41c \ub300\ub85c JSON \uacc4\uce35\uc801 \ubc0f \uad00\uacc4\ud615 \ub370\uc774\ud130 \ubaa8\ub378\uc744 \ucffc\ub9ac\ud558\ub294 \ud6a8\uc728\uc801\uc778 \ubc29\ubc95\uc744 \uc81c\uacf5\ud558\ub294\uc9c0 \uc54c\uace0 \uc2f6\uc73c\uc2e0\uac00\uc694?<\/li>\n<\/ol>\n

    FHIR\uc774\ub780 \ubb34\uc5c7\uc778\uac00\uc694?<\/span><\/h3>\n

    FHIR\u00ae - \ube60\ub978 \uc758\ub8cc \uc0c1\ud638 \uc6b4\uc6a9\uc131 \ub9ac\uc18c\uc2a4<\/a> - \ub294 HL7\uc5d0\uc11c \ub9cc\ub4e0 \ucc28\uc138\ub300 \ud45c\uc900 \ud504\ub808\uc784\uc6cc\ud06c\uc785\ub2c8\ub2e4. \"\ubd88\"\ub85c \ubc1c\uc74c\ub418\ub294 FHIR\uc740 HL7\uc758 \ucd5c\uace0\uc758 \uae30\ub2a5\uc744 \uacb0\ud569\ud558\uace0 \ucd5c\uc2e0 \uc6f9 \ud45c\uc900\uc744 \ud65c\uc6a9\ud558\uba70 \uc815\ubcf4 \uad50\ud658\uc744 \uc704\ud55c \uad6c\ud604 \uac00\ub2a5\uc131\uc5d0 \uc911\uc810\uc744 \ub450\uace0 \uc788\uc2b5\ub2c8\ub2e4.<\/span><\/p>\n

    FHIR \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc740 '\ub9ac\uc18c\uc2a4'\ub77c\ub294 \uac1c\ub150\uc744 \uae30\ubc18\uc73c\ub85c \ud569\ub2c8\ub2e4. \uc774\ub7ec\ud55c \ub9ac\uc18c\uc2a4\ub294 \uad00\ub9ac, \uc784\uc0c1, \ud658\uc790 \uad00\ub9ac \uae30\ub2a5\uc5d0 \uc774\ub974\ub294 \ud2b9\uc815 \uc758\ub8cc \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc73c\ub85c \uc870\ub9bd\ub429\ub2c8\ub2e4. <\/span>FHIR\uc740 \ud734\ub300\ud3f0 \uc571, \ud074\ub77c\uc6b0\ub4dc \ud1b5\uc2e0, EHR \uae30\ubc18 \ub370\uc774\ud130 \uacf5\uc720, \uc758\ub8cc \uc11c\ube44\uc2a4 \uc81c\uacf5\uc790\ub97c \uc704\ud55c \uc11c\ubc84 \ud1b5\uc2e0 \ub4f1 \ub2e4\uc591\ud55c \uc0c1\ud669\uc5d0\uc11c \uc0ac\uc6a9\ud558\uae30\uc5d0 \uc801\ud569\ud569\ub2c8\ub2e4.<\/p>\n

    FHIR\uc758 \uc8fc\uc694 \ubaa9\ud45c \uc911 \ud558\ub098\ub294 \ub2e4\uc591\ud55c \uc758\ub8cc \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc774 \ucc44\ud0dd\ud560 \uc218 \uc788\ub294 \ud45c\uc900\uc744 \uc9c0\uc815\ud558\uc5ec \uc11c\ub85c \ub2e4\ub978 \uae30\ub2a5\uc758 \uc560\ud50c\ub9ac\ucf00\uc774\uc158 \uac04\uc5d0 \uc0c1\ud638 \uc6b4\uc6a9\uc131\uc744 \uac00\ub2a5\ud558\uac8c \ud558\uace0 \uad81\uadf9\uc801\uc73c\ub85c \uad6c\ud604 \ube44\uc6a9\uc744 \uc808\uac10\ud558\ub294 \uac83\uc785\ub2c8\ub2e4.<\/p>\n

    \ucc38\uace0\ud558\uc138\uc694. FHIR \uac1c\uc694 \uc6f9\uc0ac\uc774\ud2b8<\/a> \uc5d0\uc11c \uc790\uc138\ud55c \uc815\ubcf4\ub97c \ud655\uc778\ud558\uc138\uc694.<\/span><\/p>\n

    FHIR \ub370\uc774\ud130 \ubaa8\ub378<\/span><\/h4>\n

    FHIR\uc758 \ud575\uc2ec\uc740 \uc758\ub8cc\uc758 \ub2e4\uc591\ud55c \uce21\uba74\uc744 \ubaa8\ub450 \ud3ec\uad04\ud558\ub294 \ub2e4\uc591\ud55c \ub9ac\uc18c\uc2a4 \uc720\ud615\uc5d0 \ub300\ud55c \uacf5\ud1b5\ub41c \uc815\uc758\uc785\ub2c8\ub2e4. \ud658\uc790, \uc758\ub8cc\uc9c4, \uc758\ub8cc\ud300, \uae30\uae30, \uc870\uc9c1, \uc704\uce58, \uc758\ub8cc \uc11c\ube44\uc2a4 \ub4f1\uc758 \uad00\ub9ac \uae30\ub2a5\ubd80\ud130 \uc784\uc0c1, \uc9c4\ub2e8, \uc57d\ubb3c, \ubcf4\ud5d8 \uc801\uc6a9\uacfc \uac19\uc740 \uc7ac\uc815 \uae30\ub2a5\uae4c\uc9c0.<\/span><\/p>\n

    \uc774 \uae00\uc758 \ubaa9\uc801\uc5d0 \ub530\ub77c Synthetic Mass\uc5d0\uc11c \uc0dd\uc131\ub41c \uc0d8\ud50c \ud569\uc131 \ub370\uc774\ud130 \uc138\ud2b8\ub97c \uc0ac\uc6a9\ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4. Synthea<\/a>\uc5d0\uc11c \uc81c\uacf5\ud558\ub294 \uc624\ud508 \uc18c\uc2a4 \ud658\uc790 \uc9d1\ub2e8 \uc2dc\ubbac\ub808\uc774\uc158\uc785\ub2c8\ub2e4.<\/span><\/p>\n

    \ub370\uc774\ud130\ub294 \uac01 \ud569\uc131 \ud658\uc790\uc5d0 \ub300\ud55c \ub9ac\uc18c\uc2a4 \ubc88\ub4e4\ub85c \uc81c\uacf5\ub418\uba70, \uc774 \ub370\uc774\ud130\ub294 Couchbase 6.5 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc778\uc2a4\ud134\uc2a4\ub85c \uac00\uc838\uc635\ub2c8\ub2e4.<\/span><\/p>\n

    \"HL7<\/p>\n

    SELECT resourceType, COUNT(1) doc_count\r\n FROM fhir_admin\r\nWHERE resourceType IS NOT MISSING\r\n GROUP BY resourceType\r\n\r\ndoc_count\tresourceType\r\n567\t\"AllergyIntolerance\"\r\n3577\t\"CarePlan\"\r\n3577\t\"CareTeam\"\r\n52387\t\"Claim\"\r\n8714\t\"Condition\"\r\n57\t\"Device\"\r\n17069\t\"DiagnosticReport\"\r\n42019\t\"Encounter\"\r\n42019\t\"ExplanationOfBenefit\"\r\n2942\t\"Goal\"\r\n965\t\"ImagingStudy\"\r\n14982\t\"Immunization\"\r\n926\t\"MedicationAdministration\"\r\n10368\t\"MedicationRequest\"\r\n235332\t\"Observation\"\r\n1033\t\"Organization\"\r\n1177\t\"Patient\"\r\n1034\t\"Practitioner\"\r\n32454\t\"Procedure\"\r\n<\/pre>\n
    FHIR \ub370\uc774\ud130 \ubaa8\ub378\uc5d0 \ub300\ud55c \uba87 \uac00\uc9c0 \uc8fc\ubaa9\ud560 \ub9cc\ud55c \uc0ac\ud56d<\/span><\/h4>\n
      \n
    1. \uc774 \ubaa8\ub378\uc740 '\ud658\uc790' \uac1c\uccb4\ub97c \uc911\uc2ec\uc73c\ub85c \ud569\ub2c8\ub2e4.<\/span><\/li>\n
    2. \uac1d\uccb4 \uc720\ud615\uc740 'resourceType' \ud544\ub4dc\ub85c \ud45c\uc2dc\ub429\ub2c8\ub2e4.<\/span><\/li>\n
    3. JSON \uad6c\uc870\ub294 \uac74\uac15 \uc218\uc900, \uc5f0\ub77d\ucc98 \uc815\ubcf4, \uc8fc\uc18c, \ucee4\ubba4\ub2c8\ucf00\uc774\uc158 \ub4f1 \ud658\uc790\uc5d0 \ub300\ud574 \ubcf4\uad00\ud560 \uc218 \uc788\ub294 \ub354 \ud48d\ubd80\ud55c \uac74\uac15 \uc815\ubcf4 \uc138\ud2b8\ub97c \uc9c0\uc6d0\ud569\ub2c8\ub2e4.<\/span><\/li>\n
    4. \uac01 \uac1d\uccb4\uc5d0\ub294 \uace0\uc720\ud558\uac8c \uc2dd\ubcc4\ud560 \uc218 \uc788\ub294 'ID' \ud544\ub4dc\uac00 \uc788\uc2b5\ub2c8\ub2e4.<\/span><\/li>\n
    5. \uac1d\uccb4\ub4e4\uc774 \uc11c\ub85c\ub97c \ucc38\uc870\ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4. \ub300\ubd80\ubd84\uc740 '\ud658\uc790' \uac1d\uccb4\uc5d0 \ub300\ud55c \ucc38\uc870\ub97c \uac00\uc9c0\uace0 \uc788\uc2b5\ub2c8\ub2e4.<\/span><\/li>\n<\/ol>\n
      \uce74\uc6b0\uce58\ubca0\uc774\uc2a4\uac00 FHIR\uc5d0 \uc801\ud569\ud55c \uc774\uc720<\/span><\/h3>\n
      \uc704\uc5d0\uc11c \uc5b8\uae09\ud588\ub4ef\uc774 Couchbase\ub294 \uae30\ubcf8\uc801\uc73c\ub85c \ub370\uc774\ud130\ub97c \uc77d\uc744 \uc218 \uc788\ub294 \ubb38\uc11c \ud615\uc2dd\uc778 JSON\uc73c\ub85c \uc800\uc7a5\ud569\ub2c8\ub2e4. \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc740 \ud0a4-\uac12 API\ub97c \uc0ac\uc6a9\ud558\uac70\ub098 Couchbase N1QL \ucffc\ub9ac \uc5b8\uc5b4\ub97c \ud65c\uc6a9\ud558\uc5ec \ubb38\uc11c\ub97c \uc870\uc791\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub9ce\uc740 RDBMS\uc5d0\uc11c\ucc98\ub7fc \uc5f4 \ud615\uc2dd\uc774 \uc544\ub2cc JSON \ud615\uc2dd\uc73c\ub85c \ub370\uc774\ud130\ub97c \uc800\uc7a5\ud558\uba74 \uc0ac\uc6a9\uc790\uac00 \uadf8 \uc548\uc5d0 \uc788\ub294 \uc815\ubcf4\uc5d0 \uc27d\uac8c \uc561\uc138\uc2a4\ud560 \uc218 \uc788\ub2e4\ub294 \uc774\uc810\uc774 \uc788\uc2b5\ub2c8\ub2e4. \ud544\ub4dc, \ubc30\uc5f4 \uac1d\uccb4, \uacc4\uce35 \uac1d\uccb4\uc640 \uac19\uc740 JSON \ubb38\uc11c \uc694\uc18c\ub294 \ucd94\uac00 \uad6c\ubb38 \uc5c6\uc774\ub3c4 \uc0c1\uc704 \uac1d\uccb4\uc5d0\uc11c \uc9c1\uc811 \uc561\uc138\uc2a4\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. <\/span><\/p>\n
      \ub2e4\uc74c\uc740 FHIR\uc5d0\uc11c \uc815\uc758\ud55c \ud658\uc790 \ubb38\uc11c\uc758 \uc608\uc785\ub2c8\ub2e4.<\/span><\/p>\n
      \"HL7<\/p>\n
      FHIR \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc758 \uc758\ubbf8\ub294 SQL\uc5d0 \ub300\ud55c \uae30\ubcf8\uc801\uc778 \uc2e4\ubb34 \uc9c0\uc2dd\uc774 \uc788\ub294 RDBMS \uacbd\ud5d8\uc774 \uc788\ub294 \uc0ac\uc6a9\uc790\uac00 \uae30\uc874 RDBMS\uc640 \ub611\uac19\uc740 \ubc29\uc2dd\uc73c\ub85c FHIR \ud658\uc790 \ubc0f \uad00\ub828 \ub9ac\uc18c\uc2a4\uc5d0 \uc561\uc138\uc2a4\ud560 \uc218 \uc788\ub2e4\ub294 \uac83\uc785\ub2c8\ub2e4.\u00a0<\/span><\/p>\n
      FHIR \ub370\uc774\ud130 \uac80\uc0c9\uc744 \uc704\ud55c Couchbase N1QL<\/h4>\n
      ID\ub85c \ud658\uc790 \ucffc\ub9ac\ud558\uae30<\/strong><\/h5>\n
      SELECT *\r\nFROM fhir_admin res\r\nWHERE res.resourceType='Patient'\r\nAND\u00a0 res.id='e3ae7831-14c8-4d13-a8fb-dad68fa12bc9'<\/pre>\n
      \uc5f0\ub839\ub300\ubcc4 \ud658\uc790 \ucffc\ub9ac<\/strong><\/h5>\n
      SELECT\u00a0 agegroup,count(*)\r\nFROM fhir_admin p\r\n\u00a0\u00a0\u00a0LET age=DATE_DIFF_STR(now_str(),p.birthDate,'year'),\r\n\u00a0\u00a0\u00a0\u00a0agegroup = CASE WHEN age <= 4 THEN 'A - 0-4'\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0WHEN age <= 17 THEN 'B - 5-17'\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0WHEN age <= 49 THEN 'C - 18-49'\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0WHEN age <= 64 THEN 'D - 50-64'\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0ELSE 'E - > 65' END\u00a0\r\nWHERE p.resourceType='Patient'\r\nGROUP BY agegroup<\/pre>\n
        \n
      1. \ud658\uc790\uc758 \ub098\uc774\ub294 \ud604\uc7ac \ub0a0\uc9dc(\uc0dd\ub144\uc6d4\uc77c)\ub97c \uae30\uc900\uc73c\ub85c \uacc4\uc0b0\ud574\uc57c \ud569\ub2c8\ub2e4.<\/li>\n
      2. \uc774 \ucffc\ub9ac\ub294 N1QL LET \uad6c\ubb38\uc744 \uc0ac\uc6a9\ud558\uc5ec '\uc5f0\ub839'\uc744 \uc815\uc758\ud558\uace0 \uc5f0\ub839\uc744 '\uc5f0\ub839 \uadf8\ub8f9'\uc73c\ub85c \ubc84\ud0b7\ud654\ud569\ub2c8\ub2e4.<\/li>\n
      3. \ud45c\uc900 ANSI GROUP BY \ubc0f COUNT\ub294 \uc5f0\ub839\ub300\ubcc4 \ud658\uc790 \uc218\ub97c \ubc18\ud658\ud569\ub2c8\ub2e4.<\/li>\n<\/ol>\n
        \ub610\ud55c Couchbase N1QL\ub85c \ubb38\uc11c\ub97c \uc870\uc778 \ubc0f \uc5b8\uc870\uc778\ud558\ub294 \uae30\ub2a5\uc744 \ud1b5\ud574 \uc0ac\uc6a9\uc790\ub294 \ud658\uc790\uc758 \uad00\ub828 \uc815\ubcf4\ub97c \uc870\ud68c\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
        \ud658\uc790 \ubc0f \ud604\uc7ac \ubbf8\ud574\uacb0 \uc0c1\ud0dc \uc870\ud68c\ud558\uae30\u00a0<\/strong><\/h5>\n
        SELECT ARRAY v FOR v IN p.name WHEN v.`use`='official' END fullname ,\r\n       cc.display\r\nFROM fhir_admin c\r\nINNER JOIN fhir_admin p USE HASH(BUILD) ON split(c.subject.reference,':')[2] = p.id AND p.resourceType='Patient'\r\nUNNEST c.code.coding as cc\r\nWHERE c.resourceType='Condition'\r\nAND EVERY s in c.clinicalStatus.coding SATISFIES s.code != 'resolved' END\r\n<\/pre>\n
          \n
        1. \ud658\uc790\ub294 \uc5ec\ub7ec \uac1c\uc758 \uc774\ub984\uc744 \uac00\uc9c8 \uc218 \uc788\uc73c\uba70, \uc774\ub294 'name' \ubc30\uc5f4\ub85c \ud45c\uc2dc\ub429\ub2c8\ub2e4. \uc774 \ucffc\ub9ac\ub294 ARRAY \uc5f0\uc0b0\uc790\ub97c \uc0ac\uc6a9\ud558\uc5ec \uacf5\uc2dd 'name' \ubc30\uc5f4 \uc694\uc18c\ub9cc \ud544\ud130\ub9c1\ud569\ub2c8\ub2e4.<\/li>\n
        2. \uc774 \ucffc\ub9ac\ub294 'condition' \uac1c\uccb4\uc758 'subject.reference' \ud544\ub4dc \uc77c\ubd80\ub97c 'patient.id'\uc5d0 \uc0ac\uc6a9\ud558\uc5ec 'condition'\uc744 'patient' \uac1c\uccb4\uc5d0 \uc870\uc778\ud569\ub2c8\ub2e4.<\/li>\n
        3. \uac01 '\ud658\uc790'\ub294 \uc5ec\ub7ec \uc870\uac74\uc744 \uac00\uc9c8 \uc218 \uc788\uc73c\ubbc0\ub85c '\uc870\uac74->\ucf54\ub4dc' \ubc30\uc5f4\uc744 \ud3c9\ud0c4\ud654(UNNEST)\ud574\uc57c \ud569\ub2c8\ub2e4.<\/li>\n
        4. '\uc870\uac74'\uc5d0 \ub300\ud574 \uc5ec\ub7ec \uac1c\uc758 '\uc784\uc0c1.\uc0c1\ud0dc'\uac00 \uc788\uc744 \uc218 \uc788\uc9c0\ub9cc \ucffc\ub9ac\ub294 \ud574\uacb0\ub418\uc9c0 \uc54a\uc740 \uc870\uac74\ub9cc \ubc18\ud658\ud558\uba74 \ub429\ub2c8\ub2e4.<\/li>\n<\/ol>\n
          2011\ub144 8\uc6d4 18\uc77c\ubd80\ud130 \uc77c\uc8fc\uc77c\uac04 \ubca0\ubc8c\ub9ac \ubcd1\uc6d0\uc5d0 \uc785\uc6d0\ud588\ub358 \ubaa8\ub4e0 \ud658\uc790 \ubaa9\ub85d<\/strong><\/h5>\n
          SELECT ARRAY v FOR v IN p.name WHEN v.`use`='official' END fullname ,\r\n       p.telecom phonecontact,\r\n       p.address, \r\n       p.communication,\r\n       p.identifier\r\nFROM fhir_admin m\r\n INNER JOIN fhir_admin p ON split(m.subject.reference,':')[2] = p.id AND p.resourceType='Patient' \r\nWHERE m.resourceType='Encounter'\r\nAND DATE_FORMAT_STR(m.period.`start`, '1111-11-11') BETWEEN '2011-08-18' AND '2011-08-25'\r\nAND m.serviceProvider.display = 'BEVERLY HOSPITAL CORPORATION' \r\n<\/pre>\n
            \n
          1. \uc774 \ucffc\ub9ac\ub294 '\ub9cc\ub0a8' \uac1c\uccb4\ub97c \uac80\uc0ac\ud558\uc5ec \uc774 \ud2b9\uc815 \ubcd1\uc6d0\uc5d0\uc11c \uce58\ub8cc\ubc1b\uc740 \ubaa8\ub4e0 '\ud658\uc790'\ub97c \ucc3e\uc2b5\ub2c8\ub2e4.<\/li>\n
          2. ARRAY \uc5f0\uc0b0\uc790\ub294 '\ud658\uc790'\uc758 \uacf5\uc2dd \uc774\ub984\uc744 \uac00\uc838\uc624\ub294 \ub370 \uc0ac\uc6a9\ub429\ub2c8\ub2e4.<\/li>\n<\/ol>\n
            \ubcf4\ud5d8 \uccad\uad6c \uc138\ubd80 \uc815\ubcf4\uac00 \ud3ec\ud568\ub41c \ud658\uc790 \ubaa9\ub85d - \uc11c\ube44\uc2a4 \ubc0f \ube44\uc6a9<\/strong><\/h5>\n
            SELECT  c.patient.reference, cis.display,SUM( c.total.`value`)\r\nFROM fhir_admin c\r\n INNER JOIN fhir_admin p ON split(c.patient.reference,':')[2] = p.id AND p.resourceType='Patient' \r\n UNNEST c.item as ci\r\n UNNEST ci.productOrService.coding as cis\r\nWHERE c.resourceType='Claim'\r\nGROUP by cis.display,c.patient.reference\r\n<\/pre>\n
              \n
            1. '\uccad\uad6c' \uac1c\uccb4\ub97c '\ud658\uc790' \uac1c\uccb4\uc5d0 \uc870\uc778\ud558\uc5ec \ud658\uc790\uc758 \uc138\ubd80 \uc815\ubcf4\uc5d0 \uc561\uc138\uc2a4\ud569\ub2c8\ub2e4.<\/li>\n
            2. '\ud074\ub808\uc784' \uac1d\uccb4\uc5d0\ub294 '\ud074\ub808\uc784->\uc544\uc774\ud15c'\uc5d0 \ub300\ud55c \uc911\ucca9 \ubc30\uc5f4\uc774 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n
            3. '\uccad\uad6c->\ud56d\ubaa9'\uc740 \uce58\ub8cc\uc5d0 \ub300\ud55c \uc124\uba85\uc774 \ud3ec\ud568\ub41c \ubc30\uc5f4 \ucf54\ub529\uc774 \uc788\ub294 '\uc81c\ud488 \ub610\ub294 \uc11c\ube44\uc2a4'\uc5d0 \uc5f0\uacb0\ub429\ub2c8\ub2e4.<\/li>\n
            4. \ube44\uc6a9\uc740 \uccad\uad6c \uc218\uc900\uc785\ub2c8\ub2e4.<\/li>\n<\/ol>\n
              \ubcd1\uc6d0\ubcc4 \uc808\ucc28 \uc218 \uc21c\uc704<\/strong><\/h5>\n
              SELECT e.serviceProvider.display hospital,\r\n       p.code.text treatment,\r\n       RANK() OVER ( PARTITION BY e.serviceProvider.display ORDER BY COUNT(p.code.text) DESC ) serviceRank\r\nFROM fhir_admin p\r\n  INNER JOIN fhir_admin e USE HASH(PROBE) ON split(p.encounter.reference,':')[2] = e.id and e.resourceType='Encounter'\r\nWHERE p.resourceType='Procedure'\r\nGROUP by e.serviceProvider.display,p.code.text<\/pre>\n
                \n
              1. 'procedure' \uac1c\uccb4\ub97c 'encounter' \uac1c\uccb4\uc5d0 \uc870\uc778\ud558\uc5ec \uc2dc\uc220\uc744 \uc2dc\ud589\ud55c \ubcd1\uc6d0\uc5d0 \uc561\uc138\uc2a4\ud569\ub2c8\ub2e4.<\/li>\n
              2. N1QL \ucc3d RANK \ud568\uc218\ub294 \ud504\ub85c\uc2dc\uc800\uc758 \uac1c\uc218\ub9cc\ud07c \uac12\uc744 \ud560\ub2f9\ud558\ub294 \ub370 \uc0ac\uc6a9\ub429\ub2c8\ub2e4.<\/li>\n
              3. \ud574\uc2dc \uc870\uc778 \ud78c\ud2b8\ub294 \ubb38\uc11c JOIN\uc758 \uc131\ub2a5\uc744 \uac1c\uc120\ud558\ub294 \ub370 \uc0ac\uc6a9\ub429\ub2c8\ub2e4.<\/li>\n<\/ol>\n
                \uc694\uc57d<\/h3>\n
                Couchbase\ub294 \ub370\uc774\ud130\ub97c JSON \ud615\uc2dd\uc73c\ub85c \uc800\uc7a5\ud558\ub294 \ub370 \uc0ac\uc6a9\ud558\ub294 \uc811\uadfc \ubc29\uc2dd \ub54c\ubb38\uc5d0 FHIR \uad6c\ud604\uc5d0 \ub9e4\uc6b0 \uc801\ud569\ud569\ub2c8\ub2e4. \uac15\ub825\ud55c N1QL \ucffc\ub9ac \uc5b8\uc5b4\ub97c \ud1b5\ud574 SQL \uacbd\ud5d8\uc774 \uc788\ub294 \uac1c\ubc1c\uc790\ub294 FHIR \ub370\uc774\ud130 \ubaa8\ub378\uc744 \ud0d0\uc0c9\ud558\uc5ec \uc0ac\uc6a9\uc790\uac00 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\uc11c \uae30\ub300\ud560 \uc218 \uc788\ub294 \ubaa8\ub4e0 CRUD \uc791\uc5c5\uc744 \uc218\ud589\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
                \ubb38\uc11c \uc870\uc778\ubd80\ud130 \uc784\ubca0\ub514\ub4dc \ubc30\uc5f4 \uac1d\uccb4\uc758 \uace0\uae09 \ucc98\ub9ac\uae4c\uc9c0 \uc218\ud589\ud560 \uc218 \uc788\ub294 \uae30\ub2a5\uc744 \uac16\ucd98 N1QL \ucffc\ub9ac \uc5b8\uc5b4\ub294 \ubaa8\ub4e0 \ucc98\ub9ac \uc694\uad6c \uc0ac\ud56d\uc744 Couchbase \ucffc\ub9ac \ubc0f \uc778\ub371\uc2f1 \uc11c\ube44\uc2a4\ub85c \uc774\uc804\ud558\uc5ec, \ubaa8\ub4e0 \uac1d\uccb4 \uc5f0\uacb0\uc744 \uc218\ud589\ud574\uc57c \ud558\ub294 FHIR \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc758 \ubd80\ub2f4\uc744 \uc904\uc5ec\uc90d\ub2c8\ub2e4.<\/p>\n
                \uc0c8\ub85c\uc6b4 \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uacfc \ub9c8\ucc2c\uac00\uc9c0\ub85c, \uc560\ud50c\ub9ac\ucf00\uc774\uc158 \uad00\ub9ac\uc790\ub098 \ub370\uc774\ud130 \ubd84\uc11d\uac00\uac00 \uae30\ubcf8 FHIR \uac80\uc0c9 \uae30\ub2a5\uc744 \ub118\uc5b4\uc11c\ub294 \uac80\uc0c9\uc744 \uc218\ud589\ud574\uc57c \ud560 \ud544\uc694\uac00 \uc788\ub294 \uacbd\uc6b0 \ud56d\uc0c1 \uae30\ucd08 \ub370\uc774\ud130\ub97c \uc9c1\uc811 \uac80\uc0ac\ud574\uc57c \ud560 \ud544\uc694\uac00 \uc788\uc744 \uac83\uc785\ub2c8\ub2e4.<\/p>\n
                \ub2e4\uc74c \ube14\ub85c\uadf8\uc5d0\uc11c\ub294 Couchbase \uc11c\ubc84\uc640 \ud1b5\uc2e0\ud558\uc5ec \uae30\ubcf8 \uae30\ub2a5\uc744 \uc81c\uacf5\ud560 \uc218 \uc788\ub294 FHIR API \uc811\uadfc \ubc29\uc2dd\uc5d0 REST\ub97c \uc0ac\uc6a9\ud558\ub294 \ub370 \ud544\uc694\ud55c \uc0ac\ud56d\uc744 \uc0b4\ud3b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4. FHIR \uac80\uc0c9 \uc694\uad6c \uc0ac\ud56d.<\/a><\/p>\n
                \ub9ac\uc18c\uc2a4<\/h3>\n