Scope of this master’s thesis contains agile data warehouse design. It begins with a brief demonstration of data warehouse issues, shows the architectures dimensional data warehouse, corporate information factory and data vault. Furthermore, the thesis introduces agile methodologies suitable for data warehouses. Main part of this thesis focuses on the data warehouse design and development in Kentico Software s.r.o. using the modelstorming, shows implementation of universal ETL process for loading dimensional data warehouse, designs ETL processes, data warehouse storage and presentation layer. In the end, the thesis discusses future extensions to the data warehouse such as knowledge discovery module or large-scale data expansion.

Lagerhantering avser aktiviteter som mottagning av varor, inlagring, lagring, orderplockning, omlagring, sortering och frakt. Enligt tidigare studier, av bland annat Drury (1988), uppstår 55% - 60% av lagrets kostnader i orderplockning och omlagring. Idag finns teorier och modeller om hur lagerhantering kring orderplockning och omlagring kan optimeras. Dock behandlas bulklager sällan i forskning eller litteratur. Detta arbete hade således i syfte att undersöka vedertagen teoris anpassningsförmåga på en verksamhet med bulklager. Studien har uppfyllt syftet genom en fall- och litteraturstudie med både kvalitativa och kvantitativa tillvägagångssätt i form av intervjuer och observationer. Lagerutformning och lagerstyrning kan med fördel ses som grundläggande metoder som förutsätter effektivitetsutveckling inom plockning och omlagring i bulklager. Metoder som MUDA och 5S skapar förutsättningarna att identifiera, upprätthålla och genomföra effektivitetsförbättringar.  De vedertagna metoderna som studerats kunde genom observation och intervju konstateras som implementerbar eller icke implementerbar. Som sammanfattning kunde en övergripande mall av metoderna sammanställas där det gemensamt och separat kunde bidra till effektivisering. Fallföretaget kunde förses med förbättringsförslag som rekommenderas att införas i både mindre etapper och under större, mer omfattande projekt. / Inventory management refers to activities such as receiving goods, storing, in storage, order picking, rearranging, sorting and shipping. According to previous studies, by Drury (1988), 55% - 60% of the warehouse costs incur in order picking and rearrangement. Today there are theories and models on how inventory management around order picking and rearrangement can be optimized. However, bulk stocks are rarely addressed in research or literature. Thus, this work was aimed at examining the adaptive theory of customary methods in a business with bulk storage. The study has fulfilled its purpose through a case and literature study with both qualitative and quantitative approaches in the form of interviews and observations. Inventory design and inventory control can advantageously be seen as basic methods that require efficiency development in picking and rearranging in bulk storages. Methods such as MUDA and 5S create the conditions for identifying, maintaining and implementing efficiency improvements. The customary methods studied could, through observation and interview, be found to be implementable or non-implementable. In summary, an overall template of the methods could be compiled where they could jointly and separately contribute to efficiency improvements. The studied company could be provided with improvement proposals that are recommended to be introduced in both smaller stages and during larger, more extensive projects.

The content of this diploma thesis is the design of a new warehouse hall with administration in the Zetor complex in the Brno – Líšeň district. It is the building thaht is divided into warehouse hall and administrative part. The warehouse hall has one floor and will be used for storage of steel products within the Zetor complex. The administrative part has three floors, where the 1st floor serves as a background for warehouse employees, on the 2nd and 3rd floors there are office space with social facilities. The construction is based on deep foundations on embossed piles. The supporting structure of the building is designed as a prefibricated reinforces concrete skeleton with continuous columns and beams places on the columns. The peripheral shell of the both part sis made of sandwich mineral panels. The supporting structure of the roof of the warehouse hall consists of roof trusses and is made as a flat single-skin. The ceiling construction of the administrative part is made of SPIROLL ceiling panels, the roof of the administration is also made as a flat single-skin.

