Need Help With SCADA database. 50 thousand points

dansomerville

Member
Join Date
Apr 2008
Location
canada
Posts
4
Hello,

Let me preface this. I have used this site many times when searching for issues and it has always been helpful. This is my first post here. I have been programming PLC's, HMI's, VFD's etc etc for 15 years, fairly complex stuff. I have also done lots of SCADA programming but more just for basic interface, monitoring, basic parameters changes, logging, etc etc.

I am not facing a setup where I must do a large recipe/batch data transfer and I am confused as to what the best path is to achieve this. I have fairly basic knowledge of VB script as I have not needed to use it very often. Here is the problem I am facing.

The SCADA package the customer has is Omron CX-Supervisor. The network is all Ethernet Based

1) I have 26 moulding machines on the plant floor
2) There are 50 different moulds that are moved around from machine to machine
3) Each mould can run 1 of 10 different colours
4) There are 100 differing cycle parameters for each colour/mould combination

=50x10x100 = 50 k points
for total machine that = 50k x 26 = 1.3 million !

What the end result will be is this.

From the SCADA operator terminal they would like to be able to keep a 'master set' of these settings, call up a mould/colour combo and see the individual parameters. Then they would like to edit individual parameters and download to each individual machine, or all at once.

I do have a PLC at the Main terminal that was used for translation of the old serial network to ethernet. All of the serial connections have been removed so it is basically doing nothing. I could use this as a "master" for holding parameters if needed.

What is the best way to go about this. Create a database, use the built in recipe manager, use PLC here as 'master storage". I feel once I get down a path it will make more sense...I just don't want to pick the wrong option and have to redo it all.

Keep in mind my PLC coding is vastly superior to my knowledge of database manipulating and VB coding

Thanks
Dan
 
A relational database is the best way to deal with such large dataset with so many permutations. I think now is a good opportunity to hone your data base skills.

You can have a table for the machines, one for the tools, colors, and one for the parameters. Then a set of tables to relate the different tables.

See if your local library has some primers on databases. There are lots of websites on the subject but until you know what you are looking for you might drown in the information. Maybe drop by your local bookstore and browse through "Database Development for Dummies" and decide if it will help you or not.
 

Similar Topics

hi.. i want to configure 3 buttons using c action for open single picture window with 3 different .pdl files. that is if i click on 1st button...
Replies
5
Views
1,846
Hi all,, Can anyone help me in installing the scada ifix software... I have 5 sets of CDs.. is there any one by one methodology in installing...
Replies
2
Views
2,562
hello all... my company want using scada system. can some body help me to give me the scada software system where can support Mitsubishi PLC (...
Replies
4
Views
3,278
hi to everyone i need any file about citectscada i need to learn the program way please help me if you can .....bye
Replies
23
Views
6,169
Hi guys we are constructing a small production line 5 km away from our factory that includes hydrolic presses and small machines. We want to get...
Replies
8
Views
3,944
Back
Top Bottom