Device for generating and searching sensor tag data in real time
AssigneeMachbase, Inc.
InventorSung Jin Kim
Life of this patent
Estimating the term…
Abstract
A device for generating and searching sensor tag data in real time is provided. The device can include a rollup executor that is configured to generate statistics data per time from raw data; and a rollup memory storing per-second statistics data in units of seconds for new input data and per-minute statistics data in units of minutes for the per-second statistics data, where the statistics data can be automatically calculated and provided by the system by using statistics for time series sensor tag data based on tag names/times.
Claims9
A device for generating and searching sensor tag data in real time, the device comprising:
- a rollup executor configured to generate statistics data per time from raw data;
- a rollup memory storing per-second statistics data in units of seconds for new input data and per-minute statistics data in units of minutes for the per-second statistics data;
- and
- an interface configured to receive an input query,
- wherein the rollup executor stores the per-second statistics data in a rollup_sec table and stores the per-minute statistics data in a rollup_min table,
- the per-second data and the per-minute data are recorded with a minimum, a maximum, a count, and a sum calculated for each tag name and time group,
- the interface is further configured to receive sensor data from a plurality of IoT sensor devices,
- the sensor data is stored as the raw data in a raw memory, the raw memory being physically separate from the rollup memory, the raw data including a device ID, measurement time, and measurement value of a particular IoT device,
- the tag names are assigned for a plurality of different sensing groups according to sensing purposes of systems having the plurality of IoT devices included therein,
- the rollup memory stores the per-second statistics data from the raw data in the rollup_sec table and stores the per-minute statistics data in the rollup_min table for each of the plurality of sensing groups, and
- a particular IoT sensor device from among the plurality of IoT sensor devices is included in two or more of the plurality of sensing groups during a particular period of time.
A device for generating and searching sensor tag data in real time, the device comprising:
- a rollup executor configured to generate statistics data per time from raw data;
- a rollup memory storing per-second statistics data in units of seconds for new input data and per-minute statistics data in units of minutes for the per-second statistics data;
- and
- an interface configured to receive an input query,
- wherein the rollup executor stores the per-second statistics data in a rollup_sec table and stores the per-minute statistics data in a rollup_min table,
- the per-second data and the per-minute data are recorded with a minimum, a maximum, a count, and a sum calculated for each tag name and time group,
- the interface is further configured to receive sensor data from a plurality of IoT sensor devices,
- the sensor data is stored as the raw data in a raw memory, the raw memory being physically separate from the rollup memory, the raw data including a device ID, measurement time, and measurement value of a particular IoT device,
- the tag name is assigned differently for each of the plurality of IoT devices,
- the rollup memory stores the per-second statistics data from the raw data in the rollup_sec table and stores the per-minute statistics data in the rollup_min table for each of the plurality of IoT devices,
- the per-second statistics data and the per-minute statistics data are processed into tag metadata associated with the tag names, rollup metadata associated with rollup data values stored in the rollup memory, and performance view metadata associated with a performance of the per-second statistics data and the per-minute statistics data,
- and the tag metadata, the rollup metadata, and the performance view metadata are transmitted by way of a REST API to different external devices according to the tag names.
Dependencies are inferred from the claim text.