/
ํƒœ๊ทธ ๋ฐ์ดํ„ฐ์˜ ์ž…๋ ฅ

ํƒœ๊ทธ ๋ฐ์ดํ„ฐ์˜ ์ž…๋ ฅ

ํƒœ๊ทธ ๋ฐ์ดํ„ฐ๋ฅผ ์ž…๋ ฅํ•˜๊ธฐ ์œ„ํ•ด์„œ๋Š” ์•„๋ž˜์™€ ๊ฐ™์€ ๋‹ค์–‘ํ•œ ๋ฐฉ๋ฒ•์„ ํ™œ์šฉํ•  ์ˆ˜ ์žˆ๋‹ค.


INSERT ๊ตฌ๋ฌธ์„ ํ†ตํ•ด ์ž…๋ ฅํ•˜๊ธฐ



๊ฐ€์žฅ ๊ฐ„๋‹จํ•œ ๋ฐฉ๋ฒ•์œผ๋กœ ์•„๋ž˜์™€ ๊ฐ™์ด INSERT ๊ตฌ๋ฌธ์„ ํ†ตํ•ด ์ž…๋ ฅํ•  ์ˆ˜ ์žˆ๋‹ค.

๊ฐ„๋‹จํ•˜๊ฒŒ ํ…Œ์ŠคํŠธ ์šฉ๋„๋กœ ํ•  ์ˆ˜ ์žˆ๋Š” ๋ฐฉ๋ฒ•์ด๊ณ , ๋งŒ์ผ ๋Œ€๋Ÿ‰์˜ ๋ฐ์ดํ„ฐ๋ฅผ ๋นจ๋ฆฌ ๋„ฃ๊ณ ์ž ํ•  ๊ฒฝ์šฐ์—๋Š” ๋‹ค๋ฅธ ๋ฐฉ๋ฒ•์„ ํ™œ์šฉํ•œ๋‹ค.

Mach> create tagdata table TAG (name varchar(20) primary key, time datetime basetime, value double summarized);
Executed successfully.

Mach>  insert into tag metadata values ('TAG_0001');
1 row(s) inserted.

Mach> insert into tag values('TAG_0001', now, 0);
1 row(s) inserted.

Mach> insert into tag values('TAG_0001', now, 1);
1 row(s) inserted.

Mach> insert into tag values('TAG_0001', now, 2);
1 row(s) inserted.

Mach> select * from tag where name = 'TAG_0001';
NAME                  TIME                            VALUE                       
--------------------------------------------------------------------------------------
TAG_0001              2018-12-19 17:41:37 806:901:728 0                           
TAG_0001              2018-12-19 17:41:42 327:839:368 1                           
TAG_0001              2018-12-19 17:41:43 812:782:202 2                           
[3] row(s) selected.

์œ„์™€ ๊ฐ™์ด 3๊ฐœ์˜ TAG ๊ฐ’์„ ํ˜„์žฌ์˜ ์‹œ๊ฐ„์œผ๋กœ ๋„ฃ์–ด ๋ณด์•˜๋‹ค.

๋ชฉ์ฐจ



CSV ํŒŒ์ผ์„ ํ†ตํ•ด ํ•œ๊บผ๋ฒˆ์— ๋กœ๋”ฉํ•˜๊ธฐ


๋งˆํฌ๋ฒ ์ด์Šค๋Š” csvimport ๋ผ๋Š” ๋„๊ตฌ๋ฅผ ํ†ตํ•ด์„œ CSV ํŒŒ์ผ ๋Œ€๋Ÿ‰์œผ๋กœ ๋กœ๋”ฉํ•  ์ˆ˜ ์žˆ๋„๋ก ํ•ด ์ค€๋‹ค.

๋” ์ž์„ธํ•œ ๋‚ด์šฉ์€ ์‹ค์ œ ์˜ˆ์ œ๋ฅผ ํ†ตํ•ด์„œ ํŒŒ์•…ํ•  ์ˆ˜ ์žˆ์œผ๋ฉฐ, ์•„๋ž˜์— ๊ฐ„๋‹จํ•˜๊ฒŒ ๊ธฐ์ˆ ํ•œ๋‹ค.

CSV ํŒŒ์ผ ํ˜•ํƒœ (data.csv)

TAG_0001, 2009-01-28 07:03:34 0:000:000, -41.98
TAG_0001, 2009-01-28 07:03:34 1:000:000, -46.50
TAG_0001, 2009-01-28 07:03:34 2:000:000, -36.16
....

์œ„์™€ ๊ฐ™์ด <ํƒœ๊ทธ๋ช…, ์‹œ๊ฐ„, ๊ฐ’> ์œผ๋กœ ๊ตฌ์„ฑ๋œ csv ํŒŒ์ผ ์ค€๋น„ํ•œ๋‹ค.