Bakgrund: Under de senaste decennierna har behovet gällande effektivare logistikhantering inom alla branscher ökat. Detta härstammar bland annat från förändrade ekonomiska förutsättningar, geopolitiska omvälvningar och utvidgade globala försörjningskedjor. Den interna logistiken har en central roll för att effektivisera interna logistikaktiviteter som till stor del avser ett företags lager, färdigvarulager och godshantering. En bidragande faktor som avgör svårighetsgraden för dessa aktiviteter är produktens fysiska utformning, då tyngre och större föremål kräver mer resurser, såsom planering och hantering. Dock med dagens föränderliga marknad och dess tillhörande osäkerhet, blir påfrestningarna för företag och deras logistik- och lagerplanering mer påtagliga. Syftet: Syftet med denna studie är att undersöka hanteringen av tungt och otympligt gods i färdigvarulagret för att tidseffektivisera lageraktiviteterna som påverkar utlastningskapaciteten. Metod: Det har utförts en fallstudie på ett företag beläget i Gävle kommun, som i denna studie kallas för Företag X. För att kunna undersöka kring det valda ämnet har även ett till företag varit aktuell till denna fallstudie, även det företaget är beläget i Gävle kommun och kallas i denna studie för Företag Y. Genom observationer på Företag Y, intervjuer med personal från Företag Y, samt skriftlig och fysisk kontakt med personal på Företag X har empiriska data samlats in. En kvalitativ deduktiv ansats har använts för att besvara studiens syfte och frågeställning. Empiri: Från produktionen på Företag X till utlastningen på Företag Y är det många medverkande aktörer som alla har en påverkan på utlastningskapaciteten. Det sker även tre olika betydande aktiviteter innan kund får sina produkter, dessa är inlagring, preppning och direktlast/förlast. I dagsläget är det avtalat att Företag Y ska hantera utlastningen av 13 lastbilar per dag åt Företag X. Dock finns det en ojämn spridning kring antalet lastbilar som ankommer per dag samt deras ankomsttider. Slutsats: Studien påvisar att lageraktiviteterna som påverkar utlastningskapaciteten kunna tidseffektiviseras om slottidsbokningssystem, ett mer utvecklat lagerhanteringssystem samt rutiner kring inlagringen infördes, även att all tillgänglig resurs utnyttjades. / Background: In recent decades, more efficient logistics management has been increasingly required in all industries. This comes from, among other things, changed economic conditions, geopolitical upheavals and extended global supply chains. Internal logistics has a central role when the internal logistics activities are going to get more effective. Those internal logistics activities are mainly about a company's warehouse, finished goods warehouse and goods handling. A contributing factor that determines the degree of difficulty of these activities is the physical design of the product, as heavier and larger objects require more resources, such as planning and handling. However, with today's changing market and its associated uncertainty, the stresses on companies and their logistics and inventory planning are becoming more apparent. Purpose: The purpose of this study is to investigate the handling of heavy and unwieldy goods in the finished goods warehouse in order to make the warehouse activities that affect the loading capacity time-efficient.  Method: During this study we have implemented a case study on a company located in Gävle, that is referred to in this study as Company X. In order to investigate the chosen topic, another company has also been relevant to this case study, that company is also located in Gävle and is referred to in this study as Company Y. Through observations at Company Y, interviews with personnel from Company Y, as well as written and physical contact with personnel at Company X, the empirical data has been collected. A qualitative deductive approach has been used to answer the purpose and question of the study. Empiricism: From the production at Company X to the utilization at Company Y there are many participating actors who all have an impact on the loading capacity. There are also three different significant activities before the customer receives their products, which is storage, prepping and directloading/preloading. Currently is has been agreed that Company Y will handle the loading of 13 trucks per day for Comapny X. However, there is an uneven spread regarding the number of trucks that arrive per day and their arrival times.  Conclusion: The study shows that the warehouse activities that affect the loading capacity can be time-efficient if a slot time booking system, a more developed warehouse management system and routines regarding the storage were introduced, also that all available resources were utilized.

