Log in

Relevant bibliographies by topics / PostgreSQL / Journal articles

To see the other types of publications on this topic, follow the link: PostgreSQL.

Journal articles on the topic 'PostgreSQL'

Author: Grafiati

Published: 4 June 2021

Last updated: 25 July 2025

Create a spot-on reference in APA, MLA, Chicago, Harvard, and other styles

Select a source type:

Consult the top 50 journal articles for your research on the topic 'PostgreSQL.'

Next to every source in the list of references, there is an 'Add to bibliography' button. Press on it, and we will generate automatically the bibliographic reference to the chosen work in the citation style you need: APA, MLA, Harvard, Chicago, Vancouver, etc.

You can also download the full text of the academic publication as pdf and read online its abstract whenever available in the metadata.

Browse journal articles on a wide variety of disciplines and organise your bibliography correctly.

1

Salunke, Sanket Vilas, and Abdelkader Ouda. "A Performance Benchmark for the PostgreSQL and MySQL Databases." Future Internet 16, no. 10 (2024): 382. http://dx.doi.org/10.3390/fi16100382.

Full text

Abstract:

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, Post

APA, Harvard, Vancouver, ISO, and other styles

2

Gkamas, Theodosios, Vasileios Karaiskos, and Sotirios Kontogiannis. "Performance Evaluation of Distributed Database Strategies Using Docker as a Service for Industrial IoT Data: Application to Industry 4.0." Information 13, no. 4 (2022): 190. http://dx.doi.org/10.3390/info13040190.

Full text

Abstract:

Databases are an integral part of almost every application nowadays. For example, applications using Internet of Things (IoT) sensory data, such as in Industry 4.0, are a classic example of an organized storage system. Due to its enormous size, it may be stored in the cloud. This paper presents the authors’ proposition for cloudcentric sensory measurements and measurements acquisition. Then, it focuses on evaluating industrial cloud storage engines for sensory functions, experimenting with three open-source types of distributed Database Management Systems (DBMS); MongoDB and PostgreSQL, with t

APA, Harvard, Vancouver, ISO, and other styles

3

Stěhule, Pavel. "PostgreSQL 8.3." Geoinformatics FCE CTU 2 (December 19, 2007): 91–100. http://dx.doi.org/10.14311/gi.2.12.

Full text

Abstract:

Práce na Open Source databázích pokračují nezadržitelným tempem. Vývojáři se musí vyrovnat s rostoucími požadavky uživatelů na objem dat ukládaných do databází, na náročnější požadavky na odezvu atd. Zatím nedostižnou metou je implementace celého standardu ANSI SQL 200x. Všechny databáze z velké trojky (Firebird, MySQL a PostgreSQL) používají multigenerační architekturu, cenově orientované hledání optimálního prováděcího plánu, write ahead log atd. MySQL se profiluje jako SQL databáze schopná používat specializované databázové backendy schopné maximální efektivity pro určité konkrétní prostřed

APA, Harvard, Vancouver, ISO, and other styles

4

Guliato, Denise, Ernani V. de Melo, Rangaraj M. Rangayyan, and Robson C. Soares. "POSTGRESQL-IE: An Image-handling Extension for PostgreSQL." Journal of Digital Imaging 22, no. 2 (2008): 149–65. http://dx.doi.org/10.1007/s10278-007-9097-5.

Full text

APA, Harvard, Vancouver, ISO, and other styles

5

Natti, Murali. "Migrating from Oracle to PostgreSQL: Leveraging Open-Source to Reduce Database Costs and Enhance Flexibility." Eastasouth Journal of Information System and Computer Science 1, no. 02 (2023): 109–12. https://doi.org/10.58812/esiscs.v1i02.433.

Full text

Abstract:

In today’s competitive landscape, organizations are under increasing pressure to reduce IT costs while maintaining or improving operational efficiency. One of the largest ongoing expenses for businesses with significant database infrastructure is the licensing and support fees associated with proprietary database systems, such as Oracle. While Oracle is renowned for its enterprise-grade capabilities and robust features, the escalating costs associated with scaling Oracle database environments can pose a significant financial burden. In contrast, PostgreSQL, a widely adopted open-source relatio

APA, Harvard, Vancouver, ISO, and other styles

6

Murali Natti. "Reducing postgreSQL read and write latencies through optimized fillfactor and hot percentages for high-update applications." International Journal of Science and Research Archive 9, no. 2 (2023): 1059–62. https://doi.org/10.30574/ijsra.2023.9.2.0657.

Full text

Abstract:

In PostgreSQL, optimizing performance [1] for high-transaction, high-update applications is crucial for maintaining low latency and high throughput. One of the primary challenges faced in these environments is the default behavior of PostgreSQL, which can lead to row migration, the accumulation of dead tuples, and increased vacuum overhead due to frequent updates to the same rows. When data is updated frequently, PostgreSQL typically writes updated rows into new locations, which can result in row migration and the creation of "dead tuples" (old versions of rows that are no longer needed). This

