Structural features of automated lean production planning system database

International Workshop "Advanced Technologies in Material Science, Mechanical and Automation Engineering – MIP: Engineering – 2019"

材料科学;机械制造;原子能学

Skorniakova, E.A.^1 ; Vasyukov, V.M.^2 ; Sulaberidze, V. Sh.^1 ; Yastrebov, A.P.^1

Saint-Petersburg State University of Aerospace Instrumentation, Bolshaya Morskaia str. 67, Saint-Petersburg

190000, Russia^1

Individual Entrepreneur Vasyukov Vasiliy Mikhaylovich, 52^2

Krasnoselskoe (Gorelovo) Highway 12, Saint-Petersburg

198323, Russia^3

关键词: Automated systems;    Automation of process;    Customer orientation;    Database creation;    Database structures;    Iterative development;    Production planning systems;    Structural feature;   

Others  :  https://iopscience.iop.org/article/10.1088/1757-899X/537/3/032026/pdf
DOI  :  10.1088/1757-899X/537/3/032026

学科分类：材料科学（综合）

来源: IOP

【 摘 要 】

Necessity of creation of special automated systems based on lean manufacturing principles for efficient recourse usage and maximum customer-orientation was proved. Process of one of the planning system key elements such as structure of database creation is described. Importance of mixed development, includes technical task with description of subject area and problematics of solvable task and also variant of database structure, is explained. Provided initial and final structures of database after all stages of testing and adjustment with description of tables contents. Quantity of tables was increased from 9 to 25 in final version, this can be explained by the point that structure created only by planning specialist doesn't include all specifics of process interpretation in automated system, and the fact is that iterative development is very important for such automation of processes. Provided research of methods that can increase speed of data processing was provided - specific type of key and algorithmic filling of data array by typical values.