Log in

Relevant bibliographies by topics / PostgreSQL JSONB / Journal articles

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

Journal articles on the topic 'PostgreSQL JSONB'

Author: Grafiati

Published: 7 June 2025

Last updated: 17 July 2025

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

Select a source type:

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

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

Morales, Nicolas, Guillaume J. Bauchet, Titima Tantikanjana, et al. "High density genotype storage for plant breeding in the Chado schema of Breedbase." PLOS ONE 15, no. 11 (2020): e0240059. http://dx.doi.org/10.1371/journal.pone.0240059.

Full text

Abstract:

Modern breeding programs routinely use genome-wide information for selecting individuals to advance. The large volumes of genotypic information required present a challenge for data storage and query efficiency. Major use cases require genotyping data to be linked with trait phenotyping data. In contrast to phenotyping data that are often stored in relational database schemas, next-generation genotyping data are traditionally stored in non-relational storage systems due to their extremely large scope. This study presents a novel data model implemented in Breedbase (https://breedbase.org/) for

APA, Harvard, Vancouver, ISO, and other styles

2

Zolotukhina, Daria. "Comparative analysis of indexing strategies in PostgreSQL under various load scenarios." Программные системы и вычислительные методы, no. 1 (January 2025): 21–31. https://doi.org/10.7256/2454-0714.2025.1.73138.

Full text

Abstract:

The subject of the study is the effectiveness of various indexing strategies implemented in PostgreSQL and their impact on the performance of SELECT, UPDATE and INSERT operations in conditions of different data scales. The object of the study are the B-Tree, GIN and BRIN indexes used to optimize the operation of databases. The author examines in detail such aspects of the topic as the time characteristics of operations, the size of indexes and their resource intensity. Special attention is paid to the impact of data volume on the performance of indexes and their suitability for working with va

APA, Harvard, Vancouver, ISO, and other styles

3

Di Felice, Paolino, Gaetanino Paolone, Romolo Paesani, and Martina Marinelli. "Design and Implementation of a Metadata Repository about UML Class Diagrams. A Software Tool Supporting the Automatic Feeding of the Repository." Electronics 11, no. 2 (2022): 201. http://dx.doi.org/10.3390/electronics11020201.

Full text

Abstract:

Model-Driven Engineering is largely recognized as the most powerful method for the design of complex software. This study deals with the automated archival of metadata about the content of UML class diagrams (a particularly relevant category of models) into a pre-existing repository. To define the structure of the repository, we started from the definition of a UML metamodel. From the latter, we derived the schema of the metadata repository. Then, a parser was developed that is responsible for extracting the useful information from the XMI file about class diagrams and enters it as metadata in

APA, Harvard, Vancouver, ISO, and other styles

4

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

5

Shirokov, I. A. "The study of performance and methods of storage of JSON objects in PostgreSQL database management system." Vestnik NSUEM, no. 3 (October 2, 2023): 144–53. http://dx.doi.org/10.34020/2073-6495-2023-3-144-153.

Full text

Abstract:

Currently there are several methods of data storage, such as table and object, as JSON objects. National and foreign scientists conducted studies on the comparison of performance of relational database management systems and NoSQL database management system, but there were no studies that compared the performance in data insertion and storage using ordinary records and JSON objects within the relational database management system. An experiment was carried out in terms of the real examples of corporate use of the database management system; the results show the relevance of the use of JSON obj

APA, Harvard, Vancouver, ISO, and other styles

6

Rosid, Mochamad Alfan. "Implementasi JSON untuk Minimasi Penggunaan Jumlah Kolom Suatu Tabel Pada Database PostgreSQL." JOINCS (Journal of Informatics, Network, and Computer Science) 1, no. 1 (2017): 33. http://dx.doi.org/10.21070/joincs.v1i1.802.

Full text

Abstract:

On the development of the database currently has become a very important thing, each will plan something, consider any thing we will need and use existing data in a database, The development of the database currently has become a very important thing, when we want to plan something and consider everything, we will need and use existing data in a database, PostgreSQL is one Object Relational Database Management Systems (DBMS) open source with a lot of features that are not less sophisticated to commercial databases. On daily use, it sometimes occurs a case that requires a dynamic column, theref

APA, Harvard, Vancouver, ISO, and other styles

7

Rosid, Mochamad Alfan. "JSON Implementation to Minimize the Use of the Number of Columns of a Table in a PostgreSQL Database." JOINCS (Journal of Informatics, Network, and Computer Science) 1, no. 1 (2017): 33–42. http://dx.doi.org/10.21070/10.21070/joincs.v1i1.802.

Full text

Abstract:

On the development of the database currently has become a very important thing, each will plan something, consider any thing we will need and use existing data in a database, The development of the database currently has become a very important thing, when we want to plan something and consider everything, we will need and use existing data in a database, PostgreSQL is one Object Relational Database Management Systems (DBMS) open source with a lot of features that are not less sophisticated to commercial databases. On daily use, it sometimes occurs a case that requires a dynamic column, theref

APA, Harvard, Vancouver, ISO, and other styles

8

Tandalov, Kirill D., and Vadim A. Pechenin. "Development of a data exchange service between software systems." Journal of Dynamics and Vibroacoustics 10, no. 3 (2024): 50–57. http://dx.doi.org/10.18287/2409-4579-2024-10-3-50-57.

Full text

Abstract:

This article presents the development of a service information model for data exchange between ERP and MES systems used for planning and control of production processes. The purpose of the service is the efficient transfer and structuring of information between databases in the production process, as well as control of operations through the user interface. This approach allows for the integration of various external software systems, which is an urgent task in the field of automation and control of production processes. The service was implemented in Python using SQLAlchemy to work with Postg

APA, Harvard, Vancouver, ISO, and other styles

9

Bucko, Ahmet, Kamer Vishi, Bujar Krasniqi, and Blerim Rexha. "Enhancing JWT Authentication and Authorization in Web Applications Based on User Behavior History." Computers 12, no. 4 (2023): 78. http://dx.doi.org/10.3390/computers12040078.

Full text

Abstract:

The rapid growth of the web has transformed our daily lives and the need for secure user authentication and authorization has become a crucial aspect of web-based services. JSON Web Tokens (JWT), based on RFC 7519, are widely used as a standard for user authentication and authorization. However, these tokens do not store information about the user’s behavior history. To address this issue, this paper presents a solution to enhance the trustworthiness of user authentication in web applications based on their behavior history. The solution considers factors such as the number of password attempt

APA, Harvard, Vancouver, ISO, and other styles

10

Dinur, Rafel, Haris Suryamen, and Fajril Akbar. "Pembangunan Sistem Informasi Geografis Penyebaran Lokasi Usaha Florist Berbasis Web di Kota Padang." Jurnal Nasional Teknologi dan Sistem Informasi 6, no. 1 (2020): 29–37. http://dx.doi.org/10.25077/teknosi.v6i1.2020.29-37.

Full text

Abstract:

Usaha florist merupakan usaha yang bergerak di bidang jasa yang menawarkan jasa pemesanan berbagai macam produk barang karangan bunga seperti papan karangan bunga, bunga krans dan lain-lain. Dari segi pendaftaran pemesanan, masyarakat/calon pemesan masih melakukan pencarian dengan cara mencari terlebih dahulu informasi, yaitu dengan mengunjungi langsung ke usaha florist yang dituju, sehingga hal tersebut membutuhkan waktu yang lama. Salah satu alternatif yang dapat digunakan untuk mengatasi permasalahan yang muncul tersebut adalah dengan memanfaatkan sistem informasi berbasis Web GIS (Web Geog

APA, Harvard, Vancouver, ISO, and other styles

11

Dmitriev, Dmitry. "TaxonWorks." Biodiversity Information Science and Standards 2 (May 22, 2018): e25560. http://dx.doi.org/10.3897/biss.2.25560.

Full text

Abstract:

TaxonWorks (http://taxonworks.org) is an integrated workbench for taxonomists and biodiversity scientists. It is designed to capture, organize, and enrich data, share and refine it with collaborators, and package it for analysis and publication. It is based on PostgreSQL (database) and the Ruby-on-Rails programming language and framework for developing web applications (https://github.com/SpeciesFileGroup/taxonworks). The TaxonWorks community is built around an open software ecosystem that facilitates participation at many levels. TaxonWorks is designed to serve both researchers who create and

APA, Harvard, Vancouver, ISO, and other styles

12

Dmitriev, Dmitry. "TaxonWorks." Biodiversity Information Science and Standards 2 (May 22, 2018): e25560. https://doi.org/10.3897/biss.2.25560.

Full text

Abstract:

TaxonWorks (http://taxonworks.org) is an integrated workbench for taxonomists and biodiversity scientists. It is designed to capture, organize, and enrich data, share and refine it with collaborators, and package it for analysis and publication. It is based on PostgreSQL (database) and the Ruby-on-Rails programming language and framework for developing web applications (https://github.com/SpeciesFileGroup/taxonworks). The TaxonWorks community is built around an open software ecosystem that facilitates participation at many levels. TaxonWorks is designed to serve both researchers who create and

APA, Harvard, Vancouver, ISO, and other styles

13

Ломницька, С. І., та Л. М. Журавчак. "Реалізація вебзастосунку для книжкового магазину-маркетплейсу". Scientific Bulletin of UNFU 35, № 3 (2025): 141–49. https://doi.org/10.36930/40350315.

Full text

Abstract:

Наведено результати дослідження, проєктування та опису реалізації вебзастосунку для книжкового магазину-маркетплейсу, призначеного для надання ефективної, масштабованої та зручної платформи для взаємодії покупців і продавців на ринку літературної продукції. Дослідження базувалося на аналізі наявних платформ електронної комерції та програмних продуктів для онлайн-продажу книг, визначенні функціональних та нефункціональних вимог до системи, обґрунтуванні вибору сучасних технологій (React.js, Node.js з фреймворком NestJS, PostgreSQL) та проєктуванні трирівневої клієнт-серверної архітектури з вико

APA, Harvard, Vancouver, ISO, and other styles

14

Detry, Geoffroy, Javier Villarreal Piqueras, and Joaquín López Flores. "Normalización y geocodificación masiva de direcciones postales mediante procesos ETL y los servicios web del callejero digital de Andalucía unificado (CDAU)." REVISTA INTERNACIONAL MAPPING 32, no. 211 (2023): 18–24. http://dx.doi.org/10.59192/mapping.391.

Full text

Abstract:

El Inventario de Sedes y Equipamientos de la Junta de Andalucía (ISE) ofrece una visión global de la ubicación de los servicios prestados por la administración andaluza, ofreciendo tanto la localización geográfica como los datos alfanuméricos más relevantes de cada servicio. El ISE solventa los problemas asociados a la gran dispersión de datos y formatos en los que cada organismo responsable los publica, integrándolos en una única base de datos PostgreSQL/PostGIS normalizada que puede ser consultada mediante un visualizador web y servicios interoperables. Una de las tareas principales en el IS

APA, Harvard, Vancouver, ISO, and other styles

15

Brovelli, M. A., M. Minghini, C. E. Kilsedar, M. Zurbarán, M. Aiello, and M. Gianinetto. "MIGRATE: A FOSS WEB MAPPING APPLICATION FOR EDUCATING AND RAISING AWARENESS ABOUT MIGRATION FLOWS IN EUROPE." ISPRS - International Archives of the Photogrammetry, Remote Sensing and Spatial Information Sciences XLII-4/W2 (July 5, 2017): 51–55. http://dx.doi.org/10.5194/isprs-archives-xlii-4-w2-51-2017.

Full text

Abstract:

Recent years have seen a noticeable growth in migration flows from Africa and Middle East to Southern Europe, thus generating a remarkable increase of attention on media and public opinion, sometimes resulting in stereotypes and prejudices. Funded by the European Commission – Joint Research Centre through the MYGEOSS program, MIGRation pATtterns in Europe (MIGRATE) aims at educating the citizens about migration fluxes in Europe using a gamification approach based on a trivia game. MIGRATE is completely developed with Free and Open Source Software. On the server-side Django is used to define th

APA, Harvard, Vancouver, ISO, and other styles

16

Олексійчук, Ю. Ф., Д. М. Ольховський, О. В. Ольховська та О. М. Андрушків. "ПРОЄКТУВАННЯ, РОЗРОБКА ТА ТЕСТУВАННЯ WEB-СЕРВІСУ ДЛЯ ВИБОРУ ТЕМ ДИПЛОМНИХ РОБІТ". Systems and Technologies 67, № 1 (2024): 43–50. http://dx.doi.org/10.32782/2521-6643-2024-1-67.7.

Full text

Abstract:

У роботі розглядається проєктування, розробка та тестування web-сервісу для вибору тем студентських дипломних робіт. Цей застосунок може бути корисний як викладачам, так і студентам. Web-сервіс реалізує серверну частину програмного забезпечення, яке надає можливості по створенню, збереженню та розподілу тем серед студентів ВНЗ. REST API – це архітектурний стиль для реалізації веб-сервісів, що ґрунтується на простих та уніфікованих принципах, таких як використання стандартних HTTP-методів для взаємодії з ресурсами через URI, підтримка безстанової комунікації між клієнтом і сервером, підтримка п

APA, Harvard, Vancouver, ISO, and other styles

17

Adam, Marielle, Franck Theeten, Jean-Marc Herpers, et al. "DaRWIN: An open source natural history collections data management system." Biodiversity Information Science and Standards 3 (August 20, 2019): e39054. https://doi.org/10.3897/biss.3.39054.

Full text

Abstract:

DaRWIN (Data Research Warehouse Information Network) is an in-house solution developed by the Royal Belgian Institute of Natural Sciences (RBINS), as a Natural History collections management system for biological and geological samples in collections. In 2014, the Royal Museum for Central Africa (RMCA) adopted this system for its collections and started to take part in new developments. The DaRWIN database currently manages information on more than 600,000 records (about 4 million specimens) housed at the RBINS and more than 650,000 records (more than 1 million specimens) at the RMCA. DaRWIN i

APA, Harvard, Vancouver, ISO, and other styles

18

Brovelli, Maria Antonia, Candan Eylül Kilsedar, and Francesco Frassinelli. "Mobile Tools for Community Scientists." Abstracts of the ICA 1 (July 15, 2019): 1–3. http://dx.doi.org/10.5194/ica-abs-1-30-2019.

Full text

Abstract:

<p><strong>Abstract.</strong> While public participation in scientific achievements has a long history, the last decades have seen more attention and an impressive increase in the number of involved people. Citizen science, the term used for denoting such an attitude, is a very diverse practice, encompassing various forms, depths, and aims of collaboration between scientists and citizen researchers and a broad range of scientific disciplines. Different classifications of citizen science projects exist based on the degrees of influence and contributions of citizens. Haklay, Ma

APA, Harvard, Vancouver, ISO, and other styles

19

Omorov, Akzholbek. "Adopting open contracting data standards (OCDS) for government transparency: technical frameworks and implementation models." Актуальные исследования, no. 19-1 (149) (May 11, 2023). https://doi.org/10.5281/zenodo.15265772.

Full text

Abstract:

<em>This article focuses on the technical frameworks that are needed to ensure successful implantation of Open Contracting Data Standards in the public procurement systems of any country. OCDS is one of the architecture standards that have been openly exposed for the consumption of standardization and reusability of government procurement data, with open contracting, in turn, catalyzing transparency, anti-corruption, and trust through release and use of machine-readable data parameters. The paper presents the best practices in developing interoperable systems using REST APIs, effective models

APA, Harvard, Vancouver, ISO, and other styles

20

-, Sri Charitha Pagadala, Pulletikurthi Nithisha -, Pallikonda Rahul -, Musiboina Ram Mohan Rao -, and Dr Akkineni Haritha -. "Improving Document Digitization with Machine Learning-Based OCR." International Journal on Science and Technology 16, no. 1 (2025). https://doi.org/10.71097/ijsat.v16.i1.1890.

Full text

Abstract:

In today’s digital era, the extraction of text from unstructured formats such as images, PDFs, and handwritten documents is critical for digitization and automation. Traditional methods often struggle with scalability , complex layouts and multi-language support. This project addresses these challenges by leveraging Machine Learning, Optical Character Recognition (OCR), AWS Textract model and microservices architecture to create a robust, scalable, and efficient text extraction system. The proposed solution integrates advanced technologies such as Java Spring Boot for backend development, Post

APA, Harvard, Vancouver, ISO, and other styles

21

Bucher, Elmar, Cheryl J. Claunch, Derrick Hee, et al. "Annot: a Django-based sample, reagent, and experiment metadata tracking system." BMC Bioinformatics 20, no. 1 (2019). http://dx.doi.org/10.1186/s12859-019-3147-0.

Full text

Abstract:

Abstract Background In biological experiments, comprehensive experimental metadata tracking – which comprises experiment, reagent, and protocol annotation with controlled vocabulary from established ontologies – remains a challenge, especially when the experiment involves multiple laboratory scientists who execute different steps of the protocol. Here we describe Annot, a novel web application designed to provide a flexible solution for this task. Results Annot enforces the use of controlled vocabulary for sample and reagent annotation while enabling robust investigation, study, and protocol t

APA, Harvard, Vancouver, ISO, and other styles

22

Cevallos Ronquillo, Carlota Mabel, Galo Wilfrido Tobar Farias, Alberto Paul Maldonado de la Rosa, and Angélica del Rocío Tonalá de la Cruz. "Análisis de la conexión de Google charts a bases de datos y otras fuentes para visualización dinámica de datos." Revista Científica Multidisciplinar G-nerando 6, no. 1 (2025). https://doi.org/10.60100/rcmg.v6i1.690.

Full text

Abstract:

La investigación analiza cómo Google Charts se articula con diversas fuentes de datos para lograr visualizaciones dinámicas y actualizadas en tiempo real. Se profundizó en su integración con bases de datos relacionales como mysql y postgresql, destacando la generación automatizada de gráficos interactivos y la coherencia entre los datos y su representación visual. También se exploró la interoperabilidad con Google Sheets, resaltando su utilidad para usuarios sin conocimientos técnicos, lo que facilita el análisis colaborativo en entornos educativos. Además, se examinó su conexión con datos no

APA, Harvard, Vancouver, ISO, and other styles

23

Mateus, Souza de Melo, and de Oliveira da Silva Evaldo. "DATAW: API WEB PARA ANONIMIAZAÇÃO DE DADOS." Caderno de Estudos em Sistemas de Informação 11, no. 2 (2024). https://doi.org/10.5281/zenodo.15046796.

Full text

Abstract:

Com o surgimento da Lei Geral de Proteção de Dados (LGPD), as organizações enfrentam muitos desafios para garantir a privacidade e a segurança de informações pessoais, exigindo tecnologias eficientes para anonimização de dados que garantam a privacidade e a conformidade legal. Entre os desafios encontrados, destaca-se a dificuldade de implementar soluções que preservem a identificação de indivíduos no uso de dados pessoais por partes das empresas. Esse trabalho tem como objetivo desenvolver uma AP

APA, Harvard, Vancouver, ISO, and other styles

24

Adam, Marielle, Franck Theeten, Jean-Marc Herpers, et al. "DaRWIN: An open source natural history collections data management system." Biodiversity Information Science and Standards 3 (August 20, 2019). http://dx.doi.org/10.3897/biss.3.39054.

Full text

Abstract:

DaRWIN (Data Research Warehouse Information Network) is an in-house solution developed by the Royal Belgian Institute of Natural Sciences (RBINS), as a Natural History collections management system for biological and geological samples in collections. In 2014, the Royal Museum for Central Africa (RMCA) adopted this system for its collections and started to take part in new developments. The DaRWIN database currently manages information on more than 600,000 records (about 4 million specimens) housed at the RBINS and more than 650,000 records (more than 1 million specimens) at the RMCA. DaRWIN i

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!