Building permission procedure of landscape works and its relation to valuation regulations

Diplomová práce se zabývá terénními úpravami z hlediska návaznosti na stávající legislativu a posuzuje vliv térenních úprav na cenu pozemku dle oceňovacích předpisů a ceny obvyklé v lokalitě Staré Město.This thesis deals with landscaping issues from the legal standpoint and evaluates the influence of landcaping on the price of estate according to legislative assessment and standard price in the Stare Mesto region.

Vizualization Tool of SQL Server Optimization Process

Základem každého pokročilého databázového systému je tzv. optimalizátor, který se snaží nalézt co nejefektivnější plán vykonání pro vstupní SQL příkaz. Proces optimalizace využívá tzv. memo struktury, která celý proces zefektivňuje. SQL Server umožňuje vypsat základní podobu memo struktury v textové podobě. Memo struktura může být relativně velká a textová podoba bývá nepřehledná i pro relativně jednoduché SQL příkazy. Cílem této práce je grafické zobrazení memo struktury na základě textových výstupů SQL Serveru.The basis of every advanced database system is the so-called optimizer, which tries to find the most efficient execution plan for the input SQL statement. The optimization process uses a so-called memo structure, which streamlines the entire process. SQL Server allows you to list the basic form of the memo structure in text form. The memo structure can be relatively large and the text is usually confusing even for relatively simple SQL statements. The aim of this work is a graphical representation of the memo structure based on the text outputs of SQL Server.460 - Katedra informatikyvelmi dobř

Apache Calcite Rewriting Rule

Apache Calcite je projekt, který je zaměřen na vytvoření modifikovatelného optimalizátoru pro relační databáze. Calcite umožňuje kombinovat různé datové modely a různé databázové systémy do jednoho optimalizátoru a také nabízí možnost vytvořit vlastní přepisovací pravidla. Cílem této práce je implementovat přepisovací pravidlo pro window funkce, které jsou dnes stále častěji součástí běžných SQL dotazů.Apache Calcite is a project that aims to create a modifiable relational optimizer database. Calcite allows you to combine different data models and different database systems into one optimizer and also offers the possibility to create custom transformation rules. The aim of this work is implement a transformation rule for window functions, which are increasingly part of regular SQL today questions.460 - Katedra informatikyvelmi dobř

User Interface for Interactive Web Pages

Cílem práce je vytvořit webový nástroj usnadňující a urychlujícívytváření dynamických webových stránek umísťováním widgetů libovolně do prostoru stránky. Každý tento widget zobrazuje konkrétní obsah. Taky je možné vytvářet nové či upravovat stávající podle potřeby nebo pouze využít již existujících. V tomto dokumentu je popsáno, jakým způsobem byla tato aplikace vytvářena a jak vypadá výsledek.Goal of this thesis is to create web based tool which simplifies and accelerates the process of making dynamic web pages by placing widgets arbitrarily into the page area. Every widget can display specific content. It is also possible to develop new widgets, modify them or just use the ones that already exists. This document describes how this application was created and the result of that process.

Prehabilitation in elective abdominal cancer surgery in older patients: systematic review and meta‐analysis

Background Prehabilitation has emerged as a strategy to prepare patients for elective abdominal cancer surgery with documented improvements in postoperative outcomes. The aim of this study was to assess the evidence for prehabilitation interventions of relevance to the older adult. Methods Systematic searches were conducted using MEDLINE, Web of Science, Scopus, CINAHL and PsychINFO. Studies of preoperative intervention (prehabilitation) in patients undergoing abdominal cancer surgery reporting postoperative outcomes were included. Age limits were not set as preliminary searches revealed this would be too restrictive. Articles were screened and selected based on PRISMA guidelines, and assessment of bias was performed. Qualitative, quantitative and meta‐analyses of data were conducted as appropriate. Results Thirty‐three studies (3962 patients) were included. Interventions included exercise, nutrition, psychological input, comprehensive geriatric assessment and optimization, smoking cessation and multimodal (two or more interventions). Nine studies purposely selected high‐risk, frail or older patients. Thirty studies were at moderate or high risk of bias. Ten studies individually reported benefits in complication rates, with meta‐analyses for overall complications demonstrating significant benefit: multimodal (risk difference −0·1 (95 per cent c.i. −0·18 to −0·02); P = 0·01, I2 = 18 per cent) and nutrition (risk difference −0·18 (−0·26 to −0·10); P < 0·001, I2 = 0 per cent). Seven studies reported reductions in length of hospital stay, with no differences on meta‐analysis. Conclusion The conclusions of this review are limited by the quality of the included studies, and the heterogeneity of interventions and outcome measures reported. Exercise, nutritional and multimodal prehabilitation may reduce morbidity after abdominal surgery, but data specific to older patients are sparse

Complications of Peripherally Inserted Central Venous Catheters: A Retrospective Cohort Study

Background and Aim The use of venous catheters is a widespread practice, especially in oncological and oncohematological units. The objective of this study was to evaluate the complications associated with peripherally inserted central catheters (PICCs) in a cohort of patients. Materials and Methods In this retrospective cohort study, we included all patient carrying PICCs (n = 603) inserted at our institute between October 2010 and December 2013. The main variables collected were medical diagnosis, catheter care, location, duration of catheterization, reasons for catheter removal, complications, and nursing care. Complications were classified as infection, thrombosis, phlebitis, migration, edema, and/or ecchymosis. Results All patients were treated according to the same “nursing care” protocol. The incidence rate of complications was two cases per 1000 days of catheter duration. The most relevant complications were infection and thrombosis, both with an incidence of 0.17 cases per 1000 days of the total catheterization period. The total average duration of catheterization was 170 days [SD 6.06]. Additionally to “end of treatment” (48.42%) and “exitus”, (22.53%) the most frequent cause of removal was migration (displacement towards the exterior) of the catheter (5.80%). Conclusions PICCs are safe devices that allow the administration of long-term treatment and preserve the integrity of the venous system of the patient. Proper care of the catheter is very important to improve the quality life of patients with oncologic and hematologic conditions. Therefore, correct training of professionals and patients as well as following the latest scientific recommendations are particularly relevant

Základové konstrukce s kluznou spárou

Prezenční221 - Katedra konstrukcíNeuveden

Uplatnění fosforu a draslíku na výnos a kvalitu kukuřice seté

Over the past 20 years the approach to fertilisation of most of the crops on agricultural land has changed considerably. Complex nutrition has unfortunately gradually changed into one-sided nitrogen fertilisation; to a very limited extent also applying phosphorus and potassium. Other macro-nutrients are usually used for fertilisation only very sporadically and on a long-term basis only more deepening the deficit of nutrients in the soil and decreasing the soil reaction (pH)

Activity of youth squads in football clubs in the view of economical security

Import 04/12/2006Prezenční713 - Katedra tělesné výchovy a sport