APA, Harvard, Vancouver, ISO, and other styles

7

Pilicita Garrido, Anabel, Yolanda Borja López, and Gonzalo Gutiérrez Constante. "Rendimiento de MariaDB y PostgreSQL." Revista Científica y Tecnológica UPSE 7, no. 2 (2020): 09–16. http://dx.doi.org/10.26423/rctu.v7i2.538.

Full text

Abstract:

El almacenamiento de información en las bases de datos es un tema importante para toda organización, en la actualidad. Son los Sistemas Gestores de Bases de Datos conocidos como SGDB encargados de ocultar la complejidad que conlleva la administración de las base de datos. Es común que cada día sean almacenados millones de datos más aún porque en la actualidad existen nuevas tendencias y exigencias para el procesamiento de grandes volúmenes de datos a gran velocidad. Por lo tanto, es indispensable que los SGBD tengan un correcto rendimiento para hacer frente a estas nuevas exigencias. El presen

APA, Harvard, Vancouver, ISO, and other styles

8

Gudriks, Rinalds, and Sergejs Kodors. "POSTGRESQL DATABASES SECURITY CONFIGURATION CHECKLIST." HUMAN. ENVIRONMENT. TECHNOLOGIES. Proceedings of the Students International Scientific and Practical Conference, no. 23 (April 24, 2019): 38. http://dx.doi.org/10.17770/het2019.23.4386.

Full text

APA, Harvard, Vancouver, ISO, and other styles

9

Ports, Dan R. K., and Kevin Grittner. "Serializable snapshot isolation in PostgreSQL." Proceedings of the VLDB Endowment 5, no. 12 (2012): 1850–61. http://dx.doi.org/10.14778/2367502.2367523.

Full text

APA, Harvard, Vancouver, ISO, and other styles

10

Малых, Владимир Леонидович, and Алексей Николаевич Калинин. "Migration from Oracle to PostgreSQL." Program Systems: Theory and Applications 13, no. 4 (2022): 77–91. http://dx.doi.org/10.25209/2079-3316-2022-13-4-77-91.

Full text

Abstract:

Во многих сферах прикладного программного обеспечения наблюдается тенденция к более широкому использованию свободного программного обеспечения (СПО). Эта тенденция связана с переходом к более экономичной модели создания и эксплуатации ПО, с повышением безопасности использования ПО, исключением контроля проприетарного ПО за пользователями и их данными, с преодолением различных санкций в области проприетарного ПО. Для России становится актуальным отказ от проприетарного ПО Oracle и переход к СПО PostgreSQL. В статье предлагается подход к решению проблемы миграции с Oracle на PostgreSQL сильно св

APA, Harvard, Vancouver, ISO, and other styles

11

Kawada, Akiyoshi, Go Nishimura, Junji Teramoto, Etsuro Fujita, Takeshi Yamamuro, and Takuma Wakamori. "PostgreSQL: Leader in Cost Reduction." NTT Technical Review 12, no. 6 (2014): 38–42. http://dx.doi.org/10.53829/ntr201406fa6.

Full text

APA, Harvard, Vancouver, ISO, and other styles

12

Voronchikhin, M. V., and N. A. Galanina. "Using the Migration-KS Software Package to Solve the Problem of Database Import Substitution." Informacionnye Tehnologii 30, no. 9 (2024): 462–67. http://dx.doi.org/10.17587/it.30.462-467.

Full text

Abstract:

Ways to solve the problem of import substitution and transfer of software to an open-source database management system (DBMS) in state and municipal institutions are considered (in particular, migration from a foreign SQL Server DBMS to domestic DBMSs based on PostgreSQL, such as PostgreSQL and DBMS-KS). The results of a detailed study of the main stages of database migration are presented, and the advantages and disadvantages of various migration methods are identified. A review of software solutions that enable the transition from MS SQL to PostgreSQL was carried out, such us AWS Database Mi

APA, Harvard, Vancouver, ISO, and other styles

13

Ikhsan, Akmal, and Dana Kusumo. "The Development of High Availability Database Infrastructure for OSS Projects with Monitoring Systems in Cloud Computing Environments." International Journal on Information and Communication Technology (IJoICT) 9, no. 2 (2023): 41–52. http://dx.doi.org/10.21108/ijoict.v9i2.761.

Full text

Abstract:

This study addressed a critical problem in the Kominfo's Operation Support System (OSS) project, which significantly impacted business operations. The outage of the MongoDB database, a vital component of OSS, resulted in server crashes and data damage. To overcome this issue, the OSS team initiated a project to migrate to PostgreSQL for high availability and improved database performance. The implementation involved the use of HA PostgreSQL technology, with multiple connected servers sharing data in real-time. Through functional and performance testing, the study has demonstrated that the HA P

