How do you store your data in a time series database?

The data model for RAPID™ is centered around the concept of an item. An item is a sequence of events, each of which store a tuple of {timestamp, value, quality} for a single source of measurement data. Quality is an optional field that is stored by exception for efficiency.

Consider the example of a weather station below. Let's say it is measuring Temperature, Rainfall and Humidity every 5 seconds.


Temperature


Wind


Rainfall

 

That would equate to three different items in the rapid database.

 

Temperature

  • 2014-03-20T00:00:00.000Z, 1234.52, 0xC0
  • 2014-03-20T00:00:01.000Z, 1234.12, 0xC0
  • 2014-03-20T00:23:02.000Z, 1234.89, 0xC0
  • 2014-03-20T00:23:03.000Z, 1234.01, 0xC0
  • 2014-03-20T00:23:04.000Z, 1224.73, 0xC0
  • 2014-03-20T00:23:05.000Z, 972.23, 0xC0

Wind

  • 2014-03-20T00:00:00.000Z, 1234.52, 0xC0
  • 2014-03-20T00:00:01.000Z, 1234.12, 0xC0
  • 2014-03-20T00:23:02.000Z, 1234.89, 0xC0
  • 2014-03-20T00:23:03.000Z, 1234.01, 0xC0
  • 2014-03-20T00:23:04.000Z, 1224.73, 0xC0
  • 2014-03-20T00:23:05.000Z, 972.23, 0xC0

Rainfall

  • 2014-03-20T00:00:00.000Z, 1234.52, 0xC0
  • 2014-03-20T00:00:01.000Z, 1234.12, 0xC0
  • 2014-03-20T00:23:02.000Z, 1234.89, 0xC0
  • 2014-03-20T00:23:03.000Z, 1234.01, 0xC0
  • 2014-03-20T00:23:04.000Z, 1224.73, 0xC0
  • 2014-03-20T00:23:05.000Z, 972.23, 0xC0

 

What if my index isn't time?

In the database, timestamps are stored as 64 bit integer values. To store non time-value indices, just convert your value to an int64 and you'll be able to enjoy the same speed performance as time series data.

To learn more, check out the Automsoft REST API docs, or drop us an email at support@automsoft.com

Automsoft is a technology pioneer. In 2001, Automsoft launched the world’s fastest and highest performing data historian, completely re-thinking conventions on technology and the management of process data. Today, Automsoft’s RAPID™ database technology is at the forefront in complex asset management, and provides the data backbone for managing the massive volume of data generated by sensor networks, control systems and devices across industries from smart grid to medical sensing technology. Automsoft is headquartered in the Republic of Ireland.

Contact

EMEA

Automsoft
24 Lansdowne Road
Dublin 4
Ireland
Tel:  +353 1 449 1100
Fax:  +353 1 449 1199
E-mail:  info@automsoft.com

North America

Automsoft
5 Independence Way, Suite 300
Princeton
NJ 08540
USA
Tel:  +1 650 585 4338
E-mail:  info@automsoft.com