<p>Data warehouse maintenance and maintenance cost has been well studied in the literature. Integrating data sources, in a data warehouse environment, may often need data cleaning, transformation, or any other function applied to the data in order to integrate it. The impact on view maintenance, when data is integrated with other comparison operators than defined in theta join, has, however, not been closely looked at in previous studies.</p><p>In this study the impact of using a complex join in data warehouse environment is analyzed to measure how different maintenance strategies are affected when data needs to be integrated using other comparison operators than defined in a theta join. The analysis shows that maintenance cost is greatly increased when using complex joins since such joins often lack optimization techniques which are available when using a theta join. The study shows, among other things, that the join aware capability of sources is not of importance when performing complex joins, and incremental view maintenance is better approach than using recomputed view maintenance, when using complex joins. Strategies for maintaining data warehouses when data is integrated using a complex join are therefore different than when a theta join is used, and different maintenance strategies need to be applied.</p>

published_or_final_version / Public Administration / Master / Master of Public Administration

Darbo tikslas — ištirti tarptautinių bendrovių sandėlių išdėstymo politiką, nustatyti svarbiausius veiksnius, lemiančius įmonių apsisprendimą statyti sandėlius tam tikrose vietose. Darbe nagrinėjami tarptautinių bendrovių sandėlių išdėstymą lemiantys veiksniai, bendrovėms reikalingo sandėlių skaičiaus ir dydžio nustatymas, išanalizuotos sandėlių panaudojimo efektyvumo, logistinio aptarnavimo bei logistikos informacinių sistemų panaudojimo įtakos sandėliavimo veiklai problemos. Darbe buvo atliktas tyrimas ir nustatyta, jog pagrindiniai tarptautinių bendrovių sandėlių išdėstymą lemiantys veiksniai yra darbo jėgos kiekis ir kokybė, darbo jėgos sąnaudos, pardavimo vietos bei vartotojo artumas, magistraliniai keliai, valstybės geopolitinė padėtis bei žemės kaina. Kiekvienas veiksnys atskiru atveju gali turėti daugiau ar mažiau įtakos, tad kiekvienu konkrečiu atveju juos reikia analizuoti ir pasirinkti tinkamiausią vietą sandėliui. Išnagrinėjus teorinius ir praktinius sandėlių išdėstymo aspektus, pateikiamos baigiamojo darbo išvados ir pasiūlymai. / Purpose of the work is to analyze the warehouse positioning politics of international companies, to establish the main factors which determine a decision of international companies to locate its warehouses in particular locations. There are investigated the main factors of warehouse locating, necessary number and size requirements, efficiency of warehouse utilization, logistical service and usage of logistics information systems in this paper. There are a few the most important factors such as supply and charge of the labour-force, nearness to manufacturer and purchaser, arterial roads, regional supply and demand of the warehouse, cost of the territory, legislation of each country, geopolitical location of country and some others. The importance of each factor may vary according to specific case. After analyzing theorethical and practical aspects of warehouse locating politics, the conclusion and suggestions are presented.

Transportation is one of the most frequent problems in the business world. The major feature of the problem is that there are many warehouses and many delivery places. The objective of solving this problem is to find the amount of goods that should be sent from each warehouse to each customer while minimizing cost.Unfortunately, understanding the process and interpreting the results are not easy tasks. The method is very complex. The result is in the form of a table. We might say that it is not a friendly user-interface.In this thesis, we will create an application which uses a window as an interface, and uses minimal storage.Borland C++ v.4.0 is chosen to handle the implementation, and Borland Object Windows (class) Library for C++ v.2.0, OWL, is used for the interface. Therefore, this application operates on Windows 3.1 or Windows 95, but not on DOS. / Department of Computer Science

