Comparative analysis of connection performance with databases via JDBC interface and ORM programming frameworks

The research subject of this paper was the comparative analysis of efficiency of connections with databases using different communication methods based on Java programming language. The tools investigated included JDBC drivers and Object-relational mapping (ORM) frameworks. A survey based on 8 different criteria was conducted to determine the most effective method and tool for working with relational databases when developing Java applications. The weights of the criteria were determined through a survey of Java programmers and computer science students.

Exploring the Alternative Model for Personality Disorders Using SCORS-G Ratings on Thematic Apperception Test Narratives

The Alternative Model for Personality Disorders (AMPD) in Section III of the fifth edition of the Diagnostic and Statistical Manual of Mental Disorders (DSM-5; American Psychiatric Association, 2013) conceptualizes personality pathology as a combination of impairment (Criterion A) and traits (Criterion B). One measure used to develop Criterion A was the Social Cognition and Object Relations Scale – Global Rating Method (SCORS-G), which is a multidimensional, object-relational clinician-rated measure of personality functioning. Although there are conceptual links between the AMPD and SCORS-G dimensions, there exists no research examining the relationship. To address this, we examined associations between the SCORS-G dimensions and measures of the AMPD constructs in a large, archival dataset of outpatients and inpatients. More pathological scores on SCORS-G dimensions reflecting self- and interpersonal functioning were associated with greater pathological traits and impairment. Overall, results support further investigation into SCORS-G as a useful measure in AMPD research and assessment.

Database Private Security Jurisprudence: A Case Study using Oracle

Oracle is one of the largest vendors and the best DBMS solution of Object Relational DBMS in the IT world. Oracle Database is one of the three market-leading database technologies, along with Microsoft SQL Server's Database and IBM's DB2. Hence in this paper, we have tried to answer the million-dollar question “What is user’s responsibility to harden the oracle database for its security?” This paper gives practical guidelines for hardening the oracle database, so that attacker will be prevented to get access into the database. The practical lookout for protecting TNS, Accessing Remote Server and Prevention, Accessing Files on Remote Server, Fetching Environment Variables, Privileges and Authorizations, Access Control, writing security policy, Database Encryption, Oracle Data Mask, Standard built in Auditing and Fine Grained Auditing (FGA) is illustrated with SQL syntax and executed with suitable real life examples and its output is tested and verified. This structured method acts as Data Invictus wall for the attacker and protect user’s database.

Development of an Automated Management System for Agricultural Technologies in Horticulture

The implementation of intelligent technologies in industrial horticulture is possible with the help of an automated system for managing production processes. (Research purpose) To develop and substantiate the parameters of an automated management system for agricultural technologies in horticulture with the ability to conduct land inspections using a mobile application. (Materials and methods) ADO.NET driver Npqsql was used for work with the database. Dapper was used as Object Relational Mapping. The web application used the Model View Controller design pattern, and Bootstrap as the css framework. Data visualization from the database was carried out using cloud technology, placing the site using a set of Internet Information Services. Jquery (a set of JavaScript functions) served as the main framework for working with the client-side of the program code. The authors also used the PostgreSql database management system. The mobile application was created in the Android studio integrated environment. (Results and discussion) The authors developed an automated system for managing agricultural technologies. They formed the structure of the hardware and software base. They created the system ability to operate in a dialogue mode with the user through forms, based on the algorithm for choosing the optimal options for technological processes in the horticultural products production. A mobile application was implemented to conduct digital land inspections. They determined the procedure for conducting land inspections by agronomists using a mobile application. (Conclusions) The authors developed a system for the automated technologies formation and management in horticulture, which provided operational processing of information flows in real time, reflecting the characteristics of the plants’ growth and state in critical phases of development. They provided modern recording devices and a mobile application operation. They showed that the system automatically optimized machine technologies for the cultivation of horticultural crops according to biological (realization of the potential biological productivity of crops) and economic (increasing the efficiency of using production resources) criteria.

DESIGN AND IMPLEMENTATION OF PERSONNEL MANAGEMENT INFORMATION SYSTEM BASED ON SSM

Personnel management is a series of management activities for the company to select, use, train, evaluate, reward and punish its employees. The personnel management information system designed and implemented in this paper integrates the functions of batch import of information, instant update of personnel information, position transfer, information inquiry and statistical analysis. This system is oriented to various users such as managers at all levels of small and medium-sized enterprises and institutions. In this paper, using the aspect-oriented programming, Inversion of Control features of the Spring framework, using spring MVC model and using the ORM (Object Relational Mapping, Object Relational Mapping) feature of MyBatis, using B/S architecture and MySQL database, with high scalability, high refactorability as the design goal, designs and implements an Personnel Management Information System. The system builds a personnel database covering more than 20 information about personnel's basic information, education background, and positions, and realizes functions such as batch import of information, instant update of personnel information, job transfer, entry management, resignation management, information inquiry and statistical analysis. At the same time, it is ensured that these functions will not be illegally operated by users without authority, so that the system has higher security. This system provides an integrated solution for the informatization of personnel management and has high practical and commercial value.

Proposal of a spatial database for indoor navigation

This paper presents an approach to build a spatial database for indoor environments. It will be presented the main requirements for the implementation of an object-relational database for the representation and analysis of indoor environments, which considers the solutions for both type of representations, floor plan and schematic map. These representations consider the high number of information found in an indoor environment and the fact that they are disposed in different floors of the structure. The relationship between objects and their attributes defines the links and restrictions between them. Hence, the model should describe the entities and their interrelationships, as well as the attributes of the elements and their characteristics. After the database was developed, it was implemented an algorithm that calculates routes between points in the indoor environment, considering not only the shortest distance but also the floor change. The model was tested by Antunes and Delazari (2019) using an application and some interviews with users to evaluate the elements included in the database considering a navigating task. Some results pointed out the need to insert new information in the database regarding physical characteristics (color, material) of elements found in the indoor environment to assist users during orientation and navigation tasks. Moreover, it is necessary to include elements from the outdoor environment used as reference points in the cartographic representation.

Data migration: relational RDBMS to non-relational NoSQL

As a part of achieving specific targets, business decision making involves processing and analyzing large volumes of data that leads to growing enterprise databases day by day. Considering the size and complexity of the databases used in today’s enterprises, it is a major challenge for enterprises to re-engineering their applications that can handle large amounts of data. Compared to traditional relational databases, non-relational NoSQL databases are better suited for dynamic provisioning, horizontal scaling, significant performance, distributed architecture and developer agility benefits. Based on the concept of Object Relational Mapping (ORM) and traditional ETL data migration technique this thesis proposes a methodology for migrating data from RDBMS to NoSQL. The performance of the proposed solution is evaluated through a comparative analysis of RDBMS and NoSQL implementations based on query performance evaluation, query structure and developmental agility.