APA, Harvard, Vancouver, ISO, and other styles

14

Ye, Shengke, Kaiye Dai, Guoli Fan, Ling Zhang, and Zhihao Liang. "Exploring the intersection of network security and database communication: a PostgreSQL Socket Connection case study." Transactions on Computer Science and Intelligent Systems Research 3 (April 10, 2024): 1–9. http://dx.doi.org/10.62051/pzqebt34.

Full text

Abstract:

In this study, the network security of PostgreSQL database using Socket connection is deeply analyzed. By exploring Socket connections established by PostgreSQL over TCP, we find potential security threats and vulnerabilities during data transmission, which may expose database systems to network attacks such as unauthorized access and data leakage. In order to assess these security risks, this study simulated a variety of network attack scenarios, especially the implantation and detection of Webshell, to reveal the vulnerability of PostgreSQL to such network threats. Especially in defending ag

APA, Harvard, Vancouver, ISO, and other styles

15

Firman Pratama, Firman Pratama, Devi Damayanti Devi Damayanti, Fitri Yanti Fitri Yanti, Jaka Sutresna Jaka Sutresna, and Khanif Faozi Khanif Faozi. "Evaluasi Performa PostgreSQL 16 pada FreeBSD 13.2 dan Ubuntu 22.04.3." Prosiding TAU SNARS-TEK Seminar Nasional Rekayasa dan Teknologi 5, no. 1 (2025): 147–57. https://doi.org/10.47970/snarstek.v2i1.882.

Full text

Abstract:

Penelitian ini bertujuan untuk melakukan evaluasi performa sistem manajemen basis data PostgreSQL versi 16 pada dua sistem operasi yang berbeda, yaitu FreeBSD 13.2 dan Ubuntu 22.04.3. Performa sistem diukur dan dibandingkan melalui serangkaian uji beban dan skenario penggunaan khusus. Metodologi penelitian melibatkan instalasi dan konfigurasi PostgreSQL 16 pada kedua sistem operasi, dengan parameter konfigurasi yang disesuaikan untuk mempertahankan konsistensi dan keadilan dalam pengujian. Pengujian dilakukan menggunakan berbagai dataset dan skenario penggunaan yang mencakup operasi penulisan,

APA, Harvard, Vancouver, ISO, and other styles

16

Kurako, E. A., and V. L. Orlov. "Database Migration from ORACLE to PostgreSQL." Programming and Computer Software 49, no. 5 (2023): 455–63. http://dx.doi.org/10.1134/s0361768823050055.

Full text

APA, Harvard, Vancouver, ISO, and other styles

17

Lew, Dong June, Kihyun Yoo, and Kwang Woo Nam. "DeepVQL: Deep Video Queries on PostgreSQL." Proceedings of the VLDB Endowment 16, no. 12 (2023): 3910–13. http://dx.doi.org/10.14778/3611540.3611583.

Full text

Abstract:

The recent development of mobile and camera devices has led to the generation, sharing, and usage of massive amounts of video data. As a result, deep learning technology has gained attention as an alternative for video recognition and situation judgment. Recently, new systems supporting SQL-like declarative query languages have emerged, focusing on developing their own systems to support new queries combined with deep learning that are not supported by existing systems. The proposed DeepVQL system in this paper is implemented by expanding the PostgreSQL system. DeepVQL supports video database

APA, Harvard, Vancouver, ISO, and other styles

18

Mahesh Thoutam. "Comparative Analysis of Data Warehousing Solutions in the Cloud: A Focus on Azure PostgreSQL." International Journal of Scientific Research in Computer Science, Engineering and Information Technology 10, no. 5 (2024): 423–31. http://dx.doi.org/10.32628/cseit241051016.

Full text

Abstract:

This article provides a comprehensive analysis of cloud data warehousing solutions, with a focus on Azure PostgreSQL. It examines the rapidly growing cloud data warehouse market, highlighting key advantages such as scalability, cost-effectiveness, and advanced analytics capabilities. The article compares major platforms including Azure PostgreSQL, Amazon Redshift, Google BigQuery, and Snowflake, detailing their features, strengths, and market positions. Special attention is given to Azure PostgreSQL, outlining scenarios where it excels and providing best practices for leveraging its features.

APA, Harvard, Vancouver, ISO, and other styles

19

Huda, Ibnu Qomaril, and Agus Prihanto. "Perbandingan Tahap Implementasi Dan Performa CHATBOT Telegram Dengan Platform Google DIALOGFLOW Dan Database POSTGRESQL." Journal of Informatics and Computer Science (JINACS) 5, no. 02 (2023): 253–64. http://dx.doi.org/10.26740/jinacs.v5n02.p253-264.

