When companies begin their search for a data historian or a time series database for storing large amounts of process data, they often evaluate solutions on their features and offerings. Rather than ask the correct questions, they mistakenly structure their RFIs and requirement lists around these three areas:
Recently, a system integrator asked us to provide data that would provide both speed and storage requirement comparisons between an out-of-the-box SQL database and Canary. They wanted to use this data to decide whether it would be best for customer's to deploy a Canary system, or deploy, tune, and maintain an SQL system.
The ninth edition of a weekly Question and Answer column with Gary Stern, President and Founder of Canary Labs. Have a question you would like me to answer? Email email@example.com
Recently Canary has received several questions regarding max capacity of our Unlimited solution. Particularly, exactly how many tags can be stored on a single server. Although we have addressed this question before, we thought it would be a good time to provide a new test.
Your data historian holds more analytical potential today than you may realize. This process knowledge powerhouse can help you transform operations and fundamentally change the way time-series data is interpreted. However, few companies have taken the necessary steps to actualize their data historian’s full potential. Most engineers, supervisors, and operators are either working double-time to meet spikes in demand, or are handling duties outside their typical job description to reduce cost. The bottom line? You are likely too busy elsewhere to spend time mining the knowledge base waiting inside your process historian.
This past Sunday morning Daylight Saving Time ended at 2:00AM and the clocks rolled back an hour, giving us all some extra rest. However, for data process historians and engineers like yourself, this semi-annual phenomenon can be anything but relaxing! In fact as you have learned, the Daylight Saving Time (DST) scenario is one of the most difficult situations for a data historian to handle. Let me explain for others, not as familiar, while I answer your question.
Imagine you were to search for data at 1:35AM on the Sunday of DST. How would the computer know if you meant the first 1:35AM or the second 1:35AM of the morning? The Canary Historian solves this problem by storing all the data with UTC time stamps. UTC stands for Coordinated Universal Time and is the basis for civil time today. Note, this is a time standard, not a time zone.
The fourth edition of a weekly Question and Answer column with Gary Stern, President and Founder of Canary Labs. Have a question you would like me to answer? Email firstname.lastname@example.org