Most large contemporary mines already have considerable amounts of data, much of which goes largely unused. The key challenge in big data is increasing data utilization. Much of the data in the mine (not plant) come from a variety of systems, each with different databases and reporting environments. Standard technology deployments create a "silo-ification" of data leading to poor system usage. Through modern server monitoring, data utilization can quantifiably be measured. A host of other quantifiable, often automated approaches, to measuring data use and value can also be incorporated as a means of monitoring value generation. A data valuation tool is presented to measure the data assets at an operation. The Data Value Index (DVI) quantifies business intelligence best practices and user interaction considering managerial flexibility and data utilization rates. The DVI is built considering many case studies of data warehousing at various mining companies, some of which will be presented.

Atualmente no mercado brasileiro de condomínios de galpões logísticos são ofertados empreendimentos em variados estratos de qualidade. Isto decorre do grande espectro de necessidades e demandas de uma ampla variedade de usuários interessados em ocupar Condomínios Logísticos (CL). De modo geral, os usuários desta tipologia de empreendimento procuram, além da eficiência de armazenagem, outros serviços e atributos tais como: localização privilegiada, moderna infraestrutura de sistemas prediais, forte segurança patrimonial, incentivos fiscais na região, flexibilidade no projeto para ajustar as instalações existentes a requisitos operacionais específicos, entre outros. A partir do conjunto de atributos de qualidade oferecidos aos usuários é possível enquadrar empreendimentos deste segmento em classes específicas que permitam o mercado fazer uma leitura sem viés do padrão de qualidade dos empreendimentos em oferta, a exemplo do que já é utilizado em outros segmentos de empreendimentos de Base Imobiliária no Brasil. Contudo, um sistema de classificação de CL rigoroso e isento de viés é inexistente hoje no Brasil. O mercado dispõe exclusivamente de critérios formulados pelas empresas responsáveis pela comercialização dos espaços nos empreendimentos, o que compromete a isenção da avaliação da qualidade para o usuário. Esta notória ausência de um sistema de classificação reclama a construção de critérios mais bem fundamentados e com análise do estado dos atributos, sob o ponto de vista do usuário de CLs. Portanto o objetivo desta pesquisa é desenvolver um sistema de certificação da qualidade de CL no Brasil, no qual sejam identificados e analisados os diferentes atributos que possam enquadrar um empreendimento dentro de uma classe específica, para dar suporte a uma leitura de qualidade dos empreendimentos pelo mercado. Para atingir o objetivo mencionado, foi necessário identificar os principais aspectos comuns às classificações existentes no mercado de CL através de levantamento bibliográfico e de práticas de mercado, para, em seguida, eleger uma metodologia de análise que permita avaliar os atributos que fundamentam na visão dos usuários o que configura a qualidade dos CLs. O método empregado foi o Delphi, que envolve a aplicação sucessivas de questionários a especialistas no tema, com o intuito de reconhecer a opinião prevalente acerca da qualidade de CL segundo o ponto de vista de seus usuários típicos. Deste modo, os resultados alcançados são, i) construção de uma Matriz de atributos que identifica a importância relativa dos sistemas e atributos requeridos pelos usuários de CLs, ii) construção de um sistema de classificação da qualidade de CLs para ser oferecido ao mercado. / Currently in the Brazilian Warehouses Business Park (WBP) are offered projects in varying quality strata. This follows from the broad spectrum of needs and demands of a wide variety of users interested in occupying charges (WBP). In general, users of this project typology looking beyond the storage efficiency, other services and attributes such as: prime location, modern infrastructure building systems, strong balance security, tax incentives in the region, design flexibility to adjust the facilities existing specific operational requirements, among others. From the set of quality attributes offered to users can frame projects this segment in specific classes that allow the market to do a reading without standard bias quality of the projects on offer, similar to what is already used in other segments of enterprises Base of Real Estate in Brazil. However, a strict classification system of WBP whit free bias is nonexistent today in Brazil. The market has only criteria formulated by the companies responsible for marketing the spaces in the projects, which compromises the quality assessment of the exemption for the user. This notorious absence of a classification system calls for the construction of wellfounded criteria and analysis of the state of the attributes from the point of view of WBP user. Therefore the aim of this research is to develop a quality certification system to Warehouses Business Park in Brazil, which are identified and analyzed the different attributes that can frame a project within a specific class, to support a quality reading of developments in the market . To achieve the goal mentioned, it was necessary to identify key commonalities of existing ratings in the WBP market through literature and market practices, to then elect a methodology for assessing the attributes that support the vision of users which sets the quality of WBP. The method used was Delphi, which involves the successive application of questionnaires to experts on the subject, in order to recognize the prevailing opinion about the quality of WBP from the point of view of their typical users. Thus, the results obtained are i) construction of an array of attributes that identify the relative importance of the attributes required for systems and users shed, ii) construct a quality classification system of WBP to be offered to the market.

