OrientDB Time Series Data

Question

I saw an example of using OrientDB to model time series data, but I don’t know what the insert looks like.

It would be great if someone had an example for this.

Regards, Tom

https://github.com/orientechnologies/orientdb/wiki/Time-series-use-case

Answer 1

To get a clearer picture of the usefulness of the Time Series, you can imagine this casuistry:

, . , , , , (, , , ), , , .

:

CREATE CLASS Year extends V
CREATE CLASS Month extends V
CREATE CLASS Day extends V
CREATE CLASS Hour extends V
CREATE CLASS Log extends V

CREATE PROPERTY Year.value STRING
CREATE PROPERTY Year.month LINKMAP Month
CREATE PROPERTY Month.day LINKMAP Day
CREATE PROPERTY Day.hour LINKMAP Hour
CREATE PROPERTY Hour.log LINKSET Log

CREATE VERTEX Log SET priority='high'
CREATE VERTEX Log SET priority='medium'
CREATE VERTEX Log SET priority='low'

INSERT INTO Hour(log) VALUES ([#16:0,#16:1])
INSERT INTO Hour(log) VALUES ([#16:2])
INSERT INTO Day(hour) VALUES ({'15':#15:0})
INSERT INTO Day(hour) VALUES ({'10':#15:1})
INSERT INTO Month(day) VALUES ({'4':#14:0})
INSERT INTO Month(day) VALUES ({'21':#14:1})
INSERT INTO Year(value,month) VALUES ('2012',{'3':#13:0})
INSERT INTO Year(value,month) VALUES ('2015',{'8':#13:1})

1: , 4/3/2012 h15

SELECT EXPAND(month[3].day[4].hour[15].log) FROM Year WHERE value='2012'

2: , 21/8/2015 h10

SELECT EXPAND(month[8].day[21].hour[10].log) FROM Year WHERE value='2015'

,