Posts Tagged ‘information’

Thankful for Open Source

Friday, November 7th, 2008

Well, we are deep in a financial down-turn and no one is immune. As I look back over the last decade and view all the twists and turns in my I.T. shop with different technologies and software…I have no regrets about embracing open source today.

When I first started at my present job we used DOS 6.1, Windows 3.11, Novell 4.11, Lotus, Oracle 7.34 and SPX/IPX protocol. For those of you who know what I just said…quit laughing. The rest of you are lucky to have missed all this stuff. Although, I do still like Oracle for a database. I just would have NEVER ran it on Novell with SPX/IPX packets bouncing aimlessly around my hub based network. But, that was what I inherited.

Mid-way, we transitioned to Windows NT 4.0 and 2000, TCP/IP, Office 97, Switches, Exchange Server, Oracle on Solaris and started dabbling in Apache web servers, not seriously though. This was an improvement, in that, I did not need to restart my Novell Oracle server everyday…but the Exchange Server took it’s place on a weekly basis. Praying that the datastore was not corrupted each time. Oh yea, and the innumerable pockets of corporate data created by Access97 was always fun, too.

Today, our entire core is either Linux or Unix. We run our email on load balanced linux servers running Egroupware. Oracle is still on Solaris SPARC machines. Our network file systems, domain controllers, authentication services, DNS, DHCP and all other related network service are run on Linux. Our only Windows machines are our Citrix farm and the few desktops we have left. This may seem silly, but we have server birthday parties based on the years they’ve been up since a cold or soft reboot. So far the record is 900+ days.

OK, so what does this all have to do with the financial down turn…try a nearly two-thirds cost ownership reduction over the same time period…enough said.

Measuring Flow

Saturday, January 19th, 2008

We need to measure the flow of a liquid through a pipe at work. This seems easy enough on the surface. I’m thinking…just “click” off the liquid in some measurement as it goes by…right? Well, it could be…maybe. In reality, it turns out that it may not be all that simplistic. There are other things to consider. What kind of meter should you use? There are many. What exactly are you trying to measure? What’s the density or viscosity of the liquid? Are these variable during the process? Are you actually trying to ‘regulate’ flow or ‘meter’ flow or both?

During the consideration of this task of measuring the flow of a liquid, we would need to define ‘flow’. The straight-forward definition is… the flow of material past a given location. When we dig into it further and look at actual formulas for measuring flow, it starts getting more complex.

For instance, look at this formula for ‘Flow Rate’ (FRV). This is a volume per unit time or ‘volumetric’…

FRV = V x A, where A equals the cross-sectional area of the inlet pipe and V is the average velocity of the liquid being measured. Now consider this formula in practice. We have liquid flowing through a pipe that has 2 square meters of cross-sectional area, traveling at an average velocity of 2 meters per second. So, I have a flow rate of 4 cubic meters per second.

Next, look at this formula for ‘Flow Rate’ (FRM). But this time, we will deal with ‘mass per unit time’ or a ‘mass metric’…

FRM = FD x FRV, where FD is the fluid density and FRV is our volumetric product from the first example. So, if 4 cubic meters per second of fluid is flowing through a pipe, with a density of 2 kilograms per cubic meter, your FRM is 8 kilograms per second.

Do you want to measure flow in terms of a ‘mass’ or ‘volume’? It depends on your application. In some instances the process may have a limit on the ‘volume per unit time’ measurement it can accept. Some examples might be…filling a tank, painting widgets, etc. Other processes may have a limit on the ‘mass per unit time’ it can accept…like mixing chemicals or measuring chemicals for sale.

You can see that a person can purchase a meter that measures flow in terms of volume or mass. I found that you can even buy meters that ‘infer’ volume and mass using a similar formula to ~ ‘1/2 FD x V x V’. These meters are commonly referred to as ‘head flow meters’. But, further reading indicates that this ‘inference’ approach is problematic and can introduce errors when calculating ‘mass’ flow.

Careful consideration of what you really intend to measure about ‘flow’ should lead you in the right direction when purchasing a meter. Do you want to measure velocity, mass, volume or inferential values of each?

Wade Stankich
Information Technology Manager

View Wade Stankich's Profile at Spoke

Digital Evidence and the System Admin…watch out!

Sunday, January 13th, 2008

Many companies and organizations are increasingly being faced with having to collect digital evidence in response to situations like fraud, child pornography, intellectual property theft, sexual harassment…etc. These are all examples of cyber-crimes that are happening inside, as well as outside corporate walls. This means system administrators are finding themselves having to be constantly educated on current legal issues and laws concerning the reporting and collection of evidence concerning cyber-crimes in their companies. Not only do system administrators need to preserve and collect digital evidence in these situations, but they also have to recover quickly from an incident to minimize losses.

System administrators can be caught in a potentially career damaging position. Take this scenario for instance…finding child pornography on a computer in your workplace. If you simply delete the material, this may be interpreted as being criminally negligent. If the system administrator were to alert authorities to the material before getting the support of his/her’s employer, the system administrator could find themselves fighting the company, with their own money, time and lawyer. Ultimately, this could lead to the loss of the system administrator’s job.

Even well intentioned attempts to investigate child porongraphy allegations, have left the system administrators being prosecuted for downloading and possessing this material themselves! In light of these potential hazards, companies should have clear policies and procedures that outline how to properly deal with these situations.

