Catalogue Search | MBRL
Are you sure you want to remove the book from the shelf?
{{itemTitle}}
63
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
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
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
An open source WebGIS approach to empower glacier research with scalability and reproducibility
Glacier monitoring is a key component in understanding climate change, especially for small and rapidly retreating glaciers in regions like the Alps. These ice bodies, though limited in size, play a crucial role in local water resources, ecosystem stability, and natural hazard management. However, their fragmented terrain poses significant challenges for data collection and interpretation. This study presents a WebGIS platform developed for the Belvedere Glacier (Italian Alps), designed to enhance data accessibility, visualization, and analysis through a low-cost, open-source solution. The platform integrates heterogeneous datasets — including GNSS measurements, displacement, velocities and acceleration time series — using CesiumJS for 3D geospatial visualization and PostgreSQL/PostGIS for spatial data management. It allows users to explore monitoring points, visualize glacier dynamics, and perform comparative temporal analyses via an intuitive interface. Built entirely with Free and Open Source Software for Geospatial, the system supports both data upload and export, promoting collaborative workflows and reproducibility. Designed with usability in mind, the platform targets a broad audience, from researchers to policymakers, and demonstrates the potential of WebGIS to support long-term glacier monitoring. The proposed architecture is transferable to other environmental applications, contributing to the digital transition in climate impact documentation.
Journal Article
A VECTOR ANALYTICAL FRAMEWORK FOR POPULATION MODELING
We propose a vector alternative to the typical raster based population modeling framework. When compared with rasters, vectors are more precise, have the ability to hold more information, and are more conducive to areal constructs such as building and parcel outlines. While rasters have traditionally provided computational efficiency, much of this efficiency is reduced at finer resolutions and computational resources are more plentiful today. Herein we describe the approach and implementation methodology. We also describe the output data stack for the United States and provide examples and applications.
Journal Article
3D CITYGML BUILDING MODELS DEVELOPMENT WITH CROSS-SCALE QUERY DATABASE
CityGML model-based is now a norm for smart city or digital twin city development for better planning, management, risk-related modelling and other applications. CityGML comes with five levels of details (LoD, in version 2.0) of buildings. The LoDs are also known as pre-defined multi-scale models requiring a large storage-memory-graphic consumption than a single scale model. LoD CityGML models are primarily constructed using point cloud measurements and images of multiple systems, resulting in a range of accuracies and detailed model representations. Additionally, it entails several software, procedures, and formats for the construction of the respective LoDs prior to the final result in the CityGML schema. Thus, this paper discusses several issues of accuracy and consistency, proposing several quality controls (QC) for multiple data acquisition systems (e.g. airborne laser systems and mobile laser systems), model construction techniques (e.g. LoD1, LoD2, and LoD3), software (interchange formats), and migration to a PostgreSQL database. Additionally, the paper recommends the importance of minimising implementation errors. A scale-specific unique identifier is introduced to link all associated LoDs, enabling cross-LoD information queries within a database. Proper model construction, accuracy control, and format interchange of LoD models in accordance with national and international standards will undoubtedly encourage and expedite data sharing among data owners, agencies, stakeholders, and public users. A summary of the work and accomplishments is included, as well as a plan for future research on this subject.
Journal Article
Innovative PEDRERA Model Tool Boosting Sustainable and Feasible Renovation Programs at District Scale in Spain
In accordance with the new recovery plan, Next Generation EU (NGEU), and the need to speed up the transition of cities towards a new sustainable model, this paper provides an overview of the outcomes of the PEDRERA project, which is focused on the development of a novel tool able to calculate multiple key performance indicators that can support renovation actions at the district level, according to a Positive Energy District (PED) concept. The new tool is programmed in Python programming language and is useful to evaluate several strategies for the renovation of existing building stock. It moves from a quick list of input according to several Public Private Partnership (PPP) models, in addition to other potential business models. Furthermore, the design of the model is supported by a step-by-step methodology in order to deal with a “financial appraisal” that is interactive in each context, customizable for each stakeholder, and user-friendly. The paper describes this innovative tool and reports on the stronger potential that this model can offer when it runs in a QGIS software environment and interacts with a PostgreSQL database, as demonstrated in two case studies located in Spain.
Journal Article