Look inside a Hershey database effort

P. Michael Rosenshine, staff engineer, Information Services area of Hershey Chocolate North America (Hershey, Pa., www.hersheys.com), is working on a pilot project on three lines to test the feasibility of a plant-wide database for process parameters and results (excluding labor, which is handled in another system). The project uses Oracle 8i, but may be ported to Microsoft SQL Server 2000 for some plants.

08/14/2002


This article is provided as enhanced online coverage to the June 2002 issue of Control Engineering. How to Get the Most from a Database '' (Control Engineering, June 2002).

In considering a central data model, sometimes it's easier to gain knowledge and experience working on a smaller piece.

P. Michael Rosenshine, staff engineer, Information Services area of Hershey Chocolate North America (Hershey, Pa., www.hersheys.com ), is working on a pilot project on three lines to test the feasibility of a plant-wide database for process parameters and results (excluding labor, which is handled in another system). The project uses Oracle 8i, but may be ported to Microsoft SQL Server 2000 for some plants. Computations for reporting process results are performed on the database server side for future migration to browser-based information access, rather than incorporated with SCADA system functions or client-side software.

Mr. Rosenshine says having a single general database design fit any line would require too many fields and tables, many of which would be for metadata (information about the structure of tables and their mappings to the configuration of production lines). In the database, he's found that 60-75%-perhaps 100 tables and views and 100 procedures-can be central, then others added to meet the specific process architecture. Core information includes ingredients and materials, equipment, sequencing, recipes, quality, and product tracking, among other parameters.

Part of Mr. Rosenshine's effort is abstracting common process elements such as quality assurance testing or waste/rework, and then creating the metadata elements required to present information to the user with the minimum amount of programming on the SCADA or client-side systems. That way, when the database needs to be modified for a new line or process, adaptation takes three or four hours, instead of days creating something new in SCADA software. The additional benefit is that it has the same "look and feel," even though a plant's lines and processes are different.

Users log-in via a Microsoft VisualBasic interface. However, in the future, the effort will incorporate Microsoft .Net tools to move to a web client, Mr. Rosenshine says, to protect the value created going forward.

Mr. Rosenshine talked with Control Engineering Feb. 12, 2002, at the ARC Advisory Group Manufacturing Strategies Forum meeting, in Orlando, Fla.

For a bit of fun, the www.hersheys.com website includes a plant tour of "world's largest chocolate factory."

- Mark T. Hoske, editor in chief
MHoske@cfemedia.com





No comments
The Top Plant program honors outstanding manufacturing facilities in North America. View the 2013 Top Plant.
The Product of the Year program recognizes products newly released in the manufacturing industries.
The Engineering Leaders Under 40 program identifies and gives recognition to young engineers who...
The true cost of lubrication: Three keys to consider when evaluating oils; Plant Engineering Lubrication Guide; 11 ways to protect bearing assets; Is lubrication part of your KPIs?
Contract maintenance: 5 ways to keep things humming while keeping an eye on costs; Pneumatic systems; Energy monitoring; The sixth 'S' is safety
Transport your data: Supply chain information critical to operational excellence; High-voltage faults; Portable cooling; Safety automation isn't automatic
Case Study Database

Case Study Database

Get more exposure for your case study by uploading it to the Plant Engineering case study database, where end-users can identify relevant solutions and explore what the experts are doing to effectively implement a variety of technology and productivity related projects.

These case studies provide examples of how knowledgeable solution providers have used technology, processes and people to create effective and successful implementations in real-world situations. Case studies can be completed by filling out a simple online form where you can outline the project title, abstract, and full story in 1500 words or less; upload photos, videos and a logo.

Click here to visit the Case Study Database and upload your case study.

Maintaining low data center PUE; Using eco mode in UPS systems; Commissioning electrical and power systems; Exploring dc power distribution alternatives
Synchronizing industrial Ethernet networks; Selecting protocol conversion gateways; Integrating HMIs with PLCs and PACs
Why manufacturers need to see energy in a different light: Current approaches to energy management yield quick savings, but leave plant managers searching for ways of improving on those early gains.

Annual Salary Survey

Participate in the 2013 Salary Survey

In a year when manufacturing continued to lead the economic rebound, it makes sense that plant manager bonuses rebounded. Plant Engineering’s annual Salary Survey shows both wages and bonuses rose in 2012 after a retreat the year before.

Average salary across all job titles for plant floor management rose 3.5% to $95,446, and bonus compensation jumped to $15,162, a 4.2% increase from the 2010 level and double the 2011 total, which showed a sharp drop in bonus.

2012 Salary Survey Analysis

2012 Salary Survey Results

Maintenance and reliability tips and best practices from the maintenance and reliability coaches at Allied Reliability Group.
The One Voice for Manufacturing blog reports on federal public policy issues impacting the manufacturing sector. One Voice is a joint effort by the National Tooling and Machining...
The Society for Maintenance and Reliability Professionals an organization devoted...
Join this ongoing discussion of machine guarding topics, including solutions assessments, regulatory compliance, gap analysis...
IMS Research, recently acquired by IHS Inc., is a leading independent supplier of market research and consultancy to the global electronics industry.
Maintenance is not optional in manufacturing. It’s a profit center, driving productivity and uptime while reducing overall repair costs.
The Lachance on CMMS blog is about current maintenance topics. Blogger Paul Lachance is president and chief technology officer for Smartware Group.