Extending Middleware Protocols for Database Replication with Integrity Support

Current middleware database replication protocols take care of read-write conflict evaluation. If there are no such conflicts, protocols sanction transactions to commit. Other conflicts may arise due to integrity violation. So, if, in addition to the consistency of transactions and replicas, also the consistency of integrity constraints is to be supported, some more care must be taken. Some classes of replication protocols are able to seamlessly deal with the integrity support of the underlying DBMS, but others are not. In this paper, we analyze the support for integrity that can be provided in various classes of replication protocols. Also, we propose extensions for those that cannot directly manage certain kinds of constraints that are usually supported in DBMSs

The utility of Next Generation Sequencing for molecular diagnostics in Rett syndrome

Rett syndrome (RTT) is an early-onset neurodevelopmental disorder that almost exclusively affects girls and is totally disabling. Three genes have been identified that cause RTT: MECP2, CDKL5 and FOXG1. However, the etiology of some of RTT patients still remains unknown. Recently, next generation sequencing (NGS) has promoted genetic diagnoses because of the quickness and affordability of the method. To evaluate the usefulness of NGS in genetic diagnosis, we present the genetic study of RTT-like patients using different techniques based on this technology. We studied 1577 patients with RTT-like clinical diagnoses and reviewed patients who were previously studied and thought to have RTT genes by Sanger sequencing. Genetically, 477 of 1577 patients with a RTT-like suspicion have been diagnosed. Positive results were found in 30% by Sanger sequencing, 23% with a custom panel, 24% with a commercial panel and 32% with whole exome sequencing. A genetic study using NGS allows the study of a larger number of genes associated with RTT-like symptoms simultaneously, providing genetic study of a wider group of patients as well as significantly reducing the response time and cost of the study

Genotype-first approach to identify associations between CDH1 germline variants and cancer phenotypes: a multicentre study by the European Reference Network on Genetic Tumour Risk Syndromes.

BACKGROUND: Truncating pathogenic or likely pathogenic variants of CDH1 cause hereditary diffuse gastric cancer (HDGC), a tumour risk syndrome that predisposes carrier individuals to diffuse gastric and lobular breast cancer. Rare CDH1 missense variants are often classified as variants of unknown significance. We conducted a genotype-phenotype analysis in families carrying rare CDH1 variants, comparing cancer spectrum in carriers of pathogenic or likely pathogenic variants (PV/LPV; analysed jointly) or missense variants of unknown significance, assessing the frequency of families with lobular breast cancer among PV/LPV carrier families, and testing the performance of lobular breast cancer-expanded criteria for CDH1 testing. METHODS: This genotype-first study used retrospective diagnostic and clinical data from 854 carriers of 398 rare CDH1 variants and 1021 relatives, irrespective of HDGC clinical criteria, from 29 institutions in ten member-countries of the European Reference Network on Tumour Risk Syndromes (ERN GENTURIS). Data were collected from Oct 1, 2018, to Sept 20, 2022. Variants were classified by molecular type and clinical actionability with the American College of Medical Genetics and Association for Molecular Pathology CDH1 guidelines (version 2). Families were categorised by whether they fulfilled the 2015 and 2020 HDGC clinical criteria. Genotype-phenotype associations were analysed by Student's t test, Kruskal-Wallis, χ(2), and multivariable logistic regression models. Performance of HDGC clinical criteria sets were assessed with an equivalence test and Youden index, and the areas under the receiver operating characteristic curves were compared by Z test. FINDINGS: From 1971 phenotypes (contributed by 854 probands and 1021 relatives aged 1-93 years), 460 had gastric and breast cancer histology available. CDH1 truncating PV/LPVs occurred in 176 (21%) of 854 families and missense variants of unknown significance in 169 (20%) families. Multivariable logistic regression comparing phenotypes occurring in families carrying PV/LPVs or missense variants of unknown significance showed that lobular breast cancer had the greatest positive association with the presence of PV/LPVs (odds ratio 12·39 [95% CI 2·66-57·74], p=0·0014), followed by diffuse gastric cancer (8·00 [2·18-29·39], p=0·0017) and gastric cancer (7·81 [2·03-29·96], p=0·0027). 136 (77%) of 176 families carrying PV/LPVs fulfilled the 2015 HDGC criteria. Of the remaining 40 (23%) families, who did not fulfil the 2015 criteria, 11 fulfilled the 2020 HDGC criteria, and 18 had lobular breast cancer only or lobular breast cancer and gastric cancer, but did not meet the 2020 criteria. No specific CDH1 variant was found to predispose individuals specifically to lobular breast cancer, although 12 (7%) of 176 PV/LPV carrier families had lobular breast cancer only. Addition of three new lobular breast cancer-centred criteria improved testing sensitivity while retaining high specificity. The probability of finding CDH1 PV/LPVs in patients fulfilling the lobular breast cancer-expanded criteria, compared with the 2020 criteria, increased significantly (AUC 0·92 vs 0·88; Z score 3·54; p=0·0004). INTERPRETATION: CDH1 PV/LPVs were positively associated with HDGC-related phenotypes (lobular breast cancer, diffuse gastric cancer, and gastric cancer), and no evidence for a positive association with these phenotypes was found for CDH1 missense variants of unknown significance. CDH1 PV/LPVs occurred often in families with lobular breast cancer who did not fulfil the 2020 HDGC criteria, supporting the expansion of lobular breast cancer-centred criteria. FUNDING: European Reference Network on Genetic Tumour Risk Syndromes, European Regional Development Fund, Fundação para a Ciência e a Tecnologia (Portugal), Cancer Research UK, and European Union's Horizon 2020 research and innovation programme