Development of a database for efficient management of gas stations
Background. Modern gasoline stations face a number of challenges related to data management, inventory accounting, and customer service. Traditional accounting and management methods are often inefficient, resulting in increased time spent on processing information and an increased likelihood of err...
Saved in:
| Main Authors: | , , , , |
|---|---|
| Format: | Article |
| Language: | English |
| Published: |
Science and Innovation Center Publishing House
2025-06-01
|
| Series: | International Journal of Advanced Studies |
| Subjects: | |
| Online Access: | https://ijournal-as.com/jour/index.php/ijas/article/view/360 |
| Tags: |
Add Tag
No Tags, Be the first to tag this record!
|
| _version_ | 1849427589719916544 |
|---|---|
| author | Gulnara A. Gareeva Aigul G. Faizullina Zulfina Sh. Aglyamova Yulia N. Burkhanova Ruslan V. Spevakov |
| author_facet | Gulnara A. Gareeva Aigul G. Faizullina Zulfina Sh. Aglyamova Yulia N. Burkhanova Ruslan V. Spevakov |
| author_sort | Gulnara A. Gareeva |
| collection | DOAJ |
| description | Background. Modern gasoline stations face a number of challenges related to data management, inventory accounting, and customer service. Traditional accounting and management methods are often inefficient, resulting in increased time spent on processing information and an increased likelihood of errors. The lack of a centralized system for storing and processing data makes it difficult to analyze sales and manage inventory, which negatively affects the overall efficiency of the station.
Creating a database for a gas station solves these problems by providing automation of accounting, inventory management and customer service processes. The database allows centralized storage of information on sales, customers, fuel and financial transactions, which greatly simplifies data access and processing.
Purpose. The objective is to develop a tool that will provide automation of accounting and management at a filling station, including storage of information on customers, fuel and transactions, as well as support for analytics to make informed management decisions. This will increase the efficiency of the station, improve customer service and reduce the likelihood of accounting errors.
Method and methodology. To develop the gas station database, the Java programming language was used to create the interface and application logic, and PostgreSQL was used to store and manage the data. The approach was based on the use of a relational data model, which ensures the reliability, integrity and scalability of the system.
Results. The database supports storage of customer, fuel, sales and financial transaction information. Data is centrally managed in PostgreSQL, allowing easy operations for creating, editing and deleting records. The system also includes functions to analyze the data to facilitate informed management decisions. The database architecture provides modularity, allowing new functions to be added without significant changes to existing code.
Scope of the results. The developed database can be used in the management of gas stations, for automation of accounting and customer service processes, as well as in analytics to improve the efficiency of business processes.
Conclusions. The created database significantly simplifies data management at the gasoline station, reduces the probability of errors and increases the overall efficiency of work. Automation of accounting and customer service processes saves time and resources.
EDN: XVPFOM |
| format | Article |
| id | doaj-art-cdd84418dcbc49e09f9bdb7f3e205ecb |
| institution | Kabale University |
| issn | 2328-1391 2227-930X |
| language | English |
| publishDate | 2025-06-01 |
| publisher | Science and Innovation Center Publishing House |
| record_format | Article |
| series | International Journal of Advanced Studies |
| spelling | doaj-art-cdd84418dcbc49e09f9bdb7f3e205ecb2025-08-20T03:28:58ZengScience and Innovation Center Publishing HouseInternational Journal of Advanced Studies2328-13912227-930X2025-06-01152648510.12731/2227-930X-2025-15-2-360360Development of a database for efficient management of gas stationsGulnara A. Gareeva0Aigul G. Faizullina1Zulfina Sh. Aglyamova2Yulia N. Burkhanova3Ruslan V. Spevakov4Kazan National Research Technical University named after A.N. Tupolev-KAIKazan Federal University Naberezhnochelninsk InstituteKazan Innovation University named after V.G. TimiryasovKazan Innovation University named after V.G. Timiryasov; Naberezhnochelninsky State Pedagogical UniversityKazan Innovation University named after V.G. TimiryasovBackground. Modern gasoline stations face a number of challenges related to data management, inventory accounting, and customer service. Traditional accounting and management methods are often inefficient, resulting in increased time spent on processing information and an increased likelihood of errors. The lack of a centralized system for storing and processing data makes it difficult to analyze sales and manage inventory, which negatively affects the overall efficiency of the station. Creating a database for a gas station solves these problems by providing automation of accounting, inventory management and customer service processes. The database allows centralized storage of information on sales, customers, fuel and financial transactions, which greatly simplifies data access and processing. Purpose. The objective is to develop a tool that will provide automation of accounting and management at a filling station, including storage of information on customers, fuel and transactions, as well as support for analytics to make informed management decisions. This will increase the efficiency of the station, improve customer service and reduce the likelihood of accounting errors. Method and methodology. To develop the gas station database, the Java programming language was used to create the interface and application logic, and PostgreSQL was used to store and manage the data. The approach was based on the use of a relational data model, which ensures the reliability, integrity and scalability of the system. Results. The database supports storage of customer, fuel, sales and financial transaction information. Data is centrally managed in PostgreSQL, allowing easy operations for creating, editing and deleting records. The system also includes functions to analyze the data to facilitate informed management decisions. The database architecture provides modularity, allowing new functions to be added without significant changes to existing code. Scope of the results. The developed database can be used in the management of gas stations, for automation of accounting and customer service processes, as well as in analytics to improve the efficiency of business processes. Conclusions. The created database significantly simplifies data management at the gasoline station, reduces the probability of errors and increases the overall efficiency of work. Automation of accounting and customer service processes saves time and resources. EDN: XVPFOMhttps://ijournal-as.com/jour/index.php/ijas/article/view/360gas stationdatabasepostgresqldbeaverautomationdata managementanalyticsefficiencyintegrationrelational modelcustomer accountinginventory management |
| spellingShingle | Gulnara A. Gareeva Aigul G. Faizullina Zulfina Sh. Aglyamova Yulia N. Burkhanova Ruslan V. Spevakov Development of a database for efficient management of gas stations International Journal of Advanced Studies gas station database postgresql dbeaver automation data management analytics efficiency integration relational model customer accounting inventory management |
| title | Development of a database for efficient management of gas stations |
| title_full | Development of a database for efficient management of gas stations |
| title_fullStr | Development of a database for efficient management of gas stations |
| title_full_unstemmed | Development of a database for efficient management of gas stations |
| title_short | Development of a database for efficient management of gas stations |
| title_sort | development of a database for efficient management of gas stations |
| topic | gas station database postgresql dbeaver automation data management analytics efficiency integration relational model customer accounting inventory management |
| url | https://ijournal-as.com/jour/index.php/ijas/article/view/360 |
| work_keys_str_mv | AT gulnaraagareeva developmentofadatabaseforefficientmanagementofgasstations AT aigulgfaizullina developmentofadatabaseforefficientmanagementofgasstations AT zulfinashaglyamova developmentofadatabaseforefficientmanagementofgasstations AT yulianburkhanova developmentofadatabaseforefficientmanagementofgasstations AT ruslanvspevakov developmentofadatabaseforefficientmanagementofgasstations |