These procedures should inform system administrators how to handle and preserve digital evidence of this kind. The companies policies should formally state the company’s position regarding illegal digital material. Employ the help of technically competent attorneys to aid in forming your policies and continue to have them review the policies periodically to stay up to date with technological changes.

Wade Stankich
Information Technology Manager

View Wade Stankich's Profile at Spoke

Bridging the Gap Between Maintenance and I.T.

Saturday, January 5th, 2008

Over the years, it seems that past traditional roles of the maintenance department and the information technology department of a manufacturing company are (or have been) changing. The lines are getting blurred. Those guys in the ’shop’ with the wrenches need to be just as versed in techno-jargon as ‘those geeks’ in the computer room. The I.T. guys also need to understand plant operations and maintenance concepts and the language that goes along with it, too. Why?…plant automation.

Most backplanes you see on the plant floor have a multitude of different modules plugged into them besides just the PLC. Today, usually a person will find an ethernet module plugged into them. For the I.T. department this is another network device on their network. Many times an electrical engineer deploying a new machine with an ethernet module gives no consideration to an IP address that fits with the companies current scheme. They may not give consideration to broadcasting issues that can potentially bring a network to it’s knees.

Conversely, a typical I.T. department doesn’t give enough attention to what basically amounts to another I.T. department within maintenance. Most of the machines maintenance deals with have processors and can be networked today. The engineers in maintenance are skilled at programming ladder logic, and once that task is complete…it simply goes out. I.T. should be working with this department to help them successfully roll out there machinery and take on the more global considerations of the company’s network.

This cooperation of two departments, that are so different on the surface, is sometimes easier said than done. It can be a huge cultural shift for some companies. This cultural divide usually is established from the beginning because of typical organizational structures and the resulting presumptions. What I mean is, that typically the maintenance department falls under Operations and the I.T. department falls under Finance. Foundationally, the wall of separation is “…I.T. is administrative, and Maintenance is production.” This may have worked 30 years ago, but it is no longer a valid structure that serves it’s company well, or to the fullest potential.

The Maintenance department and the I.T. department need to be solidly joined at some level. Neither, falling exclusively under Operations or Finance, but working somewhere in the middle for the global good of the company. It starts with communication. Project managers of both departments meeting once a week to review projects would be a good start. At some point along the way each will realize they both share the same copper wires.

Wade Stankich
Information Technology Manager
View Wade Stankich's Profile at Spoke

Information Technology is in the Manufacturing Business

Friday, November 30th, 2007

I.T. is a unique department within a manufacturing company. This department can assist in answering some of the most basic business questions from the top of an organization to the shop floor. In a company with adequate I.T. resources, I.T. should be able to assist in answering questions like…

What’s my capacity?

Are we profitable?

What are my customer needs?

What’s the cost?

What are my critical issues?

What are my yields?

What’s my production schedule?

How’s my shift producing?

Where’s my material?

The potential for relevant, accurate and timely answers to many business questions is often overlooked. The fact that I.T. has a global view of the entire company to answer these questions, should make I.T. an essential part of the business unit, as opposed to the necessary ’support only’ department of days past.

So how does I.T. assist their company in answering some of their most important questions?

Obviously, the more data the organization collects and is made available, the better. If you’re lucky enough to be in an organization that has production, accounting, and HR databases, it will be just a matter of good planning to ensure data entregrity and having the reporting skills and tools available. For the purposes of the following paragraphs, let’s assume we have these databases available to us.

Let’s start with “What’s my capacity?”. First, lets define capacity: the facility or power to produce, perform, or deploy. : capability <a plan to double the factory’s capacity>; also : maximum output <industries running at three-quarter capacity>.

Let’s also assume our production database is collecting statistics from the processes in the routing of a widget. This means I have data available to the organization such as, widgets produced, scrap produced, time taken to produce the widgets, people resources need to produce the widgets, machine resources needed to produce the widgets, how much material I consumed to produce the widgets, etc. After some time to collect history, a company should be able to use this kind of data to derive real capacities and capabilities that would be of use to Materials Management, Sales, Product Development, Operations, etc.

Also, how does I.T. assist in answering questions like “Are we profitable?” or “What’s the actual cost of the widget?” Let’s define profit and cost. Proifit: the excess of the selling price of goods over their cost; Cost:the outlay or expenditure (as of effort or sacrifice) made to achieve an object .

We can merge our production data, purchasing and inventory data, and human resources data in a fashion that with give the organization a view of the true costs of those widgets, thus giving us the ability, when merged with accounting data, to see our true profits. Maybe we even see that doing business with a particular customer is actually costing the organization money. We could see that producing a particular widget is more profitable, and that may influence how we diversify the different markets we are involved in pursuing.

With the right infrastructure in place, the data is available to answer all the above questions. Today, I.T.’s role should be to have the business understanding that brings it all together in a way that gives their company a competitive advantage and is relevant to their organization. I think there are many I.T. professionals that already recognize this and are ready to participate as a business professional in their company, if they aren’t already. It would stand to reason, as I.T. professionals have a very unique view of their company that is global in nature and scope. They see the business as a whole not departmently. This is what enables them to put the pieces together in a way that benefits the company as a whole.

Wade Stankich

Information Technology Manager

View Wade Stankich's Profile at Spoke