{"id":2271,"date":"2021-11-19T17:00:52","date_gmt":"2021-11-19T08:00:52","guid":{"rendered":"https:\/\/www.dbsheetclient.jp\/blog\/?p=2271"},"modified":"2021-11-19T17:19:00","modified_gmt":"2021-11-19T08:19:00","slug":"%e3%83%a1%e3%83%a2%e3%83%aa%e6%9c%80%e9%81%a9%e5%8c%96%e3%83%86%e3%83%bc%e3%83%96%e3%83%ab%e5%a4%89%e6%95%b0%ef%bc%88sql-server%ef%bc%89","status":"publish","type":"post","link":"https:\/\/www.dbsheetclient.jp\/blog\/?p=2271","title":{"rendered":"\u30e1\u30e2\u30ea\u6700\u9069\u5316\u30c6\u30fc\u30d6\u30eb\u5909\u6570\uff08SQL Server\uff09"},"content":{"rendered":"

IT\u30b3\u30fc\u30c7\u30a3\u30cd\u30fc\u30bf\u306e\u30b7\u30e5\u30a6\u3067\u3059\u3002<\/p>\n

\"IMG_4486\"<\/a><\/p>\n

\u3053\u306e\u5199\u771f\u306f\u3001\u524d\u56de\u306e\u30d6\u30ed\u30b0<\/a>\u3067\u5199\u771f\u3092\u8f09\u305b\u305f\u3001\u5927\u6839\u5cf6\u306b\u3042\u308b\u300c\u7531\u5fd7\u5712\u300d\u306b\u884c\u3063\u305f\u3068\u304d\u306b\u3001\u3064\u3044\u3067\u306b\u8a2a\u308c\u305f\u3001\u5cf6\u6839\u534a\u5cf6\u306e\u5148\u306e\u307b\u3046\u306b\u3042\u308b\u300c\u7f8e\u4fdd\u795e\u793e\u300d\u3067\u64ae\u3063\u305f\u3082\u306e\u3067\u3059\u3002\u79c1\u3082\u9ad8\u6821\u751f\u306e\u6642\u306b\u4e00\u5ea6\u5144\u306b\u9023\u308c\u3066\u884c\u3063\u3066\u3082\u3089\u3063\u305f\u3053\u3068\u304c\u3042\u3063\u305f\u3068\u3044\u3046\u304b\u3059\u304b\u306a\u8a18\u61b6\u304c\u3042\u308a\u307e\u3057\u305f\u304c\u3001\u305d\u308c\u4ee5\u6765\u306a\u306e\u3067\u3001\u307b\u3068\u3093\u3069\u521d\u3081\u3066\u3068\u3044\u3046\u611f\u3058\u3067\u3057\u305f\u3002\u3053\u306e\u795e\u793e\u306e\u796d\u795e\u306f\u3001\u3048\u3073\u3059\u69d8\uff08\u4e8b\u4ee3\u4e3b\u795e\uff09\u3068\u5927\u56fd\u4e3b\u795e\u306e\u540e\u306e\u4e09\u7a42\u6d25\u59eb\u3067\u3001\u5546\u58f2\u7e41\u76db\u3001\u6d77\u4e0a\u5b89\u5168\u3001\u4e94\u7a40\u8c4a\u7a63\u3001\u592b\u5a66\u548c\u5408\u306a\u3069\u306e\u5b88\u8b77\u795e\u3068\u3057\u3066\u7940\u3089\u308c\u3066\u3044\u307e\u3059\u3002\u5b9f\u5bb6\u304c\u3001\u6bce\u5e74\u3001\u6b63\u6708\u306b\u306f\u7f8e\u4fdd\u795e\u793e\u306e\u304a\u672d\u3092\u9001\u3063\u3066\u3082\u3089\u3046\u3088\u3046\u306b\u3057\u3066\u3044\u308b\u3068\u3044\u3046\u3053\u3068\u3092\u3001\u9053\u3059\u304c\u3089\u521d\u3081\u3066\u805e\u304d\u307e\u3057\u305f\u3002\u7236\u89aa\u3082\u6570\u5341\u5e74\u3076\u308a\u306b\u53c2\u308b\u3053\u3068\u304c\u3067\u304d\u305f\u3068\u559c\u3093\u3067\u3044\u305f\u306e\u3067\u3001\u5c11\u3057\u9060\u56de\u308a\u306b\u306f\u306a\u308a\u307e\u3057\u305f\u304c\u3001\u884c\u3063\u3066\u826f\u304b\u3063\u305f\u3068\u601d\u3044\u307e\u3059\u3002

\uff1c\u672c\u65e5\u306e\u984c\u6750\uff1e
<\/strong>\u30e1\u30e2\u30ea\u6700\u9069\u5316\u30c6\u30fc\u30d6\u30eb\u5909\u6570\uff08SQL Server<\/strong>\uff09<\/p>\n

<\/strong>SQL Server2014\u304b\u3089\u5b9f\u88c5\u3055\u308c\u305fIn-Memory OLTP \u6a5f\u80fd\u306b\u3001\u30e1\u30e2\u30ea\u6700\u9069\u5316\u30c6\u30fc\u30d6\u30eb\u3068\u3044\u3046\u3082\u306e\u304c\u3042\u308a\u307e\u3059\u3002\u4eca\u307e\u3067\u3042\u307e\u308a\u8a66\u3057\u305f\u3053\u3068\u304c\u306a\u304b\u3063\u305f\u306e\u3067\u3059\u304c\u3001\u4eca\u56de\u306f\u3001\u305d\u306e\u30e1\u30e2\u30ea\u6700\u9069\u5316\u30c6\u30fc\u30d6\u30eb\u5909\u6570\u3068\u3044\u3046\u3082\u306e\u3092\u8a66\u3057\u3066\u307f\u305f\u3044\u3068\u601d\u3044\u307e\u3059\u3002<\/p>\n

\u4f8b)
\u30c6\u30b9\u30c8\u7528\u30c6\u30fc\u30d6\u30eb\u3092\u4f5c\u6210\u3057\u3001\u30c6\u30b9\u30c8\u30c7\u30fc\u30bf\u309250\u4e07\u4ef6\u4f5c\u6210\u3057\u307e\u3059\u3002\u305d\u3053\u304b\u3089\u691c\u7d22\u3057\u305f\u3044\u30c7\u30fc\u30bf\u3092\u62bd\u51fa\u3057\u3001\u30c6\u30b9\u30c8\u7528\u30c6\u30fc\u30d6\u30eb\u306e\u5217\u5b9a\u7fa9\u3068\u540c\u3058\u8a2d\u5b9a\u306e\u30e1\u30e2\u30ea\u6700\u9069\u5316\u30c6\u30fc\u30d6\u30eb\u5909\u6570\u306b\u767b\u9332\u3057\u3066\u3001\u7d50\u679c\u3092\u62bd\u51fa\u3057\u3066\u307f\u307e\u3059\u3002<\/p>\n

\u307e\u305a\u3001\u30e1\u30e2\u30ea\u6700\u9069\u5316\u6a5f\u80fd\u3092\u4f7f\u7528\u3059\u308b\u305f\u3081\u306b\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b MEMORY_OPTIMIZED_DATA \u3067\u5ba3\u8a00\u3055\u308c\u305f FILEGROUP\u3092\u4f5c\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002\u4eca\u56de\u306f\u3001\u65e2\u5b58\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u300cBLOG\u300d\u306b\u8ffd\u52a0\u3057\u307e\u3059\u3002<\/p>\n

ALTER DATABASE BLOG ADD FILEGROUP BLOG_mod CONTAINS MEMORY_OPTIMIZED_DATA;<\/p>\n

ALTER DATABASE BLOG ADD FILE (name=’BLOG_mod1′, filename=’C:\\Program Files\\Microsoft SQL Server\\MSSQL12.MSSQLSERVER\\MSSQL\\DATA\\iBLOG_mod1′) TO FILEGROUP BLOG_mod;<\/p>\n

\"blog102_2\"<\/a><\/p>\n

\u6b21\u306b\u3001\u30c7\u30fc\u30bf\u3092\u767b\u9332\u3059\u308b\u300c mem_test\u300d\u30c6\u30fc\u30d6\u30eb\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002<\/p>\n

CREATE TABLE mem_test(
id numeric(8)
,\u540d\u524d nvarchar(20)
,\u533a\u5206 nvarchar(2)
,\u30dd\u30a4\u30f3\u30c8 int
,Constraint PK_mem_teste Primary key(id));<\/p>\n

\"blog102_3\"
<\/a>
\u3053\u306e\u30c6\u30fc\u30d6\u30eb\u306b\u30c6\u30b9\u30c8\u30c7\u30fc\u30bf\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002\u4eca\u56de\u306f\u300150\u4e07\u4ef6\u3092\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u4f5c\u6210\u3057\u307e\u3059\u3002\u300cid\u300d\u9805\u76ee\u306b\u306f\u30011\uff5e500000\u307e\u3067\u30b7\u30fc\u30b1\u30f3\u30b7\u30e3\u30eb\u306b\u5024\u3092\u8a2d\u5b9a\u3057\u3001\u540d\u524d\u306f\u300c\u9867\u5ba2\u540d_\u300d\u306e\u5f8c\u306bid\u3092\u982d0\u57cb\u3081\u3067\u8a2d\u5b9a\u3001\u533a\u5206\u306f2\u6841\u3067\u300110,20,30, \uff5e90\u307e\u3067\u3092\u30e9\u30f3\u30c0\u30e0\u306b\u3001\u30dd\u30a4\u30f3\u30c8\u306f\u30011\uff5e100\u306e\u6574\u6570\u3092\u30e9\u30f3\u30c0\u30e0\u306b\u767b\u9332\u3057\u3066\u307f\u307e\u3059\u3002\u30e9\u30f3\u30c0\u30e0\u306b\u5024\u3092\u8a2d\u5b9a\u3059\u308b\u306e\u306f\u3001RAND\u95a2\u6570\u3068\u3001NewID\u95a2\u6570\u3092\u4f7f\u7528\u3057\u3066\u307f\u307e\u3059\u3002<\/p>\n

–\u30c7\u30fc\u30bf\u306e\u4f5c\u6210
DECLARE\u00a0@i int = 0
WHILE @i < 500000
BEGIN
\u00a0 \u00a0SET @i = @i + 1
\u00a0 \u00a0INSERT INTO mem_test(id, \u540d\u524d, \u533a\u5206, \u30dd\u30a4\u30f3\u30c8)
\u00a0 \u00a0VALUES(@i, ‘\u9867\u5ba2\u540d_’+ RIGHT(‘000000’+CAST(@i as nvarchar),6), CAST(FLOOR(1 + RAND()*9)*10 AS NVARCHAR), 1+ABS(CHECKSUM(NewId())) % 100)
END<\/p>\n

\"blog102_4\"<\/p>\n

<\/a>\u30e9\u30f3\u30c0\u30e0\u5024\u306b\u3064\u3044\u3066\u3067\u3059\u304c\u3001RAND\u95a2\u6570\u306f\u30010\uff5e1\u306e\u9593\u306e\u6570\u304c\u751f\u6210\u3055\u308c\u308b\u306e\u3067\u3001\u6307\u5b9a\u7bc4\u56f2\u5185\u306e\u6574\u6570\u5024\u4e71\u6570\u304c\u5fc5\u8981\u306a\u5834\u5408\u306f\u3001
SELECT FLOOR([FROM\u5024] + (RAND() * ([TO\u5024] – [FROM\u5024] + 1)))
\u306e\u3088\u3046\u306b\u3059\u308c\u3070\u53d6\u5f97\u3067\u304d\u307e\u3059\u3002\u4eca\u56de\u306f\u300110,20,..,90 \u3068\u3044\u3046\u6587\u5b57\u578b\u306e\u5024\u306b\u3057\u305f\u304b\u3063\u305f\u306e\u3067\u3001CAST(FLOOR(1 + RAND()*9)*10 AS NVARCHAR) \u3068\u3057\u307e\u3057\u305f\u3002
\u307e\u305f\u3001NEWID\u95a2\u6570\u306f\u3001uniqueidentifier \u30c7\u30fc\u30bf\u578b\u306e\u5024\u3092\u8fd4\u3057\u3066\u304d\u307e\u3059\u304c\u3001\u30c7\u30fc\u30bf\u3092\u6570\u5024\u306b\u3057\u3066\u30c1\u30a7\u30c3\u30af\u3059\u308bCHECKSUM\u95a2\u6570\u3068\u3001\u8ca0\u306e\u6570\u304c\u8fd4\u3063\u3066\u304f\u308b\u5834\u5408\u3082\u3042\u308b\u305f\u3081\u7d76\u5bfe\u5024\u3092\u53d6\u5f97\u3059\u308bABS\u95a2\u6570\u3092\u4f7f\u3044\u3001\u3055\u3089\u306b\u6c42\u3081\u308b\u5024\u306e\u7bc4\u56f2\u3092\u8003\u616e\u3057\u3066\u3001\u4eca\u56de\u306f1\uff5e100\u307e\u3067\u306e\u5024\u306e\u305f\u3081\u3001100\u3067\u5272\u3063\u305f\u4f59\u308a\u3092\u4f7f\u3046\u304b\u305f\u3061\u3067\u30011+ABS(CHECKSUM(NewId())) % 100\u3000\u3068\u3057\u307e\u3057\u305f\u3002<\/p>\n

\u30c7\u30fc\u30bf\u3092\u78ba\u8a8d\u3057\u3066\u307f\u307e\u3059\u3002
SELECT * FROM mem_test
ORDER BY id;<\/p>\n

\"blog102_5\"<\/a><\/p>\n

\u533a\u5206\u3068\u30dd\u30a4\u30f3\u30c8\u306f\u30e9\u30f3\u30c0\u30e0\u306b\u5024\u304c\u767b\u9332\u3055\u308c\u3066\u3044\u308b\u306e\u304c\u78ba\u8a8d\u3067\u304d\u307e\u3057\u305f\u3002
\u305d\u308c\u3067\u306f\u3001\u30e1\u30e2\u30ea\u6700\u9069\u5316\u30c6\u30fc\u30d6\u30eb\u5909\u6570\u3092\u4f7f\u7528\u3059\u308b\u305f\u3081\u306b\u3001\u305d\u306e\u305f\u3081\u306e\u30e6\u30fc\u30b6\u30fc\u5b9a\u7fa9\u30c6\u30fc\u30d6\u30eb\u578b\u3092\u5ba3\u8a00\u3057\u307e\u3059\u3002\u901a\u5e38\u3068\u9055\u3046\u306e\u306f\u3001\u300cMEMORY_OPTIMIZED = ON\u300d\u3092\u4ed8\u3051\u308b\u3053\u3068\u3068\u3001\u30cf\u30c3\u30b7\u30e5\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u3092\u4ed8\u4e0e\u3059\u308b\u70b9\u304c\u7570\u306a\u308a\u307e\u3059\u3002<\/p>\n

CREATE TYPE mem_test_type AS TABLE
(id numeric(8)
,\u540d\u524d nvarchar(20)
,\u533a\u5206 nvarchar(2)
,\u30dd\u30a4\u30f3\u30c8 int
,INDEX idx1 NONCLUSTERED HASH (id) WITH ( BUCKET_COUNT = 500000 )
) WITH ( MEMORY_OPTIMIZED = ON );<\/p>\n

\"blog102_6\"<\/a><\/p>\n

\u203bHASH\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u3067\u306f\u3001BUCKET_COUNT\uff08\u30d0\u30b1\u30c3\u30c8\u6570\uff09\u3092\u9069\u5207\u306a\u5024\u3078\u8a2d\u5b9a\u3057\u3066\u3044\u306a\u3044\u3068\u3001\u6027\u80fd\u4f4e\u4e0b\u306e\u539f\u56e0\u306b\u7e4b\u304c\u308b\u3088\u3046\u3067\u3059\u3002\uff08\u7279\u306b\u5c0f\u3055\u3059\u304e\u308b\u3068\u6027\u80fd\u304c\u5927\u304d\u304f\u3055\u304c\u308b\u3068\u306e\u3053\u3068\uff09<\/p>\n

\u3061\u306a\u307f\u306b\u3001\u6700\u521d\u306b\u884c\u3063\u305f\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b MEMORY_OPTIMIZED_DATA \u3067\u5ba3\u8a00\u3055\u308c\u305f FILEGROUP\u3092\u4f5c\u6210\u3057\u3066\u3044\u306a\u304b\u3063\u305f\u5834\u5408\u306b\u306f\u3001\u4e0a\u8a18\u306e\u30bf\u30a4\u30d7\u3092\u4f5c\u6210\u3057\u3088\u3046\u3068\u3057\u305f\u3068\u304d\u306b\u3001\u300c\u30e1\u30e2\u30ea\u6700\u9069\u5316\u30c6\u30fc\u30d6\u30eb \u3092\u4f5c\u6210\u3067\u304d\u307e\u305b\u3093\u3002\u30e1\u30e2\u30ea\u6700\u9069\u5316\u30c6\u30fc\u30d6\u30eb \u3092\u4f5c\u6210\u3059\u308b\u306b\u306f\u3001\u30aa\u30f3\u30e9\u30a4\u30f3\u72b6\u614b\u304b\u3064 1 \u3064\u4ee5\u4e0a\u306e\u30b3\u30f3\u30c6\u30ca\u30fc\u304c\u3042\u308b MEMORY_OPTIMIZED_FILEGROUP \u304c\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u542b\u307e\u308c\u3066\u3044\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002\u300d\u3068\u3044\u3046\u30a8\u30e9\u30fc\u304c\u51fa\u307e\u3059\u3002<\/p>\n

\"blog102_8\"<\/a><\/p>\n

\u305d\u308c\u3067\u306f\u3001\u4e0a\u8a18\u3092\u4f7f\u3063\u3066\u30e1\u30e2\u30ea\u6700\u9069\u5316\u30c6\u30fc\u30d6\u30eb\u5909\u6570\u3092\u5ba3\u8a00\u3057\u3001\u6307\u5b9a\u3057\u305f5\u3064\u306e\u533a\u5206\u306b\u3064\u3044\u3066\u306e\u30c7\u30fc\u30bf\u4ef6\u6570\u3092\u78ba\u8a8d\u3057\u3066\u307f\u305f\u3044\u3068\u601d\u3044\u307e\u3059\u3002<\/p>\n

— \u30e1\u30e2\u30ea\u6700\u9069\u5316\u30c6\u30fc\u30d6\u30eb\u5909\u6570\u306e\u5ba3\u8a00
DECLARE @retValue dbo.mem_test_type<\/p>\n

— \u30e1\u30e2\u30ea\u6700\u9069\u5316\u30c6\u30fc\u30d6\u30eb\u3078\u30c7\u30fc\u30bf\u306e INSERT
DECLARE
\u00a0 \u00a0 \u00a0 \u00a0@\u533a\u52061 nvarchar(2) = ’20’,
\u00a0 \u00a0 \u00a0 \u00a0@\u533a\u52062 nvarchar(2) = ’40’,
\u00a0 \u00a0 \u00a0 \u00a0@\u533a\u52063 nvarchar(2) = ’50’,
\u00a0 \u00a0 \u00a0 \u00a0@\u533a\u52064 nvarchar(2) = ’70’,
\u00a0 \u00a0 \u00a0 \u00a0@\u533a\u52065 nvarchar(2) = ’90’;
\u00a0
\u00a0 \u00a0INSERT INTO @retValue
\u00a0 \u00a0SELECT id, \u540d\u524d, \u533a\u5206, \u30dd\u30a4\u30f3\u30c8
\u00a0 \u00a0FROM dbo.mem_test
\u00a0 \u00a0WHERE \u533a\u5206 = @\u533a\u52061
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 OR \u533a\u5206 = @\u533a\u52062
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 OR \u533a\u5206 = @\u533a\u52063
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 OR \u533a\u5206 = @\u533a\u52064
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 OR \u533a\u5206 = @\u533a\u52065
\u00a0
— \u30e1\u30e2\u30ea\u6700\u9069\u5316\u30c6\u30fc\u30d6\u30eb\u5909\u6570\u306b\u683c\u7d0d\u3057\u305f\u7d50\u679c\u3092\u96c6\u8a08
SELECT \u533a\u5206, COUNT(*) \u4ef6\u6570
FROM @retValue
GROUP BY \u533a\u5206
ORDER BY \u533a\u5206;<\/p>\n

\"blog102_7\"<\/p>\n

<\/a>\u307b\u3068\u3093\u3069\u6642\u9593\u306f\u304b\u304b\u3089\u305a\u306b\u7d50\u679c\u304c\u62bd\u51fa\u3055\u308c\u3066\u304d\u307e\u3057\u305f\u3002
\u30e1\u30e2\u30ea\u6700\u9069\u5316\u30c6\u30fc\u30d6\u30eb\u5909\u6570\u3092\u3001\u4e00\u6642\u30c6\u30fc\u30d6\u30eb\u306e\u3088\u3046\u306a\u304b\u305f\u3061\u3067\u4f7f\u7528\u3067\u304d\u308b\u3053\u3068\u304c\u78ba\u8a8d\u3067\u304d\u307e\u3057\u305f\u304c\u3001\u5b9f\u969b\u306b\u306f\u3001\u3082\u3063\u3068\u9069\u3057\u305f\u4f7f\u7528\u6cd5\u304c\u3042\u308b\u306e\u3067\u306f\u306a\u3044\u304b\u3068\u601d\u3044\u307e\u3059\u3002\u4eca\u56de\u306f\u3001\u53d6\u308a\u3042\u3048\u305a\u4f7f\u3048\u308b\u3053\u3068\u3092\u78ba\u8a8d\u3057\u3066\u307f\u307e\u3057\u305f\u3002<\/p>\n

\u4eca\u65e5\u306f\u4ee5\u4e0a\u307e\u3067<\/p>\n","protected":false},"excerpt":{"rendered":"

IT\u30b3\u30fc\u30c7\u30a3\u30cd\u30fc\u30bf\u306e\u30b7\u30e5\u30a6\u3067\u3059\u3002 \u3053\u306e\u5199\u771f\u306f\u3001\u524d\u56de\u306e\u30d6\u30ed\u30b0\u3067\u5199\u771f\u3092\u8f09\u305b\u305f\u3001\u5927\u6839\u5cf6\u306b\u3042\u308b\u300c\u7531\u5fd7\u5712\u300d\u306b\u884c\u3063\u305f\u3068\u304d\u306b\u3001\u3064\u3044\u3067\u306b\u8a2a\u308c\u305f\u3001\u5cf6\u6839\u534a\u5cf6\u306e\u5148\u306e\u307b\u3046\u306b\u3042\u308b\u300c\u7f8e\u4fdd\u795e\u793e\u300d\u3067\u64ae\u3063\u305f\u3082\u306e\u3067\u3059\u3002\u79c1\u3082\u9ad8\u6821\u751f\u306e\u6642\u306b\u4e00\u5ea6\u5144\u306b\u9023\u308c\u3066\u884c\u3063\u3066\u3082 […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"enabled":false},"version":2}},"categories":[38,31,9],"tags":[],"class_list":["post-2271","post","type-post","status-publish","format-standard","hentry","category-38","category-31","category-9"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.dbsheetclient.jp\/blog\/index.php?rest_route=\/wp\/v2\/posts\/2271","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbsheetclient.jp\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbsheetclient.jp\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbsheetclient.jp\/blog\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbsheetclient.jp\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2271"}],"version-history":[{"count":16,"href":"https:\/\/www.dbsheetclient.jp\/blog\/index.php?rest_route=\/wp\/v2\/posts\/2271\/revisions"}],"predecessor-version":[{"id":2296,"href":"https:\/\/www.dbsheetclient.jp\/blog\/index.php?rest_route=\/wp\/v2\/posts\/2271\/revisions\/2296"}],"wp:attachment":[{"href":"https:\/\/www.dbsheetclient.jp\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2271"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbsheetclient.jp\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2271"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbsheetclient.jp\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2271"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}