Full text

Abstract:

Abstrak— Komunikasi di era saat ini banyak menggunakan media sosial sebagai perantaranya. Saat ini implementasi chatbot pada media sosial kerap dilakukan demi mempermudah pekerjaan. Dalam pembuatan chatbot, ada beberapa platform yang dapat mempermudah pembuatan chatbot, contohnya seperti Google Dialogflow. Selain memberikan dampak positif, implementasi chatbot menggunakan Google Dialogflow juga memiliki dampak negatif juga. Penelitian ini bertujuan untuk melakukan perbandingan tahap implementasi dan performa chatbot Telegram dengan menggunakan platform Google Dialogflow dan database PostgreSQL

APA, Harvard, Vancouver, ISO, and other styles

20

Bhargav, Bachina. "Efficient RESTful API Development with NodeJS, Express, and PostgreSQL." European Journal of Advances in Engineering and Technology 10, no. 6 (2023): 26–37. https://doi.org/10.5281/zenodo.10901259.

Full text

Abstract:

<strong>ABSTRACT</strong> This paper explores the construction of REST APIs using NodeJS and PostgreSQL, guided by the principles of REpresentational State Transfer (REST). REST is a popular architectural style for designing networked applications, due to its stateless communication and standard operations, which enhance system interoperability. The core of our investigation focuses on leveraging the Express Framework to initiate and structure a RESTful API, subsequently integrating PostgreSQL to manage database operations. We commence by outlining the necessary prerequisites for building a RE

APA, Harvard, Vancouver, ISO, and other styles

21

Saada, Ouday, and Jihad Daba. "Automatic SQL to HQL-NoSQL Querying using PostgreSQL and Integrated Hive-Hbase." WSEAS TRANSACTIONS ON INFORMATION SCIENCE AND APPLICATIONS 20 (January 26, 2023): 16–27. http://dx.doi.org/10.37394/23209.2023.20.3.

Full text

Abstract:

The amount of digital data is constantly growing in almost all fields. This data is divided into two categories, structured and unstructured data. Non-structural databases known as NoSQL became one of the main fields of big data. Many companies are still using relational databases like PostgreSQL and MySQL. But with the rapid evolution and diversity of stored data, companies find themselves obliged to use big data tools like HBase or Hive. Big data is characterized by its capacity, speed, and ability to store diverse types of data. Data analysis and high storage capacity are the main reasons f

APA, Harvard, Vancouver, ISO, and other styles

22

ANISYA, ANISYA, INDRA WARMAN, DEDE WIRA TRISE PUTRA, EVA YULIANTI, and Hendra Cahyo Setiawan. "INTEGRASI XML DAN PYTHON PADA PENGEMBANGAN FRAMEWORK ODOO SISTEM GUDANG." Device 14, no. 1 (2024): 1–8. http://dx.doi.org/10.32699/device.v14i1.5606.

Full text

Abstract:

Sistem Enterprise Resource Planning (ERP) dengan modul gudang Odoo 15,perlu disesuaikan dengan proses bisnis perusahaan yang,Ini mencakup penyesuaian fitur dan alur kerja agar sesuai dengan kebutuhan dan tuntutan operasional perusahaan. Selain itu, integrasi kompleks antara XML dan Python.Dengan melakukan pengembangan ini, sistem ERP dapat menjadi alat yang lebih efektif dan efisien dalam mendukung operasi bisnis yang unik dari perusahaan tersebut.Diharapkan dengan pengembangan modul gudang berbasis Odoo 15 dapat berhasil dan memberikan solusi optimal bagi perusahaan dalam mengatasi masalah pe

APA, Harvard, Vancouver, ISO, and other styles

23

Apriliyanto, Erwin. "Comparison of Response Time Database RDBMS with NoSQL on Electronic Medical Records (EMR)." Jurnal Ilmiah SINUS 21, no. 2 (2023): 65. http://dx.doi.org/10.30646/sinus.v21i2.746.

Full text

Abstract:

The electronic medical record is a system for storing and managing patient medical data in electronic form. EMR replaces traditional medical record systems that still use paper, allowing doctors and other medical personnel to access patient medical records more quickly and easily from anywhere, as long as they are connected to the same network. In the EMR, patient medical data is stored in electronic format, such as text, images, and test results. EMR allows doctors to create patient medical records, make drug prescriptions, place laboratory orders and radiology orders, and access other patien

APA, Harvard, Vancouver, ISO, and other styles

24

Florentina, Jennifer, and Hans Christian Kurniawan. "Perbandingan Penerapan Relational Database Dan Graph Database Dalam Sistem Rekomendasi Film." Jurnal Telematika 18, no. 2 (2024): 94–103. http://dx.doi.org/10.61769/telematika.v18i2.608.

Full text

Abstract:

