Calculation for Log data base

Dear Sir,

As per customer requirement in one project, to store our data like daily production, power consumption (1-2 daily sample values)... in the form of "data Log", regarding the same we have following queries

1. Logs are reliable to store our data for years (5-10 years)?

2. What is the calculation to calculate storage size?

3. Which one is better Logs or SQL?

We are using computers with Raid configuration.


Add New Comment


nitinpulastya   

asked 7 days ago
Closed



Best Answer

1

A Lab Data log in Basic History may hold a user defined number of samples; each sample will drain about 24 bytes worth of disk space. The max size is not defined, but could probably be compared with regular logs, where e.g. a 1 second min time log will burn 86400 samples of storage per day (~2MB disk space).

Basic History before 5.1 RevD RU5 is limited to 32-bit addressing and total storage should not exceed 10.000 files or 50 GB (these are a rule of thumb, there are likely deviations when less is recommended, e.g. if many secondary logs are deployed). After this said rollup, Basic History can be trusted with slightly more data.

You can also deploy a Basic History service group only for your lab needs and put this service group on the aspect servers. The History Source aspect control what Service Group that gets to cater for the Log Configurations below it. This way you can create a dedicated Basic History service only for lab data purpose.

An asyncronous Oracle based log in IM History can hold up to 50.000 samples, each sample will allocate roughly 100 bytes from the Oracle tablespace (datafile).

(Page 249 in 3BUF001092-600 B lists the sizes allocated by IM logs).

With as few as 1-2 daily sample values, a Basic History labdata log will take you a very long way.

I have made examples here on AKS in the past how to use Calculation service to "inject" data into a lab log. I suggest trying the Calculation/Basic History solution for a starter.

Stefan Stromqvist   

answered 6 days ago


 


Add New Comment


Answers

0

For more detailed information please refer to "Information Management Configuration" documentation.

kmk691   

answered 7 days ago


 


Add New Comment


1

A Lab Data log in Basic History may hold a user defined number of samples; each sample will drain about 24 bytes worth of disk space. The max size is not defined, but could probably be compared with regular logs, where e.g. a 1 second min time log will burn 86400 samples of storage per day (~2MB disk space).

Basic History before 5.1 RevD RU5 is limited to 32-bit addressing and total storage should not exceed 10.000 files or 50 GB (these are a rule of thumb, there are likely deviations when less is recommended, e.g. if many secondary logs are deployed). After this said rollup, Basic History can be trusted with slightly more data.

You can also deploy a Basic History service group only for your lab needs and put this service group on the aspect servers. The History Source aspect control what Service Group that gets to cater for the Log Configurations below it. This way you can create a dedicated Basic History service only for lab data purpose.

An asyncronous Oracle based log in IM History can hold up to 50.000 samples, each sample will allocate roughly 100 bytes from the Oracle tablespace (datafile).

(Page 249 in 3BUF001092-600 B lists the sizes allocated by IM logs).

With as few as 1-2 daily sample values, a Basic History labdata log will take you a very long way.

I have made examples here on AKS in the past how to use Calculation service to "inject" data into a lab log. I suggest trying the Calculation/Basic History solution for a starter.

Stefan Stromqvist   

answered 6 days ago


 


Add New Comment



Get weekly AKS updates


Partner Exclusive Webinars

 

> – Login to the partner portal to register



Points Redemption Program - Redeem your points for ABB training, Bluetooth speakers and mugs. Terms and conditions >


Earn points when you refer a friend
AKS Referral Program is "Live" - Learn more



AKS Experts


avatar
Ask Rob Lyon   

Rank: 2

info@lymac.co.nz I'm an independent DCS software and commissioning engineer with extensive experience in 800xA and other ABB products. I've worked in almost every corner of the world and still haven't seen it all.


avatar
Ask Flavio Mussolin   

Rank: 4

ABB AVP, Senior Electronic and Automation Engineer with over 30 years of experience in the field of process automation automotive, pharmaceutical, hollow glass, steel and rolling.


avatar
Ask Govindaraj   

Rank: 10

Working in ABB India Operation Center. Have Project engineering and commissioning experience in ABB 800xA, Freelance, AC500.


avatar
Ask Harsha.D   

Rank: 7

Tech.Support,software and commisioning engineer with Proficient knowledge in 800xA and its products, RNRP,Networking in general.


avatar
Ask MMM   

Rank: 5

ABB PA CT Technical Support


avatar
Ask Stefan Stromqvist   

Rank: 1

I joined ABB in the year of 1994 and has since 1999 been working as a Service & Support Engineer at BU Control Technologies in Västerås, Sweden. My areas of expertise are: 800xA Base, 800xA for Advant Master, Information Management, operating systems, RNRP and Ethernet comms/networking in general.


avatar
Ask Ronny Lindström   

Rank: 17

ABB Service Engineer


avatar
Ask nikismith   

Rank: 257

I have been a part of the Recording & Control Factory team for 17 years in total, having spent a number of years as a repairs technician withi the manufacturing department, but being in my current role for 9 years now.


avatar
Ask Sumit Gargav   

Rank: 3

I have worked with Freelance in majority, with 800xA FD and Melody system partly. Also had opportunity to work with Protocols - HART,Profibus,FF & Modbus.


avatar
Ask kstoilov   

Rank: 9

Control System Engineer: 800xA, Compact 800, AC500, AC31-50, Advant Master, Simatic, AC&DC Drives 11 years worked for ABB - Control Systems


avatar
Ask WvanWees   

Rank: 6

I'm a senior service engineer working for ABB in The Netherlands.


avatar
Ask Dieter Henkel   

Rank: 19