Using Amazon Timestream in Nikon's remote monitoring platform

[ishanijerin1]

Why we chose Amazon Timestream
When we first started developing One Board , we first considered whether to use an on-premise database or a cloud database. As a result, we chose a cloud database for the following reasons:

As a managed service, scaling up and down is done automatically, so you can focus on development work with less effort than on-premise.
Best practices are also widely published
We then compared it with databases provided by cloud vendors other than AWS, and decided to use AWS for the following reasons:

There are many internal AWS development cases
We have a corporate contract with AWS, so we can keep costs down.
24/7 support available
Furthermore, One Board uses Amazon RDS for MySQL to store data other than time series data, and chooses the most appropriate database on a case-by-case basis.

Data Model
Here is a part of the data model that One Board applies to Timestream. One Board uses multi-measure records, which register multiple measurements in a single record:



Table 1. One Board data model

Here's a summary of each column:

Serial_number:
Identifier for each metal 3D printer. Used to collect data for each machine.
Time
record timestamp
Laser_power:
The actual measured value of the laser output used by the metal 3D printer for metal additive manufacturing [kW]. Since the quality of metal additive manufacturing is affected by whether the output is as expected, this is collected as one of the indicators of quality.
Oximeter_1, Oximeter_2Measurement
values ​​[%] of two types of oxygen concentration meters installed inside the metal 3D printer. In order for a metal 3D printer to use a laser to perform metal additive organize your finances with mint manufacturing, the oxygen concentration inside the metal 3D printer must be below a certain value. In addition, for safety reasons, the operation door of the metal 3D printer is automatically locked during metal additive manufacturing, and is automatically unlocked when the oxygen concentration exceeds a certain value after metal additive manufacturing is completed. In this way, oxygen concentration is an important indicator for metal additive manufacturing, and two types of oxygen concentration systems, each with a different measurement range, are collected and used as one of the indicators that show that the metal 3D printer is operating correctly.
Gas_pressureThe
supply pressure of the inert gas to ensure safety during metal additive manufacturing using a laser [kPa]. If the supply pressure falls below a certain value, metal additive manufacturing will automatically stop for safety reasons. One Board collects this information as one of the indicators that the metal 3D printer is working correctly.