Data warehouse maintenance and maintenance cost has been well studied in the literature. Integrating data sources, in a data warehouse environment, may often need data cleaning, transformation, or any other function applied to the data in order to integrate it. The impact on view maintenance, when data is integrated with other comparison operators than defined in theta join, has, however, not been closely looked at in previous studies. In this study the impact of using a complex join in data warehouse environment is analyzed to measure how different maintenance strategies are affected when data needs to be integrated using other comparison operators than defined in a theta join. The analysis shows that maintenance cost is greatly increased when using complex joins since such joins often lack optimization techniques which are available when using a theta join. The study shows, among other things, that the join aware capability of sources is not of importance when performing complex joins, and incremental view maintenance is better approach than using recomputed view maintenance, when using complex joins. Strategies for maintaining data warehouses when data is integrated using a complex join are therefore different than when a theta join is used, and different maintenance strategies need to be applied.

This thesis presents a comprehensive view on the commercial properties market in the Czech Republic and its development in time both before the economic crisis and after its beginning. Author tracks both major segments of commercial properties market -- offices and industrial & logistic properties from the rental as well as investment point of view. The target of the thesis is to characterize commercial properties market, its major actors and branches and to point out the most important differences in impact of the crisis on the two major market segments. The author uses relevant public data as well as own experience based on more than 4 year track record on real estate market. Based on attainable data and own experience, the author predicts also future market development.

This thesis is focused on ensuring the prosperity of the agricultural company Novohradské hory Ltd. In the theoretical part are described the methods of internal and external analysis (PESTEL -- MAP, ETOP, Causal analysis, Key success factors), methods based on internal logistics (warehousing capacity, Sanky diagram) and evaluation of investment (ROI, playback period). The practical section addresses main areas - analysis of companies, warehouses and parking area, zootherapy implementation and integration into the portfolio of activities.

