Les ED deviennent des composants incontournables dans les entreprises et les organisations.Le thème de conception des ED a fait l'objet de recherches actives ces dernières années. Laprincipale limitation des approches proposées est le manque d'une vision globale s'inscrivantdans le cadre du cycle de conception des ED, même si la communauté reconnait toutes lesphases de ce cycle. Nos principales contributions dans cette thèse portent sur la proposition d'uneméthode de conception adaptée aux récentes évolutions qu'a connu le cycle de conception, etenglobant l'ensemble de ses phases. Le cycle de conception a connu une diversification importantedes modèles de stockage de données et des architectures de déploiement possibles offrant deschoix de conception variés. Ce cycle reconnait l'importance des besoins des utilisateurs dansle processus de conception, et l'importance d'accès et de représentation de la sémantique desdonnées. Notre première proposition présente une méthode de conception suivant une approcheà base d'ontologies de domaine, permettant de valoriser les besoins des utilisateurs en leur offrantune vue persistante au sein de l'ED. Cette vue permet d'anticiper diverses tâches de conceptionet de simuler les différents choix de conception. Notre deuxième proposition revisite le cycle deconception en exécutant la phase ETL (extraction-transformation-chargement des données) dèsla phase conceptuelle. Cette proposition permet de fournir un moyen de déploiement multiplesur différentes plateformes disponibles.

Submitted by Automa??o e Estat?stica (sst@bczm.ufrn.br) on 2017-03-14T23:51:19Z No. of bitstreams: 1 ArlindoRodriguesDaSilvaNeto_DISSERT.pdf: 3147140 bytes, checksum: 65ec83f6b7b7603769da720a2273e85b (MD5) / Approved for entry into archive by Arlan Eloi Leite Silva (eloihistoriador@yahoo.com.br) on 2017-03-16T23:01:46Z (GMT) No. of bitstreams: 1 ArlindoRodriguesDaSilvaNeto_DISSERT.pdf: 3147140 bytes, checksum: 65ec83f6b7b7603769da720a2273e85b (MD5) / Made available in DSpace on 2017-03-16T23:01:46Z (GMT). No. of bitstreams: 1 ArlindoRodriguesDaSilvaNeto_DISSERT.pdf: 3147140 bytes, checksum: 65ec83f6b7b7603769da720a2273e85b (MD5) Previous issue date: 2016-08-26 / Este trabalho consiste em criar uma ferramenta de BI (Business Intelligence) dispon?vel em nuvem (cloud computing) atrav?s de SaaS (Software as Service) utilizando t?cnicas de ETL (Extract, Transform, Load) e tecnologias de Big Data, com a inten??o de facilitar a extra??o descentralizada e o processamento de dados em grande quantidade. Atualmente, constata-se que ? praticamente invi?vel realizar uma an?lise consistente sem o aux?lio de um software para gera??o de relat?rios e estat?sticas. Para tais fins, a obten??o de resultados concretos com a tomada de decis?o exige estrat?gias de an?lise de dados e vari?veis consolidadas. Partindo dessa vis?o, enfatiza-se neste estudo o Business Intelligence (BI) com o objetivo de simplificar a an?lise de informa??es gerenciais e estat?sticas para propiciar indicadores atrav?s de gr?ficos ou listagens din?micas de dados gerenciais. Assim, ? poss?vel inferir que, com o crescimento exponencial dos dados torna-se cada vez mais dif?cil a obten??o de resultados de forma r?pida e consistente, tornando necess?rio atuar com novas t?cnicas e ferramentas para tratamentos de dados em larga escala. Este trabalho ? de natureza t?cnica de cria??o de um produto de Engenharia de Software, fundamentado a partir do estudo da arte da ?rea, e de um comparativo com as principais ferramentas existentes no mercado, evidenciando vantagens e desvantagens da solu??o criada. / This work is to create a BI tool (Business Intelligence) available in the cloud (cloud computing) through SaaS (Software as Service) using ETL techniques (extract, transform, load) and Big Data technologies, with the intention of facilitating decentralized extraction and data processing in large quantities. Currently, it appears that it is practically impossible conduct a consistent analysis without the aid of a software for reporting and statistics. For these purposes, the achievement of concrete results with decision making requires data analysis strategies and consolidated variable. From this view, it is emphasized in this study Business Intelligence (BI) in order to simplify the analysis of management information and statistics to provide indicators through graphs or dynamic lists of data management. Thus, it is possible to infer that with the exponential growth of data becomes increasingly difficult to obtain results quickly and consistently, making it necessary to work with new techniques and tools for large-scale data processing. This work is technical in nature to create a product of Software Engineering, based from the study of art in the area, and a comparison with the main existing tools on the market, showing advantages and disadvantages of the created solution. / 2020-12-31