Recommendation system is used in various applications such as e-commerce, social media, and others. In building a recommendation system, a database is needed as data storage. The importance of database selection on system performance makes research on the application of various types of databases to recommendation systems increase, including in this study. This study compares the latency and memory usage between relational database and graph database on film recommendation systems. The main indicators in this study are the threshold value for the similarity value limit and the recommendation s

APA, Harvard, Vancouver, ISO, and other styles

25

Feng, Ke, Peng Huang, and Wen Yi Zhang. "Research on Coverage Calculation of Remote Sensing Satellite Data Based on PostgreSQL." Advanced Materials Research 356-360 (October 2011): 2860–63. http://dx.doi.org/10.4028/www.scientific.net/amr.356-360.2860.

Full text

Abstract:

For the characteristics of remote sensing satellite data, this paper adopts spatial information services of open source PostgreSQL database to analyze and calculate coverage of remote sensing data. The remote sensing data is shown in the Chinese administrative divisions intuitively in order to improve the efficiency in ordering the data. This paper addresses the method to calculate the coverage of remote sensing satellite data based on PostgreSQL.

APA, Harvard, Vancouver, ISO, and other styles

26

Vellanki, Ravi Babu. "PostgreSQL Configuration: Best Practices for Performance and Security." European Journal of Computer Science and Information Technology 13, no. 47 (2025): 172–82. https://doi.org/10.37745/ejcsit.2013/vol13n47172182.

Full text

Abstract:

PostgreSQL configuration significantly impacts database performance and security, yet default settings often prioritize compatibility over optimization. This article presents a comprehensive framework for PostgreSQL configuration, addressing critical aspects including memory allocation, query planning, security hardening, and monitoring. By examining the interdependencies between configuration parameters and their effects on system behavior under various workloads, the article provides a structured approach to database optimization. Memory allocation strategies focus on shared buffers, work me

APA, Harvard, Vancouver, ISO, and other styles

27

Tochilin, Sergei. "PERFORMANCE OF PHP CRUD WEB SERVICES WHEN WORKING WITH POSTGRESQL DATA." Technical Sciences and Technologies, no. 1(27) (2022): 136–41. http://dx.doi.org/10.25140/2411-5363-2022-1(27)-136-141.

Full text

Abstract:

When developing modern distributed computer systems that work with DBMS data, a service-oriented architecture is widely used. For the practical implementation of such systems, Web services are used, which are developed using various technologies.At the same time, the performance of a Web service largely determines the possibility of its use in a distributed system.PHP tools provide an efficient platform for building Web services that support various technologies.PostgreSQL is one of the most common and productive DBMS. The performance of XML-RPC, SOAP and RESTful PHP Web services when searchin

APA, Harvard, Vancouver, ISO, and other styles

28

Hairah, U., and E. Budiman. "Inner Join Query Performance: MariaDB vs PostgreSQL." Journal of Physics: Conference Series 1844, no. 1 (2021): 012021. http://dx.doi.org/10.1088/1742-6596/1844/1/012021.

Full text

APA, Harvard, Vancouver, ISO, and other styles

29

Сорокин, В. Е., та V. E. Sorokin. "Об эффективности наследования таблиц в субд postgresql". Международный журнал "Программные продукты и системы" 32 (22 серпня 2016): 15–23. http://dx.doi.org/10.15827/0236-235x.115.015-023.

Full text

APA, Harvard, Vancouver, ISO, and other styles

30

Ma Meng, Dou Yong, Deng Lin, Li Xin, and Ma Li. "Data Access Characteristics of OLTP on PostgreSQL." Journal of Convergence Information Technology 6, no. 10 (2011): 137–45. http://dx.doi.org/10.4156/jcit.vol6.issue10.18.

Full text

APA, Harvard, Vancouver, ISO, and other styles

31

Hartono, Nahrun. "KEUNTUNGAN PENGGUNAAN EXTERNAL FUNCTION PADA DATABASE POSTGRESQL." CSRID (Computer Science Research and Its Development Journal) 7, no. 1 (2015): 39. http://dx.doi.org/10.22303/csrid.7.1.2015.39-47.

Full text

Abstract:

<p>Database merupakan pusat data bagi sebuah sistem informasi, telah banyak aplikasi sistem database yang beredar baik yang berbayar maupun yang gratis. PostgreSQL merupakan salah satu sistem database yang gratis dan memiliki fitur fitur yang handal, salah satu fitur yang membedakan PostgreSQL dengan sistem basisdata yang lainnya adalah adanya fitur pembuatan Function, dimana pengguna dapat mendefinisikan sendiri Function-nya dengan menggunakan bahasa pemrograman tertentu, yang kemudian dapat dipanggil kembali untuk dieksekusi. Pada peneletian ini penulis mencoba melakukan pengujian pena

