Maintaining Database Integrity Using Data Macros In Microsoft Access

The introduction of Data Macros in Microsoft Access 2010 addresses a major shortcoming of Access in enforcing business rules associated with a database application. Specifically, data macros remove the onerous “coordination” across data entry/update forms touching a base table in order to enforce semantic integrity constraints. More importantly, similar to triggers in SQL, Access data macros allow users to update tables by direct datasheet edits or explicit SQL update while enforcing that any update violating an integrity constraint is rejected. This paper categorizes semantic integrity constraints and presents the approach to implement each of the five categories in Microsoft Access using data macros

An automatic calibration procedure of driving behaviour parameters in the presence of high bus volume

Most of the microscopic traffic simulation programs used today incorporate car-following and lane-change models to simulate driving behaviour across a given area. The main goal of this study has been to develop an automatic calibration process for the parameters of driving behaviour models using metaheuristic algorithms. Genetic Algorithm (GA), Particle Swarm Optimization (PSO), and a combination of GA and PSO (i.e. hybrid GAPSO and hybrid PSOGA) were used during the optimization stage. In order to verify our proposed methodology, a suitable study area with high bus volume on-ramp from the 0-1 Highway in Istanbul has been modelled in VISSIM. Traffic data have been gathered through detectors. The calibration procedure has been coded using MATLAB and implemented via the VISSIM-MATLAB COM interface. Using the proposed methodology, the results of the calibrated model showed that hybrid GAPSO and hybrid PSOGA techniques outperformed the GA-only and PSO-only techniques during the calibration process. Thus, both are recommended for use in the calibration of microsimulation traffic models, rather than GA-only and PSO-only techniques.This study is a part of Ph.D. thesis of the corresponding author from the Istanbul Technical University, Turkey. We would like to thank Prof. Dr. Toma? Maher and Assist. Dr. Rok Marseti? from the Traffic Technical Institute of Civil and Geodetic Engineering Faculty, University of Ljubljana, Slovenia, for their kind support, valuable comments, and helpful suggestions. The authors are also thankful to the PTV-AG Karlsruhe Company for their support in providing a thesis-based unlimited version of VISSIM softwarePublisher's Versio

Understanding User Intent Modeling for Conversational Recommender Systems: A Systematic Literature Review

Context: User intent modeling is a crucial process in Natural Language Processing that aims to identify the underlying purpose behind a user's request, enabling personalized responses. With a vast array of approaches introduced in the literature (over 13,000 papers in the last decade), understanding the related concepts and commonly used models in AI-based systems is essential. Method: We conducted a systematic literature review to gather data on models typically employed in designing conversational recommender systems. From the collected data, we developed a decision model to assist researchers in selecting the most suitable models for their systems. Additionally, we performed two case studies to evaluate the effectiveness of our proposed decision model. Results: Our study analyzed 59 distinct models and identified 74 commonly used features. We provided insights into potential model combinations, trends in model selection, quality concerns, evaluation measures, and frequently used datasets for training and evaluating these models. Contribution: Our study contributes practical insights and a comprehensive understanding of user intent modeling, empowering the development of more effective and personalized conversational recommender systems. With the Conversational Recommender System, researchers can perform a more systematic and efficient assessment of fitting intent modeling frameworks

Erratum – Carrier Status for p.Gly61Glu and p.Arg368His CYP1B1 Mutations Causing Primary Congenital Glaucoma in Iran

This is an Erratum to "Carrier Status for p.Gly61Glu and p.Arg368His CYP1B1 Mutations Causing Primary Congenital Glaucoma in Iran" [J Ophthalmic Vis Res 2021;16(4):574–581] and does not have an abstract. Please download the PDF or view the article HTML

Carrier Status for p.Gly61Glu and p.Arg368His CYP1B1 Mutations Causing Primary Congenital Glaucoma in Iran

Purpose: To estimate carrier frequencies of CYP1B1 mutations p.Gly61Glu and p.Arg368His, respectively, in Talesh and the east of Guilan province in Iran with a maximum error of 2%. Previously, it was shown that these CYP1B1 mutations may be relatively prevalent in these regions. Methods: Population-based screenings were performed. DNA was extracted from saliva samples of 1036 individuals from Talesh and 3029 individuals from the east of Guilan. P.Gly61Glu and p.Arg368His screenings were performed, respectively, by RFLP and ARMS-based PCR protocols. For confirmation, the DNA of individuals with mutations was sequenced using the Sanger protocol. Results: Nine individuals from Talesh (0.86%; 95%CI: 0.45–1.64%) carried the p.Gly61Glu mutation, and 73 from the east of Guilan (2.41%; 95%CI: 1.91–3.04%) carried p.Arg368His. There was no significant difference in frequencies between urban and rural regions of the various cities, nor among four cities within the east of Guilan. Conclusion: The frequencies of p.Gly61Glu carriers in Talesh and of p.Arg368His carriers in the east of Guilan were within the 95% confidence interval of a previous study based on screenings of fewer individuals. The reliability of the recent estimates is higher, as the confidence interval for p.Gly61Glu decreased from 6.5% to 1.19% and the interval for p.Arg368His decreased from 4% to 1.13%. Based on the new findings, the maximum expected frequency of p.Gly61Glu carriers in Talesh is 1.64%, and of p.Arg368His carriers in the east of Guilan is 3%. The need for performing premarital screenings in the respective cities can be evaluated

