Technical and industrial issues of Advanced Planning and Scheduling (APS) systems

Hvolby, Hans‐Henrik; Steger-Jensen, Kenn

doi:10.1016/j.compind.2010.07.009

Cited by 76 publications

(44 citation statements)

References 9 publications

Supporting

Mentioning

Contrasting

Unclassified

Order By: Relevance

“…Cios, Pedrycz, Winiarski et al (2007) consider the snowflake and the galaxy schemas as the variations of the star schema, while Inmon (1995), Kimball (2008), Linstedt (2010), Corr and Stagnittno (2014) and Jensen et al (2010) consider it as a separate dimensional modelling philosophy and not as a variation of the star schema.…”

Section: The Star Schemamentioning

confidence: 99%

“…Dimension tables do not confirm to the relational model strategy of normalisation and may contain redundancy (Jensen et al, 2010). The Fact table, on the other hand, holds the foreign key to dimensional table values and as there is no redundancy it could be considered to be in 3NF (Jensen et al, 2010). All foreign keys to the dimensional tables build together the primary key for the fact table.…”

Section: The Star Schemamentioning

confidence: 99%

“…Dimensions have a key field and one additional field for every attribute (Kimball et al, 2008;Jensen et al, 2010). The fact table is a central table that contains transactional information and foreign keys to dimensional tables, while dimensional tables contain only master data (Kimball et al, 2008;Jensen et al, 2010;Cios, Pedrycz, Winiarski et al, 2007). In visual model representation, the dimension model resembles a star, thus the name (Jensen, 2010).…”

Section: The Star Schemamentioning

confidence: 99%

See 2 more Smart Citations

An Evaluation of the Challenges of Multilingualism in Data Warehouse Development

Dediź

Stanier

2016

Proceedings of the 18th International Conference on Enterprise Information Systems

View full text Add to dashboard Cite

ICEIS 2016 received 257 paper submissions from 42 countries in all continents, which makes it one of the largest conferences in the World in the area of Information Systems, thus demonstrating the success and global dimension of this conference. From these, 42 papers were selected for publication and presentation at the Conference as full papers. These numbers, leading to a full-paper acceptance ratio of 16%, show the intention of preserving a high quality forum for this conference, a quality that we intend to maintain in the future, for the next editions of this conference.The high number and high quality of the received papers imposed difficult choices in the selection process. To evaluate each submission, a double blind paper review was performed by the Program Committee, whose members are highly qualified researchers in ICEIS topic areas.All presented papers will be available at the SCITEPRESS Digital Library and will be submitted for indexation by Thomson Reuters Conference Proceedings Citation Index (ISI), INSPEC, DBLP, EI (Elsevier Index) and Scopus.Additionally, a short list of presented papers will be selected to be expanded into a forthcoming book of ICEIS 2016 Selected Papers to be published by Springer in the LNBIP Series.The technical program of the conference included a panel and 4 invited talks delivered by internationally distinguished speakers, namely: Claudia Loebbecke (University of Cologne, Germany), Sergio Gusmeroli (TXT e-solutions SPA, Italy), Wil Van Der Aalst (Technische Universiteit Eindhoven, Netherlands) and Jan Vom Brocke (University of Liechtenstein, Liechtenstein). Their participation positively contributes to reinforce the overall quality of the Conference and to provide a deeper understanding of the fields addressed by the conference.Moreover, ICEIS 2016 had a Doctoral Consortium on Enterprise Information Systems and 1 tutorial. We are thankful to the Conference Co-chairs (Olivier Camp and José Cordeiro) and Program Co-chairs (Slimane Hammoudi, Leszek Maciaszek and Michele M. Missikoff) for their dedication and hard work in organizing these events.We sincerely thank all the authors for their submissions and participation in ICEIS 2016. Furthermore, we would like to thank all the members of the program committee and reviewers, who helped us with their expertise, dedication and time. We would also like to thank the invited speakers for their excellent contribution in sharing their knowledge and vision and the workshop/special session chairs whose collaboration with ICEIS 2015 was much appreciated. Finally, we gratefully acknowledge the professional support of the ICEIS 2016 team for all organizational processes. XIIIWe hope that all colleagues find this a fruitful and inspiring conference. We hope to contribute to the development of the Enterprise Information Systems community and look forward to having additional research results presented at the next edition of ICEIS, details of which are available at http://www.iceis.org. Slimane Hammoudi University of Cologne, GermanyAbstract:...

show abstract

Section: The Star Schemamentioning

confidence: 99%

Section: The Star Schemamentioning

confidence: 99%

Section: The Star Schemamentioning

confidence: 99%

See 1 more Smart Citation

An Evaluation of the Challenges of Multilingualism in Data Warehouse Development

Dediź

Stanier

2016

Proceedings of the 18th International Conference on Enterprise Information Systems

View full text Add to dashboard Cite

show abstract

“…Almeder et al (2015) tackle this issue by solving the MLCLSP in two steps: batching and lot-streaming. Albeit enterprise resource planning (ERP) systems are significantly improved in the integration of material and capacity planning (Hvolby and Steger-Jensen 2010), they are still unable to perform satisfactory in a dynamic, uncertain environment (Tenhiälä and Helkiö 2015). To tackle these challenges more efficiently, advanced planning and scheduling systems (APS) combine production planning and scheduling and utilise ERP data to adjust the plans to the actual status of the production system (Fleischmann, Meyr, and Wagner 2005).…”

