Dynamic data masking (DDM) is a powerful data-security technique for protecting personal and other sensitive information in databases from unauthorized access. A DDM can be used to mask or obfuscate information in real time, as it is accessed by unauthorized users. This prevents sensitive information from being exposed, while still allowing authorized users to access the data. In current multilayered applications, data masking may be incorporated as special modules placed anywhere between the storage and user interface. In this paper, we consider the solution of implementing masking directly in the persistence layer so that data do not travel unmasked along the network. The data at rest are unchanged (i.e., unmasked), but when users query the database, the sensitive columns in the results are displayed in a masked format, which makes it impossible to identify the original data. Given the diversity of masking features proposed by commercial and open-source database servers, this study proposes a framework for assessing the performance penalty of SQL queries when using database masking relative to the original (unmasking) scenario. We implemented and applied the framework to a basic masking scenario in the Oracle database server using the TPC-H benchmark database. Exploratory analysis and Machine Learning models suggest that DDM has a weak impact on query performance. This could be a powerful incentive for incorporating DDM in real-world software applications when up to 100GB data is stored using Oracle database server.
Background: Identifying skeletal remains has been and will remain a challenge for forensic experts and forensic anthropologists, especially in disasters with multiple victims or skeletal remains in an advanced stage of decomposition. This study examined the performance of two machine learning (ML) algorithms in predicting the person’s sex based only on the morphometry of L1–L5 lumbar vertebrae collected recently from Romanian individuals. The purpose of the present study was to assess whether by using the machine learning (ML) techniques one can obtain a reliable prediction of sex in forensic identification based only on the parameters obtained from the metric analysis of the lumbar spine. Method: This paper built and tuned predictive models with two of the most popular techniques for classification, RF (random forest) and XGB (xgboost). Both series of models used cross-validation and a grid search to find the best combination of hyper-parameters. The best models were selected based on the ROC_AUC (area under curve) metric. Results: The L1–L5 lumbar vertebrae exhibit sexual dimorphism and can be used as predictors in sex prediction. Out of the eight significant predictors for sex, six were found to be particularly important for the RF model, while only three were determined to be important by the XGB model. Conclusions: Even if the data set was small (149 observations), both RF and XGB techniques reliably predicted a person’s sex based only on the L1–L5 measurements. This can prove valuable, especially when only skeletal remains are available. With minor adjustments, the presented ML setup can be transformed into an interactive web service, freely accessible to forensic anthropologists, in which, after entering the L1–L5 measurements of a body/cadaver, they can predict the person’s sex.
1 December 2016 in Scientific Annals of Economics and Business
Big Data systems manage and process huge volumes of data constantly generated by various technologies in a myriad of formats. Big Data advocates (and preachers) have claimed that, relative to classical, relational/SQL Data Base Management Systems, Big Data technologies such as NoSQL, Hadoop and in-memory data stores perform better. This paper compares data processing performance of two systems belonging to SQL (PostgreSQL/Postgres XL) and Big Data (Hadoop/Hive) camps on a distributed five-node cluster deployed in cloud. Unlike benchmarks in use (YCSB, TPC), a series of R modules were devised for generating random non-aggregate queries on different subschema (with increasing data size) of TPC-H database. Overall performance of the two systems was compared. Subsequently a number of models were developed for relating performance on the system and also on various query parameters such as the number of attributes in SELECT and WHERE clause, number of joins, number of processing rows etc.
1 June 2018 in Review of Economic and Business Studies
The most prominent Big Data solutions – such as NoSQL systems, Hadoop Frameworks, Spark, etc. – have been open-sourced. Nevertheless, commercial providers have targeted niches of this huge market with products more or less viable and affordable. This paper addresses the problem of benchmarking Big Data platforms with a focus on Oracle Exadata solution provided by one the most important data technologies vendor. Many classical benchmark approaches, such as TPC-H, are based on a predefined set of queries, and consequently they are not prone to predictive modeling. By contrast, for the TPC-H benchmark schema, we generate a set of 500 random queries containing not only tuple filters (WHERE), but also tuple grouping (GROUP BY) and group filters (HAVING), we collected results of the queries execution on four Oracle Exadata settings. Query duration was the outcome variable. Various query parameters, such as the number of joins, the number of attributes of different types within SELECT and WHERE clauses, and also some environment metrics served as predictors. Results were interpreted using exploratory data analysis and also Multivariate Adaptive Regression Splines (MARS) for both predicting the performance and explaining the main drivers of the system performance.
This paper presents the design and implementation of a blockchain-secured system for monitoring driver sobriety and real-time geolocation. The proposed platform integrates a Modular Sensor Battery (MSB) for detecting alcohol concentration in exhaled air, a centralized Data Collection Platform (DC Platform) for real-time data visualization and storage, and a complementary physiological monitoring device—the IoT Fit-Bit Smart Band (IFSB)—which captures heart rate and blood oxygen saturation as alternative indicators when breath-based sensing may be compromised. The MSB, the DC Platform, integration with the IoT FitBit Smart Band, and the blockchain-based data management architecture represent the authors’ direct contribution to both the conceptual design and technical implementation. These elements are introduced as part of a unified, fully integrated system designed to enable non-invasive sobriety monitoring and secure data integrity in vehicular contexts. To ensure data authenticity, a custom Ethereum smart contract stores cryptographic hashes of sensor readings, enabling decentralized, tamper-evident verification without exposing sensitive medical information. The system was validated in a controlled experimental environment, confirming its operational robustness and demonstrating its potential to improve road safety through secure, real-time sobriety detection and geolocation tracking.
Introduction: Forensic identification practice requires a multitude of methods for positive identification, among which the facial reconstruction occupies a high place. For this to be done in the best way possible, it is mandatory that each population have their own database regarding soft tissue thickness. Objective: The present research is focused on creating such a database for the Romanian adult population and on exploring the statistical distribution and correlation of craniometric landmarks, overall, and in groups defined according to sex and weight categories. This might provide support in estimating the values of missing landmarks or other variables (e.g., age, sex) for unidentified bodies. Methods: Twelve craniometric landmarks were measured on 100 cadavers less than 24 h after death. Results and discussions: Of the 12 anatomical landmarks, only one appears to manifest statistically significant differences between sexes, and seven landmarks appear to vary significantly among the weight categories. Additionally, some evidence of interpopulation differences in the average soft tissue thicknesses were observed by the comparison of these data with similar studies from Caucasian groups with different geographic origin. Additionally, correlations between facial landmarks were examined, overall and between sexes.