ANALYSIS AND DESIGN OF DATA WAREHOUSE BASED ON SNDIKTI USING DATA WAREHOUSE LIFE CYCLE METHOD AT UNSOED ENGINEERING FACULTY

The National Standard for Higher Education (Standar Nasional Pendidikan Tinggi or SNDIKTI) is a standard unit that includes the National Education Standards, plus the Research Standards, and Community Service Standards. Based on the policy in the Regulation of the Minister of Education and Culture (Peraturan Menteri Pendidikan dan Kebudayaan or Permendikbud) No. 3 of 2020 regarding SNDIKTI, Jenderal Soedirman University (Unsoed) Architecture needs to prepare data/ information for analysis based on SNDIKTI 2020. The data is obtained from several internal systems and manual recapitulation within a predetermined period of time. Currently the architecture already has many information systems, but it is still difficult to manage the existing data. So it is important for the architecture to have an important repository to minimize human errors and data inconsistencies. So to perform complex data management, a data warehouse is needed. In this study, the data warehouse design uses the Data Warehouse Life Cycle (DWLC) method with the data warehouse model used is the star schema model. The results of the data warehousing process are in the form of a dashboard, Online Analytical Processing (OLAP), and reports intended for the executives of the Unsoed Faculty of Engineering. The output is presented using a BI (Business Intelligence) tool called Knowage

PENGEMBANGAN SISTEM INFORMASI PENGOLAHAN INVENTORY BARANG JADI DAN LOGISTIK DI PT. SNFOOD

Inventory System at PT SNFOOD has existed and still manual with data processing using MsExcel. Inventory system is used for finished goods needs of customers while logistics to see the basic material obtained from the supplier. Many parts logistics process data quantity of incoming and outgoing goods. Methodology Software Development Life Cycle (SDLC) and Object Oriented Analysis Design (OOAD), While tools that use Wamp Server, PHP, Apache Server, MySQL.These applications facilitate employees in the warehouse to monitor and determine information regarding incoming outgoing goods in the warehouse for speed processing of items.Application System can be used for parts inventory warehouse as well as to provide convenience in the process of controlling the data in the warehouse of finished goods and provide information updates stock of goods

RANCANGAN DATA WAREHOUSE UNTUK ANALISIS KINERJA PRODUKSI DI PT. URECEL INDONESIA

PT. Urecel Indonesia engaged in the manufacturing and production of polyurethane foam. The business process of production is closely linked to the function of three divisions: marketing, purchasing, and production. The amount of data stored in each division and resulted in the accumulation of data. The data in the division has not integrated each other mutually. The leaders often have not get the information that he/she was needed to evaluate the performance of production. This is because the information is presented based on every division itsefl and using a different data source. This study discusses the design of the data warehouse to solve these problems. Research carried out by the System Development Life Cycle (SDLC). In other parts, the design of the data warehouse is done using a snowflake schema, while the extract, transform, and loading (ETL) performed on the data relating to production performance needs. The results of the ETL process is then stored in the data warehouse for analysis. Implemengtasi results and analysis carried out showed that the design of data warehouse generated in this study proved it can be used to measure the performance of the production of PT. Urecel Indonesia

A comprehensive approach to data warehouse testing

Testing is an essential part of the design life-cycle of any software product. Nevertheless, while most phases of data warehouse design have received considerable attention in the literature, not much has been said about data warehouse testing. In this paper we introduce a number of data mart-specific testing activities, we classify them in terms of what is tested and how it is tested, and we discuss how they can be framed within a reference design methodology. Categories and Subject Descriptor

Assessment of CO2 emissions reduction in a distribution warehouse