APA, Harvard, Vancouver, ISO, and other styles

32

Buchatskiy, R. A., E. Y. Sharygin, L. V. Skvortsov, R. A. Zhuykov, D. M. Melnik, and R. V. Baev. "Dynamic compilation of SQL queries for PostgreSQL." Proceedings of the Institute for System Programming of the RAS 28, no. 6 (2016): 37–48. http://dx.doi.org/10.15514/ispras-2016-28(6)-3.

Full text

APA, Harvard, Vancouver, ISO, and other styles

33

Платонова, А. И. "Сравнение производительности PostgreSQL и ее расширения TimescaleDB". Современные инновации, системы и технологии - Modern Innovations, Systems and Technologies 4, № 3 (2024): 0121–33. http://dx.doi.org/10.47813/2782-2818-2024-4-3-0121-0133.

Full text

Abstract:

В данной статье рассмотрена база данных PostgreSQL и ее расширение TimescaleDB. Целью данной работы является сравнение производительности баз данных при работе с большими данными. Так как в настоящее время при разработке приложений одним из первых вопросов, над которым задумывается разработчик, является выбор базы данных и время работы с ней, то данная тема остается актуальной. Для развертывания обеих баз данных использовано облачное хранилище, так как оно имеет ряд преимуществ перед развертыванием на локальной машине, и пользовательский интерфейс pgAdmin 4. Для проведения тестов сгенерирован

APA, Harvard, Vancouver, ISO, and other styles

34

Han, Bo, Yan-Xia Zhang, Shou-Bo Zhong, and Yong-Heng Zhao. "Astronomical data fusion tool based on PostgreSQL." Research in Astronomy and Astrophysics 16, no. 11 (2016): 178. http://dx.doi.org/10.1088/1674-4527/16/11/178.

Full text

APA, Harvard, Vancouver, ISO, and other styles

35

Татарникова, Т. М., та T. M. Tatarnikova,. "Кластеризация данных на лету для СУБД PostgreSQL". Международный журнал "Программные продукты и системы" 20 (11 червня 2023): 196–201. http://dx.doi.org/10.15827/0236-235x.142.196-201.

Full text

APA, Harvard, Vancouver, ISO, and other styles

36

Kalay, Mustafa Utku. "Concurrency Challenges in Database Systems: A Focus on Postgresql." Bilgisayar Bilimleri ve Teknolojileri Dergisi 6, no. 2 (2025): 1–16. https://doi.org/10.54047/bibted.1574178.

Full text

Abstract:

Concurrent execution is a pivotal factor in enhancing database system performance. However, as concurrency introduces certain anomalies, accurately tuning concurrent execution while considering the balance between throughput and data integrity becomes a crucial challenge. Isolation levels, specifically, act as database-side settings designed to manage anomalies that pose threats to integrity. In this article, we provide an overview of concurrency control techniques employed to achieve complete accuracy, namely, serializability. Additionally, we discuss weaker isolation levels to enhance perfor

APA, Harvard, Vancouver, ISO, and other styles

37

Efendi, Yasin, Sodikin Sodikin, and Rahmat Haryanto. "Perancangan Dan Implementasi System Incremental Backup Database Postgresql Menggunakan Aplikasi Barman Di PT. ROF." Jurnal Minfo Polgan 12, no. 1 (2023): 958–65. http://dx.doi.org/10.33395/jmp.v12i1.12539.

Full text

Abstract:

Perkembangan teknologi berkembang sangat cepat, tidak hanya dari segi hardware, namun software juga mengalami perkembangan yang sama. Salah satu dari sekian banyak hal yang perlu diperhatikan adalah backup. Backup adalah proses membuat data cadangan dengan cara menyalin atau membuat arsip data sehingga data tersebut dapat digunakan kembali apabila data tersebut hilang, rusak, terhapus atau yang di sebabkan oleh kesalahan kita sendiri atau factor lain diluar kemampuan kita. Database postgresql memiliki stabilitas yang lebih tinggi, sebab satu proses yang mati tidak akan menyebabkan seluruh daem

APA, Harvard, Vancouver, ISO, and other styles

38

Dias Wendri, Yoga Pramuda, Ari Kusmiran, and Molavi Arman. "Implementasi Model Perhitungan Untuk Menentukan Performa Basis Data MySQL Dan PostgreSQL." Jurnal Algoritme 3, no. 1 (2022): 141–50. http://dx.doi.org/10.35957/algoritme.v3i1.4219.

Full text

Abstract:

