ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'CodigoInstitucion'. [20018] (severity 16) [SELECT PublicObrasAutores.NumeroEmpleado, PublicObrasAutores.ApellidoPaterno, PublicObrasAutores.ApellidoMaterno, PublicObrasAutores.Nombre, PublicObrasAutores.NombreCompleto FROM PublicObrasAutores LEFT JOIN PublicObrasAutoresFil ON PublicObrasAutores.RefPublicacion = PublicObrasAutoresFil.RefPublicacion WHERE PublicObrasAutores.RefPublicacion = '613721' AND PublicObrasAutores.NumeroEmpleado IS NULL AND PublicObrasAutoresFil.CodigoInstitucion IS NOT NULL;]
SELECT PublicObrasAutores.NumeroEmpleado, PublicObrasAutores.ApellidoPaterno, PublicObrasAutores.ApellidoMaterno, PublicObrasAutores.Nombre, PublicObrasAutores.NombreCompleto FROM PublicObrasAutores LEFT JOIN PublicObrasAutoresFil ON PublicObrasAutores.RefPublicacion = PublicObrasAutoresFil.RefPublicacion WHERE PublicObrasAutores.RefPublicacion = '613721' AND PublicObrasAutores.NumeroEmpleado IS NULL AND PublicObrasAutoresFil.CodigoInstitucion IS NOT NULL;

ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'CodigoInstitucion'. [20018] (severity 16) [SELECT PublicObrasAutores.NumeroEmpleado, PublicObrasAutores.ApellidoPaterno, PublicObrasAutores.ApellidoMaterno, PublicObrasAutores.Nombre, PublicObrasAutores.NombreCompleto FROM PublicObrasAutores LEFT JOIN PublicObrasAutoresFil ON PublicObrasAutores.RefPublicacion = PublicObrasAutoresFil.RefPublicacion WHERE PublicObrasAutores.RefPublicacion = '613721' AND PublicObrasAutores.NumeroEmpleado IS NULL AND PublicObrasAutoresFil.CodigoInstitucion IS NULL;]
SELECT PublicObrasAutores.NumeroEmpleado, PublicObrasAutores.ApellidoPaterno, PublicObrasAutores.ApellidoMaterno, PublicObrasAutores.Nombre, PublicObrasAutores.NombreCompleto FROM PublicObrasAutores LEFT JOIN PublicObrasAutoresFil ON PublicObrasAutores.RefPublicacion = PublicObrasAutoresFil.RefPublicacion WHERE PublicObrasAutores.RefPublicacion = '613721' AND PublicObrasAutores.NumeroEmpleado IS NULL AND PublicObrasAutoresFil.CodigoInstitucion IS NULL;

ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'Institucion'. [20018] (severity 16) [SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = '613721']
SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = '613721'

ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'Institucion'. [20018] (severity 16) [SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = 613721 AND InstitucionPropia = 'S' UNION SELECT Adscripciones.Entidad FROM PublicacionesObras JOIN PublicObrasAutores ON PublicacionesObras.Identificador = PublicObrasAutores.RefPublicacion JOIN Adscripciones ON PublicObrasAutores.NumeroEmpleado = Adscripciones.NumeroEmpleado WHERE (PublicacionesObras.FechaPublicacion BETWEEN Adscripciones.FechaDesde AND Adscripciones.FechaHasta OR (PublicacionesObras.FechaPublicacion >= Adscripciones.FechaDesde AND Adscripciones.FechaHasta IS NULL)) AND PublicacionesObras.Identificador= 613721]
SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = 613721 AND InstitucionPropia = 'S' UNION SELECT Adscripciones.Entidad FROM PublicacionesObras JOIN PublicObrasAutores ON PublicacionesObras.Identificador = PublicObrasAutores.RefPublicacion JOIN Adscripciones ON PublicObrasAutores.NumeroEmpleado = Adscripciones.NumeroEmpleado WHERE (PublicacionesObras.FechaPublicacion BETWEEN Adscripciones.FechaDesde AND Adscripciones.FechaHasta OR (PublicacionesObras.FechaPublicacion >= Adscripciones.FechaDesde AND Adscripciones.FechaHasta IS NULL)) AND PublicacionesObras.Identificador= 613721

Título del libro: 23rd European Modeling And Simulation Symposium, Emss 2011
Título del capítulo: Stochastic optimization of industrial maintenance strategies

Autores UNAM:
ANN GODELIEVE WELLENS;

---

Autores externos:

---

Idioma:
Inglés

---

Año de publicación:
2011

---

Palabras clave:

Control variable; Equipment characteristics; Excel; Industrial maintenance; Industrial production; Legal requirements; Maintenance management; Maintenance management techniques; Maintenance policy; Maintenance practices; Maintenance strategies; Mathematical simulation model; Output variables; Simulation; Simulation strategies; Simulink; Stochastic optimizations; Computer simulation; Economics; Industrial research; Industry; MATLAB; Optimization; Random processes; Reliability; Maintenance

---

Resumen:

The dynamics of business requires industries to produce more and more at the lowest cost, highest quality and a high level of reliability (availability and reliability of their equipment) to meet the stringent technical, economical and legal requirements, and to remain efficiently and competitively in the market. The aim of this research is the development of a mathematical simulation model for the optimization of maintenance policy in a complex industrial production system, in which maintenance practices and production are integrated into a single procedure, in which control variables are the maintenance policies. This was done using a combination of maintenance management techniques and stochastic processes. This work combines an efficient methodology for maintenance management, such as RCM, with mathematical modeling, to be able to optimize the availability of a complex system. To be able to compare different maintenance strategies and the corresponding reliability, availability and economics, the model's output variables are the system and parts availability in a given time. Two different simulation strategies were used, on one hand being the modeling of the complex system using an Excel database and the interaction of variables through constraints and likelyhood behavior, and on the other hand Matlab's Simulink / SimEvents, feeded by equipment characteristics, behavior, the companies' environment, needs and maintenance strategy actions.

---

Entidades citadas de la UNAM:

---

Fuente:



ISBN:
9788890372445
Editorial:
DIPTEM UNIV GENOA

Tipo de producto:
Conference Paper