Database Systems Journal

ISSN 2069 - 3230

Published with the support of:
The Bucharest University of Economic Studies


Database Systems Journal, Vol. XI, 2020


Open PDF Journal


CONTENTS


1. Operational Research in the Emergency Medical System of Romania (p. 3-13)
Ionut NICA, The Bucharest University of Economic Studies, Romania
The explosive development of the human society in contrast to the limited character of resources determines the need for successful implementation of mathematic models in the decision-making process concerning the use of available resources. One of the critical areas where the need for rigorous criteria for resource allocation is strongly felt is the medical field. This issue appears to be currently affecting the great majority of nations in the world, being considered one of the most important challenges for modern states. The limited amount of resources allocated to the medical system brings forward the importance of optimizing the decision-making process concerning this field using models able to reflect the increasing complexity of the medical system, its interactions with the human society and its dynamics, therefore providing the perturbation control and adjustment instruments. From this point of view, the economical and mathematical modeling of the social phenomena provides strong, elegant and rigorous tools for the description of medical system that appears to be organized as a cybernetic system with a high level of complexity, focused on maximizing the social utility, and allowing the use of cybernetic methods designed for diagnosing, developing automatic medical archives, reducing time consumption and increasing overall efficiency.
Keywords: Markov network, Poisson distribution, cybernetics models, optimal decision, emergency medical system
2. Business Analytics Applications for Consumer Credits (p. 14-23)
Claudia ANTAL_VAIDA, The Bucharest University of Economic Studies, Romania
The fast-paced and dynamic economical background determines all the industries to quickly adapt to change and adopt emerging technologies to remain competitive on the market. This tendency led to high volumes of data generated each second and to a decreasing ability of the manpower to analyze it and use if for beneficial purposes. This paper reviews the impact of Digital Transformation on the Banking area and how financial institutions leverage the advantage created by this trend, especially in the credit risk management field. Multiple papers on consumer credit scoring models written after the financial crisis from 2007 were reviewed and their results were summarized in this article, to increase the accuracy of future analysis by leveraging the already known results.
Keywords: Business Analytics, Machine Learning, Banking, Credit Risk Assessment, Scoring Models, Consumer Credits
3. Business Intelligence and Machine Learning. Integrated cloud solutions providing business insights for decision makers. (p. 24-36)
Laura-Gabriela TANASESCU, The Bucharest University of Economic Studies, Romania
The aim of this paper is to present the latest trends in business intelligence and ways in which nowadays organizations can implement cloud technologies. This work is going to present challenges of the market, providers of integrated cloud business intelligences tools, advantages and disadvantages of moving to the cloud. A real life use case will argue the importance of taking advantage of data, as well as the necessity and the obvious benefits of having the right tools of transforming data into correct business decisions.
Keywords: business intelligence, cloud computing, artificial intelligence, analytics, machine learning, innovation, data
5. A Big Data Modeling Methodology for NoSQL Document Databases (p. 37-46)
Gerardo ROSSEL, Facultad de Ciencias Exactas y Naturales, Universidad de Buenos Aires, Argentina
Andrea MANNA, Facultad de Ciencias Exactas y Naturales, Universidad de Buenos Aires, Argentina
In recent years, there has been an increasing interest in the field of non-relational databases. However, far too little attention has been paid to design methodology. Key-value datastores are an important component of a class of non-relational technologies that are grouped under the name of NoSQL databases. The aim of this paper is to propose a design methodology for this type of database that allows overcoming the limitations of the traditional techniques. The proposed methodology leads to a clean design that also allows for better data management and consistency
Keywords: NoSQL, Document Databases, Conceptual Modeling, Data Modeling, NoSQL Database developing
5. Learning view over the implementation of business process optimizations (p. 47-57)
Radu SAMOILA, The Bucharest University of Economic Studies, Romania
Current context of great development and changes in the technological matters, national and global economies have to keep pace and undergone major changes. The ultimate aim of the companies and organization is to improve or optimize its business processes to cope with increased competitiveness in order to deliver more efficiently better products or services. The success of current businesses is linked to the efficiency but also the effectiveness of their core processes. Most part of the latest researches have recognized this importance leading to efforts concentrated on analyzing and optimizing the business processes. There are many techniques which are considered but also others which are not causing potentially significant opportunities of improvement not being addressed. However, currently, there is a scarce of an universal technique or methodology that can be used by the organizations to address business optimizations. This paper addresses different topics on how companies are analyzing the decision to initiate a business process optimization and how optimizations landed within organizations.
Keywords: business process, optimization, efficiency and effectiveness of internal processes, business automation, optimization methodology
6. Natural Learning Processing based on Machine Learning Model for automatic analysis of Online Reviews related to Hotels and Resorts (p. 58-77)
Bogdan-Stefan POSEDARU, The Bucharest University of Economic Studies, Romania
Tiberiu-Marian GEORGESCU, The Bucharest University of Economic Studies, Romania
Florin-Valeriu PANTELIMON, The Bucharest University of Economic Studies, Romania
This article describes the development and implementation of a natural language processing (NLP) model based on machine learning (ML) for automatic analysis of customers' reviews on hotels and resorts written in English. The model performs named entity recognition (NER), relation extraction (RE) as well as sentiment analysis (SA). The performance indicators validate the model, as we obtained an F1 score of 0.79 for ER and 0.61 for RE. Our results prove to be remarkable compared to other models that use similar techniques and technologies. Furthermore, we developed a web application which allows users to benefit from our model to automatically analyze customers' reviews about hotels and resorts.
Keywords: Natural Language Processing, Machine Learning, Entity Recognition, Relation Extraction, Sentiment Analysis
7. Application for the efficiency improvement of the work process in an energy company (p. 78-89)
Madalina-Florina DANALACHE, The Bucharest University of Economic Studies, Romania
Simona-Vasilica OPREA, The Bucharest University of Economic Studies, Romania
In modern society, electricity is necessary for the proper conduct of daily activities, becoming es-sential for life. All existing domains such as industry, transport, information technology, agricultu-re, economy, etc. requires energy resources to carry out the activities undertaken in optimal condi-tions. Thus, distribution companies invest enormously to transform networks into smart grids thro-ugh a digitization effort that is constantly supported by modernization projects. As an alternative with lower costs, an application can be implemented that helps consumers and employees regarding the the continuity of electricity supply, the quality of services provided to them and better communication between the consumer and the distribution operator.
Keywords: electricity distribution company, consumer satisfaction, web application, prompt and quality services, automation of daily activities, easy reporting

