A Structural Model of Data Warehousing Success

Data warehousing is an important area of practice and research, yet few studies have assessed its practices in general and critical success factors in particular. Although plenty of guidelines for implementation exist, few have been subjected to empirical testing. Furthermore, no model is available for comparing and evaluating the various claims made in different studies. In order to better understand the critical success factors and their effects on data warehousing success, a research model is developed in this paper. This model is useful for comparing findings across studies and for selecting variables for future research. The model is tested using data collected from a cross sectional survey of data warehousing professionals. Partial Least Square (PLS) is used to validate the structural relations identified in the model. The resulting model has three groups of success factors. Technical factor is found to positively influence information quality, whereas both operational and economic factors have a positive effect on system quality. Structural relations are also found among the dependent variables. System quality positively influences information quality, which in turn positively affects individual benefits. Individual benefits in turn has a positive relation with organizational benefits

Heterogeneous biomedical database integration using a hybrid strategy: a p53 cancer research database.

Complex problems in life science research give rise to multidisciplinary collaboration, and hence, to the need for heterogeneous database integration. The tumor suppressor p53 is mutated in close to 50% of human cancers, and a small drug-like molecule with the ability to restore native function to cancerous p53 mutants is a long-held medical goal of cancer treatment. The Cancer Research DataBase (CRDB) was designed in support of a project to find such small molecules. As a cancer informatics project, the CRDB involved small molecule data, computational docking results, functional assays, and protein structure data. As an example of the hybrid strategy for data integration, it combined the mediation and data warehousing approaches. This paper uses the CRDB to illustrate the hybrid strategy as a viable approach to heterogeneous data integration in biomedicine, and provides a design method for those considering similar systems. More efficient data sharing implies increased productivity, and, hopefully, improved chances of success in cancer research. (Code and database schemas are freely downloadable, http://www.igb.uci.edu/research/research.html.)

XML content warehousing: Improving sociological studies of mailing lists and web data

In this paper, we present the guidelines for an XML-based approach for the sociological study of Web data such as the analysis of mailing lists or databases available online. The use of an XML warehouse is a flexible solution for storing and processing this kind of data. We propose an implemented solution and show possible applications with our case study of profiles of experts involved in W3C standard-setting activity. We illustrate the sociological use of semi-structured databases by presenting our XML Schema for mailing-list warehousing. An XML Schema allows many adjunctions or crossings of data sources, without modifying existing data sets, while allowing possible structural evolution. We also show that the existence of hidden data implies increased complexity for traditional SQL users. XML content warehousing allows altogether exhaustive warehousing and recursive queries through contents, with far less dependence on the initial storage. We finally present the possibility of exporting the data stored in the warehouse to commonly-used advanced software devoted to sociological analysis

An ES process framework for understanding the strategic decision making process of ES implementations

Enterprise systems (ES) implementations are regarded costly, time and resource consuming and have a great impact on the organization in terms of the risks they involve and the opportunities they provide. The steering committee (SC) represents the group of individuals who is responsible for making strategic decisions throughout the ES implementation lifecycle. It is evident from recent studies that there is a relationship between the decision making process and ES implementation success. One of the key elements that contribute to the success of ES implementations is a quick decision making process (Brown and Vessey, 1999; Gupta, 2000; Parr, et al., 1999). This study addresses the strategic decision-making process by SC through its focus on four research questions (1) How can the strategic decision-making process in the implementation of ES be better understood, during each phase of the ES implementation lifecycle? (2) What is the process by which the SC makes strategic decisions? (3) How are fast decisions made? and (4) How does decision speed link to the success of ES implementation? Process models of ES implementation will provide a framework to investigate the strategic decision making process during each phases of the ES implementation lifecycle. Patterns in the decision making process will be explored using strategic choice models. This study develops a research model that focuses on the decision making process by steering committee to explore research questions. It concludes with identifying contributions to both IS research and business practitioners

A unified view of data-intensive flows in business intelligence systems : a survey

Data-intensive flows are central processes in today’s business intelligence (BI) systems, deploying different technologies to deliver data, from a multitude of data sources, in user-preferred and analysis-ready formats. To meet complex requirements of next generation BI systems, we often need an effective combination of the traditionally batched extract-transform-load (ETL) processes that populate a data warehouse (DW) from integrated data sources, and more real-time and operational data flows that integrate source data at runtime. Both academia and industry thus must have a clear understanding of the foundations of data-intensive flows and the challenges of moving towards next generation BI environments. In this paper we present a survey of today’s research on data-intensive flows and the related fundamental fields of database theory. The study is based on a proposed set of dimensions describing the important challenges of data-intensive flows in the next generation BI setting. As a result of this survey, we envision an architecture of a system for managing the lifecycle of data-intensive flows. The results further provide a comprehensive understanding of data-intensive flows, recognizing challenges that still are to be addressed, and how the current solutions can be applied for addressing these challenges.Peer ReviewedPostprint (author's final draft

Approaching delivery as a service

This paper explores the new logistics business model of Delivery as a Service, a concept aiming at a more efficient, fast and customer-oriented practice, linking IT solution development, urban logistics operations, supply chain efficiency and new business models. Delivery as a Service (DaaS) is defined as a service-oriented delivery and business processes in line with customer expectations and needs in the on-demand economy. The approach of this paper is an industry report based on evidence collected in multiple exploratory European projects integrating ambitious and strategic findings on Internet of Things, urban planning, consolidation centres, transport optimisation, and clean vehicle use. It contributes to a future scenario of urban logistics business models

Outsourcing the logistics function: the supply chain role of third-party logistics service providers in UK convenience retailing

Logistics, defined as the process of strategically managing the procurement, movement and storage of materials; parts; finished inventory and related information flow through the organisation and its marketing channels, is increasingly being recognised as a vital part of an organisation’s marketing strategy. In many organisations, the logistics function is currently facing significant challenges. Pressures from increasing competition and high customer service-level expectations have created a need for more professional and better-equipped logistics services. Confronted with such competitive pressures, these organisations are faced with decisions of the make OR buy kind with regard to the logistics processes of supply and distribution. In addition, the emergence of a need to focus on core capabilities has led many organisations to contract out all, or part of, the logistics function to third-party providers. This paper explores the challenges of outsourcing logistics in the UK convenience-retailing sector

Automated schema matching techniques: an exploratory study

Manual schema matching is a problem for many database applications that use multiple data sources including data warehousing and e-commerce applications. Current research attempts to address this problem by developing algorithms to automate aspects of the schema-matching task. In this paper, an approach using an external dictionary facilitates automated discovery of the semantic meaning of database schema terms. An experimental study was conducted to evaluate the performance and accuracy of five schema-matching techniques with the proposed approach, called SemMA. The proposed approach and results are compared with two existing semi-automated schema-matching approaches and suggestions for future research are made

Service : the new focus in international manufacturing and trade

Major breakthroughs in communications technologies in the 1980s made it possible to monitor all phases of moving a product from raw material sourcing through processing to delivery to the customer. Close monitoring revealed major inefficiencies in the traditional set-up of materials acquisition, production, and distribution - especially large inventory holdings. At the same time, patterns of customer demand began to shift more rapidly, partly because of better communications networks. The need to reduce costs and become responsive to volatile changes in customer preferences forced businesses to substantially restructure their corporate practices. With domestic factor costs rising, manufacturers outsourced intermediate production to foreign enterprises in countries with lower wages. Merchants also sought cheaper supply sources - developments that held promise for developing countries. Many developing countries have been unable to take advantage of structural changes in world manufacturing and trade because they have been unable to deliver the quality of production, fast turnaround, and reliability of delivery manufacturing businesses need to keep up with changing market demand. A new management approach - logistics management - is needed to cut business costs and to be more responsive to rapidly changing markets. Logistics management orchestrates materials acquisition, production, and marketing to reduce inventories to a minimum. Effective logistics management enables many organizations to conduct their business with less than a week's worth of supplies. Such a radical change requires major corporate restructuring and the development of strategic alliances with service providers. Outsourcing of production is projected to continue growing, and the search for less costly supply sources will continue. Developing countries can capitalize on those trends - but only if they substantially improve their infrastructure, liberalize their regulations, and begin to apply modern logistics management techniques. If they do not, their outlook is not promising.Transport and Trade Logistics,Common Carriers Industry,Business in Development,Business Environment,Environmental Economics&Policies