cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Is there life cycle management for the persistent data in Thingworx ?

SOLVED
Highlighted
Level 8

Is there life cycle management for the persistent data in Thingworx ?

Hi, 

I got the requirement from a customer: 

 

"The data stored for query remain 3 months,  then the data is regarded as "cold data" , user can still query it , but the data should be moved(not removed) to somewhere, like archive database or data warehouse. So that the "cold data" doesn't affect the query performance. "

 

This is something like life circle management of data and it's necessary for the time-series data I think , like value stream or stream. 

 

Does thingworx supports it natively ?  I mean the the archive database and archive strategy can be specified during deployment and developers don't need to care about querying data query from archive database or live database. 

 

Regards,

Sean

 

 

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Is there life circle management for the persistent data in Thingworx ?

3 REPLIES 3

Re: Is there life cycle management for the persistent data in Thingworx ?

there is no OOTB archive functionality.

So you would need to create this capability.

probably create a separate data store (external DB separate persistence provider)

and create a separate set of services etc. to handle 'live' short term data vs. the historical data.

Re: Is there life circle management for the persistent data in Thingworx ?

Hi PaiChung, Thank you for the hint. Is there any guide or sample for creating a new external DB separate persistence provider ? Regards, Sean

Re: Is there life circle management for the persistent data in Thingworx ?