Applying HTM to an OLTP System: No Free Lunch

Transactional memory is a promising way for implementing efficient synchronization mechanisms for multicore processors. Intel's introduction of hardware transactional memory (HTM) into their Haswell line of processors marks an important step toward mainstream availability of transactional memory. Transaction processing systems require execution of dozens of critical sections to insure isolation among threads, which makes them one of the target applications for exploiting HTM. In this study, we quantify the opportunities and limitations of directly applying HTM to an existing OLTP system that uses fine-grained synchronization. Our target is Shore-MT, a modern multithreaded transactional storage manager that uses a variety of fine-grained synchronization mechanisms to provide scalability on multicore processors. We find that HTM can improve performance of the TATP workload by 13-17% when applied judiciously. However, attempting to replace all synchronization reduces performance compared to the baseline case due to high percentage of aborts caused by the limitations of the current HTM implementation. Copyright 2015 ACM

Characterization of the Impact of Hardware Islands on OLTP

Modern hardware is abundantly parallel and increasingly heterogeneous. The numerous processing cores have non-uniform access latencies to the main memory and processor caches, which causes variability in the communication costs. Unfortunately, database systems mostly assume that all processing cores are the same and that microarchitecture differences are not significant enough to appear in critical database execution paths. As we demonstrate in this paper, however, non-uniform core topology does appear in the critical path and conventional database architectures achieve suboptimal and even worse, unpredictable performance. We perform a detailed performance analysis of OLTP deployments in servers with multiple cores per CPU (multicore) and multiple CPUs per server (multisocket). We compare different database deployment strategies where we vary the number and size of independent database instances running on a single server, from a single shared-everything instance to fine-grained shared-nothing configurations. We quantify the impact of non-uniform hardware on various deployments by (a) examining how efficiently each deployment uses the available hardware resources and (b) measuring the impact of distributed transactions and skewed requests on different workloads. We show that no strategy is optimal for all cases and that the best choice depends on the combination of hardware topology and workload characteristics. Finally, we argue that transaction processing systems must be aware of the hardware topology in order to achieve predictably high performance

Push and Pull Factors of Why Medical Students Want to Leave Türkiye: A Countrywide Multicenter Study

Phenomenon: Physician immigration from other countries is increasing as developed countries continue to be desirable destinations for physicians; however, the determinants of Turkish physicians’ migration decisions are still unclear. Despite its wide coverage in the media and among physicians in Türkiye, and being the subject of much debate, there is insufficient data to justify this attention. With this study, we aimed to investigate the tendency of senior medical students in Türkiye to pursue their professional careers abroad and its related factors. Approach: This cross-sectional study involved 9881 senior medical students from 39 different medical schools in Türkiye in 2022. Besides participants’ migration decision, we evaluated the push and pull factors related to working, social environment and lifestyle in Türkiye and abroad, medical school education inadequacy, and personal insufficiencies, as well as the socioeconomic variables that may affect the decision to migrate abroad. The analyses were carried out with a participation rate of at least 50%. Findings: Of the medical students, 70.7% had emigration intentions. Approximately 60% of those want to stay abroad permanently, and 61.5% of them took initiatives such as learning a foreign language abroad (54.5%) and taking relevant exams (18.9%). Those who wanted to work in the field of Research & Development were 1.37 (95% CI: 1.22–1.54) times more likely to emigrate. The push factor that was related to emigration intention was the “working conditions in the country” (OR: 1.89, 95% CI: 1.56–2.28) whereas the “social environment/lifestyle abroad” was the mere pull factor for the tendency of emigration (OR: 1.73, 95% CI: 1.45–2.06). In addition, the quality problem in medical schools also had a significant impact on students’ decisions (OR: 2.20, 95% CI: 1.83–2.65). Insights: Although the percentage of those who want to emigrate “definitely” was at the same level as in the other developing countries, the tendency to migrate “permanently” was higher in Türkiye. Improving working conditions in the country and increasing the quality of medical faculties seem vital in preventing the migration of physicians