scholarly journals METHOD FOR DETECTING ANOMALIES OF SQL-SPECIFIC QUERY OF RELATIONAL DATABASES

2018 ◽  
Vol 22 (1) ◽  
pp. 53-61
Author(s):  
A. S. Markovskiy ◽  
N. I. Svekolkin

In the context of toughening of the requirements in the field of information security (the conditions of its safety) difficult-to-implement, the increasing number of external destabilizing factors (including the high level of false alarms), the increase of scopes and speed of information changes, and the drawbacks inherent to most databases, the probability of anomalies occurrence in the process of operation (acquisition, processing and storage) of relational databases is high. The article provides detailed description of the method for the construction a formal grammar executed by a SQL query of relational databases. This approach considers formal grammar under study from a mathematical point of view, as a model that defines a set of discrete objects in the form of description of the original objects and the rules for constructing new objects from the original and already created ones. Thus, a system of rules for further work is formed, represented in the form of a system of equations. The described method makes it possible to determine mathematical properties of the similarity invariants of the SQL query of relational databases intended for the collection, storage and analysis of statistical data, such as reference data of the operation of software and hardware, various statistical data about population, .production etc. The results of the testing of the demonstration prototype of the anomaly detection system, implemented on the basis of the proposed method, obtained in the course of the experimental implementation are presented in comparison with some existing and applied security systems. The solution proposed in the article is effective, simple and universal for the majority of currently used relational databases, In addition, it has a low cost of financial expenses in case of practical implementation.

Sensors ◽  
2021 ◽  
Vol 21 (6) ◽  
pp. 2254
Author(s):  
Francisco Javier González-Cañete ◽  
Eduardo Casilari

Over the last few years, the use of smartwatches in automatic Fall Detection Systems (FDSs) has aroused great interest in the research of new wearable telemonitoring systems for the elderly. In contrast with other approaches to the problem of fall detection, smartwatch-based FDSs can benefit from the widespread acceptance, ergonomics, low cost, networking interfaces, and sensors that these devices provide. However, the scientific literature has shown that, due to the freedom of movement of the arms, the wrist is usually not the most appropriate position to unambiguously characterize the dynamics of the human body during falls, as many conventional activities of daily living that involve a vigorous motion of the hands may be easily misinterpreted as falls. As also stated by the literature, sensor-fusion and multi-point measurements are required to define a robust and reliable method for a wearable FDS. Thus, to avoid false alarms, it may be necessary to combine the analysis of the signals captured by the smartwatch with those collected by some other low-power sensor placed at a point closer to the body’s center of gravity (e.g., on the waist). Under this architecture of Body Area Network (BAN), these external sensing nodes must be wirelessly connected to the smartwatch to transmit their measurements. Nonetheless, the deployment of this networking solution, in which the smartwatch is in charge of processing the sensed data and generating the alarm in case of detecting a fall, may severely impact on the performance of the wearable. Unlike many other works (which often neglect the operational aspects of real fall detectors), this paper analyzes the actual feasibility of putting into effect a BAN intended for fall detection on present commercial smartwatches. In particular, the study is focused on evaluating the reduction of the battery life may cause in the watch that works as the core of the BAN. To this end, we thoroughly assess the energy drain in a prototype of an FDS consisting of a smartwatch and several external Bluetooth-enabled sensing units. In order to identify those scenarios in which the use of the smartwatch could be viable from a practical point of view, the testbed is studied with diverse commercial devices and under different configurations of those elements that may significantly hamper the battery lifetime.


Author(s):  
Houache Noureddine ◽  
Kechar Bouabdellah

