• Subscribe

Common Data Model enables RAPID deployment for productivity solutions – Solutions (Part 2/3)

Common data framework for rapid deployment of factory productivity and supply chain solutions

In today’s semiconductor factories, it’s become increasingly difficult and time-consuming to generate valid data for factory productivity solutions.

To address this gap, Applied Materials is developing a common data model using the Extract, Transform and Map (ETL) capabilities modules from Applied’s APF (Advanced Productivity Platform) software environment.

Figure 1 below shows steps involved in building the common data model schema

Smartfactory productivity solutions components

Smartfactory Productivity Solutions Components
Common framework from dispaching to automation — Built on Smartfactory Platform ETM, Common Data Model (CDM), EngineeredWorks, Solution UI > Open Box Solutions

Applied solution leverages out of box APF adapters to integrate the data from various sources such as MES, MCS and other applications in the CIM solution.

Figure 2 shows the data intercepted from various solutions in APF repository

Once the data is replicated in APF repository then it is mapped to the common data model schema using APF macros as shown in figure 3

Extract, Transpose, and MAP(ETM)

Once the data is transformed in the common data model format then it is ready to get used in various factory productivity solutions.

Figure 4 shows some of the snapshot of various tables

Recently, Applied Materials has been using this approach to rapidly deploy Factory Productivity solutions within 6 months.

About the Author

Madhav Kidambi, Director, Technical Marketing, Automation Products Group
Madhav Kidambi, Director, Technical Marketing, Automation Products Group
Madhav has been working in the semiconductor industry for the past 24 years in the areas of simulation modeling, dispatching /scheduling, and factory automation systems. He has led the deployment of the Dispatching and Full Auto solutions at numerous 200mm and 300mm front end manufacturing sites. He has also helped deploy scheduling and planning solutions from Applied Materials. Prior to joining Applied Materials, Mr. Kidambi worked at Infineon, Qimonda, and Spansion. He is currently leading the product management group for factory productivity and supply chain solutions within Applied Materials Automation Products Group. He has an MS in industrial and systems engineering from Virginia Tech University and a BE in mechanical engineering from VNIT, India.