(E)-N′-[4-(Dimethyl­amino)­benzyl­idene]-4-methyl­benzohydrazide methanol monosolvate

In the title compound, C17H19N3O·CH3OH, the hydrazone mol­ecule exists in a trans geometry with respect to the methyl­idene unit and the dihedral angle between the two substituted benzene rings is 42.6 (2)°. In the crystal, the components are linked through N—H⋯O and O—H⋯O hydrogen bonds, forming [100] chains of alternating hydrazone and methanol mol­ecules

A Method for Automatically Generating Join Queries Based on Relations-Attributes Distance Matrix over Data Lakes

Techniques for identifying joinable or unionable tables in data lakes can yield valuable information for data scientists. However, more than half of their working time is spent familiarizing themselves with the metadata and correlations of datasets. Simplifying the use of information in data lakes is crucial for enhancing their utilization. The existing solution of integrating correlated relations into a single large data table via full disjunction requires integration updating when either data or metadata changes, complicating data maintenance. This paper proposes a method for automatically generating join queries based on the distance matrix of relations and attributes in data lakes. The distance matrix only requires updating when metadata changes, simplifying data maintenance. Experimental results demonstrate that once the distance matrix is generated, the time required to generate the join queries is negligible. Compared to the existing solution, the time cost for executing join queries over correlated tables is nearly identical to that of selection queries over integrated tables. The results of these two queries are also the same, showcasing the effectiveness and efficiency of our method

Query with Assumptions for Probabilistic Relational Databases

Users may have prior knowledge about a probabilistic database. They prefer to query over a probabilistic database on their prior knowledge which cannot be written as component clauses of conventional SQL queries. A naive approach is to query over a new database version, which is generated by transforming the original probabilistic database to satisfy users\u27 prior knowledge; however, it is impractical to generate a different probabilistic database version for each prior knowledge. In this paper, we propose the concept of the query with assumptions which allow users to describe their prior knowledge with a newly introduced ASSUMPTION clause of SQL. We also propose an approach to obtain the result of a query based on assumption clauses. The experimental studies show our approach has better performance compared to the naive approach

Enabling Access Control for Encrypted Multi-Dimensional Data in Cloud Computing through Range Search

With the growing popularity of cloud computing, data owners are increasingly opting to outsource their data to cloud servers due to the numerous benefits it offers. However, this outsourcing raises concerns about data privacy since the data stored on remote cloud servers is not directly controlled by the owners. Encryption of the data is an effective approach to mitigate these privacy concerns. However, encrypted data lacks distinguishability, leading to limitations in supporting common operations such as range search and access control. In this research paper, we propose a method called RSAC (Range Search Supporting Access Control) for encrypted multi-dimensional data in cloud computing. Our method leverages policy design, bucket embedding, algorithm design, and Ciphertext Policy-Attribute Based Encryption (CPABE) to achieve its objectives. We present extensive experimental results that demonstrate the efficiency of our method and conduct a thorough security analysis to ensure its robustness. Our proposed RSAC method addresses the challenges of range search and access control over encrypted multi-dimensional data, thus contributing to enhancing privacy and security in cloud computing environments

An Efficient Top-k Query Scheme Based on Multilayer Grouping

The top-k query is to find the k data that has the highest scores from a candidate dataset. Sorting is a common method to find out top-k results. However, most of existing methods are not efficient enough. To remove this issue, we propose an efficient top-k query scheme based on multilayer grouping. First, we find the reference item by computing the average score of the candidate dataset. Second, we group the candidate dataset into three datasets: winner set, middle set and loser set based on the reference item. Third, we further group the winner set to the second-layer three datasets according to k value. And so on, until the data number of winner set is close to k value. Meanwhile, if k value is larger than the data number of winner set, we directly return the winner set to the user as a part of top-k results almost without sorting. In this case, we also return the top results with the highest scores from the middle set almost without sorting. Based on above innovations, we almost minimize the sorting. Experimental results show that our scheme significantly outperforms the current classical method on the performance of memory consumption and top-k query

Efficient Q-Value Zero-Leakage Protection Scheme in SRS Regularly Publishing Private Data

