Results 1 to 10 of about 40,776 (245)

Serializable Snapshot Isolation in PostgreSQL [PDF]

open access: greenProceedings of the VLDB Endowment (PVLDB), Vol. 5, No. 12, pp. 1850-1861 (2012), 2012
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]

open access: greenarXiv, 2022
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]

open access: diamondТруды Института системного программирования РАН, 2018
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]

open access: goldJournal of Healthcare Engineering, 2015
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]

open access: yes, 2019
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]

open access: greenarXiv
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]

open access: greenТруды Института системного программирования РАН, 2018
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]

open access: greenarXiv
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]

open access: yesarXiv, 2012
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]

open access: yesarXiv, 2010
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

Home - About - Disclaimer - Privacy