Database Systems Journal, 2020
Special issue: Software solutions for efficient trading on the electricity markets


Open PDF Journal


CONTENTS


1. Testing Approaches for an Electricity Market Simulator (p. 3-16)
Anca Ioana ANDREESCU, The Bucharest University of Economic Studies, Romania
Ana Ramona BOLOGA, The Bucharest University of Economic Studies, Romania
Software testing methodologies represent different approaches and techniques to ensure that a particular software application is fully tested. This paper addresses the functional testing of a software system for simulating electricity markets. The tested functionalities are briefly presented and the main testing techniques compatible with this type of system are analyzed. The purpose is to recommend the best combination of techniques recommended in this case and to present results obtained by applying them to the simulator.
Keywords: functional testing technics, behavioral testing, electricity market, simulator
2. Dashboard for analysis of electricity imbalances at the Balancing Responsible Parties level (p. 17-30)
Simona-Vasilica OPREA, The Bucharest University of Economic Studies, Romania
Adela BARA, The Bucharest University of Economic Studies, Romania
Ciprian Georgian DRAGOMIR, CEZ Romania
Osman Bülent TÖR, EPRA, Engineering Procurement Research Analysis, Ankara, Turkey
Stefan PREDA, The Bucharest University of Economic Studies, Romania
The paper presents the Dashboard for the analysis of imbalances at the level of a Balancing Responsible Party BRP (ABI-PRE). It describes the allocation between the members of a BRP of the costs/revenues generated by the net imbalances of the respective BRP and the calculation methodology implemented within the IT prototype. The reports created within the ABI-PRE Dashboard are generated following the analysis of specific indicators (contribution of BRP members to imbalances, revenues/expenses resulting from internal redistribution, additional revenues/expenses from system balancing, share of imbalance at BRP level, ratios between adjusted average prices and average prices on the Balancing Market) and BRP performance (BRP efficiency).
Keywords: balancing market, balancing responsible parties, surplus, deficit, cost allocation method
3. Consumption Management Software for Electric Power Suppliers (p. 31-40)
Ana-Ramona BOLOGA, The Bucharest University of Economic Studies, Romania
Simona-Vasilica OPREA, The Bucharest University of Economic Studies, Romania
Adela BARA, The Bucharest University of Economic Studies, Romania
Florin-Constantin CIOBANU, CEZ Romania
Osman Bülent TÖR, EPRA, Engineering Procurement Research Analysis, Ankara, Turkey
The electricity market is a very complex reality, with numerous participants, rules, factors that influence the evolution of energy production and consumption. This paper presents a software solution that supports electric power suppliers as participants in this complex market. The prototype uses machine learning algorithms to determine consumer clusters and forecast the next day's consumption, the purpose being to obtain the flattening of the consumption curve at the level of the electricity supplier. Based on the initial consumption planning of programmable devices transmitted by consumers, four consumption optimization algorithms are applied in parallel, giving the energy supplier the possibility to decide the optimal plan for the next day.
Keywords: power sector, software, power suppliers, forecast, optimization
4. Electricity Consumption Management Software Tool for Consumers - MY SMART HOME (p. 41-53)
Anca ANDREESCU, The Bucharest University of Economic Studies, Romania
Adela BARA, The Bucharest University of Economic Studies, Romania
Simona-Vasilica OPREA, The Bucharest University of Economic Studies, Romania
George Adrian IFRIM, "Dunarea de Jos" University, Department of Automatic control and Electrical Engineering , Galati, Romania
Osman Bülent TÖR, EPRA, Engineering Procurement Research Analysis, Ankara, Turkey
Andrei BUCUR, Smarte Tech Energy Concept SRL, Bucharest, Romania
In the introductory part, this paper summarizes the main aspects related to smart homes and home energy management (HEM) technologies and presents several existing HEM solutions. The proposed Electricity consumption management software tool for consumers - MY SMART HOME allows the management of the types of devices that facilitate the monitoring and optimization of electricity consumption: meters, smart devices, and sensors. A process for optimal scheduling of the devices was implemented, through a series of seven steps to be followed by the user. Some reporting solutions, both in graphical and tabular form, for analyzing the initial and optimal consumption per device, consumption place and household are offered.
Keywords: power sector, smart homes, software, energy consumption, optimization
5. Data Analytics for the Transmission System Operators (p. 54-73)
Dan PREOTESCU, Romanian Energy Center, Bucharest, Romania
Simona-Vasilica OPREA, The Bucharest University of Economic Studies, Romania
Adela BARA, The Bucharest University of Economic Studies, Romania
Niculae OPREA, Transelectrica S.A., Bucharest, Romania
Osman Bülent TÖR, EPRA, Engineering Procurement Research Analysis, Ankara, Turkey
In the beginning the paper briefly presents the worldwide context determined by the global warming phenomenon evolution, and the foreseen impact on the power sector, with the focus on the massive integration of the RES powered electricity generators. Identifying the TSOs and grid operators as the main actors for implementing the necessary changes, the authors of the paper are proposing data analytics, designed to support the TSOs and grid operators in fulfilling their main functions and responsibilities. The structure and the capabilities (analysis and reports) of the software product are presented, including practical examples for usage, and highlighting the potential usefulness of each analyze and/or report, from TSOs and grid operators' point of view.
Keywords: power sector, Renewable Energy Sources, software, Transmission System Operators, grid operator, forecast