MDICA: Maintenance of data integrity in column-oriented database applications

Suárez-Cabal, María José; Suárez-Otero, Pablo; Riva, Claudio de la; Tuya, Javier

doi:10.1016/j.csi.2022.103642

Cited by 4 publications

(2 citation statements)

References 38 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…This design provides advantages for analytical queries that typically involve aggregating data from specific columns. By storing data in a columnar format, these databases can perform operations like data filtering, aggregation, and compression more efficiently, resulting in faster query execution times [11].…”

Section: Column-oriented Nosql Databasementioning

confidence: 99%

Creation of column-oriented NoSQL databases automatically in Big Data environments and its impact on energy consumption

Elotmani,

Esbai,

Atounti

2023

E3S Web Conf.

View full text Add to dashboard Cite

This study investigates the automatic creation of column-oriented NoSQL databases in Big Data environments and their impact on energy consumption. Traditional row-oriented databases face limitations in handling large volumes of data, resulting in slower query response times and energy inefficiencies. In contrast, column-oriented NoSQL databases store data in columns, enabling efficient compression, retrieval, and query processing. Innovative techniques are employed to automatically create these databases, optimizing performance and minimizing manual intervention. Storing data in a columnar format reduces storage requirements and power consumption while improving data locality and reducing I/O operations. This study emphasizes the benefits of adopting column-oriented NoSQL databases, including improved performance, scalability, and energy efficiency in Big Data environments.

show abstract

Section: Column-oriented Nosql Databasementioning

confidence: 99%

Creation of column-oriented NoSQL databases automatically in Big Data environments and its impact on energy consumption

Elotmani,

Esbai,

Atounti

2023

E3S Web Conf.

View full text Add to dashboard Cite

show abstract

“…In this regard, the PostgreSQL object-relational database management system programming language was chosen. The fundamental characteristic of an object-relational database is the support of user objects and their behavior, including data types, functions, operations, domains and indexes [11].…”

Section: Main Partmentioning

confidence: 99%

Development of a Database of Digital Multicultural Content and Application in Journalism Lessons

Petrov

Bakenova

Yensebayeva

2022

SJAITU

View full text Add to dashboard Cite

The development of digital technologies stimulates changes in the field of education, including for students of the educational programs «Digital Journalism» and «Media Technologies». This paper presents the practice of using a database of digital multicultural content in journalism lessons. The relevance of this scientific publication is due to the need to integrate digital technologies into the educational process and the development of students’ skills in working with programming languages. The importance of using such content is described by the modern realities of the educational system, when all members of the academic community are involved in the process of forming national identity within the country and global globalization. Kazakhstan’s conditions demonstrate the penetration of cultures of various ethnic groups, religions, which is the reality of modern teachers and students. The author offers a model for creating a database of digital multicultural content. To do this, the multicultural content of three TV channels and online publications posted on digital services is being studied. The design and structuring of web portals, interfaces, and content are studied. The author conducts quantitative and qualitative research of media materials. A parallel is drawn between the amount of digital content published on television and on Internet resources. Through lexical and compositional analysis, trends and issues of digital multicultural content are identified. The information obtained during the study was organized into a database in the PostgreSQL programming language. As an experiment, the use of the database was tested in journalism lessons when performing exercises and conducting mini-studies. At the end of the training course, a survey of students was conducted on the effectiveness of using databases in the classroom. The students’ answers are analyzed and presented in a generalized form. The methodological methods of working with students described and analyzed in this article are important material for the development of the educational goals of future journalists.

show abstract