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
4. Testing Approaches for an Electricity Market Simulator (p. 37-50)
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
5. A Big Data Modeling Methodology for NoSQL Document Databases (p. 51-60)
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
6. Learning view over the implementation of business process optimizations (p. 61-71)
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
7. Dashboard for analysis of electricity imbalances at the Balancing Responsible Parties level (p. 72-85)
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
8. Natural Learning Processing based on Machine Learning Model for automatic analysis of Online Reviews related to Hotels and Resorts (p. 86-105)
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
9. Application for the efficiency improvement of the work process in an energy company (p. 106-117)
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