Hello Historians and databases Gurus,
We are looking for solutions to upgrade our current Labview-based application that takes data from PLCs through OPC servers and store them into a home-designed binary file structures, locally on a PC.
These are our specifications:
- All our processes are parts driven (discrete). We are not dealing with time-based processes
- One part is produced every 1min
- The data acquisition is triggered by the polling of a ‘trigger’ (counter) and when this counter increments the application get all related data. In other words, nothing happen during 1min (just the trigger scrutiny) and all data transfer is once per minute.
- Per cycle we are taking about 15.000 tags (16 bits words) per machine
- Per plant we have roughly 10 machines, all with a cycle time of 1 min. One PC today is connected to 1 or 2 machines. So 5 PCs per plant roughly.
- Emphasis given on the visualization of the data close to the machine to help the operator in his process adjustments. Here the operator needs to visualize all parameters for a specific machine cycle, overlay profiles (a profile is a serie of tags for a defined cycle), graph parameters against cycles or against time (but even against time the different points of the graph mean a specific part produced)
- We do not really have time constraints as to the time it takes to fetch and write the data into the database. It can take 10s, we do not really care.
- Open database so that people can make cross-machines analysis of data (data mining)
- Cost-effective solution
An internal discussion lead to considering that instead of writing into a local home-made Database we could simply write into a centrally located SQL database (located on a plant’s server).
I know that Historians could also be a way to go but do not understand the advantages that we would have especially considering the specs given here-above.
What solutions would you recommend to implement or to study?
Thank you very much to share some thoughts with me