Development of an openoffice application for working with simple relational database text format

This work presented the development of an OpenOffice application for working withsimple relational database text format. OpenOffice application automatically loads all CSVfiles in the form of tables into a document, each table is created on a separate tab, supportsautomatic setting of column width, according to the length of its name. It is very importantthat the OpenOffice application signals the user if he accidentally violates the restriction onthe uniqueness of the primary key. Composite primary keys are also supported. Thus, thisapplication simplifies the development, editing and maintenance of databases in CSVDBformat. Further development of this application is possible in the direction of supportingwork with foreign keys and creating similar applications for various types of table proces-sors.

Authors

Institutions

Publication Details

Journal
Problems of applied mathematics and mathematic modeling
Published
2024-11-22
DOI
https://doi.org/10.15421/322411
Primary Topic
Service-Oriented Architecture and Web Services
Type
article
Field-Weighted Citation Impact
0.00
Controls
|||
ALL TIME
JAN
FEB
MAR
APR
MAY
JUN
JUL
AUG
SEP
OCT
article

Development of an openoffice application for working with simple relational database text format

K. Y. Zolotko, D. V. Krasnoshapka, N. Stepanova, S.F. Siryk
Problems of applied mathematics and mathematic modeling
Service-Oriented Architecture and Web Services
article

Development of an openoffice application for working with simple relational database text format

K. Y. Zolotko, D. V. Krasnoshapka, N. Stepanova, S.F. Siryk
article en

Abstract

This work presented the development of an OpenOffice application for working withsimple relational database text format. OpenOffice application automatically loads all CSVfiles in the form of tables into a document, each table is created on a separate tab, supportsautomatic setting of column width, according to the length of its name. It is very importantthat the OpenOffice application signals the user if he accidentally violates the restriction onthe uniqueness of the primary key. Composite primary keys are also supported. Thus, thisapplication simplifies the development, editing and maintenance of databases in CSVDBformat. Further development of this application is possible in the direction of supportingwork with foreign keys and creating similar applications for various types of table proces-sors.

Problems of applied mathematics and mathematic modeling
Oles Honchar Dnipro National University (UA)
Openalex Percentile: Top 56%
Service-Oriented Architecture and Web Services
AI Navigator

Ask Laika to Summarize, Analyze, and Connect papers live on the map.

Summarize Papers & Methodologies

Extract key findings, datasets, and comparative methods across publications.

Benchmark Rankings & Visual Analytics

Rank top research institutions, authors, funders, topics, and journals by Field-Weighted Citation Impact (FWCI) and paper volume with instant charts.

Connect Distant Disciplines

Bridge topological clusters on the map to find hidden collaborative intersections.