Academic literature on the topic 'PostgreSQL JSONB'

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

Select a source type:

Consult the lists of relevant articles, books, theses, conference reports, and other scholarly sources 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.

Journal articles on the topic "PostgreSQL JSONB"

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

Mammadov, Nail, Gulshan Umud Mammadova, and Tunar Babali. "OPTIMIZATION OF ACCESS TO STATIC DATA IN DISTRIBUTED SYSTEMS: A KUBERNETES-BASED SOLUTION WITH POSTGRESQL AND DJANGO." Problems of Information Technology 16, no. 2 (2025): 56–68. https://doi.org/10.25045/jpit.v16.i2.05.

Full text
Abstract:
Static data is a crucial component in distributed systems, ensuring the seamless operation of various components. However, achieving reliable and high-frequency access to such data poses challenges due to its heterogeneous structure. This paper introduces a Kubernetesorchestrated Static Data Database that integrates advanced technologies and best practices to address these challenges effectively. The proposed system leverages the Django framework and PostgreSQL database, optimized with advanced features such as JSONB indexing and metadata flexibility. These technologies are not only widely ado
APA, Harvard, Vancouver, ISO, and other styles
4

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
5

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
6

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
7

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
8

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
9

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
10

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
More sources

Dissertations / Theses on the topic "PostgreSQL JSONB"

1

Edman, Fredrik. "Läsa och lagra data i JSON format för smart sensor : En jämförelse i svarstid mellan hybriddatabassystemet PostgreSQL och MongoDB." Thesis, Högskolan i Skövde, Institutionen för informationsteknologi, 2018. http://urn.kb.se/resolve?urn=urn:nbn:se:his:diva-15482.

Full text
Abstract:
Sociala media genererar stora mängder data men det finns fler saker som gör det och lagrar i NoSQL databassystem och smarta sensorer som registrerar elektrisk förbrukning är en av de. MongoDB är ett NoSQL databassystem som lagrar sin data i dataformatet JSONB. PostgreSQL som är ett SQL databassystem har i sina senare distributioner också börjat hantera JSONB. Det gör att PostgreSQL är en typ av hybrid då den hanterar operationer för både SQL och NoSQL. I denna studie gjordes ett experiment för att se hur dessa databassystem hanterar data för att läsa och skriva när det gäller JSON för smarta s
APA, Harvard, Vancouver, ISO, and other styles

Book chapters on the topic "PostgreSQL JSONB"

1

Shaik, Baji, and Dinesh Kumar Chemuduru. "Handling JSON." In Procedural Programming with PostgreSQL PL/pgSQL. Apress, 2023. http://dx.doi.org/10.1007/978-1-4842-9840-4_7.

Full text
APA, Harvard, Vancouver, ISO, and other styles

Conference papers on the topic "PostgreSQL JSONB"

1

Широков, И. А. "ИССЛЕДОВАНИЕ ВОЗМОЖНОСТЕЙ ХРАНЕНИЯ И ОБРАБОТКИ МНОГОУРОВНЕВЫХ ДАННЫХ В PostgreSQL". У X Международная научно-практическая конференция "Культура, наука, образование: проблемы и перспективы". Нижневартовский государственный университет, 2022. http://dx.doi.org/10.36906/ksp-2022/61.

Full text
Abstract:
В статье анализируются проблемы, связанные с замещением в Российской Федерации компаний-поставщиков баз данных. В качестве альтернативы рассматривается open source база данных PostgreSQL, а также анализируется JSON формат как один из примеров хранения данных, позволяющий создавать уровни хранения. Далее, исследуется возможность хранения и обработки многоуровневых данных в виде JSON-объектов в PostgreSQL.
APA, Harvard, Vancouver, ISO, and other styles
2

Mota, Denysson Axel Ribeiro, and Gracy Kelli Martins. "Metadados e Twitter: uso do Tweet Object para identificação de local." In II Workshop de Informação, Dados e Tecnologia - WIDAT. Faculdade de Ciências e Engenharia (UNESP), 2018. http://dx.doi.org/10.22477/ii.widat.131.

Full text
Abstract:
Esta pesquisa apresenta um estudo, com base nos Estudos Métricos da Ciência da Informação, sobre a disseminação de informações na plataforma Twitter. Este trabalho teve como objetivos identificar elementos para análises métricas nos Tweets, utilizando como recorte mensagens coletadas na ferramenta via API. Para alcançar estes objetivos, utilizou dados obtidos via API do Twitter, usando sistema operacional Debian Linux e uma aplicação Ruby, armazenados em formato JSON em uma base de dados no SGBD PostGreSQL, e manipulados no SublimeText 3 e OpenOffice quando necessário. Apresenta como resultado
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!