Catalogue Search | MBRL
Are you sure you want to remove the book from the shelf?
{{itemTitle}}
65
result(s) for
"PostgreSQL."
Sort by:
Beginning PostgreSQL on the cloud : simplifying database as a service on cloud platforms
Get started with PostgreSQL on the cloud and discover the advantages, disadvantages, and limitations of the cloud services from Amazon, Rackspace, Google, and Azure. Once you have chosen your cloud service, you will focus on securing it and developing a back-up strategy for your PostgreSQL instance as part of your long-term plan. This book covers other essential topics such as setting up replication and high availability; encrypting your saved cloud data; creating a connection pooler for your database; and monitoring PostgreSQL on the cloud.
Book
Geohash-Based High-Definition Map Provisioning System Using Smart RSU
High-definition (HD) maps are essential for safe and reliable autonomous driving, but their growing size and the need for real-time updates pose significant challenges for in-vehicle storage and communication efficiency. This study proposes a lightweight and scalable HD map provisioning system based on Geohash spatial indexing and Smart Roadside Units (Smart RSUs). The system divides HD map data into Geohash-based spatial blocks and enables vehicles to request only the map segments corresponding to their current location, reducing storage burden and communication load. To validate the system’s effectiveness, we constructed a simulation environment where multiple vehicle clients simultaneously request map data from a Smart RSU. Experimental results showed that the proposed Geohash-based approach achieved an average response time (RTT) of 1244.82 ms—approximately 296.3% faster than the conventional GPS-based spatial query method—and improved database query performance by 1072.6%. Additionally, we demonstrate the system’s scalability by adjusting Geohash levels according to road density, using finer blocks in urban areas and coarser blocks in rural areas. The hierarchical nature of Geohash also enables consistent integration of blocks with different resolutions. These results confirm that the proposed method provides an efficient and real-time HD map delivery framework suitable for dynamic and dense traffic environments.
Journal Article
A Performance Benchmark for the PostgreSQL and MySQL Databases
This study highlights the necessity for efficient database management in continuous authentication systems, which rely on large-scale behavioral biometric data such as keystroke patterns. A benchmarking framework was developed to evaluate the PostgreSQL and MySQL databases, minimizing repetitive coding through configurable functions and variables. The methodology involved experiments assessing select and insert queries under primary and complex conditions, simulating real-world scenarios. Our quantified results show PostgreSQL’s superior performance in select operations. In primary tests, PostgreSQL’s execution time for 1 million records ranged from 0.6 ms to 0.8 ms, while MySQL’s ranged from 9 ms to 12 ms, indicating that PostgreSQL is about 13 times faster. For select queries with a where clause, PostgreSQL required 0.09 ms to 0.13 ms compared to MySQL’s 0.9 ms to 1 ms, making it roughly 9 times more efficient. Insert operations were similar, with PostgreSQL at 0.0007 ms to 0.0014 ms and MySQL at 0.0010 ms to 0.0030 ms. In complex experiments with simultaneous operations, PostgreSQL maintained stable performance (0.7 ms to 0.9 ms for select queries during inserts), while MySQL’s performance degraded significantly (7 ms to 13 ms). These findings underscore PostgreSQL’s suitability for environments requiring low data latency and robust concurrent processing capabilities, making it ideal for continuous authentication systems.
Journal Article
Integrating Postgresql and R: Open-Source Tools For Processing and Reporting Monitoring Data
Environmental monitoring requires effective data collection, management and presentation. With the increasing amount of monitoring data, it is becoming increasingly important to develop tools for effective data management and visualisation. This paper explores the potential of integrating the PostgreSQL database system with the R environment to automate the processing, analysis and reporting of multidimensional environmental data. The results of hydrological monitoring conducted as part of the Integrated Monitoring of the Natural Environment (ZMŚP) programme were used as a case study. The basic component of the ZMŚP programme’s IT system is a relational database, where the results of environmental monitoring are stored. This database serves as a data source for the data warehouse. The data processing process, which includes archiving, verification and aggregation, uses Structured Query Language (SQL) and the procedural language PL/pgSQL. In order to generate interactive visualisations and automate reporting, the R programming environment was used in conjunction with the R Markdown tool and the plotly library. The combination of the PostgreSQL system with the plotly package in the R environment offers a number of benefits in terms of data visualisation and analysis, while also serving as an example of the use of Online Analytical Processing (OLAP) tools in the analysis and presentation of environmental data. The use of open-source solutions not only significantly reduces implementation costs but also increases the availability of technology to a wide range of users, including public institutions involved in environmental monitoring.
Journal Article
PostgreSQL 11 Server Side Programming Quick Start Guide
PostgreSQL is a rock-solid, scalable, and safe, enterprise-level relational database. With a broad range of features and stability it is ever increasing in popularity. The book shows you how to take advantages of PostgreSQL 11 features for Server-Side-Programming. Server-Side-Programming enables strong data encapsulation and coherence.
eBook
DEVELOPMENT OF A WEBGIS FOR SOLAR PV RESOURCE AND INSTALLATION ASSESSMENT USING GEOSPATIAL TECHNOLOGIES
The SINAG Web Portal, a web-based GIS platform that hosts spatial data and a forecasting model for solar PV installation assessment, serves as a repository for the products and outputs of the SolarPot and OutSolar components of a research project called Solar PV Resource and Installation Assessment Using Geospatial Technologies (SINAG). The website was developed with frontend and backend services which involved the use of a content management system, database systems, cloud virtual machines, Linux operating systems, programming languages, specifically Python and JavaScript, and a style scripting framework. All outputs generated by the two components of Project SINAG are stored on the dedicated cloud server of the website. It includes processed spatial data, a graphical summary of the created models, the ability to explore historical data, data requests and downloads, and the use of mapping tools. It is anticipated that the web portal will play a significant role in the assessment and decision-making process for selecting candidate sites for installing solar PV systems across the Philippine archipelago.
Journal Article
Introducing server-side support for 3DCityDB 5.0 to the 3DCityDB-Tools plug-in for QGIS
The 3DCityDB-Tools plug-in for QGIS enables users to connect to the open-source 3D City Database (3DCityDB) 4.x, load CityGML 1.0 and 2.0 data, and structure it as GIS layers within QGIS. The plug-in simplifies interaction with the complex structure of the 3DCityDB 4.x by providing a GUI-based tool and a server-side package for seamless data retrieval and management from QGIS. With the release of the CityGML 3.0 conceptual data model in 2021, the 3D City Database has been updated to version 5.0, introducing several changes to support the new characteristics of CityGML 3.0 and a significant redesign and restructuring of the database schema. However, the current 3DCityDB-Tools plug-in for QGIS does not support the latest CityGML and 3DCityDB versions. This paper presents the findings and experiences gathered to modify the plug-in’s server-side architecture to cope with the new 3DCityDB 5.0. Similar to what already happens with the current plug-in version, the proposed new approach enables the generation of GIS layers following the Simple-Feature-for-SQL model, optimising query performance and improving attribute management. The resulting vector-based layers can be seamlessly imported into QGIS, allowing for interaction between QGIS and the underlying CityGML data stored in the latest version of the 3DCityDB.
Journal Article
High Performance PostgreSQL for Rails: Reliable, Scalable, Maintainable Database Applications
Build faster, more reliable Rails apps by taking the best advanced PostgreSQL and Active Record capabilities, and using them to solve your application scale and growth challenges. Gain the skills needed to comfortably work with multi-terabyte databases, and with complex Active Record, SQL, and specialized Indexes. Develop your skills with PostgreSQL on your laptop, then take them into production, while keeping everything in sync. Make slow queries fast, perform any schema or data migration without errors, use scaling techniques like read/write splitting, partitioning, and sharding, to meet demanding workload requirements from Internet scale consumer apps to enterprise SaaS.Deepen your firsthand knowledge of high-scale PostgreSQL databases and Ruby on Rails applications with dozens of practical and hands-on exercises. Unlock the mysteries surrounding complex Active Record. Make any schema or data migration change confidently, without downtime. Grow your experience with modern and exclusive PostgreSQL features like SQL Merge, Returning, and Exclusion constraints. Put advanced capabilities like Full Text Search and Publish Subscribe mechanisms built into PostgreSQL to work in your Rails apps. Improve the quality of the data in your database, using the advanced and extensible system of types and constraints to reduce and eliminate application bugs. Tackle complex topics like how to improve query performance using specialized indexes. Discover how to effectively use built-in database functions and write your own, administer replication, and make the most of partitioning and foreign data wrappers. Use more than 40 well-supported open source tools to extend and enhance PostgreSQL and Ruby on Rails. Gain invaluable insights into database administration by conducting advanced optimizations - including high-impact database maintenance - all while solving real-world operational challenges. Take your new skills into production today and then take your PostgreSQL and Rails applications to a whole new level of reliability and performance.What You Need:A computer running macOS, Linux, or Windows and WSL2PostgreSQL version 16, installed by package manager, compiled, or running with DockerAn Internet connection
eBook
Mastering postgreSQL 10 expert techniques on postgreSQL 10 development and administration
PostgreSQL is an open source database used for handling large datasets (big data) and as a JSON document database. This book highlights the newly introduced features in PostgreSQL 10, and shows you how you can build better PostgreSQL applications, and administer your PostgreSQL database more efficiently. We begin by explaining advanced database design concepts in PostgreSQL 10, along with indexing and query optimization. You will also see how to work with event triggers and perform concurrent transactions and table partitioning, along with exploring SQL and server tuning. We will walk you through implementing advanced administrative tasks such as server maintenance and monitoring, replication, recovery, high availability, and much more. You will understand common and not-so-common troubleshooting problems and how you can overcome them. By the end of this book, you will have an expert-level command of advanced database functionalities and will be able to implement advanced administrative tasks with PostgreSQL 10.
eBook
PostgreSQL 10 Administration Cookbook
PostgreSQL is a powerful open source database management system, now recognized as the experts' choice for a wide range of applications. This book contains useful administration recipes for improving the performance, security, and stability of your PostgreSQL solution.
eBook