Aplikasi harus dapat diakses selama 24 jam dalam sehari oleh penggunanya, implementasi dan perbedaan database yang tepat sangat penting untuk mendukung koneksi dari ratusan ribu pengguna. Semakin banyak keluhan dari pengguna yang muncul terhadap performa, serta meningkatnya jumlah kunjungan terhadap aplikasi database yang menggunakan MySQL dan PostgreSQL terhadap komponen Queries Performed: Read, Write dan Transaction, Per-request Statistics: Average dan Threads Fairness: Execution Time. Dalam tiga komponen tersebut dilakukan pengujian untuk menentukan mana yang terbaik antara penggunaan datab

APA, Harvard, Vancouver, ISO, and other styles

39

Fatich, Steven Arycena, and Yeremia Alfa Susetyo. "Analisis Pengujian Database SQL dan NoSQL pada Aplikasi Berbasis Microservice dengan Spring Boot." Kesatria : Jurnal Penerapan Sistem Informasi (Komputer dan Manajemen) 6, no. 1 (2025): 197–209. https://doi.org/10.30645/kesatria.v6i1.561.

Full text

Abstract:

Efficient database utilization is essential in application development. This study aims to analyze the performance of PostgreSQL (SQL) and MongoDB (NoSQL) in CRUD operations and data aggregation using the Spring Boot framework. The research stages include developing a test application, conducting 10 simulation tests for each operation, and analyzing response times. The results indicate that MongoDB excels in create operations with an average response time of 230.4 ms and delete operations at 2.6 ms. In contrast, PostgreSQL demonstrates better efficiency in read operations and aggregations (sum

APA, Harvard, Vancouver, ISO, and other styles

40

Aitkhozhayeva, Y. Zh, and D. S. Akhmetsharipov. "Technology for using special encryption functions in PostgreSQL." Bulletin of the National Engineering Academy of the Republic of Kazakhstan 91, no. 1 (2024): 21–29. http://dx.doi.org/10.47533/2024.1606-146x.02.

Full text

Abstract:

Cryptographic encryption mechanisms in the open source PostgreSQL server DBMS are discussed. Special high-level and low-level functions of symmetric encryption of the Pgcrypto module for ensuring information security of data are analyzed. The analysis of special functions of the third-party GPG program is performed, which allow performing asymmetric encryption in the PostgreSQL database server. A combined data encryption technology in database tables is proposed, using a hierarchy of keys (asymmetric and symmetric encryption) with a passphrase, which is also encrypted to ensure better protecti

APA, Harvard, Vancouver, ISO, and other styles

41

Syatriana, Funny Putri, and Rio Yunanto. "IMPLEMENTASI APLIKASI PENGENDALIAN INTERN TERHADAP QUALITY CONTROL PT. INDO SADANG FABRIKATOR BERBASIS WEBSITE MENGGUNAKAN PHP DAN POSTGRESQL." PENGABDIAN PADA MASYARAKAT SISTEM INFORMASI AKUNTANSI 2, no. 1 (2022): 7–10. http://dx.doi.org/10.34010/abdikamsia.v2i1.8521.

Full text

Abstract:

Indo Sadang Fabrikator beralamatkan di Jalan Purwakarta- Subang, Kp. Kiara Dua RT.10/ RW.03 Desa Cikumpay, Kec. Campaka Kabupaten Purwakarta, Jawa Barat – 41181. Penulis melakukan kerja praktik di bagian departemen Quality Control yang dalam penginputan data dan pembuatan laporan-laporan sehari-hari, masih menggunakan Microsoft Excel, sehingga sering terjadi permasalahan dalam pencatatan, penginputan maupun pelaporannya. Berdasarkan permasalahan tersebut, penulis mengambil judul Kerja Praktik “Perancangan Aplikasi Pengendalian Intern Terhadap Quality Control PT. Indo Sadang Fabrikator berbasis

APA, Harvard, Vancouver, ISO, and other styles

42

Repas, Diogo, Zhicheng Luo, Maxime Schoemans, and Mahmoud Sakr. "Selectivity Estimation of Inequality Joins in Databases." Mathematics 11, no. 6 (2023): 1383. http://dx.doi.org/10.3390/math11061383.

Full text

Abstract:

Selectivity estimation refers to the ability of the SQL query optimizer to estimate the size of the results of a predicate in the query. It is the main calculation based on which the optimizer can select the least expensive plan to execute. While the problem has been known since the mid-1970s, we were surprised that there are no solutions in the literature for the selectivity estimation of inequality joins. By testing four common database systems: Oracle, SQL-Server, PostgreSQL, and MySQL, we found that the open-source systems PostgreSQL and MySQL lack this estimation. Oracle and SQL-Server ma

APA, Harvard, Vancouver, ISO, and other styles

43

Zhu, Daoye, Bing Han, Elisabete A. Silva, et al. "Novel Grid Collection and Management Model of Remote Sensing Change Detection Samples." Remote Sensing 15, no. 23 (2023): 5528. http://dx.doi.org/10.3390/rs15235528.

Full text

Abstract:

Remote sensing data have become an important data source for urban and regional change detection, owing to their advantages of authenticity, objectivity, immediacy, and low cost. The method of collection and management for remote sensing change detection samples (RS_CDS) assumes a crucial role in the effectiveness of remote sensing intelligent change detection (RSICD). To achieve rapid collection and real-time sharing of RS_CDS, this study proposes a grid collection and management model of RS_CDS based on GeoSOT (GCAM-GeoSOT), including the grid collection method of RS_CDS (GCM-SD) and grid ma

APA, Harvard, Vancouver, ISO, and other styles

44

Yijie Weng and Jianhao Wu. "Database management systems for artificial intelligence: Comparative analysis of postgre SQL and MongoDB." World Journal of Advanced Research and Reviews 25, no. 2 (2025): 2336–42. https://doi.org/10.30574/wjarr.2025.25.2.0586.

Full text

Abstract:

The rapid evolution of artificial intelligence (AI) has amplified the need for efficient database management systems (DBMS) to handle the growing volume, variety, and velocity of data. PostgreSQL, a robust relational database, and MongoDB, a leading NoSQL solution, are two widely adopted DBMSs in AI applications, each offering unique advantages. This paper provides a comprehensive comparative analysis of PostgreSQL and MongoDB, focusing on their suitability for AI use cases. Key evaluation criteria include data modeling, query complexity, scalability, ACID compliance, indexing, and integration

APA, Harvard, Vancouver, ISO, and other styles

45

Indrayana, I. Made, I. Made Sukarsa, and Kadek Suar Wibawa. "Text Similarity Measurement using PGTRGM Module Function PostgreSQL." JITTER : Jurnal Ilmiah Teknologi dan Komputer 3, no. 1 (2022): 802. http://dx.doi.org/10.24843/jtrti.2022.v03.i01.p16.

Full text

Abstract:

Perkembangan pemanfaatan teknologi dalam pengolahan informasi memberikan dampak besar dalam memudahkan manusia untuk menemukan suatu data yang spesifik dalam kumpulan data yang besar. Algoritma pencarian informasi dalam bentuk teks dapat memanfaatkan metode pengukuran kemiripan teks untuk membandingkan suatu teks atau informasi yang dicari dengan teks lain dalam kumpulan data yang besar. Penelitian ini melakukan pengukuran nilai kemiripan kumpulan kata dengan kumpulan kata lain menggunakan modul yang tersedia pada basis data PostgreSQL. Algoritma pengukuran kemiripan teks menggunakan extension

APA, Harvard, Vancouver, ISO, and other styles

46

Kim, Kisung. "Performance Comparison of PostgreSQL and MongoDB using YCSB." Journal of KIISE 43, no. 12 (2016): 1385–95. http://dx.doi.org/10.5626/jok.2016.43.12.1385.

Full text

APA, Harvard, Vancouver, ISO, and other styles

47

Austin, Tony, Shanghua Sun, Yin Su Lim, et al. "An Electronic Healthcare Record Server Implemented in PostgreSQL." Journal of Healthcare Engineering 6, no. 3 (2015): 325–44. http://dx.doi.org/10.1260/2040-2295.6.3.325.

Full text

APA, Harvard, Vancouver, ISO, and other styles

48

Pantilimonov, Michael Vyacheslavovich, Ruben Arturovich Buchatskiy, and Roman Aleksandrovich Zhuykov. "Machine code caching in PostgreSQL query JIT-compiler." Proceedings of the Institute for System Programming of the RAS 32, no. 1 (2020): 205–20. http://dx.doi.org/10.15514/ispras-2020-32(1)-11.

Full text

APA, Harvard, Vancouver, ISO, and other styles

49

Kravtsov, Kirill, Vadim Tynchenko, Evgeniya Semenova, Daria Shalaeva, and Ivan Pinchuk. "Workflow automation and performance improvement based on PostgreSQL." E3S Web of Conferences 458 (2023): 09022. http://dx.doi.org/10.1051/e3sconf/202345809022.

Full text

Abstract:

This article discusses the development of an automated information system for improving and improving the efficiency of the cinema. This is achieved by automating the process of submitting requests, monitoring the quality and quantity of solutions for such requests. The system is designed to provide access to the list of services provided, its timely updating and optimization; the formation of all types of reports; providing managers with a tool that automates most of the routine work on the registration of the results of the cinema.

APA, Harvard, Vancouver, ISO, and other styles

50

Levshin, D. V., and A. S. Markov. "Algorithms for integrating PostgreSQL with the semantic web." Programming and Computer Software 35, no. 3 (2009): 136–44. http://dx.doi.org/10.1134/s0361768809030025.

Full text

APA, Harvard, Vancouver, ISO, and other styles

We offer discounts on all premium plans for authors whose works are included in thematic literature selections. Contact us to get a unique promo code!