SoftPLC Corporation TOPDOC NexGen 1.4.070622 Released Contact | How to buy | Site Map | Home | Search

There's only one SoftPLC.
Hardware, Software & Systems Download Manuals/Software, Registration Profile, Partners, Contact Sample Applications, Customers Articles, White Papers, News Releases For Distributors/Sales Reps For Distributors/Sales Reps

One generation plants the trees; another gets the shade.

 

SoftPLC Corporation : News : Property Tables

Relational Database (Properties Tables)

SoftPLC Corporation announces another industry first! A feature of our version 3 SoftPLC runtime control software includes an embedded Internal Relational Database. SoftPLC is the only controller which offers this powerful and useful capability, which we call "Property Tables."

As an internal database, Property Tables allow crucial process data to be accessed in one or two high speed program scans, rather than having to wait for the data having to come from an external source (another computer or controller) which must send the data through a communications network. Property Tables open the door to a whole host of cost savings by minimizing the steps and hardware required to store and manage the data, as well as reducing integration time of moving the data from one location to another. Having the data in the SoftPLC can also eliminate the need for an IT department to manage the hardware and software for a separate database.

There are many different applications where this feature can provide automation controls in a more cost effective way. Manufacturing machines or processes that assemble products based on recipes or build multiple products on the same machine are all good candidates for this technology, as are conveyor or warehousing applications that need to perform sorting or picking. Projects that require setting of variables for configuration of a machine, or fast keyed look-ups of control values would also find the power of Property Tables especially useful.

Introduction to Properties

Property Definition
A Property consists of 2 parts:

Name - This is a mandatory part. It is a string and is a key in a two column relational table. Although it is a string, it can hold a number in string form. For example: 53213

Value - This is an optional part. It is a string and can consist of multiple parts separated by some agreed upon delimiter character. For example: "Milwaukee|Wisconsin|USA"

Properties can be used for just about anything. Some examples are:

  • Fast keyed look ups for control values based on a lookup string, such as in recipes, warehouse databases, etc.
  • Like "environment variables" for configuration options (for user defined instructions or drivers).

Properties are partitioned into separate property tables, called property files. You can have up to 1000 property files, each with thousands of properties. Providing support for multiple property files allows for many many relational tables to be held.

Property files can be used for material handling or sorting applications. For example, let's say you have parts coming onto a conveyor and you read the part with either a bar code reader or an RFID sensor to obtain a part number. A property file can hold the mappings of the part number to a bin or conveyor gate number.

There are property lookup ladder instructions in SoftPLC that allow fast lookups on a property file. In this example, from the part number the bin number is quickly obtained.

A similar lookup can be performed on zipcode to obtain City and State for automatic printing of a shipping label.

Property tables can be quickly entered using the TOPDOC NexGen Property Editor, or by copying database information from a spreadsheet or with SoftPLC's XML import capability.

Products | Support | Company | Applications | News | Articles | Channel

View Printer Friendly Page

Certain pages on this site may require some of the following: Acrobat Reader or Flash Player or PowerPoint Viewer

Last modified: January 2, 2007

Copyright © 2008 SoftPLC Corporation All Rights Reserved
SoftPLC and TOPDOC are registered trademarks of SoftPLC Corporation. All other trademarks are the property of their respective owners.
This website is produced by SoftPLC Corporation "as is" without warranty of any kind, either expressed or implied, including, but not limited to merchantability, fitness or non-infringement. In no event shall SoftPLC Corporation be liable for any special, indirect or consequential damages or any damages whatsoever resulting from loss of use, data or profits, arising out of or in connection with the use of any information posted on this site. . . . .