Este trabalho estuda a viabilidade de um sistema de monitoramento e de coleta de dados através da WEB, com a construção de um e-Science Zootécnico. Foram desenvolvidos os sistemas, os meios de comunicação e monitoramento, além de um simulador de deslocamento, para otimização da distribuição de antenas e identificação dos animais. Os modelos Random Walk e Pseudo-Browniano foram utilizados para a implementação do simulador. O sistema de comunicação e o sistema gestor foram desenvolvidos e testados através de experimentos que permitiram a análise e a verificação de desempenho do sistema completo, intitulado de \"e-LAFAC\", que permite o controle integral do sistema, como a comunicação das estações fixas, com as estações móveis, através de uma rede de sensores sem fio. A metodologia utilizada no projeto, bem como os resultados obtidos, permitem concluir que, o objetivo de acompanhar e monitorar o animal durante um experimento, com coleta de dados telemétricos em tempo real e à distância, foi alcançado. / This paper studies the viability of a system of monitoring and data collecting through the WEB, with the construction of a Zootechnic e-Science. The hardware systems, the electronic communication devices and monitoring protocols were developed, besides a dislocating simulator, for the improvement and distribution of the antennas and identification of the animals. The models Random Walk and Pseudo-Brownian Motion were used for the implementation of the simulator. The communication and management system were developed and tested through experiments that enable the analysis and evaluation of the performance of the complete system, called \"e-LAFAC\", that allows the complete control of the system, as well as the communication of the fixed stations with the movable stations through a wireless sensor network. The methodology used in the project, as well as the results, allow us to conclude that the objective of following and monitoring the animal during an experiment, with the telemetric data collection in real time was obtained.

Um ambiente de data warehousing oferece suporte ao processo de tomada de decisão. Ele consolida dados de fontes de informação distribuições, autônomas e heterogêneas em um único componente, o data warehouse, e realiza o processamento eficiente de consultas analíticas, denominadas OLAP (on-line analytical processing). Um data warehouse convencional armazena apenas dados alfanuméricos. Por outro lado, um data warehouse de imagens armazena, além desses dados convencionais, características intrínsecas de imagens, permitindo a realização de consultas analíticas estendidas com predicados de similaridade entre imagens. Esses ambientes demandam, portanto, a criação de estratégias que possibilitem o processamento eficiente dessas consultas complexas e custosas. Apesar de haver na literatura trabalhos voltados a índices bitmap para ambientes de data warehousing e métodos de acesso métricos para melhorar o desempenho de consultas por similaridade entre imagens, no melhor do nosso conhecimento, não há uma técnica que investigue essas duas questões em um mesmo contexto. Esta dissertação visa preencher essa lacuna na literatura por meio das seguintes contribuições: (i) proposta do ImageDWindex, um mecanismo para a otimização de consultas analíticas estendidas com predicados de similaridade entre imagens; e (ii) definição de diferentes estratégias de processamento de consultas sobre data warehouses de imagens usando o ImageDW-index. Para validar as soluções propostas, foram desenvolvidas duas outras contribuições secundárias, que são: (iii) o ImageDW-Gen, um gerador de dados com o objetivo de povoar o data warehouse de imagens; e (iv) a proposta de quatro classes de consulta, as quais enfocam em diferentes custos de processamento dos predicados de similaridade entre imagens. Utilizando o ImageDW-Gen, foram realizados testes de desempenho para investigar as vantagens introduzidas pelas estratégias propostas, de acordo com as classes de consultas definidas. Comparado com o trabalho mais correlato existente na literatura, o uso do ImageDWindex proveu uma melhora no desempenho do processamento de consultas IOLAP que variou em média de 55,57% até 82,16%, considerando uma das estratégias propostas. / A data warehousing environment offers support to the decision-making process. It consolidates data from distributed, autonomous and heterogeneous information sources into one of its main components, the data warehouse. Furthermore, it provides effcient processing of analytical queries (i.e. OLAP queries). A conventional data warehouse stores only alphanumeric data. On the other hand, an image data warehouse stores not only alphanumeric data but also intrinsic features of images, thus allowing data warehousing environments to perform analytical similarity queries over images. This requires the development of strategies to provide efficient processing of these complex and costly queries. Although there are a number of approaches in the literature aimed at the development of bitmap index for data warehouses and metric access methods for the efficient processing of similarity queries over images, to the best of our knowledge, there is not an approach that investigate these two issues in the same setting. In this research, we fill this gap in the literature by introducing the following main contributions: (i) the proposal of the ImageDW-index, an optimization mechanism aimed at the efficient processing of analytical queries extended with similarity predicates over images; and (ii) definition of different processing strategies for image data warehouses using the ImageDW-index. In order to validate these main proposals, we also introduce two secondary contributions, as follows: (iii) the ImageDW-Gen, a data generator to populate image data warehouses; and (iv) the proposal of four query classes, each one enforcing different query processing costs associated to the similarity predicates in image data warehousing environments. Using the ImageDW-Gen, performance tests were carried out in order to investigate the advantages introduced by the proposed strategies, according to the query classes. Compared to the most related work available in the literature, the ImageDW-index provided a performance gain that varied from 55.57% to 82.16%, considering one of the proposed strategies.

