Until recently, transit data lacked a common data format that could be used to share and integrate information among multiple agencies. In 2005, however, Google worked with Tri-Met in Oregon to create the General Transit Feed Specification (GTFS), an open data format now used by all transit agencies that participate in Google Maps. GTFS feeds contain data for scheduled transit service including stop and route locations, schedules and fare information. The broad adoption of GTFS by transit agencies has made it a de facto standard. Those agencies using it are able to participate in a host of traveler services designed for GTFS, most notably transit trip planners. Still, analysts have not widely used GTFS as a data source for transit planning because of the newness of the technology. The objectives of this project are to demonstrate that GTFS feeds are an efficient data source for calculating key transit service metrics and to evaluate the validity of GTFS feeds as a data source. To demonstrate GTFS feeds’ analytic potential, the author created a tool called GTFS Reader, which imports GTFS feeds into a database using open-source products. GTFS Reader also includes a series of queries that calculate metrics like headways, route lengths and stop-spacing. To evaluate the validity of GTFS feeds, annual vehicle revenue miles and hours from the National Transit Database (NTD) are compared to the calculated values from agencies whose GTFS feeds are available. The key finding of this work is that well-formed GTFS feeds are an accurate representation of transit networks and that the method of aggregation presented in this research can be used to effectively and efficiently calculate metrics for transit agencies. The daily aggregation method is more accurate than the weekly aggregation method, both introduced in this thesis, but practical limitations on processing time favor the weekly method. The reliability of GTFS feed data for smaller agencies is less conclusive than that of larger agencies because of discrepancies found in smaller agencies when their GTFS-generated metrics were compared to those in the NTD. This research will be of particular interest to transit and policy analysts, researchers and transit planners.

A Wiki is a piece of server software that allows users to freely create and edit Web page content using any Web browser. This project created the program, "Wiki-Style Administration of Online Course Content" (WAOCC) which can be used as a teaching assistant board. Students can edit their works online and the instructor can review the work and correct it directly if necessary from the WAOCC.

The purpose of this project is to design, build and implement a web application system for the Olympiad delegation registration. All the pages and user registration information will be stored in a PostgreSQL database and retrieved by JAVA Servlet and JDBC (JAVA Database Connectivity). The main purpose of this project is to provide an easy-to-register and web-base communication evironment for the National Olympic Committes (NOC) and the Organizing Committee for the Olympic Games (OCOG).

The primary object of the master thesis is creating escape route analysis in 3D model of a building. Analysis is created using mainly open source tools like PostgreSQL with PostGIS and pgRouting extensions.

The purpose of this master's thesis is to design and create system for company dealing with telephoning, which will simplify and automate the work of their employees as much as possible. System will meet the requirements on modern information system of telemarketing company and will be connected to telephone private branch exchange, from which it will be getting information about all phone calls including their voice records. The work is focused on usage of modern quality technologies and their integration into one system. First part of this work will closely describe requirements on this system and resulting creation of design. In the second part there will be presented used technologies and implementation of particular sections including configuration and connection with telephone private branch exchange. There will be also description of performance measurement process and resulting optimalization of critical sections in which high performance is required.

The diploma thesis deals with automated measurement of humidity and CO2 concentration inside buildings. Results of this measurement form the input parameters for the effective management of technologies reducing the energy performance of buildings. In the introduction, the issue of indoor air quality of buildings and indicators characterizing this quality are approached. The technical part of the thesis consists of making a measuring device which contains two prototype sensors provided by Teco Inc. with online access to measured data. The measurement of relative humidity, CO2 concentration and temperature in the interior of the building with the made device is compared with commercially available devices for measuring selected parameters. For unambiguous interpretation of online data, the virtual machine with an online database is configured for the created measuring device. The possibilities of using the prepared measuring device to achieve a reduction in the energy performance of buildings are discussed in the final part.

The aim of this thesis is to propose a way to implement the missing XML functionality for the database system PostgreSQL. The second chapter discusses the theoretical paradigm with an XML-related technologies like Xpath or XQuery. The third chapter discusses the ISO SQL standards and describes the current level of implementation of native XML databases, versus traditional relational databases. The last part focuses on different approaches and it proposes a solution to implement the XML API to PostgreSQL, which validates XML documents against XSD, DTD and RelaxNG schemes. Next point is focused on XML indexing techniques and proposal of new index based on GiST.

This thesis describes the problems of storage and management of biological data, particularly of Haloalkane Dehalogenase enzymes. Furthermore, the thesis aims at project HADES (HAloalkane DEhalogenase databaSe) initiated by protein engineering group of Loschmidt Laboratories, Masaryk University in Brno. This is a project whose main goal is simply to store, preserve and display a wide variety of proteins data. The result of this work is a flexible database system allowing easy extensibility and maintainability, which is built on technologies Apache, PostgreSQL and PHP using the Zend Framework.

This thesis focuses on a implemenation of a a temporal data support within traditional relational environment of PostgreSQL system. I pick up on Radek Jelínek's thesis and an extension developed by him. I've analyzed the extension from functional, practical and performance perspectives. Based on my results, I've designed and implemented changes to the original extension. The work also contains implementation details as well as performance comparison results between the new and the original extensions.

The goal of the master ́s thesis is to study index methods, spatial data type objects in PostgreSQL database systems and to create SP-GiST index by quadtree in the PostGIS. The PostGIS is spatial database, which extends of PostgreSQL. PostGIS adds support for geographic and spatial objects. It is a big benefit. PostGIS has its own data types, methods and GiST index too, but there is SP-GiST index missing, therefore master's thesis was created.