Submitted by Luiz Felipe Barbosa (luiz.fbabreu2@ufpe.br) on 2015-03-12T14:43:13Z No. of bitstreams: 2 license_rdf: 1232 bytes, checksum: 66e71c371cc565284e70f40736c94386 (MD5) DISSERTAÇÃO Rodrigo Costa Mateus.pdf: 3391149 bytes, checksum: 05f64e90f88333325241ea7d0600e6e4 (MD5) / Approved for entry into archive by Daniella Sodre (daniella.sodre@ufpe.br) on 2015-03-13T12:58:59Z (GMT) No. of bitstreams: 2 license_rdf: 1232 bytes, checksum: 66e71c371cc565284e70f40736c94386 (MD5) DISSERTAÇÃO Rodrigo Costa Mateus.pdf: 3391149 bytes, checksum: 05f64e90f88333325241ea7d0600e6e4 (MD5) / Made available in DSpace on 2015-03-13T12:58:59Z (GMT). No. of bitstreams: 2 license_rdf: 1232 bytes, checksum: 66e71c371cc565284e70f40736c94386 (MD5) DISSERTAÇÃO Rodrigo Costa Mateus.pdf: 3391149 bytes, checksum: 05f64e90f88333325241ea7d0600e6e4 (MD5) Previous issue date: 2013-09-05 / Plataformas de computação em nuvem proveem escalabilidade, elasticidade e tolerância a falhas aos sistemas computacionais. Além disso, elas foram projetadas para lidar com grande volume de dados utilizando recursos computacionais quase ilimitados. Data Warehouse Geográfico (DWG) se tornou uma das principais tecnologias de suporte à decisão, pois promove a integração do Data Warehouse convencionais, das ferramentas On-Line Analytical Processing e dos Sistemas de Informações Geográficas. Por esse motivo, um DWG viabiliza a análise no contexto espacial aliada à execução de consultas multidimensionais envolvendo grande volume de dados. A combinação da computação em nuvem e dos DWG traz consigo o desafio de prover análises de dados espaciais em um ambiente distribuído. Além disso, há a preocupação com o desempenho no processamento de consultas, que utilizam janelas de consultas espaciais ad-hoc e realizam várias junções entre as tabelas de dimensões e de fatos. Embora existam eficientes mecanismos para aumentar o desempenho do processamento de consultas em DWG, como as estruturas de indexação, elas se tornam impróprias aos DWG mantidos em nuvem porque estes mecanismos não lidam com a recuperação de dados em ambientes distribuídos. Nesta dissertação, propõe-se um novo índice para DWG mantidos em nuvem chamado CSB-Index (Cloud Spatial- Bitmap Index). O CSB-Index se baseia no SB-Index e permite a recuperação de dados mantidos em um ambiente distribuído, pois mantém em sua estrutura referências aos bancos de dados que compõe o DWG. Além disso, ele introduz o uso do Índice Bitmap de Junção aos DWG armazenados em nuvem, evitando o processamento das custosas operações de junção estrela. A viabilidade do CSB-Index foi comprovada por meio de testes experimentais de desempenho e escalabilidade. Comparações entre diferentes métodos de acesso indicaram que o CSB-Index diminuiu significativamente o tempo de resposta do processamento de consultas roll-up e drilldown relacionadas aos predicados espaciais “intersecta”, “está contido” e “contém”, possibilitando redução no tempo de processamento destas consultas de 58,2% até 99,65%. Também foi verificado que a escalabilidade dos dados e do número de máquinas que armazenam o DWG não afetam negativamente o desempenho do CSB-Index. Por fim, este trabalho também investigou o impacto do uso das federações no processamento das consultas SOLAP e comprovou que está técnica possibilita maior desempenho ao processamento destas consultas.