Improving the calibration time of traffic simulation models using parallel computing technique

The calibration procedure for traffic simulation models can be a very time-consuming process in the case of a large-scale and complex network. In the application of Evolutionary Algorithms (EA) such as Genetic Algorithms (GA) and Particle Swarm Optimization (PSO) for calibration of traffic simulation models, objective function evaluation is the most time-consuming step in such calibration problems, because EA has to run a traffic simulation and calculate its corresponding objective function value once for each set of parameters. The main contribution of this study has been to develop a quick calibration procedure for the parameters of driving behavior models using EA and parallel computing techniques (PCTs). The proposed method was coded and implemented in a microscopic traffic simulation software. Two scenarios with/without PCT were analyzed using the developed methodology. The results of scenario analysis show that using an integrated calibration and PCT can reduce the total computational time of the optimization process significantly-in our experiments by 50%-and improve the optimization algorithm's performance in a complex optimization problem. The proposed method is useful for overcoming the limitation of computational time of the existing calibration methods and can be applied to various EAs and traffic simulation software.Publisher's Versio

A Wide-Angle Scanning Sub-Terahertz Leaky-Wave Antenna Based on a Multilayer Dielectric Image Waveguide

This paper presents a new layered dielectric leaky-wave antenna (LWA) for the sub-terahertz (THz) frequency range capable of efficient operation at the broadside with a wide beam scanning angle and stable gain. It consists of a conductor-backed alumina dielectric image line (DIL) with two different dielectric layers mounted on top of each other for performance improvement. The upper layer is a high permittivity RO6010 substrate to enhance the directivity as a superstrate and the lower layer is a low-permittivity RT/duroid 5880 substrate stacked on the alumina DIL to prevent the probable excitation of higher-order modes in the DIL channel. A 15-element linear array of radiating overlapped discs is used to mitigate the open stop-band (OSB) problem, fed by the mentioned waveguide, was designed and simulated at frequencies around 170 GHz. The dominant mode of the layered dielectric waveguide is perturbed by the infinite space harmonics generated by two sets of overlapped discs periodically sandwiched between the layers. It exhibited a relatively wide impedance bandwidth of 28.19% (157.5–206 GHz). Its radiation mechanism has been widely studied through simulations. The results revealed that the antenna provides a wide scanning capability through the broadside from −23° to 38°, covering the frequency range between 157.5 GHz and 201.5 GHz. For an array with 15 radiating elements, the simulated peak gain in the band is 15 dBi and the broadside gain is 13.6 dBi at 172 GHz

Design and Analysis of a Piezoelectric-Based AC Current Measuring Sensor

Electrical current measurement is a suitable method for the performance determination of electrical devices. There are two contact and noncontact methods in this measuring process. Contact method has some disadvantages like having direct connection with wire which may endamage the system. Thus, in this paper, a bimorph piezoelectric cantilever beam which has a permanent magnet on its free end is used to measure electrical current in a noncontact way. In mathematical modeling, based on Galerkin method, the governing equation of the cantilever beam is solved, and the equation presenting the relation between applied force and beam’s output voltage is presented. Magnetic force resulting from current carrying wire is considered as the external excitation force of the system. The results are compared with other references in order to demonstrate the accuracy of the mathematical model. Finally, the effects of geometric parameters on the output voltage and natural frequency are presented

A 16 Month Survey of Cyclosporine Utilization Evaluation in Allogeneic Hematopoietic Stem Cell Transplant Recipients

Abstract Objectives: Graft versus host disease (GVHD) is a life threatening reaction in the stem cell transplantation process. Nowadays Cyclosporine is the most commonly utilized agent for GVHD prophylaxis and it has a major role in successful transplantation. Cyclosporine has been applied for many years in this field but it could be stated that currently no general consensus is available for its optimal method of administration. Conditions related to cyclosporine administration and possible related adverse reactions observed closely in our patients with the aim of constructing a comprehensive practice guideline in the future. Patients and Methods: Allogeneic stem cell transplant recipients who have been taking cyclosporine were monitored during and after their hospitalization while recording all observations on predefined questionnaires on the basis of periodic clinical and laboratory examinations for a 16 month period. Results: Mean recorded duration of infusions was 1.44 ± 0.68 h and by twice daily administration, means intravenous and oral dose was 101.85 ± 22.03 mg and 219.28 ± 63.9 mg, respectively. A mean CsA trough level after about 12 h of specified unique doses was 223 ± 65 ng/mL. We found hypertension, nephrotoxicity, neurotoxicity, hypertension, and dyslipidemia in about 14, 20, 48, and 94 percent of patients. Conclusions: This study proposed that permanent guidance of healthcare team according to a fixed and standard method of cyclosporine administration routine with using efficient facilities and protocols would be helpful considerably for an optimal pharmacotherapy