Browsing by Subject "PostgreSQL"
Now showing 1 - 15 of 15
- Results Per Page
- Sort Options
Item type:Article, Access status: Open Access , A new approach to storing dynamic data in relational databases using JSON(Wydawnictwa AGH, 2018) Piech, Mateusz; Marcjan, RobertJavaScript Object Notation was originally designed to transfer data. However, it soon found another use as a way to persist data in NoSQL databases. Recently, the most popular relational databases introduced JSON as native column type, which makes it easier to store and query dynamic database schema. In this paper, we review the currently popular techniques of storing data with a dynamic model with a large number of relationships between entities in relational databases. We focus on creating a simple dynamic schema with JSON in the most popular relational databases and we compare it with well-known EAV/CR data model and the document database. The results of precisely selected tests in the field of Criminal Data suggest that the use of JSON in dynamic database schema greatly simplifies queries and reduces their execution time compared to widely used approaches.Item type:Thesis, Access status: Restricted , Algorytm rzutowania na mapę dla PostgreSQL(Data obrony: 2021-03-18) Wrona, Wiktor
Wydział Elektrotechniki, Automatyki, Informatyki i Inżynierii BiomedycznejItem type:Thesis, Access status: Restricted , Aplikacja internetowa na potrzeby przetwarzania danych adresowych i atrybutów przestrzennych(Data obrony: 2016-07-19) Walczyk, Marcin
Wydział Geodezji Górniczej i Inżynierii ŚrodowiskaItem type:Article, Access status: Open Access , Database replication for disconnected operations with quasi real-time synchronization(Wydawnictwa AGH, 2023) Mucha, Rafał; Baliś, Bartosz; Grigoras, Costin; Kitowski, JacekDatabase replication is a way to improve system throughput or achieve high availability. In most cases, the use of an active-active replica architecture is efficient and easy to deploy. Such a system has CP properties (from the CAP theorem: consistency, availability, and network-partition tolerance). Creating an AP (available and partition-tolerant) system requires the use of multi-primary replication. Because of the many difficulties in its implementation, this approach is not widely used, however, ALICE’s deployment of CCDB (experiment conditions and calibration database) needs to be an AP system in two locations. This necessity became the inspiration for examining the state-of-the-art methods in this field and testing the available solutions. The tests that were performed evaluated the performance of the chosen replication tools: Bucardo, and EDB Replication Server, these showed that the tested tools could be successfully used for the continuous synchronization of two independent database instances.Item type:Thesis, Access status: Restricted , Implementacja bazy danych wspomagającej działanie sklepu branżowego(Data obrony: 2020-01-24) Czana, Franciszek
Wydział Geologii, Geofizyki i Ochrony ŚrodowiskaItem type:Thesis, Access status: Restricted , Increasing the performance of complex database queries by means of intelligent buffering(Data obrony: 2019-09-30) Gębarowski, Kamil
Wydział Elektrotechniki, Automatyki, Informatyki i Inżynierii BiomedycznejItem type:Thesis, Access status: Restricted , Mapowanie obiektowo-relacyjne oraz zapytania SQL na przykładzie języka Java(Data obrony: 2019-11-21) Gruca, Konrad
Wydział Geologii, Geofizyki i Ochrony ŚrodowiskaItem type:Article, Access status: Open Access , Model for dynamic and hierarchical data repository in relational database(Wydawnictwa AGH, 2018) Piech, Mateusz; Frącz, Wojciech; Turek, Wojciech; Kisiel-Dorohinicki, Marek; Dajda, Jacek; Byrski, AleksanderThe aim of this research is to build an open schema model for a digital sources repository in a relational database. This required us to develop a few advanced techniques. One of them was to keep and maintain a hierarchical data structure pushed into the repository. A second was to create constraints on any hierarchical level that allows for the enforcement of data integrity and consistency. The created solution is mainly based on a JSON file as a native column type, which was designed for holding open schema documents. In this paper, we present a model for any repository that uses hierarchical dynamic data. Additionally, we include a structure for normalizing the input and description for the data in order to keep all of the model assumptions. We compared our solution with a well-known open schema model – Entity-Attribute-Value - in the scope of saving data and querying about relationships and contents from the structure. The results show that we achieved improvements in both the performance and disk space usage, as we extended our model with a few new features that the previous model does not include. The techniques developed in this research can be applied in every domain where hierarchical dynamic data is required, as demonstrated by the digital book repository that we have presented.Item type:Thesis, Access status: Restricted , Opracowanie oprogramowania wspomagającego obsługę programu Erasmus, opartego na interfejsie WWW(Data obrony: 2020-01-21) Bieszczad, Zuzanna
Wydział Informatyki, Elektroniki i TelekomunikacjiItem type:Thesis, Access status: Restricted , Porównanie wydajności baz danych pod systemem Windows i Linux(Data obrony: 2011-10-13) Doktor, Marcin
Wydział Geologii, Geofizyki i Ochrony ŚrodowiskaThe first chapter of the work includes information on operating systems and databases. The second chapter describes the place and the software used for testing. It also includes a plan of building the tables in the databases, and introduces the commands that were used for testing. The third chapter describes the test performance of each of the databases, using different variants. In the fourth chapter was presented a summary of results for each of the tested databases. The fifth chapter contains the conclusions of the study of the database performance.Item type:Thesis, Access status: Restricted , Projekt i implementacja portalu dla sieci intranet dla Katedry Geoinformatyki i Informatyki Stosowanej(Data obrony: 2020-09-22) Mierzwiński, Artur
Wydział Geologii, Geofizyki i Ochrony ŚrodowiskaItem type:Thesis, Access status: Restricted , Projekt wirtualnej restauracji(Data obrony: 2019-01-24) Bar, Kamil
Wydział Geologii, Geofizyki i Ochrony ŚrodowiskaCelem pracy jest zaprojektowanie i zaimplementowanie portalu internetowego umożliwiającego szybkie zamawianie jedzenia.Item type:Thesis, Access status: Restricted , Serwis internetowy do zarządzania bazą materiałów dydaktycznych(Data obrony: 2019-09-18) Bartocha, Łukasz
Wydział Fizyki i Informatyki StosowanejItem type:Thesis, Access status: Restricted , Testowanie wydajności aplikacji sieciowej korzystającej ze styku REST(Data obrony: 2020-12-11) Ogrodny, Katarzyna
Wydział Informatyki, Elektroniki i TelekomunikacjiItem type:Thesis, Access status: Restricted , Wydajnościowe aspekty przetwarzania danych w bazach NoSQL(Data obrony: 2020-08-18) Bartoszewski, Dominik
Wydział Geologii, Geofizyki i Ochrony Środowiska