Made available in DSpace on 2014-06-12T15:49:03Z (GMT). No. of bitstreams: 1 license.txt: 1748 bytes, checksum: 8a4605be74aa9ea9d79846c1fba20a33 (MD5) Previous issue date: 2008 / Conselho Nacional de Desenvolvimento Científico e Tecnológico / Existem várias propostas na literatura visando a integração das funcionalidades e características pertinentes aos processamentos de dados analíticos (OLAP) e geográficos (SIG). O principal objetivo é prover um ambiente único, com capacidades de processamento geográfico e multidimensional, para dar suporte ao processo de tomada de decisões estratégicas. Este tipo de ambiente vem sendo referido atualmente como SOLAP. Entretanto, pelo fato destas duas tecnologias terem sido concebidas com propósitos distintos, a integração entre estes dois ambientes não é uma tarefa fácil, e mesmo com tantas pesquisas sendo desenvolvidas, temos alguns pontos em aberto que merecem ser explorados. A definição de modelos de dados para Data Warehouse Geográficos é um dos items desta integração. Outro ponto inserido neste contexto é a definição de funções de agregação para medidas geográficas. Estas funções são utilizadas no momento da especificação dos cubos de dados multidimensionais e geográficos. Conseqüentemente, também necessitamos de novos modelos de cubos de dados que possibilitem a associação de geometrias aos fatos e aos membros dos níveis. Uma das partes mais importantes desse processo de integração é a consulta aos dados. Porém, a maioria das abordagens que almejam esta integração de processamento, não dispõe de uma linguagem de consulta que possibilite a utilização simultânea, tanto de operadores multidimensionais como espaciais. É neste contexto que se insere esta tese, na qual apresentamos: i) um modelo formal para definição de DWG; ii) um conjunto de funções de agregação para medidas geográficas; iii) um modelo formal para cubos de dados chamado GeoMDCube; e iv) uma linguagem de consulta geográfica-multidimensional denominada GeoMDQL (Geographic Multidimensional Query Language). GeoMDQL estende e integra, em uma única sintaxe, os principais operadores multidimensionais e espaciais presentes na maioria das ferramentas e em ambientes disponíveis atualmente para processamento multidimensional e geográfico. GeoMDQL é baseada em padrões bem estabelecidos como ( MDX Multidimensional Expressions) e OGC Simple Features for SQL. As idéias propostas foram aplicadas na prática, por meio da implementação de uma arquitetura SOLAP chamada Golapware e o desenvolvimento de estudo de caso baseado em dados de aplicações reais. Dessa forma, foi possível demonstrar a utilização dos modelos, das funções e da linguagem de consulta e operadores SOLAP discutidos nesta tese

Made available in DSpace on 2014-06-12T15:53:01Z (GMT). No. of bitstreams: 2 arquivo1896_1.pdf: 1693335 bytes, checksum: 86af81558f5020ac2630511c928a5ca1 (MD5) license.txt: 1748 bytes, checksum: 8a4605be74aa9ea9d79846c1fba20a33 (MD5) Previous issue date: 2009 / Apesar da utilização de sistemas de gestão integrada (ERP) e um alto nível de informatização nas indústrias de grande porte, a maioria delas enfrenta dificuldade na geração de informação útil à tomada de decisão. A falta de instrumentos adequados para tratar os dados produzidos de forma organizada e com qualidade leva os gestores a desenvolverem formas alternativas de geração da informação através da utilização de planilhas eletrônicas. Com o aumento do volume de informações, o processo de manutenção e geração da informação acaba prejudicando a qualidade da informação gerada e conseqüentemente comprometendo o processo de tomada de decisão. Esta dissertação apresenta um processo de criação de um Data Warehouse (DW) para subsidiar os gestores de empresas, particularmente de grande porte, recentemente implantadas ou em implantação na obtenção de informações com qualidade e possibilitar a criação de cenários e tendências através de sistemas de suporte à decisão ou usando ferramentas OLAP a partir da utilização do Microsoft Excel. Considerando que as soluções de caráter puramente tecnológico têm limitações de efetividade, esta dissertação contempla ainda a análise e redefinição de processos organizacionais de geração e manutenção da informação, na implantação do DW. A proposta foi implementada em um caso real no setor financeiro de uma indústria de grande porte da área naval, em fase de implantação, o Estaleiro Atlântico Sul, localizado em Suape Pernambuco

Organisations have spent billions of dollars (USD) on investments in data warehouses. Many have succeeded, but many have also failed. These failures are considered mostly to be of an organisational nature and not of a technological, as one might have expected. Due to the failures, organisations have problems to derive business value from their data warehouse investments. Obtaining business value from data warehouses is necessary, since the investment is of such a magnitude that it is clearly visible in the balance sheet. In order to investigate how the business value may be increased, we have conducted an extensive literature study, aimed at identifying opportunities and future directions, which may alleviate the problem of low return on investment. To balance the work, we have also identified pitfalls, which may hinder organisations to derive business value from their data warehouses. Based on the literature survey, we have identified and motivated possible research areas, which we consider relevant if organisations are to derive real business value from their data warehouses. These areas are: * Integrating data warehouses in knowledge management. * Data warehouses as a foundation for information data super stores. * Using data warehouses to predict the need for business change. * Aligning data warehouses and business processes. As the areas are rather broad, we have also included examples of more specific research problems, within each possible research area. Furthermore, we have given initial ideas regarding how to investigate those specific research problems.