Este trabalho de mestrado insere-se no contexto do projeto de uma Ferramenta Inteligente de Apoio à Pesquisa (FIP), sendo desenvolvida no Laboratório de Inteligência Computacional do ICMC-USP. A ferramenta foi proposta para recuperar, organizar e minerar grandes conjuntos de documentos científicos (na área de computação). Nesse contexto, faz-se necessário um repositório de artigos para a FIP. Ou seja, um Data Warehouse que armazene e integre todas as informações extraídas dos documentos recuperados de diferentes páginas pessoais, institucionais e de repositórios de artigos da Web. Para suportar o processamento analítico on-line (OLAP) das informações e facilitar a ?mineração? desses dados é importante que os dados estejam armazenados apropriadamente. Dessa forma, o trabalho de mestrado teve como objetivo principal projetar um Data Warehouse (DW) para a ferramenta FIP e, adicionalmente, realizar experimentos com técnicas de mineração e Aprendizado de Máquina para automatizar o processo de indexação das informações e documentos armazenados no data warehouse (descoberta de tópicos). Para as consultas multidimensionais foram construídos data marts de forma a permitir aos pesquisadores avaliar tendências e a evolução de tópicos de pesquisa / This dissertation is related to the project of an Intelligent Tool for Research Supporting (FIP), being developed at the Laboratory of Computational Intelligence at ICMC-USP. The tool was proposed to retrieve, organize, and mining large sets of scientific documents in the field of computer science. In this context, a repository of articles becomes necessary, i.e., a Data Warehouse that integrates and stores all extracted information from retrieved documents from different personal and institutional web pages, and from article repositories. Data appropriatelly stored is decisive for supporting online analytical processing (OLAP), and ?data mining? processes. Thus, the main goal of this MSc research was design the FIP Data Warehouse (DW). Additionally, we carried out experiments with Data Mining and Machine Learning techniques in order to automatize the process of indexing of information and documents stored in the data warehouse (Topic Detection). Data marts for multidimensional queries were designed in order to facilitate researchers evaluation of research topics trend and evolution

