Multidimensional Data Indexing in Relational Database Systems

Import 22/07/2015Účelom tejto práce je porovnanie možností a testovanie výkonu jednorozmerných (s viacerými atribútmi) a viacrozmerných databázových indexov v relačných databázových systémoch. Práca zahŕňa vytvorenie softwaru, ktorý vizualizuje výsledky tohto testovania vybraných klient - server, embedded databázových systémov a softwarového rámcu Radegast (predtým pomenovaný ako QuickDB), vyvíjaného na Katedre informatiky VŠB – Technickej univerzity v Ostrave. Práca obsahuje všeobecne zhrnutie dátových štruktúr používaných na indexovanie viacrozmerných dát v dnešných relačných databázových systémoch.The purpose of this bachelor thesis is to compare options and test performance of one-dimensional (with more attributes) and multidimensional database indexes in relational database systems. Thesis involves the creation of software, which visualizes results of tests selected client - server, embedded database systems and software framework Radegast (earlier named as QuickDB), developed by Department of Computer Science at the VŠB – Technical University of Ostrava. The thesis contains general summary of data structures used to indexing multidimensional data in today’s relational database systems.460 - Katedra informatikydobř

Development of a mobile 100 kg/h plant for pyrolysis using a mechanically fluidized reactor

Current pyrolysis processes perform the thermal decomposition of biomass into a liquid bio-oil, bio-char and non-condensable gases, at around 500 °C, without the addition of oxygen gas. The bio-oil is a complex mixture of many components that is used either as a substitute for fuel oil or for applications such as liquid smoke and bio-phenol resins that do not require pure chemicals. The large-scale mechanical fluidized reactor (MFR) is a new technology for the pyrolysis of biomass developed by ICFAR, which does not require a sand bed and, thus, provides an undiluted solid char residue, which is essential to realize its full value. The MFR is made of a vertical cylinder (0.3 m ID, 1.1 m high) with a volume of 78 litres, which is mixed with a spiral blade impeller. Its biomass processing capacity is 50 to 100 kg/h. The unit is made of a feeder able to move any kind of biomass up to 70% humidity without limitation due to the biomass size. Please click Additional Files below to see the full abstract

Heidelberg standard examination and "Heidelberg standard procedures" - Development of faculty-wide standards for physical examination techniques and clinical procedures in undergraduate medical education

The competent physical examination of patients and the safe and professional implementation of clinical procedures constitute essential components of medical practice in nearly all areas of medicine. The central objective of the projects "Heidelberg standard examination" and "Heidelberg standard procedures", which were initiated by students, was to establish uniform interdisciplinary standards for physical examination and clinical procedures, and to distribute them in coordination with all clinical disciplines at the Heidelberg University Hospital. The presented project report illuminates the background of the initiative and its methodological implementation. Moreover, it describes the multimedia documentation in the form of pocketbooks and a multimedia internet-based platform, as well as the integration into the curriculum. The project presentation aims to provide orientation and action guidelines to facilitate similar processes in other faculties

The Limerick bubbly flow rig: design, performance, hold-up and mixing pattern

peer-reviewedAs Euler-Euler CFD simulations of bubbly flows suffer from uncertainties due to the many underpinning models, there is an obvious need of accurate experimental data for validation. With this in mind, a new bubbly flow test rig was built to be operated with and without liquid co-flow, with bubble size as uniform as possible in the range 4–7 mm, and with a very even horizontal bubble distribution. We designed the gas sparging system such that we can also produce an essentially bi-modal bubble size distribution. The column consists of two square sections to allow for studying the mixing of two originally separated bubbly flows with either the same or a different bubble size. The bubbles are produced from 2 × 196 needles, bubble sizes are determined with high-speed imaging and with a simple acoustical method, overall volume fractions in the column by means of air chamber pressure measurements. Overall volume fractions are presented as a function of gas and liquid flow rates, with slip velocity mostly increasing with increasing void fraction. First results are obtained on (a) producing bi-model bubble size distributions and the pertinent volume fractions in the column, and (b) flow patterns in the case of unequal aeration

Global and local hydrodynamics of bubble columns: effect of gas distributor

Global (level swell) and local (WMS – Wire Mesh Sensor) measurements were made on waters of different purities and air, in a cylindrical laboratory bubble column (2 m tall, 0.127 m dia) using two different gas distributors: a perforated plate (to produce homogeneous flow) and a spider sparger (to produce heterogeneous flow). The level swell method provided the steady space-averaged gas holdup/gas flow rate data. The WMS method provided the actual gas holdups and bubble sizes resolved in time and space at one cross-sectional horizontal plane (1 m above distributor), whose integration yields the timeaveraged data. The following results were obtained: The global and local data agree relatively well; there are distinct differences between the radial profiles and bubble size distributions between the two main flow regimes; the local information identifies why the predictions of published models, which account for the smaller and larger bubbles in the flow, may not perform well; the modelling approaches based on the hindrance and enhancement concepts prove to be suitable for the flow regime identification and description, including the transition range between the homogeneous and heterogeneous flows; based on the hydrodynamics, the specific interfacial area is obtained, together with the mass transfer coefficient

Impact of the CNB's interventions on the economz and comparison with other countries

This bachelor thesis analyzes influence of foreign exchange intervention of CNB on economy and compare it with influences of foreign exchange intervention of SNB and BOI on their economies. At first, we compare foreign exchange interventions and development of economies (banking sector, foreign trade,...) of Czech Republic, Switzerland and Israel. A hypothesis of efficiency of foreign exchange interventions of CNB, SNB and BOI is tested on specific empirical data. The bachelor thesis describes VAR model for given countries with basic macroeconomic variables (GDP growth, money supply, inflation, interest rate, nominal effective exchange rate and balance of current account of balance of payments). The results of model show on relative efficiency of foreign exchange interventions i.e. SNB mitigated influence of appreciation of CHF, CNB supported GDP growth and BOI increased foreign exchange reserves and supported GDP growth