酪農IoTにおけるリアルタイム分析 @AWSカーニバル 2023-11-04

2023年11月4日に開催されたAWSカーニバルのエゾウィン株式会社 CTO 奥山 森 登壇資料

Transcript

1. IoT CTO #aws_carnival 2 0 2 3 / 1 1 / 0 4
2. IoT 

3. ⛰ ⛄ 🏀 🍵 🎆 AWS DynamoDB / Shigeru Okuyama CTO 

6. ( )
10. OLTP OLTP OLTP 
 OLTP OLTP OLTP 
 (GB) OLTP OLTP : https://aws.amazon.com/jp/compare/the-difference-between-olap-and-oltp/
11. : https://aws.amazon.com/jp/compare/the-difference-between-olap-and-oltp/ OLTP OLAP OLAP 
 OLAP ( ) 
 OLAP OLAP (TB) (PB) OLAP OLAP
12. OLTP OLAP 2 頻
13. IoT 
 OLTP OLAP OLTP OLAP 2 頻
15. 2~6 
 (Lambda 2 5 6 MB 10sec )
17. A few seasons later … 🗿
18. 🛠
19. 🛠 プ プ プ
21. 🛠 プ プ プ ( )
22. 🆕 
 ( 1300% 21 ) 2~6 n
23. ( )
24. 🆕 
 ( 1300% 21 ) 2~6 n
25. 🤔 ,SI 

26. 😥 ,SI CU 頻 
 / 
 頻
28. ER 
 : https://pages.awscloud.com/rs/ 7
29. ✗ り 

30. IoT ~24 mSec 24 頻 n ~n 10 5 ~10 (Attribute)
32. ( )Timestream Timestream SQL(ANSI- 2 0 0 3 SQL) JOIN 🆕 S 3 S 3 AWS Backup
33. DynamoDB Timestream ⾒
34. DynamoDB Timestream ⾒ DynamoDB 
 
 
 24 / / 
 1 / 
 mSec 
 
 DynamoDB 
 
 Redis MemoryDB
35. DynamoDB Timestream ⾒ Timestream 
 
 KinesisDataStreams for DDB,Lambda 
 
 Timesteam DynamoDB Timestream ⾒ 

36. DynamoDB Timestream ⾒ ⚠Timestream Timestream DynamoDB 
 
 
 
 
 Quota Write/Query API
37. (ap-northeast- 1 ) 2 0 2 3 / 1 1 / 3
38. (ap-northeast- 1 ) 2 0 2 3 / 1 1 / 3 87%
39. DynamoDB TTL 24 ~n Timestream Minimum 1 (5~10 ) 
 Timestream (5~10 ) 
 S 3 Unload
40. DynamoDB ( 4KB ) 
 Timestream ( 10MB ) DynamoDB GSI, 
 DB Timestream 2 
 
 
 
 70% ( ) 30%
43. 
 DynamoDB Timestream ⾒ 
 
 
 ( )