Forest fire disasters have arisen each year due to a number of factors. The main interest of the authorities is to fight against these fires as early as possible with a minimum of damage, by exploiting recent technologies suitable for this field. In this paper, we present the design and the implementation of a forest fire detection system based on the Wireless Multimedia Sensor Networks (WMSN) technology applied to our region (M'sila forest, Oran city - Algeria) using a field experiment testbed with low cost hardware and software. In our previous study, the designed system detects the fire using a mono modal approach (the sensed data was scalar in nature such as the temperature and humidity). In this work, we enhanced this system by collecting, in addition, richer information sources using cameras as data sources (by capturing images) to eliminate the false alarms which present the main weakness of the first system. We call this new system as Multimedia Forest Fire System (M2FS). Field experiments that we have carried out using the testbed under different scenarios by evaluating the image compression, time constraint and energy consumption, allowed us to validate our chosen technology (Arduino mote) for any application (scalar or multimedia), and also revealed the supremacy of the multimodal approach to mitigate efficiently false alarms.


Author(s):  
M. V. Smirnov ◽  
V. M. Polenok

The article actualizes the need to develop software for modeling relational databases for use in the process of teaching students of technical specialties in disciplines related to databases.The problem is considered from the point of view of assessing modern software used in the process of teaching students database design skills. Based on the shortcomings identified during the software review, a number of requirements for the actual software were determined. Formed key requirements are mobility, accessibility, versatility and openness of the development platform.The article describes the process of solving key problems that arose during the implementation of a project to develop a web application for modeling relational databases in accordance with the generated requirements. The practical implementation of the following functions is sequentially considered: creation of a logical relational data model, creation of a physical data model, direct engineering into relational database software. The main technological solutions used in the development of a web application to ensure the qualities specified in the condition are described.The result of the work is the successful testing of the development results in the process of creating a real web application, both within the framework of laboratory and practical work in the disciplines “Design and administration of databases” and “Data management”, and at the stage of writing graduate works for technical directions of training.


Author(s):  
Zhaoqing Wang ◽  
Bo Chen ◽  
Harry H. Cheng ◽  
Ben Shaw ◽  
Joe Palen

We have developed a laser photodiode array based detection system that can non-intrusively detect delineations of vehicles on the highway. A patent for this detection system has been recently approved by the U.S. Patent Office. The system is built with low-cost off-the-shelf opto-mechanical components. The error sources from a system design point of view will be analyzed in this paper. Our study indicates that the frequency of pulsed laser diodes, computer sampling rates, deviations in the angle of laser light and imperfectly matched detection points for sensor pairs are the main sources of error in the detection system.


2003 ◽  
Vol 125 (4) ◽  
pp. 802-808 ◽  
Author(s):  
Zhaoqing Wang ◽  
Bo Chen ◽  
Harry H. Cheng ◽  
Ben Shaw ◽  
Joe Palen

We have developed a laser photodiode array based detection system that can non-intrusively detect delineations of vehicles on the highway. The U.S. Patent Office has recently approved a patent for this detection system. The system is built with low-cost off-the-shelf opto-mechanical components. The error sources from a system design point of view will be analyzed in this paper. Our study indicates that the frequency of pulsed laser diodes, computer-sampling rates, deviations in the angle of laser light and imperfectly matched detection points for sensor pairs are the main sources of error in the detection system.


TEM Journal ◽  
2021 ◽  
pp. 954-960
Author(s):  
Irfan Syamsuddin ◽  
Anton Satria Prabuwono ◽  
Ahmad Hoirul Basori ◽  
Arda Yunianta

It is imperative for government to constantly improve e-government services through innovative technologies in order to cope with tremendous demands coming from citizen side. Although it is realized that e-services to citizens have to be improved and enriched, the realization is not an easy effort since additional budget allocation is usually considered as a hard decision from economic point of view. Cloud computing offers a sound answer to the issue by offering low cost of infrastructure spending, simplifies e-government development and on demand solution to any requirement from user. Practical implementation of OwnCloud for private data center is discussed. Then, the paper briefly reviews several features of OwnCloud that have been modified according to the need of local government and put required assessment on how to implement them appropriately.


1976 ◽  
Vol 15 (01) ◽  
pp. 36-42 ◽  
Author(s):  
J. Schlörer

From a statistical data bank containing only anonymous records, the records sometimes may be identified and then retrieved, as personal records, by on line dialogue. The risk mainly applies to statistical data sets representing populations, or samples with a high ratio n/N. On the other hand, access controls are unsatisfactory as a general means of protection for statistical data banks, which should be open to large user communities. A threat monitoring scheme is proposed, which will largely block the techniques for retrieval of complete records. If combined with additional measures (e.g., slight modifications of output), it may be expected to render, from a cost-benefit point of view, intrusion attempts by dialogue valueless, if not absolutely impossible. The bona fide user has to pay by some loss of information, but considerable flexibility in evaluation is retained. The proposal of controlled classification included in the scheme may also be useful for off line dialogue systems.


2021 ◽  
Vol 4 (1) ◽  
Author(s):  
Yehe Liu ◽  
Andrew M. Rollins ◽  
Richard M. Levenson ◽  
Farzad Fereidouni ◽  
Michael W. Jenkins

AbstractSmartphone microscopes can be useful tools for a broad range of imaging applications. This manuscript demonstrates the first practical implementation of Microscopy with Ultraviolet Surface Excitation (MUSE) in a compact smartphone microscope called Pocket MUSE, resulting in a remarkably effective design. Fabricated with parts from consumer electronics that are readily available at low cost, the small optical module attaches directly over the rear lens in a smartphone. It enables high-quality multichannel fluorescence microscopy with submicron resolution over a 10× equivalent field of view. In addition to the novel optical configuration, Pocket MUSE is compatible with a series of simple, portable, and user-friendly sample preparation strategies that can be directly implemented for various microscopy applications for point-of-care diagnostics, at-home health monitoring, plant biology, STEM education, environmental studies, etc.


Actuators ◽  
2021 ◽  
Vol 10 (3) ◽  
pp. 58
Author(s):  
Andraž Bradeško ◽  
Lovro Fulanović ◽  
Marko Vrabelj ◽  
Aleksander Matavž ◽  
Mojca Otoničar ◽  
...  

Despite the challenges of practical implementation, electrocaloric (EC) cooling remains a promising technology because of its good scalability and high efficiency. Here, we investigate the feasibility of an EC cooling device that couples the EC and electromechanical (EM) responses of a highly functionally, efficient, lead magnesium niobate ceramic material. We fabricated multifunctional cantilevers from this material and characterized their electrical, EM and EC properties. Two active cantilevers were stacked in a cascade structure, forming a proof-of-concept device, which was then analyzed in detail. The cooling effect was lower than the EC effect of the material itself, mainly due to the poor solid-to-solid heat transfer. However, we show that the use of ethylene glycol in the thermal contact area can significantly reduce the contact resistance, thereby improving the heat transfer. Although this solution is most likely impractical from the design point of view, the results clearly show that in this and similar cooling devices, a non-destructive, surface-modification method, with the same effectiveness as that of ethylene glycol, will have to be developed to reduce the thermal contact resistance. We hope this study will motivate the further development of multifunctional cooling devices.


Sign in / Sign up

Export Citation Format

Share Document