Este trabalho tem como objetivo o estudo de camadas transportadoras de carga, em especial de elétrons, em dispositivos poliméricos emissores de luz (PLEDs). Estes dispositivos são obtidos basicamente através da deposição de uma camada emissiva polimérica entre dois eletrodos. Dispositivos poliméricos luminescentes apresentam vantagens quando comparados aos LEDs convencionais, entre elas a possibilidade de fabricação de mostradores ultrafinos, com baixo custo de fabricação e flexíveis. A eficiência dos PLEDs está intimamente ligada a viabilidade de comercialização destes displays. Neste trabalho, a primeira estrutura confeccionada é formada pela deposição de um filme do polímero emissivo OC1C10 PPV - poly[2-metoxi-5-(3,7-dimetiloctiloxi)- 1,4-fenilenovinileno entre o anodo ITO (Oxido de Índio-Estanho) e o catodo alumínio. Sobre o eletrodo transparente ITO o polímero OC1C10-PPV e o Al são depositados sob forma de filme através das técnicas Spin Coating e Evaporação Térmica, respectivamente. Em uma segunda etapa, foram fabricadas amostras com uma estrutura diferenciada, de modo que foram introduzidas camadas de filmes relacionadas aos fenômenos de transporte de cargas capazes de aumentar a eficiência do dispositivo. Estas camadas são responsáveis por uma redução da barreira de potencial existente entre o polímero emissivo e os eletrodos e podem também confinar um número maior lacunas no interior da camada emissiva. Este feito implica num aumento da população de elétrons e lacunas no interior da camada ativa, gerando uma maior recombinação de cargas. Neste sentido, filmes de Alq3 (tris-(8-hydroxyquinolate)-aluminum) com diferentes espessuras foram introduzidos entre a camada ativa e o catodo, gerando uma emissão luminosa superior. Por fim, diferentes concentrações de Alq3 foram adicionadas à solução de OC1C10-PPV, resultando em compostos OC1C10-PPV:Alq3 utilizados como camada ativa, o que proporcionou um aumento da eficiência luminosa em mais de 10 vezes quando comparado aos dispositivos fabricados na primeira etapa do trabalho. A utilização do polímero PEDOT:PSS - Poli (3,4-etilenodioxitiofeno) : Poliestireno Sulfonado- como camada transportadora de lacunas (HTLs) depositada entre o alumínio e o polímero eletroluminescente se mostrou indispensável para o funcionamento dos dispositivos fabricados, evitando o curto circuito entre eletrodos. / This work has the objective to study charge carried layers, especially of electrons, in polymer light emitting devices (PLEDs). These devices are obtained basically by polymer emissive layer deposition between two electrodes. Polymer luminescent devices show advantages when compared to conventional LEDs, such as the thin displays manufacture possibility, with low cost of manufacture and flexible. The PLEDs efficiency is closely linked the commercialization feasibility these displays. In this work, the first structure fabricated is composed by the deposition of OC1C10 PPV - [poly(2-(3,7-dimethyloctyloxy)-5-(2\'-methoxy-1,4-phenylene vinylene)] emissive polymer film between the anode ITO (Indium Tin Oxide) and the aluminum cathode. On the transparent electrode ITO the polymer OC1C10-PPV and Al are deposited as a film through spin coating and thermic evaporation techniques, respectively. In other step, samples were fabricated with a differentiated structure, which films layers related to charges transport were introduced and increase efficiency device. These layers are responsible for reduction of potential barrier between polymer emissive and the electrodes and they can confine a higher number of holes in the emissive layer. This imply in an increase of electrons and hole population in active layer, producing a higher luminous emission. Finally, different Alq3 concentrations were added to solution of the OC1C10-PPV, resulting in compost OC1C10-PPV:Alq3 used as active layer, that increase the luminous efficiency more 10 times than the devices fabricated in first stage of this work. The use polymer PEDOT:PSS Poly(3,4-ethylenedioxythiophene): Poly(StyreneSulfonate) as hole transport layer (HTLs) deposited between the aluminum and the polymer electroluminescent showed essential to operation of devices produced, avoiding the short circuit between electrodes.

I stort sett alla hushåll och företag använder sig av sopor och vi är beroende att det sköts på ett korrekt sätt. Avfallshantering i Östra Skaraborg rapporterar idag in avvikelser på ungefär var tionde soptömning vilket förhindrar effektiviteten. Denna studie handlar om att analysera dessa rapporter för att kunna effektivisera sophantering och på så vis minska antalet avvikelser. Med Business Intelligence (BI) har det skapats en relationsdatabas för att kunna lagra intern och extern data på ett ställe och utföra analyser på dessa. En stor del i studien är extrahering, transformering och inladdning (ETL) där fokuset legat på transformeringen för att få så bra datakvalité som möjligt. Resultatet visar att ingen generell typ av kund står för alla avvikelser utan olika typer av kunder står för olika typer av avvikelser. Utifrån resultatet har det tagits fram beslutsunderlag vilket ska hjälpa till att kunna effektivisera sophantering inom Östra Skaraborg.

Studien har handlat om att ta fram riktlinjer för hur extrahering, transformering och inladdning (ETL) av kreditbedömningsinformation bör göras när det kommer till att införa ett Data Warehouse (DW). Ett kvalitativt angreppssätt har använts med både en fallstudie och en intervjustudie, där fallstudien genomfördes med Asitis AB som är en systemleverantör förfinans- och reskontrafinansiering (factoring) för att undersöka potentiella affärsmöjligheter med ett DW med kreditbedömningsinformation. Intervjustudien användes för att samla in värdefull information från individer inom alla berörda problemområden, och användes sedan i fallstudien. Resultatet var både framgångsfaktorer och fallgropar för ETL-processen med kreditbedömningsinformation som kan fungera som stöd för organisationer med detta behov. Det har visat sig att ETL-processen för kreditbedömningsinformation utgör ett område med stor potential för affärsmöjligheter, där det krävs hög kompetens, domänkunskap, proaktivitet och juridisk kunskap vid genomförande av ETL-processen.

Data have become number one assets of today's business world. Thus, its exploitation and analysis attracted the attention of people from different fields and having different technical backgrounds. 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. However, designing and optimizing such data flows, to satisfy both users' information needs and agreed quality standards, have been known as a burdensome task, typically left to the manual efforts of a BI system designer. These tasks have become even more challenging for next generation BI systems, where data flows typically need to combine data from in-house transactional storages, and data coming from external sources, in a variety of formats (e.g. social media, governmental data, news feeds). Moreover, for making an impact to business outcomes, data flows are expected to answer unanticipated analytical needs of a broader set of business users' and deliver valuable information in near real-time (i.e. at the right time). These challenges largely indicate a need for boosting the automation of the design and optimization of data-intensive flows. This PhD thesis aims at providing automatable means for managing the lifecycle of data-intensive flows. The study primarily analyzes the remaining challenges to be solved in the field of data-intensive flows, by performing a survey of current literature, and envisioning an architecture for managing the lifecycle of data-intensive flows. Following the proposed architecture, we further focus on providing automatic techniques for covering different phases of the data-intensive flows' lifecycle. In particular, the thesis first proposes an approach (CoAl) for incremental design of data-intensive flows, by means of multi-flow consolidation. CoAl not only facilitates the maintenance of data flow designs in front of changing information needs, but also supports the multi-flow optimization of data-intensive flows, by maximizing their reuse. Next, in the data warehousing (DW) context, we propose a complementary method (ORE) for incremental design of the target DW schema, along with systematically tracing the evolution metadata, which can further facilitate the design of back-end data-intensive flows (i.e. ETL processes). The thesis then studies the problem of implementing data-intensive flows into deployable formats of different execution engines, and proposes the BabbleFlow system for translating logical data-intensive flows into executable formats, spanning single or multiple execution engines. Lastly, the thesis focuses on managing the execution of data-intensive flows on distributed data processing platforms, and to this end, proposes an algorithm (H-WorD) for supporting the scheduling of data-intensive flows by workload-driven redistribution of data in computing clusters. The overall outcome of this thesis an end-to-end platform for managing the lifecycle of data-intensive flows, called Quarry. The techniques proposed in this thesis, plugged to the Quarry platform, largely facilitate the manual efforts, and assist users of different technical skills in their analytical tasks. Finally, the results of this thesis largely contribute to the field of data-intensive flows in today's BI systems, and advocate for further attention by both academia and industry to the problems of design and optimization of data-intensive flows. / Doctorat en Sciences de l'ingénieur et technologie / info:eu-repo/semantics/nonPublished

In this diploma thesis is processed proposition of project implentation ETL process to company, which is parsed to many parts. These parts are divided by project analysis.Diploma thesis contains processing of time analysis, risk analysis, cost analysis and source analysis. Before I processed analyzes above, I had been created study of opportunities. This study consist of 7S analysis, SWOT analysis, SLEPTE analysis and Potrer’s model of competitive forces. This proposal of project implantation of ETL process to company was mainly processed by Microsoft Project software and supplementary by Microsoft Excel software.

The aim of this thesis is to implement Business Intelligence solution in the investment banking sector. The first part of this thesis is focused on general use of Business Intelligence in the banking sector and future developments in this area. Further it defines the objectives and reasons for the implementation of BI in the areas of investment banking. This part also explains basic terms used in investment banking which occur in the thesis and introduces a project in which the Business Intelligence is implemented. The second part focuses on determination of requirements and their analysis from which the data warehouse design is derived. Another part deals with the implementation of the designed data warehouse and ETL packages for loading the data. Further the tool in which the reports are created is described by exemplary implementation of the reports. In the last part of this thesis the implemented BI solution is evaluated by the users.

První část této diplomové práce je zaměřena na vymezení základních aspektů Business Intelligence a její popis, který může být určen k prostudování, jakožto úvod pro jedince této problematiky neznalé. Základní myšlenky a principy jsou vysvětlovány na názorných obrázcích. Ideje zde přednesené ale mohou dále sloužit jako ?jiný? pohled určený k dalšímu uvažování o těchto základních otázkách. Následně se práce zabývá implementací Business Intelligence v organizaci a některými souvislostmi v projektu Business Intelligence. Shrnutí doporučení uváděných v literatuře a nejen z nich vyúsťující návrhy ETL standardů jsou poslední teoretickou částí. Práce je uzavřena dokumentací k projektu Reportingového systému, resp. především části ETL, kterou autor v době psaní textu zpracovával (neveřejná část práce)

Cílem této práce je porovnání komerčních business intelligence nástrojů s nástroji Open Source v procesu implementace BI řešení ve střední firmě. V práci jsou porovnávány komerční aplikace Oracle (http://www.oracle.com) ? Oracle Warehouse Builder, Oracle Discoverer a Open Source nástroje z projektu Pentaho (http://www.pentaho.com) ? Kettle, Cube Designer a BI Platforma. Hodnocení obou systémů probíhá na základě předem definovaných metrik. Práce kromě popisu realizace obou řešení a jejich vzájemného porovnání také dává odpověď na zcela zásadní otázku, zda může Open Source řešení konkurovat tomu komerčnímu. Dalším přínosem je návrh modifikovatelného a znovupoužitelného stromu metrik, který je k hodnocení systémů použit.