Manufacturing Optimization Via Multidimensional Database Searches

Optimization is defined as “ act, process, or methodology of making something as fully perfect, functional, or effective as possible.” Manufacturing optimization as a goal, albeit complex is actually quite achievable given the availability of manufacturing software like PINpoint’s Manufacturing Execution System (MES) / Manufacturing Operations Management (MOM) solutions. Their MES/MOM products feature a most advanced multidimensional database query search engine which empowers manufacturers to hone in on the specifics of their operations in order to improve them.


True manufacturing intelligence can only be achieved with the deep level of data manipulation possible in advanced production analytics software. In PINpoint’s MES/MOM solution multidimensional databases are created hourly using input from existing relational databases. Typically, relational databases are accessed using a Structured Query Language (SQL) query, whereas a multidimensional database allows a user to ask ‘specific’ questions like “How many product defects have there been in the last 90 days, which serial numbers, and for what specific reasons?” And similar detailed questions related to summarizing manufacturing operations and trends.

Users of PINpoint software have the power of a multidimensional database reporting system at their fingertips, accessible from a website browser in an easy to use, drag-and-drop user experience from any computer, tablet or Smartphone. PINpoint  meets the needs of discrete manufacturing operations both large and small. The starting point for any manufacturer entering into MES/MOM is PINpoint’s  ‘Essential Production Management MES’ (EPM-MES); it is the foundation from which you can build your plant floor management strategy on for the future. It features the essential production management tools you need to begin the manufacturing optimization process, including:


1. Line Configuration; Process Engineers use SmartBuild configuration software to set-up and edit their assembly lines in a website browser.

2. Work Order Creation; or import orders seamlessly from existing Enterprise Resource Planning (ERP) system.

3. Production Scheduling; set TAKT time, Goals Planned Average (GPA), monitor and report on Overall Equipment Effectiveness (OEE).

4. Work Order Tracking; track serial numbers in real-time, right down to the physical location of the product on the line.

5. Worker Interface; workers use SmartScreen human machine interfaces to ensure full-accountability in the manufacturing processes.

6. Advanced ANDON; display easy to understand information on large screens, with graphics, video messages, and send alerts via email/txt.

7. Manufacturing Intelligence; optimize production processes with detailed reports you output using Production Analytics tools and the multi-dimensional database.


For enterprise level or larger scale manufactures with automated processes PINpoint recommends its’ ‘Optimized Full Process MOM’ (OFP-MOM) solution. It is including all of the capabilities as described above in theEPM-MES version, although it is specifically set up for full-process controlled lines. Both systems are the epitome of web based configurable plant floor management and optimization.

To ensure ease of use, PINpoint software comes preloaded with various reports you can run right out-of-the-box, including Production Reports, Defects / Bypasses / Resets, Fastening Operations, Checkbox Operations and Custom Queries. Under the Defects / Bypasses / Resets tab for example, you can select from standard reports including Defects by Serial Number, Product Defects, Product & Serial Number Defects, Process Step Bypasses by either Serial Number, Product or Station, and more. You have the ability to customize any report in a simple WYSIWYG editor, and once you create the reports you need you can save them to your Favourites, and have them ready for viewing anytime.

Software Manufacturing Execution System

The ability to make informed decisions pertaining to your manufacturing processes is directly related to the quality and depth of information you have at hand. Manufacturing software development leaders like PINpoint Information Systems of Burlington, Ontario, Canada are continually pushing forward the limits of Manufacturing Execution System (MES) and Manufacturing Operations Management (MOM) technology.

Fundamental to the push are some of the World’s best known manufacturers in the automotive, heavy machinery, aerospace and recreation vehicle sectors, who use PINpoint EPM-MES / OFP-MOM software every day to get the most out of their manufacturing operations. For more information and for a no obligation consultation please contact Anthony today at

Posted in Continuous Improvement, Lean Manufacturing, Lean Six Sigma, Manufacturing Execution System, Manufacturing Operations Management, MES System, Production Analytics and tagged , , , , , , , , , , , , , , , , , , .