Spontaneous Reporting System (SRS) has been widely established to collect adverse drug events. Thus, SRS promotes the detection and analysis of ADR (adverse drug reactions), such as the FDA Adverse Event Reporting System (FAERS). The SRS data needs to be provided to researchers. Meanwhile, the SRS data is publicly available to facilitate the study of ADR detection and analysis. In general, SRS data contains private information of some individual characteristics. Before the information is published, it is necessary to anonymize private information in the SRS data to prevent disclosure of individual privacy. There are many privacy protection methods. The most classic method for protecting SRS data is called as PPMS. However, in the real world, SRS data is growing dynamically and needs to be published regularly. In this case, PPMS has some shortcomings in the memory consumption, anonymity efficiency, data update and data security. To remove these shortcomings, we propose an Efficient Q-value Zero-leakage protection Scheme in SRS regularly publishing private data, called EQZS. EQZS can deal with almost all of potential attacks. Meanwhile, EQZS removes the shortcomings of PPMS. The experimental results show that our scheme EQZS solves the problem of privacy leakage in SRS regularly publishing private data. Meanwhile, EQZS significantly outperforms PPMS on the efficiency of memory consumption, privacy anonymity and data update

Intervention and Mechanism of Dexmedetomidine on A549 Cells Injured by Hypoxia/Reoxygenation

Objective: To investigate the effect and mechanism of dexmedetomidine (DEX) on hypoxia /reoxygenation (H/R) injury of A549 cells. Methods: A549 cells were cultured and randomly divided into four groups (n=10): Normoxic group;DEX group; H/R injury group;H/R injury+DEX intervention group. Observe the morphological changes of cells; Cell viability was detected by cck-8 assay. TUNEL assay was used to detect apoptosis index (AI).Expressions of GRP78, CHOP, JNK, caspase-12, caspase-3 proteins and mRNA were detected by Western Blot and RT-PCR;Detect the activity of caspase-3. Results: Compared with the H group, the OD value and AI value in the HD group were significantly up-regulated, apoptotic cells were significantly decreased, the expressions of CHOP, caspase-12, p-JNK and caspase-3 proteins and mRNA were significantly decreased, the GRP78 protein and mRNA increased, and the caspase-3 activity was significantly decreased, the differences were statistically significant (P<0.01). Conclusion: Dexmedetomidine has a protective effect on A549 cells after H/R injury, which may be related to its inhibition of apoptosis induced by excessive endoplasmic reticulm stress. Keywords: Dexmedetomidine; Hypoxia/Reoxygenationinjury;Apoptosis;Endoplasmicreticulm stress

Three-layer approximation of two-layer shallow water equations

Two-layer shallow water equations describe flows that consist of two layers of inviscid fluid of different (constant) densities flowing over bottom topography. Unlike the single-layer shallow water system, the two-layer one is only conditionally hyperbolic: the system loses its hyperbolicity because of the momentum exchange terms between the layers and as a result its solutions may develop instabilities. We study a three-layer approximation of the two-layer shallow water equations by introducing an intermediate layer of a small depth. We examine the hyperbolicity range of the three-layer model and demonstrate that while it still may lose hyperbolicity, the three-layer approximation may improve stability properties of the two-layer shallow water system

Power loss transition of stable ZnO varistor ceramics: Role of oxygen adsorption on the stability of interface states at the grain boundary

Highly stable ZnO varistor ceramics with steadily decreasing power loss have been put into applications in electrical and electronic systems for overvoltage protections, even with the absence of general understandings on their aging behaviors. In this paper, we investigated their aging nature via conducting comparative direct current (DC) aging experiments both in air and in nitrogen, during which variations of electrical properties and interface properties were measured and analyzed. Notably, continuously increasing power loss with severe electrical degradation was observed for the sample aged in nitrogen. The power loss transition was discovered to be closely related to the consumption of oxygen adsorption at the grain boundary (GB), which could, however, remain constant for the sample aged in air. The interface density of states (DOS) Ni, which is crucial for pinning the potential barrier, was proved to decrease in nitrogen, but keep stable in air. Therefore, it is concluded that the oxygen adsorption at the GB is significant for the stability of interface states, which further correlates to the long-term stability of modern stable ZnO varistor ceramics