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.

This thesis deals with association rules mining over data warehouses. In the first part the reader will be familiarized with terms like knowledge discovery in databases and data mining. The following part of the work deals with data warehouses. Further the association analysis, the association rules, their types and mining possibilities are described. The architecture of Microsoft SQL Server and its tools for working with data warehouses are presented. The rest of the thesis includes description and analysis of the Star-miner algorithm, design, implementation and testing of the application.

No description available.

No description available.

This paper deals with data warehouses and OLAP. These technologies are defined and described here. Then an introduction of the architecture of product MS SQL Server and its tools for work with data warehouses and OLAP folow. The knowledge gained is used for creation of sample application.

Les simulations numériques sont devenues un outil indispensable dans la conception des chambres de coupure des disjoncteurs électriques haute tension. Elles sont utilisées non seulement dans le dimensionnement des différentes pièces, mais elles fournissent également une aide précieuse dans la compréhension des phénomènes intervenant entre les deux électrodes au moment de la coupure. L’arc électrique généré entre ces deux électrodes rassemble de nombreux domaines de la physique plus ou moins complexes. Tous ces phénomènes ne sont pas encore parfaitement compris. Avec l’évolution de la puissance de calcul, ces simulations peuvent prendre en compte de plus en plus de phénomènes. Mais pour des raisons de temps de développement, la question des phénomènes à prendre en compte dans ces simulations se pose. Le but de telles simulations est de déterminer de manière rapide si une configuration est plus ou moins capable qu’une autre de couper sous une contrainte donnée. Ainsi, il est important de prendre en compte uniquement les phénomènes physiques importants et nécessaires pour avoir une réponse la plus décisive possible et la plus rapide possible, de la réussite ou non à la coupure d’une configuration testée. Dans cette thèse, nous nous sommes particulièrement intéressés aux déséquilibres thermiques et chimiques qui pourraient intervenir dans les disjoncteurs électriques haute tension au moment de la coupure. En effet, pour des raisons de temps et de coût de calcul, la plupart des simulations numériques actuelles sont réalisées en faisant une hypothèse forte : l’hypothèse d’Equilibre Thermodynamique Local (ETL). Cette hypothèse consiste à considérer que dans chaque maille de notre domaine d’étude et à chaque pas de temps, on a un équilibre thermodynamique réalisé. Faire cette hypothèse nous permet d’utiliser les lois de conservation (masse, quantité de mouvement et énergie) en allégeant le problème. Mais en réalité, cette hypothèse est mise à mal dès que l’on est en présence de forts gradients de température ou de densité. Pour réaliser ces simulations, le code numérique CARBUR a été utilisé. Des modules d’arc électrique (effet Joule et rayonnement) et d’électrode mobile ont été implémentés afin de pouvoir simuler au mieux le comportement du gaz présent dans les disjoncteurs électriques haute tension. Six études différentes ont été réalisées et sont présentées. Ces études portent sur les influences de la forme du bout des électrodes, d’une modélisation en Navier-Stokes par rapport à une modélisation en Euler, de la nature du gaz (SF6, CO2 et N2), du déséquilibre thermique dans le cas de l’azote ou encore du positionnement des termes sources de l’arc électrique dans les différentes équations d’évolution des énergies. Dans ce travail, une étude sur différents modèles cinétiques chimiques est proposée. Dans ces modèles, 5 espèces chimiques sont présentes : N2, N, N+, N2+ et e-. En ce qui concerne la température, on en distingue 4 : T, TVib-N2, TVib-N2+ et Te. / The numerical simulations are become a very important tool to design the high voltage circuit breaker (HVCB) chamber. They help for the understanding of the different phenomena which can take place between the 2 electrodes during an interruption process. The electric arc brings together many fields of physics more or less complex and many of these phenomena are still poorly studied. So many aspects remain to be explored to improve simulations. With the increase of the calculation power, these numerical simulations can take into account more phenomena. However, for reasonable simulation times, we need to know which phenomena are preponderant. The aim of these numerical simulations is to rapidly conclude on the capacity of geometry to success an interruption process compared to different other geometries, under a given stress. In this PhD dissertation, we are particularly interested on thermal and chemical non equilibrium that can occur in HVCB during an interruption process. Currently, most simulations are carried out with a strong hypothesis: the hypothesis of Local Thermodynamic Equilibrium (LTE). This assumption allows us to alleviate the problem and to reduce the computing time. But this assumption becomes not valid when high temperature or density gradients occur. To do these simulations, the CARBUR numerical code has been used. In order to simulate flow behaviors in HVCB, an electrical arc (Joule effect and radiation) model and a module of mobile electrode have been added. Six different studies have been done and are presented: influence of the electrode shape, influence of the Navier-Stokes equations compared to the Euler equations, influence of the gas (SF6, CO2 et N2), influence of the thermal non equilibrium in a nitrogen case, influence of the position of the arc source terms in the different energy equations. In this work, a study on different nitrogen chemical kinetics is proposed. In these models, 5 chemical species are distinguished: N2, N, N+, N2+ and e-. Finally, 4 different temperatures are used: T, TVib-N2, TVib-N2+ and Te.

Dissertation thesis deals with development and implementation of Business Intelligence (BI) solutions for Small and Medium Sized Enterprises (SME) in the Czech Republic. This thesis represents climax of author's up to now effort that has been put into completing a methodological model for development of this kind of applications for SMEs using self-owned skills and minimum of external resources and costs. This thesis can be divided into five major parts. First part that describes used technologies is divided into two chapters. First chapter describes contemporary state of Business Intelligence concept and it also contains original taxonomy of Business Intelligence solutions. Second chapter describes two Knowledge Discovery in Databases (KDD) techniques that were used for building those BI solutions that are introduced in case studies. Second part describes the area of Czech SMEs, which is an environment where the thesis was written and which it is meant to contribute to. This environment is represented by one chapter that defines the differences of SMEs against large corporations. Furthermore, there are author's reasons why he is personally focusing on this area explained. Third major part introduces the results of survey that was conducted among Czech SMEs with support of Department of Information Technologies of Faculty of Informatics and Statistics of University of Economics in Prague. This survey had three objectives. First one was to map the readiness of Czech SMEs for BI solutions development and deployment. Second was to determine major problems and consequent decisions of Czech SMEs that could be supported by BI solutions and the third objective was to determine top factors preventing SMEs from developing and deploying BI solutions. Fourth part of the thesis is also the core one. In two chapters there is the original Methodology for development and deployment of BI solutions by SMEs described as well as other methodologies that were studied. Original methodology is partly based on famous CRISP-DM methodology. Finally, last part describes particular company that has become a testing ground for author's theories and that supports his research. In further chapters it introduces case-studies of development and deployment of those BI solutions in this company, that were build using contemporary BI and KDD techniques with respect to original methodology. In that sense, these case-studies verified theoretical methodology in real use.

Theme of this master’s thesis is design of software support for business intelligence. Design is realized in cooperation with corporation ZZN Pelhřimov a.s. Introduction is focused on theoretical description of business intelligence and datamining and also on development environment in which is project designed. Corporation is characterised also in introduction. Main part contains data collecting and definition of individual modules. In conclusion of this thesis will be several types of analysis from collected data and then according to these analysis, we can draw measures to improve current state of corporation.

This project was originated by K2 atmitec Brno s.r.o. company. The result is data mining module in K2 information system environment. Engineered data module implements association analysis over the data of K2 information system data warehouse. Analyzed data contains information about sales filed in K2 information system. Module is implementing consumer basket analysis.