Results 141 to 150 of about 40,024 (168)

IPLization of postgreSQL on NVDIMM

Proceedings of the 9th International Conference on E-Education, E-Business, E-Management and E-Learning, 2018
A novel approach to DBMS design called In-Page Logging (IPL) was proposed a decade ago. The IPL system exploits characteristic of flash memory; asymmetric write/read speed. This approach manages per page log in erase unit of flash memory and avoids page write but saves redo log.
Joobo Shim, Sang-Won Lee
openaire   +2 more sources

PHP and PostgreSQL

2003
PHP supports a large number of DBMS interfaces. In the last chapter, we covered basic database principles while focusing on the MySQL database interface. In this chapter, we will cover the PostgreSQL interface.
Chris Hubbard, Luis Argerich, Christopher Scollo, James Moore, Martin Geisler, John Coggeshall, Wankyu Choi, Chris Ullman, Andrew F. Hill, Zak Greant, Tarique Sani, Ken Egervari, Harish Rawat, Deepak Thomas, Devon O’Dell, Jon Parise   +15 more
openaire   +2 more sources

Evaluation of skyline algorithms in PostgreSQL

Proceedings of the 2009 International Database Engineering & Applications Symposium on - IDEAS '09, 2009
In this paper, we present our work on evaluating the skyline algorithms BNL, SFS, and a variant of LESS in PostgreSQL. It is well known that the performance of skyline queries is sensitive to a number of parameters. From extensive experiments on skyline implementations we have discovered several rules, which are remarkably simple and useful, but hard ...
Fang Wei, H. Eder
openaire   +2 more sources

Delete operation in PostgreSQL for bitemporal tables

2020 39th International Conference of the Chilean Computer Science Society (SCCC), 2020
The development of applications and computer systems demands the management of historical, current, and future data, which contrasts with the classic databases where only current data is managed. The SQL: 2011 standard proposes application time, system time, and bitemporal tables for the management of temporal data, however, to date very few Database ...
Cecilia Celestrin, Emilio Soler, Pedro Mirabal   +2 more
openaire   +2 more sources

PostgreSQL anomalous query detector

Proceedings of the 16th International Conference on Extending Database Technology, 2013
We propose to demonstrate the design, implementation, and the capabilities of an anomaly detection (AD) system integrated with a relational database management system (DBMS). Our AD system is trained by extracting relevant features from the parse-tree representation of the SQL commands, and then uses the DBMS roles as the classes for the bayesian ...
Ashish Kamra, Elisa Bertino, Bilal Shebaro, Asmaa Sallam   +3 more
openaire   +3 more sources

A study of the contributors of PostgreSQL

Proceedings of the 2006 international workshop on Mining software repositories, 2006
This report describes some characteristics of the development team of PostgreSQL that were uncovered by analyzing the history of its software artifacts as recorded by the project's CVS repository.
openaire   +2 more sources

PostgreSQL Ins and Outs

Открытые системы. СУБД, 2023
В помощь специалистам, знакомым с устройством реляционных СУБД, планирующим переход на PostgreSQL, издательство «ДМК Пресс» выпустило книгу «PostgreSQL 15 изнутри». The exodus of western IT vendors from Russia has led to shrinkage of local enterprise database ...
openaire   +1 more source

Realization of replication mechanism in PostgreSQL DBMS

2017 International Conference on Industrial Engineering, Applications and Manufacturing (ICIEAM), 2017
Nowadays we have a project of a high-performance parallel encrypted database on a cluster platform that will work with large volumes of data. For the smooth operation of the system, a reliable and high-speed data replication mechanism is required which should satisfy certain criteria of PostgreSQL DBMS and the mentioned project.
R. Sh. Minyazev, I.S. Vershinin, R. F. Gibadullin   +2 more
openaire   +2 more sources

Algorithms for integrating PostgreSQL with the semantic web

Programming and Computer Software, 2009
This paper addresses the integration of the PostgreSQL database management system (DBMS) with the Semantic Web. Integration algorithms based on the use of the DBMS capabilities that do not introduce changes in SQL are proposed. An integration based on one of the algorithms supporting main formats of the Semantic Web is presented.
A. S. Markov, D. V. Levshin
openaire   +2 more sources

Deploying Azure Arc-enabled PostgreSQL Hyperscale

2021
While Chapter 5 was handling SQL Managed Instance, this chapter will guide through the necessary steps when it comes to working with PostgreSQL Hyperscale instead.
Anthony E. Nocentino, Ben Weissman
openaire   +2 more sources