This diploma thesis concerns about Business Intelligence area and its current usage in business practice. The main objective is to analyze the functionality of QlikView application, which represents so called "In memory analysis" products. This work`s output may serve as basis material for making qualified decision, whether QlikView is suitable for particular implementation, or not. Work is divided into two areas. First one is general functionality analysis of QlikView in comparison to MS BI Development Studio tools. The objective of this part is to determine strengths and weaknesses of the application in various situations. In the second part business task solution is demonstrated, using QlikView to turn business requirements into working application. The main benefit of this work is detailed analysis of alternative stream of Business Intelligence applications representative with an estimation of its current market potential.

Historically, the paper market has consisted of few customers with high demands. However, the market has changed and nowadays it consists of many customer with lower demands, which causes problems in the warehouse process of Braviken Papermill. The main problem is that the utilization rates in the storage bays are low due to the relatively large bays compared to the order quantities. The purpose of this project is to develop a new set of bays that fits the current market and increases the utilization rates. The goal of the new set is to decrease the amount of manual operations and instead use the full potential of the allocation system.    The new set of bays consist of four bay types, dimensioned for 2, 4, 8 and 16 reel stacks respectively. Several experiments are done, and the new set of bays performs better than the current one, in terms of the utilization rates for storage events in the bays. The average utilization rate is significantly higher for the new set compared to the current. A decrease in effective storage space can be compensated by an increased degree of utilization. Also, it is beneficial with more and smaller bays in a market situation like the one of Holmen Paper.

Over the last decade, we have witnessed the emergence of networks in a wide spectrum of application domains, ranging from social and information networks to biological and transportation networks.Graphs provide a solid theoretical foundation for modeling complex networks and revealing valuable insights from both the network structure and the data embedded within its entities.As the business and social environments are getting increasingly complex and interconnected, graphs became a widespread abstraction at the core of the information infrastructure supporting those environments. Modern information systems consist of a large number of sophisticated and interacting business entities that naturally form graphs. In particular, integrating graphs into data warehouse systems received a lot of interest from both academia and industry. Indeed, data warehouses are the central enterprise's information repository and are critical for proper decision support and future planning. Graph warehousing is emerging as the field that extends current information systems with graph management and analytics capabilities. Many approaches were proposed to address the graph data warehousing challenge. These efforts laid the foundation for multidimensional modeling and analysis of graphs. However, most of the proposed approaches partially tackle the graph warehousing problem by being restricted to simple abstractions such as homogeneous graphs or ignoring important topics such as multidimensional integrity constraints and dimension hierarchies.In this dissertation, we conduct a systematic study of the graph data warehousing topic and address the key challenges of database and multidimensional modeling of graphs.We first propose GRAD, a new graph database model tailored for graph warehousing and OLAP analytics. GRAD aims to provide analysts with a set of simple, well-defined, and adaptable conceptual components to support rich semantics and perform complex analysis on graphs.Then, we define the multidimensional concepts for heterogeneous attributed graphs and highlight the new types of measures that could be derived. We project this multidimensional model on property graphs and explore how to extract the candidate multidimensional concepts and build graph cubes. Then, we extend the multidimensional model by integrating GRAD and show how GRAD facilitates multidimensional graph modeling, and enables supporting dimension hierarchies and building new types of OLAP cubes on graphs.Afterward, we present TopoGraph, a graph data warehousing framework that extends current graph warehousing models with new types of cubes and queries combining graph-oriented and OLAP querying. TopoGraph goes beyond traditional OLAP cubes, which process value-based grouping of tables, by considering also the topological properties of the graph elements. And it goes beyond current graph warehousing models by proposing new types of graph cubes. These cubes embed a rich repertoire of measures that could be represented with numerical values, with entire graphs, or as a combination of them.Finally, we propose an architecture of the graph data warehouse and describe its main building blocks and the remaining gaps. The various components of the graph warehousing framework can be effectively leveraged as a foundation for designing and building industry-grade graph data warehouses.We believe that our research in this thesis brings us a step closer towards a better understanding of graph warehousing. Yet, the models and framework we proposed are the tip of the iceberg. The marriage of graph and warehousing technologies will bring many exciting research opportunities, which we briefly discuss at the end of the thesis. / Doctorat en Sciences de l'ingénieur et technologie / info:eu-repo/semantics/nonPublished

Background: Retailing industry has been growing all around the world tremendously. We will see a remarkable change and improvement in clothing and baby products retailing industries in Sweden. Previously, companies either try to sell through traditional brick and mortar physical stores or online. But since the last decade, to become successful company in new global world, companies realize the fact that they need to combine the strategy of selling through different channels. In plain words the integration of these channels is referred as an omni-channel. Combining the different selling strategies and offering through different mode of channels raises the need for enhanced performance management throughout the supply chain. Within supply chain, warehouse is a crucial element and due to shift in strategies it is the most affected section. An efficient warehouse design is become essential in order to get performance and cost-effective benefits. Purpose: The purpose of this study is to analyze the impacts of having omni channel strategy on warehouse management. How it affects the overall working of warehousing, and influence their planning, need for improvement, integration and optimization. Further, challenges that a central warehouse faces in accordance to meet new demands and needs, raised due to omni channel strategy e.g. buy anything from anywhere at any time, could be explored along with their possible solutions. Method: An exploratory study is conducted, with qualitative case study methodology. Primary data with semi-structured interviews were considered to be main data collection method. Conclusion: The author has founded challenges that central warehouse faces during its operational activities. Challenges that are identified in central warehouse operational activities with reference to omni channel logistics strategy are human errors, additional work, large and mix pallets, barcoding, ERP and WMS low level integrated systems, unsuitable warehouse design, incompatible picking gears, ineffective automated packing machine and shipping. But these problems can be solved by having optimal integrated ERP system, RFID technology, new improved information technology, improved warehouse layout design and using advanced picking gears.

This thesis project is a study of a complex of historic, railway-goods warehouses in Nottingham (UK) that were internally destroyed by a fire two decades ago. The site has has become an erstwhile symbol of the city, a stark reminder of both a past age of prosperity and the century of post-industrial decline that ultimately followed.Now facing the threat of demolition, it is questioned whether it is possible to rescue the intrinsic potential of these ruins to radically transport us beyond the experience of the everyday city, to a unique and inhabitable space of transition between past and present. This thesis also examins the changing role of the library in the 21st century and the future for this public institution as a vestibule for the transmission of local culture and history. This leads to the central question of the thesis project; is it possible - through the appropriate treatment of an industrial ruin - to begin a process of reconciliation with the past, one that can provide some kind closure to the cognitive dissidence caused by language and tone of this kind of architectural heritage and the limited prospects that city like Nottingham faces today. / Detta examensarbete är en undersökning av ett komplex av historiska, järnvägsgodslager i Nottingham (Storbritannien) som internt förstördes av en brand två decennier sedan. Webbplatsen har blivit en dåvarande symbol för staden, en skarp påminnelse om både en tidigare ålder av välstånd och århundrade postindustriella nedgång som slutligen followed.Now inför hotet om rivning, är det ifrågasättas om det är möjligt att rädda inneboende potentialen hos dessa ruiner att radikalt transportera oss bortom upplevelsen av vardagliga staden, till en unik och beboelig utrymme för övergång mellan dåtid och nutid. Avhandlingen examins också förändrade roll biblioteket i det 21 century.This leder till den centrala frågan om examensarbetet; är det möjligt - genom lämplig behandling av en industriell ruin - att inleda en försoningsprocess med det förflutna, en som kan ge någon form stängning till den kognitiva oliktänkande på grund av språket och tonen i den här typen av arkitektoniska arvet och de begränsade möjligheterna att stad som Nottingham står inför i dag.

This article addresses one of the main problems faced by small- and medium-sized business in the non-metallic mining sector in Peru. These companies own warehouses and face the major problem of failing to deliver orders correctly and in a timely manner. This problem usually occurs when the business grows from a small- to medium-sized company in a short span of time; this situation leads to new processes within warehouses that are mostly not standardized. Besides, facilities are no longer optimal in space and the workers are not properly trained. The case study shows that the orders were not delivered on time due to factors such as lack of product identification, although the products have an expiration date and a warehouse without signaling and surrounded by traffic. To tackle this situation, a labeling process has been designed for the products, an adequate distribution technique is used in the warehouse through a newly designed warehouse layout, and a First Expired, First Out system has been implemented. Similarly, the design is accompanied by the 5s tool to provide a basis for order and continuous improvement. The results show that deliveries with delays were reduced from 38% to 10%. These results show that companies can grow rapidly and maintain quality of service through orderly management.