Section: Towards Robust Multi-level Planning In Practicementioning

confidence: 99%

Robust production planning and control for multi-stage systems with flexible final assembly lines

Gyulai

Pfeiffer

Monostori

2016

International Journal of Production Research

View full text Add to dashboard Cite

Production planning of final assembly systems is a challenging task, as the often fluctuating order volumes require flexible solutions. Besides, the calculated plans need to be robust against the process-level disturbances and stochastic nature of some parameters like manual processing times or machine availability. In the paper, a simulation-based optimisation method is proposed that utilises lower level shop floor data to calculate robust production plans for final assembly lines of a flexible, multi-stage production system. In order to minimise the idle times when executing the plans, the capacity control that specifies the proper operator-task assignments is also determined. The analysed multi-stage system is operated with a pull strategy, which means that the production at the final assembly lines generates demands for the preceding stages providing the assembled components. In order to guarantee the feasibility of the plans calculated for the final assembly lines, a decomposition approach is proposed to optimise the production plan of preceding stages. By this way, the robust production can be ensured resulting in reduced losses and overall production costs even though the system is exposed to changes and disturbances.

show abstract

“…Por su parte, Lee, Jeong, Moon (2002) presenta un modelo para un APS basado en algoritmos genéticos, que trabaja con órdenes de venta con fecha de entrega y que permite considerar tercerización. Lalas, et al (2005) propusieron modelo combinatorio, posteriormente implementado en C++, para integrar sistemas MRP con "scheduling" tipo shop-floor en ambientes discretos.…”

unclassified

Integración de Modelos de Planeamiento y Scheduling en Sistemas de Información Empresariales

Vidoni

Rodríguez

Vecchietti

2013

IJIE

View full text Add to dashboard Cite

RESUMEN:La aplicación e implementación de modelos matemáticos tendientes a colaborar con la toma de decisiones no resulta un proceso sencillo y directo: existen diversos factores que dificultan la integración de los modelos matemáticos desarrollados con los sistemas de información empresariales. ERP 2 Optimizer Linkage (E2OL) es un sistema que acopla un modelo matemático al sistema empresarial o ERP utilizado, proveyendo las interfaces necesarias para la adecuada visualización y facilitando el modelado de problemas típicos presentes en la gestión de empresas de producción, al incrementar el empleo de los modelos de optimización de la planificación y scheduling en los procesos de manufactura de las empresas.Palabras clave: Optimización. Modelos matemáticos. Planning. Scheduling. Integración. INTRODUCCIÓNDesde que los sistemas Enterprise Resource Planning (ERP) surgieron en el mercado de los sistemas empresariales genéricos, se han convertido en el estándar de-facto para obtener una plataforma integrada que administre el negocio de la empresa, favoreciendo la gestión en tiempo real de la información (SHAOJUN et al., 2008). Estos sistemas son "aplicaciones empaquetadas" pensadas para funcionar en la mayoría de las organizaciones, pero siempre necesitan cierto grado de personalización para poder funcionar adecuadamente en el negocio de la empresa donde se está insertando (ROTHENBERGER; SRITE, 2009). En lo que respecta a las empresas manufactureras industriales que deseen incorporar sistemas ERP, un punto clave a considerar es la administración del planeamiento y "scheduling" de la producción, lo que puede ser un determinante en la selección del ERP. YaMcCarthy y Liu (1993) hablaban de una "brecha" entre la teoría y la práctica del "scheduling", en lo que respecta a sistemas empresariales. Por su parte, Hopp y Spearman . Dicho autor también menciona que los APS se integran con la cadena de suministro y con los sistemas de la empresa que los implementa, con el objeto de extraer de ellos la información pertinente para realizar el "scheduling". Estos sistemas habilitan a las empresas generar optimizaciones de acuerdo a sus objetivos estratégicos y crear planes que satisfagan múltiples metas. A diferencia de los ERP, los APS buscan propuestas factibles y lo más cercanos al óptimo posible, al mismo tiempo que consideran -de forma explícita-los potenciales cuellos de botella.Considerando esta problemática, se han desarrollado varios trabajos en el área.Bourgeois, Artiba y Tahon (1993), presentaron un sistema de "scheduling" a corto plazo desarrollado específicamente para una empresa. Por su parte, Lee, Jeong, Moon (2002) presenta un modelo para un APS basado en algoritmos genéticos, que trabaja con órdenes de venta con fecha de entrega y que permite considerar tercerización. Tomando esto como premisa, se desarrolló un sistema de software que enlaza el sistema ERP de una empresa -o el sistema propio ya existente -con un modelo matemático de optimización (el cual puede ser reemplazado y/o modificado), para poder ejecutar el ...

show abstract

Technical and industrial issues of Advanced Planning and Scheduling (APS) systems

Cited by 76 publications

References 9 publications

An Evaluation of the Challenges of Multilingualism in Data Warehouse Development

An Evaluation of the Challenges of Multilingualism in Data Warehouse Development

Robust production planning and control for multi-stage systems with flexible final assembly lines

Integración de Modelos de Planeamiento y Scheduling en Sistemas de Información Empresariales

Contact Info

Product

Resources

About