Data mining techniques application for prediction in OLAP cube

Data warehouses represent collections of data organized to support a process of decision support, and provide an appropriate solution for managing large volumes of data. OLAP online analytics is a technology that complements data warehouses to make data usable and understandable by users, by providing tools for visualization, exploration, and navigation of data-cubes. On the other hand, data mining allows the extraction of knowledge from data with different methods of description, classification, explanation and prediction. As part of this work, we propose new ways to improve existing approaches in the process of decision support. In the continuity of the work treating the coupling between the online analysis and data mining to integrate prediction into OLAP, an approach based on automatic learning with Clustering is proposed in order to partition an initial data cube into dense sub-cubes that could serve as a learning set to build a prediction model. The technique of data mining by regression trees is then applied for each sub-cube to predict the value of a cell

The Effects of Reducing Sanitary and Phytosanitary (SPS) Barriers to Trade on the Washington State Apple Industry

Health Economics and Policy,

Benchmarking Summarizability Processing in XML Warehouses with Complex Hierarchies

Business Intelligence plays an important role in decision making. Based on data warehouses and Online Analytical Processing, a business intelligence tool can be used to analyze complex data. Still, summarizability issues in data warehouses cause ineffective analyses that may become critical problems to businesses. To settle this issue, many researchers have studied and proposed various solutions, both in relational and XML data warehouses. However, they find difficulty in evaluating the performance of their proposals since the available benchmarks lack complex hierarchies. In order to contribute to summarizability analysis, this paper proposes an extension to the XML warehouse benchmark (XWeB) with complex hierarchies. The benchmark enables us to generate XML data warehouses with scalable complex hierarchies as well as summarizability processing. We experimentally demonstrated that complex hierarchies can definitely be included into a benchmark dataset, and that our benchmark is able to compare two alternative approaches dealing with summarizability issues.Comment: 15th International Workshop on Data Warehousing and OLAP (DOLAP 2012), Maui : United States (2012

Extracting, Transforming and Archiving Scientific Data

It is becoming common to archive research datasets that are not only large but also numerous. In addition, their corresponding metadata and the software required to analyse or display them need to be archived. Yet the manual curation of research data can be difficult and expensive, particularly in very large digital repositories, hence the importance of models and tools for automating digital curation tasks. The automation of these tasks faces three major challenges: (1) research data and data sources are highly heterogeneous, (2) future research needs are difficult to anticipate, (3) data is hard to index. To address these problems, we propose the Extract, Transform and Archive (ETA) model for managing and mechanizing the curation of research data. Specifically, we propose a scalable strategy for addressing the research-data problem, ranging from the extraction of legacy data to its long-term storage. We review some existing solutions and propose novel avenues of research.Comment: 8 pages, Fourth Workshop on Very Large Digital Libraries, 201

Efficiency & sustainability model to design and manage two-stage logistic networks

The distribution and storage efficiency together with the environmental sustainability are mandatory targets to consider when designing and managing modern supply chain (SC) networks. The current literature continuously looks for quantitative multi-perspective strategies and models, including and best balancing such issues that often diverge. This paper presents and applies a bi-objective optimization model to best design and manage two-stage logistic networks looking for the best trade-off between the SC stock level and the building and distribution environmental impact. The existence of good balance confirms the possibility to reduce the average SC stock level without a relevant increase of the emissions due to frequent replenishments

The logistic leverages of short food supply chains performance in terms of sustainability

Local food supply chains seem now to be considered as a serious alternative to global ones in terms of sustainability. A lot of initiatives are developed and they often are associated with economical, social and environmental benefits. The main objective of this paper is to discuss the reality of these advantages. They are notably considered as a way to relocate or maintain agricultural activities, particularly in suburban areas. They are also supposed to be able to restore the connection between producers and consumers and to promote an alternative agricultural model based on "greener" production methods and the reduction of transport distances (the "food miles"). However, several studies have shown the limits of these models. Firstly, many important retailers have developed short food supply chains, questioning the local food system as an alternative business model. Moreover, it needs specific resources that many producers can't always offer. Secondly, an inadequacy between consumer's and producer's expectations can be observed, and many initiatives aren't based on collective approaches but on individual actions. Thirdly, these models aren't always based on alternative producing models (as organic agriculture) and the limitation of distances isn't always a factor of reduction of greenhouse gases. The paper tries to assess the performance of local food systems and the logistic leverages that could improve that performance. Long food chains have demonstrated the importance of logistic as a means to improve performance, and we can wonder how the improvement of the logistic organization of short food systems could increase their economical, social and environmental performance. Considering the fact that there's not only one local food system but a wide range of possibilities based on different numbers of intermediates or different geographic scales, our work will, at first, be based on Parker's article [2005] that defines short food supply chains as systems that reduce both the distance and the number of intermediates. After a brief presentation of short chains and of the advantages related to them, we will discuss their environmental assessment and impact, showing the role of transport and production mode in that dimension. An analysis of long food chains will then enable us to show how strategic logistics has become in that sector and the means necessary to the implementation of efficient logistic schemes. After a first look at logistics in short chains, we will propose a detailed study of the logistic schemes observed in fruit and vegetable basket systems in the Paris Region. This will lead us to build a typology of organizations to study their potential role in the improvement of short chains performance and more specifically their ability to improve coordination between the actors of those chains.LOGISTIQUE ; DEVELOPPEMENT DURABLE ; PERFORMANCE

Spatial concentration in institutional industrial real estate investment in the England and Wales

In two recent papers Byrne and Lee (2006, 2007) examined the geographical concentration of institutional office and retail investment in England and Wales at two points in time; 1998 and 2003. The findings indicate that commercial office portfolios are concentrated in a very few urban areas, whereas retail holdings correlate more closely with the urban hierarchy of England and Wales and consequently are essentially ubiquitous. Research into the industrial sector is very much less developed, and this paper therefore makes a significant contribution to understanding the structure of industrial property investment in the UK. It shows that industrial investment concentration is between that of retail and office and is focussed on LAs with high levels of manual workers in areas with smaller industrial units. It also shows that during the period studied the structure of the sector changed, with greater emphasis on the distributional element, for which location is a principal consideration

A Decision Model for E-commerce-enabled Partial Market Exit

Struggling retail chains often try to recover profitability by closing some of their stores. The challenge in this strategy lies in determining how many stores to close, as store exit has implications for both the customers and the supply chain. After a store closes, its customers are lost forever to the competition, unless there is a surviving open store nearby or an electronic alternative such as an e-store. From the supply chain perspective, after a store closes, its supporting regional distribution center is left with less business, and thus reduced viability. This paper develops a decision support model to study the profitability of alternative retail network structures by varying the proportion of stores that are closed, the average price sensitivity of demand, the price difference between the online store and the traditional retailers, and customer retention rates