Data warehouse har länge varit, och är fortfarande, en viktig tillgång för organisationer för att lagra data för analys. Under det senaste årtionde har en exponentiell ökning av data skett, vilket givit organisationer allt större möjligheter att fatta datadrivna beslut i en helt ny utsträckning. Likväl har det i många fall även satt press på organisationer att utnyttja data som en tillgång för att reagera och ta tillvara på möjligheter i ett hårdnande affärsklimat, eller rent av för att bibehålla konkurrenskraft. För att möjliggöra för organisationer att kunna reagera i tid ställs flexibilitetskrav på de tekniker som används för att hantera data för analys. Praxis som länge rått för data warehouse spås inom kort inte längre vara aktuellt. Organisationer behöver hitta nya vägar för att snabbt lyckas ställa om och anpassa sig efter marknadens behov. Många organisationer har i dagsläget ett traditionellt data warehouse, och denna studie undersöker hur väl data virtualization kan bidra till att öka flexibiliteten genom att adderas som ett komplement. Detta undersöks genom frågeställningen:Hur kan data virtualization komplettera och förbättra ett traditionellt data warehouse?För att besvara frågeställningen genomförs en litteraturanalys och en fallstudie följt av en implementation, där datainsamlingen primärt består av tester utförda utifrån implementationsresultatet, observationer och intervjuer.Resultatet visar på en delad bild, där utförda tester potentiellt kan ses ifrågasätta delar av intervjuresultatet och befintlig litteratur. Utifrån resultatet kan en del konstateranden göras om i vilka användningsfall data virtualization inte passar, samt ge en bild av när det kan vara ett alternativ. Data virtualization bör ses som en utbyggnad av ett data warehouse som möjliggör sammansättning, transformering och beräkning av data, där datastrukturer kan ändras när som helst. En organisation som anammar denna flexiblare lösning måste dock vara beredda på rejält höjda svarstider för att utvinna data. / Data warehouse has for a long time been, and still is, an important asset for organizations to store data for analysis. In the last decade, an exponential increase in data has taken place, giving organizations increasingly greater opportunities to make data-driven decisions in completely new ways. Nevertheless, in many cases, it also puts pressure on organizations to use data as an asset to react and take advantage of opportunities in a harder business climate, or even to maintain competitiveness. In order to enable organizations to be able to react in time, flexibility requirements are imposed on the techniques used to handle data for analysis. The traditional best practices for data warehouse is predicted to soon be out of date. Organizations need to find new ways to quickly change and adapt to the needs of the market. Many organizations currently have a traditional data warehouse, and this study examines how well data virtualization can help increase flexibility by being added as a complement. This is examined through the question:How can data virtualization complement and improve a traditional data warehouse?To answer this question, a literature analysis, and a case study followed by an implementation is carried out, in which the data collection consists primarily of tests performed on the implementation result, observations and interviews.The result shows a divided picture, where performed tests can potentially be seen as questioning parts of the interview results and existing literature. Based on the result, some findings can be made about in which use-cases data virtualization does not fit, and gives a picture of when it can be an alternative. Data virtualization should be seen as an extension of a data warehouse that enables the federation, transformation and computation of data, where data structures can be changed at any time. However, an organization that embraces this more flexible solution must be prepared for substantially increased response times in data extraction.

Made available in DSpace on 2017-07-21T14:19:30Z (GMT). No. of bitstreams: 1 Luiz Pedro Petroski.pdf: 3583708 bytes, checksum: cb0543041adedd80936d37a0c95d78ba (MD5) Previous issue date: 2017-03-06 / Coordenação de Aperfeiçoamento de Pessoal de Nível Superior / The aim of this work is to present a proposal of integration between Precision Agriculture, DataWarehouse / OLAP and GIS. The integration should use extensible and open components, agricultural modeling for decision support, geographical data support, communication interface between components, extension of existing GIS and Data Warehouse solutions. As a result of the integration, an open and extensible architecture was defined, with a spatial agricultural data warehouse modeling. In this way the technologies and tools are open and allow the implementation and extension of its functionalities to adapt to the agricultural scenario of decision. In order to perform the integration, the data were obtained from a farm in the city of Piraí do Sul/PR, which uses proprietary software for data management. Data was exported to the SHAPEFILE format, and through the process performed by the ETL tool, was extracted, transformed and loaded into the analytical database. Also as a source of political boundaries data of rural regions of Brazil, data from the IBGE were used. The database was modeled and implemented by PostgreSQL DBMS with the extension PostiGIS to support spatial data. To provide the OLAP query service, was used the Geomondrian server. The application was extended from the Geonode project, where it was implemented Analytic functionalities, and the interface between the application and the OLAP was performed by the Mandoline API and the OLAP4J library. And finally the interface was implemented through javascript libraries for creating charts, tables and maps. As principal result, an architecture was obtained for Data Warehouse integration, OLAP operations, agricultural and spatial data, as well as ETL process definition and the user interface. / O objetivo desta dissertação é apresentar uma proposta de integração entre agricultura de precisão, Data Warehouse/OLAP e SIG. A integração deve utilizar componentes abertos e extensíveis, modelagem agrícola para suporte a decisão, suporte a dados geográficos, interface de comunicação entre os componentes e a extensão de soluções existentes de SIG e Data Warehouse. Como resultado da integração foi definido uma arquitetura aberta e extensível, integrada, com uma modelagem de Data Warehouse agrícola espacial, que permite o suporte a tomada de decisão para o planejamento e gestão do manejo das práticas da agricultura de precisão. Desta forma as tecnologias e ferramentas utilizadas são abertas e permitem a implementação e extensão de suas funcionalidades para adequar ao cenário agrícola de tomada de decisão. Para realizar a integração foi utilizado os dados oriundos de uma fazenda localizada em Piraí do Sul/PR, a qual utiliza um software proprietário para o gerenciamento de dados. Os dados foram exportados para o formato SHAPEFILE, e através do processo realizado pela ferramenta de ETL, foram extraídos, transformados e carregados para a base de dados analítica. Também como fonte de dados sobre as fronteiras políticas das regiões rurais do Brasil, foi utilizado dados do IBGE. A base de dados analítica foi modelada e implementada em um SGBD PostgreSQL com a extensão PostiGIS para suportar os dados geográficos. Para prover o serviço de consultas OLAP, foi utilizado o servidor Geomondrian. A aplicação foi estendida do projeto Geonode, onde foi implementado as funcionalidades analíticas, e a interface entre a aplicação e o servidor OLAP, foi realizada pela API Mandoline e a biblioteca OLAP4J. E por fim a interface foi implementada por meio de bibliotecas javascript para a criação de gráficos, tabelas e mapas. Como principal resultado, obteve-se uma arquitetura para integração de datawarehouse, operações OLAP, dados espaciais e agricultura, bem como definição do processo de ETL e a interface com o usuário.

