The effectiveness of the Business Intelligence(BI)system mainly depends on the quality of knowledge it produces.The decision-making process is hindered,and the user’s trust is lost,if the knowledge offered is undesir...The effectiveness of the Business Intelligence(BI)system mainly depends on the quality of knowledge it produces.The decision-making process is hindered,and the user’s trust is lost,if the knowledge offered is undesired or of poor quality.A Data Warehouse(DW)is a huge collection of data gathered from many sources and an important part of any BI solution to assist management in making better decisions.The Extract,Transform,and Load(ETL)process is the backbone of a DW system,and it is responsible for moving data from source systems into the DW system.The more mature the ETL process the more reliable the DW system.In this paper,we propose the ETL Maturity Model(EMM)that assists organizations in achieving a high-quality ETL system and thereby enhancing the quality of knowledge produced.The EMM is made up of five levels of maturity i.e.,Chaotic,Acceptable,Stable,Efficient and Reliable.Each level of maturity contains Key Process Areas(KPAs)that have been endorsed by industry experts and include all critical features of a good ETL system.Quality Objectives(QOs)are defined procedures that,when implemented,resulted in a high-quality ETL process.Each KPA has its own set of QOs,the execution of which meets the requirements of that KPA.Multiple brainstorming sessions with relevant industry experts helped to enhance the model.EMMwas deployed in two key projects utilizing multiple case studies to supplement the validation process and support our claim.This model can assist organizations in improving their current ETL process and transforming it into a more mature ETL system.This model can also provide high-quality information to assist users inmaking better decisions and gaining their trust.展开更多
A uniform metadata representation is introduced for heterogeneous databases, multi media information and other information sources. Some features about metadata are analyzed. The limitation of existing metadata model...A uniform metadata representation is introduced for heterogeneous databases, multi media information and other information sources. Some features about metadata are analyzed. The limitation of existing metadata model is compared with the new one. The metadata model is described in XML which is fit for metadata denotation and exchange. The well structured data, semi structured data and those exterior file data without structure are described in the metadata model. The model provides feasibility and extensibility for constructing uniform metadata model of data warehouse.展开更多
This paper puts forward a new conception:model warehouse,analyzes the reason why model warehouse appears and introduces the characteristics and architecture of model warehouse.Last,this paper points out that model war...This paper puts forward a new conception:model warehouse,analyzes the reason why model warehouse appears and introduces the characteristics and architecture of model warehouse.Last,this paper points out that model warehouse is an important part of WebGIS.展开更多
Engineering data are separately organized and their schemas are increasingly complex and variable. Engineering data management systems are needed to be able to manage the unified data and to be both customizable and e...Engineering data are separately organized and their schemas are increasingly complex and variable. Engineering data management systems are needed to be able to manage the unified data and to be both customizable and extensible. The design of the systems is heavily dependent on the flexibility and self-description of the data model. The characteristics of engineering data and their management facts are analyzed. Then engineering data warehouse (EDW) architecture and multi-layer metamodels are presented. Also an approach to manage anduse engineering data by a meta object is proposed. Finally, an application flight test EDW system (FTEDWS) is described and meta-objects to manage engineering data in the data warehouse are used. It shows that adopting a meta-modeling approach provides a support for interchangeability and a sufficiently flexible environment in which the system evolution and the reusability can be handled.展开更多
In the smart warehousing system adopting cargo-to-person mode, all the items are stored in the movable shelves. There are some warehouse robots transporting the shelves to the working platforms for completing order pi...In the smart warehousing system adopting cargo-to-person mode, all the items are stored in the movable shelves. There are some warehouse robots transporting the shelves to the working platforms for completing order picking or items replenishment tasks. When the number of robots is insufficient, the task allocation problem of robots is an important issue in designing the warehousing system. In this paper, the task allocation problem of insufficient warehouse robots (TAPIR) is investigated. Firstly, the TAPIR problem is decomposed into three sub-problems: task grouping problem, task scheduling problem and task balanced allocation problem. Then three sub-problems are respectively formulated into integer programming models, and the corresponding heuristic algorithms for solving three sub-problems are designed. Finally, the simulation and analysis are done on the real data of online bookstore. Simulation results show that the mathematical models and algorithms of this paper can provide a theoretical basis for solving the TAPIR problem.展开更多
Data structure and semantics of the traditional data model cannot effectively represent the data warehouse, it is difficult to effectively support online analytical processing (referred to as OLAP). This paper is pr...Data structure and semantics of the traditional data model cannot effectively represent the data warehouse, it is difficult to effectively support online analytical processing (referred to as OLAP). This paper is propose a new multidimensional data model based on the partial ordering and mapping. The data model can fully express the complex data structure and semantics of data warehouse, and provide an OLAP operation as the core of the operation of algebra, support structure in levels of complex aggregation operation sequence, which can effectively support the application of OLAE The data model supports the concept of aggregation function constraint, and provides constraint mechanism of the hierarchy aggregation function.展开更多
The task assignment problem of robots in a smart warehouse environment (TARSWE) based on cargo-to-person is investigated. Firstly, the sites of warehouse robots and the order picking tasks are given and the task ass...The task assignment problem of robots in a smart warehouse environment (TARSWE) based on cargo-to-person is investigated. Firstly, the sites of warehouse robots and the order picking tasks are given and the task assignment problem for picking one order is formulated into a mathematical model to minimize the total operation cost. Then a heuristic algorithm is designed to solve the task assignment problem for picking multiple orders. Finally, simulations are done by using the orders data of online bookstore A. The results show that using the heuristic algorithm of this paper to assign robots, the cost was reduced by 2% and it can effectively avoid far route and unbalanced workload of robots. The feasibility and validity of the model and algorithm are verified. The model and algorithm in this paper provide a theoretical basis to solve the TARSWE.展开更多
The analysis of relevant standards and guidelines proved the lack of information on actions and activities concerning data warehouse testing. The absence of the complex data warehouse testing methodology seems to be c...The analysis of relevant standards and guidelines proved the lack of information on actions and activities concerning data warehouse testing. The absence of the complex data warehouse testing methodology seems to be crucial particularly in the phase of the data warehouse implementation. The aim of this article is to suggest basic data warehouse testing activities as a final part of data warehouse testing methodology. The testing activities that must be implemented in the process of the data warehouse testing can be split into four logical units regarding the multidimensional database testing, data pump testing, metadata and OLAP (Online Analytical Processing) testing. Between main testing activities can be included: revision of the multidimensional database scheme, optimizing of fact tables number, problem of data explosion, testing for correctness of aggregation and summation of data etc.展开更多
This research aims to validate a structural equation modeling (SEM) model for measuring warehouse performance using data from an international company in Australia (company G). Moreover, a methodological triangula...This research aims to validate a structural equation modeling (SEM) model for measuring warehouse performance using data from an international company in Australia (company G). Moreover, a methodological triangulation method was also adopted to test whether different methodological approaches produce convergent findings about warehouse performance measurement (WPM). These three different methods are the SEM model, the multiple case research study, and validation of the SEM model using data from 80 companies in Thailand and a company in Australia. With the results from the triangulation method, it is obvious that the SEM model can be used to measure the performance of warehouses in Thailand and Australia. Since the SEM model consists only of significant indicators, it is more appropriate than company G's scorecard. Furthermore, the SEM model can overcome the limitations of traditional models by allowing companies to compare their performance over time.展开更多
Visible light communication(VLC)has a paramount role in industrial implementations,especially for better energy efficiency,high speed-data rates,and low susceptibility to interference.However,since studies on VLC for ...Visible light communication(VLC)has a paramount role in industrial implementations,especially for better energy efficiency,high speed-data rates,and low susceptibility to interference.However,since studies on VLC for industrial implementations are in scarcity,areas concerning illumination optimisation and communication performances demand further investigation.As such,this paper presents a new modelling of light fixture distribution for a warehouse model to provide acceptable illumination and communication performances.The proposed model was evaluated based on various semi-angles at half power(SAAHP)and different height levels for several parameters,including received power,signal to noise ratio(SNR),and bit error rate(BER).The results revealed improvement in terms of received power and SNR with 30 Mbps data rate.Various modulations were studied to improve the link quality,whereby better average BER values of 5.55×10^(−15) and 1.06×10^(−10) had been achieved with 4 PAM and 8 PPM,respectively.The simulation outcomes are indeed viable for the practical warehouse model.展开更多
Efficiency of supply chains management mostly depends on the process coordination and information integration between the supply chain companies.The well-known integrated circuit design houses,the wafer fabrication in...Efficiency of supply chains management mostly depends on the process coordination and information integration between the supply chain companies.The well-known integrated circuit design houses,the wafer fabrication industries, and the integrated circuit packaging/testing business has together formed a contiguous supply chain from materials to system in Taiwan during the past decades.Logistic management of the wafer hence becomes the key linkage in the semiconductor foundry supply chain.The objective of this paper is to develop the wafer warehouse management system for global wafer logistics.Current operations for wafer logistics management are firstly reviewed. The system requirements are analyzed by the model-driven business transformation approach.The business operation model and the platform-independent solution architecture for the wafer logistics management are constructed.A prototype information system is also developed for validation.Results of this research can improve the effectiveness and efficiency in wafer logistics management for the semiconductor foundry supply chain.展开更多
基金King Saud University for funding this work through Researchers Supporting Project Number(RSP-2021/387),King Saud University,Riyadh,Saudi Arabia.
文摘The effectiveness of the Business Intelligence(BI)system mainly depends on the quality of knowledge it produces.The decision-making process is hindered,and the user’s trust is lost,if the knowledge offered is undesired or of poor quality.A Data Warehouse(DW)is a huge collection of data gathered from many sources and an important part of any BI solution to assist management in making better decisions.The Extract,Transform,and Load(ETL)process is the backbone of a DW system,and it is responsible for moving data from source systems into the DW system.The more mature the ETL process the more reliable the DW system.In this paper,we propose the ETL Maturity Model(EMM)that assists organizations in achieving a high-quality ETL system and thereby enhancing the quality of knowledge produced.The EMM is made up of five levels of maturity i.e.,Chaotic,Acceptable,Stable,Efficient and Reliable.Each level of maturity contains Key Process Areas(KPAs)that have been endorsed by industry experts and include all critical features of a good ETL system.Quality Objectives(QOs)are defined procedures that,when implemented,resulted in a high-quality ETL process.Each KPA has its own set of QOs,the execution of which meets the requirements of that KPA.Multiple brainstorming sessions with relevant industry experts helped to enhance the model.EMMwas deployed in two key projects utilizing multiple case studies to supplement the validation process and support our claim.This model can assist organizations in improving their current ETL process and transforming it into a more mature ETL system.This model can also provide high-quality information to assist users inmaking better decisions and gaining their trust.
文摘A uniform metadata representation is introduced for heterogeneous databases, multi media information and other information sources. Some features about metadata are analyzed. The limitation of existing metadata model is compared with the new one. The metadata model is described in XML which is fit for metadata denotation and exchange. The well structured data, semi structured data and those exterior file data without structure are described in the metadata model. The model provides feasibility and extensibility for constructing uniform metadata model of data warehouse.
文摘This paper puts forward a new conception:model warehouse,analyzes the reason why model warehouse appears and introduces the characteristics and architecture of model warehouse.Last,this paper points out that model warehouse is an important part of WebGIS.
文摘Engineering data are separately organized and their schemas are increasingly complex and variable. Engineering data management systems are needed to be able to manage the unified data and to be both customizable and extensible. The design of the systems is heavily dependent on the flexibility and self-description of the data model. The characteristics of engineering data and their management facts are analyzed. Then engineering data warehouse (EDW) architecture and multi-layer metamodels are presented. Also an approach to manage anduse engineering data by a meta object is proposed. Finally, an application flight test EDW system (FTEDWS) is described and meta-objects to manage engineering data in the data warehouse are used. It shows that adopting a meta-modeling approach provides a support for interchangeability and a sufficiently flexible environment in which the system evolution and the reusability can be handled.
文摘In the smart warehousing system adopting cargo-to-person mode, all the items are stored in the movable shelves. There are some warehouse robots transporting the shelves to the working platforms for completing order picking or items replenishment tasks. When the number of robots is insufficient, the task allocation problem of robots is an important issue in designing the warehousing system. In this paper, the task allocation problem of insufficient warehouse robots (TAPIR) is investigated. Firstly, the TAPIR problem is decomposed into three sub-problems: task grouping problem, task scheduling problem and task balanced allocation problem. Then three sub-problems are respectively formulated into integer programming models, and the corresponding heuristic algorithms for solving three sub-problems are designed. Finally, the simulation and analysis are done on the real data of online bookstore. Simulation results show that the mathematical models and algorithms of this paper can provide a theoretical basis for solving the TAPIR problem.
文摘Data structure and semantics of the traditional data model cannot effectively represent the data warehouse, it is difficult to effectively support online analytical processing (referred to as OLAP). This paper is propose a new multidimensional data model based on the partial ordering and mapping. The data model can fully express the complex data structure and semantics of data warehouse, and provide an OLAP operation as the core of the operation of algebra, support structure in levels of complex aggregation operation sequence, which can effectively support the application of OLAE The data model supports the concept of aggregation function constraint, and provides constraint mechanism of the hierarchy aggregation function.
基金Project Supported: National Natural Science Foundation of China (11131009, 71540028, F012408), Funding Project for Academic Human Resources Development in Institutions of Higher Learning Under the Jurisdiction of Beijing Municipality (CIT&TCD20130327), and major research project of Beijing Wuzi University.
文摘The task assignment problem of robots in a smart warehouse environment (TARSWE) based on cargo-to-person is investigated. Firstly, the sites of warehouse robots and the order picking tasks are given and the task assignment problem for picking one order is formulated into a mathematical model to minimize the total operation cost. Then a heuristic algorithm is designed to solve the task assignment problem for picking multiple orders. Finally, simulations are done by using the orders data of online bookstore A. The results show that using the heuristic algorithm of this paper to assign robots, the cost was reduced by 2% and it can effectively avoid far route and unbalanced workload of robots. The feasibility and validity of the model and algorithm are verified. The model and algorithm in this paper provide a theoretical basis to solve the TARSWE.
文摘The analysis of relevant standards and guidelines proved the lack of information on actions and activities concerning data warehouse testing. The absence of the complex data warehouse testing methodology seems to be crucial particularly in the phase of the data warehouse implementation. The aim of this article is to suggest basic data warehouse testing activities as a final part of data warehouse testing methodology. The testing activities that must be implemented in the process of the data warehouse testing can be split into four logical units regarding the multidimensional database testing, data pump testing, metadata and OLAP (Online Analytical Processing) testing. Between main testing activities can be included: revision of the multidimensional database scheme, optimizing of fact tables number, problem of data explosion, testing for correctness of aggregation and summation of data etc.
文摘This research aims to validate a structural equation modeling (SEM) model for measuring warehouse performance using data from an international company in Australia (company G). Moreover, a methodological triangulation method was also adopted to test whether different methodological approaches produce convergent findings about warehouse performance measurement (WPM). These three different methods are the SEM model, the multiple case research study, and validation of the SEM model using data from 80 companies in Thailand and a company in Australia. With the results from the triangulation method, it is obvious that the SEM model can be used to measure the performance of warehouses in Thailand and Australia. Since the SEM model consists only of significant indicators, it is more appropriate than company G's scorecard. Furthermore, the SEM model can overcome the limitations of traditional models by allowing companies to compare their performance over time.
基金supported by Professional Development Research University Grant(UTM Vot No.06E59).
文摘Visible light communication(VLC)has a paramount role in industrial implementations,especially for better energy efficiency,high speed-data rates,and low susceptibility to interference.However,since studies on VLC for industrial implementations are in scarcity,areas concerning illumination optimisation and communication performances demand further investigation.As such,this paper presents a new modelling of light fixture distribution for a warehouse model to provide acceptable illumination and communication performances.The proposed model was evaluated based on various semi-angles at half power(SAAHP)and different height levels for several parameters,including received power,signal to noise ratio(SNR),and bit error rate(BER).The results revealed improvement in terms of received power and SNR with 30 Mbps data rate.Various modulations were studied to improve the link quality,whereby better average BER values of 5.55×10^(−15) and 1.06×10^(−10) had been achieved with 4 PAM and 8 PPM,respectively.The simulation outcomes are indeed viable for the practical warehouse model.
文摘Efficiency of supply chains management mostly depends on the process coordination and information integration between the supply chain companies.The well-known integrated circuit design houses,the wafer fabrication industries, and the integrated circuit packaging/testing business has together formed a contiguous supply chain from materials to system in Taiwan during the past decades.Logistic management of the wafer hence becomes the key linkage in the semiconductor foundry supply chain.The objective of this paper is to develop the wafer warehouse management system for global wafer logistics.Current operations for wafer logistics management are firstly reviewed. The system requirements are analyzed by the model-driven business transformation approach.The business operation model and the platform-independent solution architecture for the wafer logistics management are constructed.A prototype information system is also developed for validation.Results of this research can improve the effectiveness and efficiency in wafer logistics management for the semiconductor foundry supply chain.