๋ฌผ๋ก , ํƒœ๊ทธ๋ช… TAG_0001์ด ์กด์žฌํ•ด์•ผ ํ•œ๋‹ค.

๋กœ๋”ฉ ํ”„๋กœ๊ทธ๋žจ csvimportย  ์‚ฌ์šฉ

csvimport -t TAG -d data.csv -F "time YYYY-MM-DD HH24:MI:SS mmm:uuu:nnn" -l error.log

TAG๋ผ๋Š” ํ…Œ์ด๋ธ”์— data.csv๋ฅผ ๋กœ๋”ฉํ•œ๋‹ค.

๊ทธ๋ฆฌ๊ณ , -F ์˜ต์…˜์€ data.csv์— ์ €์žฅ๋œ ์‹œ๊ฐ„ ํฌ๋งท์„ ์ง€์ •ํ•˜๋Š” ๊ฒƒ์ธ๋ฐ, ํ˜„์žฌ ํŒŒ์ผ์€ ๋‚˜๋…ธ ๋‹จ์œ„๊นŒ์ง€ ๊ฐ’์„ ๋„ฃ์„ ์ˆ˜ ์žˆ๋„๋ก ๋˜์–ด ์žˆ๋‹ค.

๋˜ํ•œ, -l error.log ๋Š” ์ž…๋ ฅ์‹œ ๋ฐœ์ƒํ•œ ์—๋Ÿฌ์— ๋Œ€ํ•ด ๋ณ„๋„์˜ ํŒŒ์ผ๋กœ ๊ธฐ๋กํ•˜๋Š” ๊ฒƒ์ด๋‹ค.


RESTful API๋ฅผ ํ†ตํ•ด ์ž…๋ ฅํ•˜๊ธฐ


RESTful API์˜ ๋” ์ž์„ธํ•œ ์‚ฌ์šฉ๋ฒ•์€ ๋‹ค์Œ์˜ ํ™œ์šฉ ์˜ˆ์ œ๋ฅผ ์ฐธ๊ณ ํ•˜๋„๋ก ํ•œ๋‹ค.

์ž…๋ ฅ API ๋ฌธ๋ฒ•

๋งˆํฌ๋ฒ ์ด์Šค๋Š” ๋‹ค์Œ๊ณผ ๊ฐ™์ด RESTful API๋ฅผ ์ œ๊ณตํ•œ๋‹ค.

{
 "values":[
     [TAG_NAME, TAG_TIME, VALUE],  # ํƒœ๊ทธ๋ช…,์‹œ๊ฐ„,๊ฐ’์„ ์ž…๋ ฅํ•œ๋‹ค. TAG ํ˜•ํƒœ์— ๋”ฐ๋ผ ๋ถ€๊ฐ€ ์ปฌ๋Ÿผ ์ถ”๊ฐ€ ํ•„์š” 
     [ .... ]....
 ], 
 "date_format":"Date Format"       # date_format์€ ์ƒ๋žต์‹œ 'YYYY-MM-DD HH24:MI:SS mmm:uuu:nnn' ๋กœ ์„ค์ •๋œ๋‹ค.
}

์ •์˜๋œ TAG ์Šคํ‚ค๋งˆ์˜ย  ์ปฌ๋Ÿผ ๊ฐฏ์ˆ˜๋งŒํผ์˜ ๊ฐ’์„ ์œ„์˜ ๊ตฌ์กฐ์™€ ์ผ์น˜๋˜๋„๋ก ์š”์ฒญํ•œ๋‹ค.


SDK๋ฅผ ํ†ตํ•ด ๋ฐ์ดํ„ฐ ์ž…๋ ฅํ•˜๊ธฐ


๋งˆํฌ๋ฒ ์ด์Šค๋Š” ์•„๋ž˜์™€ ๊ฐ™์€ ๋‹ค์–‘ํ•œ ์–ธ์–ด์˜ ํ‘œ์ค€ ๊ฐœ๋ฐœ ํˆด์„ ์ œ๊ณตํ•˜๊ณ  ์žˆ๋‹ค.

์ด๋Ÿฌํ•œ ๋ผ์ด๋ธŒ๋Ÿฌ๋ฆฌ๋ฅผ ํ†ตํ•ด์„œ ์‚ฌ์šฉ์ž๋Š” ์ž์‹ ์˜ ํ™˜๊ฒฝ์— ๋”ฐ๋ผ ๋‹ค์–‘ํ•œ ํ˜•ํƒœ์˜ ์‘์šฉ ํ”„๋กœ๊ทธ๋žจ์„ ์ž‘์„ฑํ•˜์—ฌ ๋งˆํฌ๋ฒ ์ด์Šค์— ๋Œ€ํ•œ ๋ฐ์ดํ„ฐ ์ž…๋ ฅ์ด ๊ฐ€๋Šฅํ•˜๋‹ค.