Este trabalho trata da especificação, desenvolvimento e utilização do Sistema de Apoio à Gestão de Utilidades e Energia - SAGUE, um sistema concebido para auxiliar na análise de dados coletados de sistemas de utilidades como ar comprimido, vapor, sistemas de bombeamento, sistemas para condicionamento ambiental e outros, integrados com medições de energia e variáveis climáticas. O SAGUE foi desenvolvido segundo conceitos presentes em sistemas de apoio à decisão como Data Warehouse e OLAP - Online Analytical Processing - com o intuito de transformar os dados oriundos de medições em informações que orientem diretamente as ações de conservação e uso racional de energia. As principais características destes sistemas, que influenciaram na especificação e desenvolvimento do SAGUE, são tratadas neste trabalho. Além disso, este texto aborda a gestão energética e os sistemas de gerenciamento de energia visando apresentar o ambiente que motivou o desenvolvimento do SAGUE. Neste contexto, é apresentado o Sistema de Gerenciamento de Energia Elétrica - SISGEN, um sistema de informação para suporte à gestão de energia elétrica e de contratos de fornecimento, cujos dados coletados podem ser analisados através do SAGUE. A aplicação do SAGUE é tratada na forma de um estudo de caso no qual se analisa a correlação existente entre o consumo de energia elétrica da CUASO - Cidade Universitária Armando de Sales Oliveira, obtido através do SISGEN, e as medições de temperatura ambiente, fornecidas pelo IAG - Instituto de Astronomia, Geofísica e Ciências Atmosféricas da USP. / This work deals with specification, development and utilization of the Support System for Utility and Energy Management - SAGUE, a system created to assist in analysis of data collected from utilities systems as compressed air, vapor, water pumping systems, environmental conditioning systems and others, integrated with energy consumption and climatic measurements. The development of SAGUE was based on concepts and methodologies from Decision Support System as Data Warehouse and OLAP - Online Analytical Processing - in order to transform data measurements in information that guide the actions for energy conservation and rational utilization. The main characteristics of Data Warehouse and OLAP tools that influenced in the specifications and development of SAGUE are described in this work. In addition, this text deals with power management and energy management systems in order to present the environment that motivated the SAGUE development. Within this context, it is presented the Electrical Energy Management System - SISGEN, a system for energy management support, whose electrical measurements can be analyzed by SAGUE. The SAGUE utilization is presented in a case study that discusses the relation between electrical energy consumption of CUASO - Cidade Universitária Armando de Sales Oliveira, obtained throughout SISGEN, and the local temperature measurements supplied by IAG - Institute of Astronomic and Atmospheric Science of USP.