Results 1 to 10 of about 40,776 (245)
Serializable Snapshot Isolation in PostgreSQL [PDF]
This paper describes our experience implementing PostgreSQL's new serializable isolation level. It is based on the recently-developed Serializable Snapshot Isolation (SSI) technique. This is the first implementation of SSI in a production database release as well as the first in a database that did not previously have a lock-based serializable ...
Dan R. K. Ports, Kevin Grittner
arxiv +7 more sources
Cognitive Visual-learning Environment for PostgreSQL [PDF]
PostgreSQL is an object-relational database (ORDBMS) that was introduced into the database community and has been avidly used for a variety of information extraction use cases. It is also known to be an advanced SQL-compliant open source Object RDBMS. However, users have not yet resolved to PostgreSQL due to the fact that it is still under the layers ...
Manuela Nayantara Jeyaraj+4 more
arxiv +5 more sources
Dynamic compilation of SQL queries for PostgreSQL [PDF]
In recent years, as performance and capacity of main and external memory grow, performance of database management systems (DBMSes) on certain kinds of queries is more determined by raw CPU speed.
R. A. Buchatskiy+5 more
doaj +3 more sources
An Electronic Healthcare Record Server Implemented in PostgreSQL [PDF]
This paper describes the implementation of an Electronic Healthcare Record server inside a PostgreSQL relational database without dependency on any further middleware infrastructure.
Tony Austin+6 more
core +9 more sources
Database support of detector operation and data analysis in the DEAP-3600 Dark Matter experiment [PDF]
The DEAP-3600 detector searches for dark matter interactions on a 3.3 tonne liquid argon target. Over nearly a decade, from start of detector construction through the end of the data analysis phase, well over 200 scientists will have contributed to the project. The DEAP-3600 detector will amass in excess of 900 TB of data representing more than 10$^{10}
Pollmann, T. R., Smith, B.
arxiv +3 more sources
Analyzing Performance Characteristics of PostgreSQL and MariaDB on NVMeVirt [PDF]
The NVMeVirt paper analyzes the implication of storage performance on database engine performance to promote the tunable performance of NVMeVirt. They perform analysis on two very popular database engines, MariaDB and PostgreSQL. The result shows that MariaDB is more efficient when the storage is slow, but PostgreSQL outperforms MariaDB as I/O ...
Ju Hee Han, Yoojin Choi
arxiv +3 more sources
Development of a Parallel DBMS on the Basis of PostgreSQL [PDF]
The paper describes the architecture and the design of PargreSQL parallel database management system (DBMS) for distributed memory multiprocessors. PargreSQL is based upon PostgreSQL open-source DBMS and exploits partitioned parallelism.
C. S. Pan
doaj +1 more source
Jovis: A Visualization Tool for PostgreSQL Query Optimizer [PDF]
In the world of relational database management, the query optimizer is a critical component that significantly impacts query performance. To address the challenge of optimizing query performance due to the complexity of optimizers -- especially with join operations -- we introduce Jovis.
Yoojin Choi+3 more
arxiv +3 more sources
Design, implementation and experiment of a YeSQL Web Crawler [PDF]
We describe a novel, "focusable", scalable, distributed web crawler based on GNU/Linux and PostgreSQL that we designed to be easily extendible and which we have released under a GNU public licence. We also report a first use case related to an analysis of Twitter's streams about the french 2012 presidential elections and the URL's it contains.
Deveaud, Romain+4 more
arxiv +3 more sources
Adding HL7 version 3 data types to PostgreSQL [PDF]
The HL7 standard is widely used to exchange medical information electronically. As a part of the standard, HL7 defines scalar communication data types like physical quantity, point in time and concept descriptor but also complex types such as interval types, collection types and probabilistic types.
de Keijzer, Ander+2 more
arxiv +5 more sources