Le volume et la complexité des données générées par les systèmes d’information croissent de façon singulière dans les entrepôts de données. Le domaine de l’informatique décisionnelle (aussi appelé BI) a pour objectif d’apporter des méthodes et des outils pour assister les utilisateurs dans leur tâche de recherche d’information. En effet, les sources de données ne sont en général pas centralisées, et il est souvent nécessaire d’interagir avec diverses applications. Accéder à l’information est alors une tâche ardue, alors que les employés d’une entreprise cherchent généralement à réduire leur charge de travail. Pour faire face à ce constat, le domaine « Enterprise Search » s’est développé récemment, et prend en compte les différentes sources de données appartenant aussi bien au réseau privé d’entreprise qu’au domaine public (telles que les pages Internet). Pourtant, les utilisateurs de moteurs de recherche actuels souffrent toujours de du volume trop important d’information à disposition. Nous pensons que de tels systèmes pourraient tirer parti des méthodes du traitement naturel des langues associées à celles des systèmes de questions/réponses. En effet, les interfaces en langue naturelle permettent aux utilisateurs de rechercher de l’information en utilisant leurs propres termes, et d’obtenir des réponses concises et non une liste de documents dans laquelle l’éventuelle bonne réponse doit être identifiée. De cette façon, les utilisateurs n’ont pas besoin d’employer une terminologie figée, ni de formuler des requêtes selon une syntaxe très précise, et peuvent de plus accéder plus rapidement à l’information désirée. Un challenge lors de la construction d’un tel système consiste à interagir avec les différentes applications, et donc avec les langages utilisés par ces applications d’une part, et d’être en mesure de s’adapter facilement à de nouveaux domaines d’application d’autre part. Notre rapport détaille un système de questions/réponses configurable pour des cas d’utilisation d’entreprise, et le décrit dans son intégralité. Dans les systèmes traditionnels de l’informatique décisionnelle, les préférences utilisateurs ne sont généralement pas prises en compte, ni d’ailleurs leurs situations ou leur contexte. Les systèmes état-de-l’art du domaine tels que Soda ou Safe ne génèrent pas de résultats calculés à partir de l’analyse de la situation des utilisateurs. Ce rapport introduit une approche plus personnalisée, qui convient mieux aux utilisateurs finaux. Notre expérimentation principale se traduit par une interface de type search qui affiche les résultats dans un dashboard sous la forme de graphes, de tables de faits ou encore de miniatures de pages Internet. En fonction des requêtes initiales des utilisateurs, des recommandations de requêtes sont aussi affichées en sus, et ce dans le but de réduire le temps de réponse global du système. En ce sens, ces recommandations sont comparables à des prédictions. Notre travail se traduit par les contributions suivantes : tout d’abord, une architecture implémentée via des algorithmes parallélisés et qui prend en compte la diversité des sources de données, à savoir des données structurées ou non structurées dans le cadre d’un framework de questions/réponses qui peut être facilement configuré dans des environnements différents. De plus, une approche de traduction basée sur la résolution de contrainte, qui remplace le traditionnel langage-pivot par un modèle conceptuel et qui conduit à des requêtes multidimensionnelles mieux personnalisées. En outre, en ensemble de patrons linguistiques utilisés pour traduire des questions BI en des requêtes pour bases de données, qui peuvent être facilement adaptés dans le cas de configurations différentes. / The amount and complexity of data generated by information systems keep increasing in Warehouses. The domain of Business Intelligence (BI) aims at providing methods and tools to better help users in retrieving those data. Data sources are distributed over distinct locations and are usually accessible through various applications. Looking for new information could be a tedious task, because business users try to reduce their work overload. To tackle this problem, Enterprise Search is a field that has emerged in the last few years, and that takes into consideration the different corporate data sources as well as sources available to the public (e.g. World Wide Web pages). However, corporate retrieval systems nowadays still suffer from information overload. We believe that such systems would benefit from Natural Language (NL) approaches combined with Q&A techniques. Indeed, NL interfaces allow users to search new information in their own terms, and thus obtain precise answers instead of turning to a plethora of documents. In this way, users do not have to employ exact keywords or appropriate syntax, and can have faster access to new information. Major challenges for designing such a system are to interface different applications and their underlying query languages on the one hand, and to support users’ vocabulary and to be easily configured for new application domains on the other hand. This thesis outlines an end-to-end Q&A framework for corporate use-cases that can be configured in different settings. In traditional BI systems, user-preferences are usually not taken into account, nor are their specific contextual situations. State-of-the art systems in this field, Soda and Safe do not compute search results on the basis of users’ situation. This thesis introduces a more personalized approach, which better speaks to end-users’ situations. Our main experimentation, in this case, works as a search interface, which displays search results on a dashboard that usually takes the form of charts, fact tables, and thumbnails of unstructured documents. Depending on users’ initial queries, recommendations for alternatives are also displayed, so as to reduce response time of the overall system. This process is often seen as a kind of prediction model. Our work contributes to the following: first, an architecture, implemented with parallel algorithms, that leverages different data sources, namely structured and unstructured document repositories through an extensible Q&A framework, and this framework can be easily configured for distinct corporate settings; secondly, a constraint-matching-based translation approach, which replaces a pivot language with a conceptual model and leads to more personalized multidimensional queries; thirdly, a set of NL patterns for translating BI questions in structured queries that can be easily configured in specific settings. In addition, we have implemented an iPhone/iPad™ application and an HTML front-end that demonstrate the feasibility of the various approaches developed through a series of evaluation metrics for the core component and scenario of the Q&A framework. To this end, we elaborate on a range of gold-standard queries that can be used as a basis for evaluating retrieval systems in this area, and show that our system behave similarly as the well-known WolframAlpha™ system, depending on the evaluation settings.