Catalogue Search | MBRL
Are you sure you want to remove the book from the shelf?
{{itemTitle}}
70
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
PostgreSQL 10 High Performance - Third Edition
PostgreSQL 10 High Performance provides you with all the tools to maximize the efficiency and reliability of your PostgreSQL 10 database. Written for database admins and architects, this book offers deep insights into optimizing queries, configuring hardware, and managing complex setups. By integrating these best practices, you'll ensure scalability and stability in your systems. What this Book will help me do Optimize PostgreSQL 10 queries for improved performance and efficiency. Implement database monitoring systems to identify and resolve issues proactively. Scale your database by implementing partitioning, replication, and caching strategies. Understand PostgreSQL hardware compatibility and configuration for maximum throughput. Learn how to design high-performance solutions tailored for large and demanding applications. Author(s) Enrico Pirozzi is a seasoned database professional with extensive experience in PostgreSQL management and optimization. Having worked on large-scale database infrastructures, Enrico shares his hands-on knowledge and practical advice for achieving high performance with PostgreSQL. His approachable style makes complex topics accessible to every reader. Who is it for? This book is intended for database administrators and system architects who are working with or planning to adopt PostgreSQL 10. Readers should have a foundational knowledge of SQL and some prior exposure to PostgreSQL. If you're aiming to design efficient, scalable database solutions while ensuring high availability, this book is for you.
eBook
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
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
PostgreSQL 11 Server Side Programming Quick Start Guide
Extend PostgreSQL using PostgreSQL server programming to create, test, debug, and optimize a range of user-defined functions in your favorite programming language Key Features * Learn the concepts of PostgreSQL 11 with lots of real-world datasets and examples * Learn queries, data replication, and database performance * Extend the functionalities of your PostgreSQL instance to suit your organizational needs Book Description 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.This book shows you how to take advantage of PostgreSQL 11 features for server-side programming. Server-side programming enables strong data encapsulation and coherence. The book begins with the importance of server-side programming and explains the risks of leaving all the checks outside the database. To build your capabilities further, you will learn how to write stored procedures, both functions and the new PostgreSQL 11 procedures, and create triggers to perform encapsulation and maintain data consistency. You will also learn how to produce extensions, the easiest way to package your programs for easy and solid deployment on different PostgreSQL installations. What you will learn * Explore data encapsulation * Write stored procedures in different languages * Interact with transactions from within a function * Get to grips with triggers and rules * Create and manage custom data types * Create extensions to package code and data * Implement background workers and Inter-Process Communication (IPC) * How to deal with foreign languages, in particular Java and Perl Who this book is for This book is for database administrators, data engineers, and database engineers who want to implement advanced functionalities and master complex administrative tasks with PostgreSQL 11.
eBook
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
Fast and scalable inequality joins
Inequality joins, which is to join relations with inequality conditions, are used in various applications. Optimizing joins has been the subject of intensive research ranging from efficient join algorithms such as sort-merge join, to the use of efficient indices such as B+ -tree, R∗ -tree and Bitmap. However, inequality joins have received little attention and queries containing such joins are notably very slow. In this paper, we introduce fast inequality join algorithms based on sorted arrays and space-efficient bit-arrays. We further introduce a simple method to estimate the selectivity of inequality joins which is then used to optimize multiple predicate queries and multi-way joins. Moreover, we study an incremental inequality join algorithm to handle scenarios where data keeps changing. We have implemented a centralized version of these algorithms on top of PostgreSQL, a distributed version on top of Spark SQL, and an existing data cleaning system, Nadeef. By comparing our algorithms against well-known optimization techniques for inequality joins, we show our solution is more scalable and several orders of magnitude faster.
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
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