Building energy use accounts for almost 50% of the total CO2 emissions in the UK. Most of the research has focused on reducing the operational impact of buildings, however in recent years many studies have indicated the significance of embodied energy in different building types. This paper primarily focuses on illustrating the relative importance of operational and embodied energy in a flexible use light distribution warehouse. The building is chosen for the study as it is relatively easy to model and represents many distribution centres and industrial warehouses in Europe. A carbon footprinting study was carried out by conducting an inventory of the major installed materials with potentially significant carbon impact and material substitutions covering the building structure. Ecotect computer simulation program was used to determine the energy consumption for the 25 years design life of the building. This paper evaluates alternative design strategies for the envelope of the building and their effects on the whole life emissions by investigating both embodied and operational implications of changing the envelope characteristics. The results provide an insight to quantify the total amount of CO2 emissions saved through design optimisation by modelling embodied and operational energy

Feasibility of Warehouse Drone Adoption and Implementation

While aerial delivery drones capture headlines, the pace of adoption of drones in warehouses has shown the greatest acceleration. Warehousing constitutes 30% of the cost of logistics in the US. The rise of e-commerce, greater customer service demands of retail stores, and a shortage of skilled labor have intensified competition for efficient warehouse operations. This takes place during an era of shortening technology life cycles. This paper integrates several theoretical perspectives on technology diffusion and adoption to propose a framework to inform supply chain decision-makers on when to invest in new robotics technology

From BIM to BEMS, covering the design- to operational-phase interoperability gap

This paper deals with the FP7 EU project “Building as a Service” (BaaS). The BaaS project is a research initiative which aims at providing a generic solution for delivering standardization and interoperability concepts for building data and open middleware platform covering the Design- and Operational-Phase In-teroperability Gap in the application domain of “non-residential buildings.” There are two important phases in the building life-cycle: the design phase and the operational phase. Development and integration of ICT tech-nologies can help best coordinate the building design and operation phases. Overcoming interoperability gaps between both phases so as providing a way of integration to use existing and future tools and services would help to enhance building operations and controls. Better design, standardization and interoperability can con-tribute themselves to the goals of improving energy efficiency. Interoperable components working as services at the building level, will lead naturally to the concept of the Building as a Service ecosystem. This paper aims at analyzing some of the BaaS project topics: (1) building data management and interoperability: data warehouse to collect, organize, store and aggregate static and dynamic data from various in- and out-of-building sources; an IFC-based BIM will act as a central repository for all static building data, and a data warehouse will be used for dynamic data, both schemes mapped using a unique vocabulary. (2) Integration of building energy management Services using Open Service Middleware Platform technologies. A service middleware platform to abstract the building physical devices, support high level services on the cloud and facili-tate secure two-way communication between the physical and ICT layers (building) with high level services (cloud)

Simulation modeling of tool delivery system in a machining line

This paper describes an industrial project aiming to enhance the existing simulation modeling suites used at a car engine factory in the UK. The company continues to enhance its simulation modeling capabilities towards so called the `total plant modeling' which not only covers the production facilities but also key ancillary facilities. Tool delivery is one such ancillary process. The existing modeling practices at the company are limited to modeling tool changes and assume that tools meet their expected life and the replacement is always available. In reality, the tools are not always reaching the expected life, the facilities in the tool crib are a limiting resource and the tool inventory has to be minimized. The tool delivery system developed in this project has specific features that model how the tool crib operates, how tools are supplied to the machining lines and various operating strategie

Designing distribution centres for agile supply chains

Increasing globalisation and market volatility represent major challenges for many supply chains, and particularly for the distribution centres within them. This paper examines how distribution centres are being designed to be agile even though they are, by their nature, long-term fixed assets. The research is based on semi-structured interviews with warehouse design companies to identify the range of agility types that were regarded as necessary during the design phase, and how these were addressed. The research also explores the cost, time and service level implications, whilst handling variances in demand or supply. The interviewee responses are expressed in terms of qualitative measures on Likert scales. The results indicate that there is generally a slightly or moderately higher cost to design for agility. Based on the literature and the case study responses, a methodology is developed of how to address agility within warehouse design, and areas of further research are identified