基于最小权和模板匹配的Oracle线路优化

优化量子线路对于提高量子算法的计算效率和降低资源成本至关重要,特别是在布尔函数构建的Oracle线路中。该优化过程分为两个关键阶段,第一个阶段基于最小权匹配算法对Oracle线路相同受控点的MCT门进行重排序,最小化生成线路的门数;第二个阶段利用模板匹配的方式进一步降低线路的门数和代价。实验结果表明,相较于优化工具RCViewer^(+),在4~10位量子比特数下, Deutsch-Jozsa算法下的Oracle线路门数降低了约48.3%,代价减少了约64.5%;Grover算法下的Oracle线路门数降低了约25.0%,代价减少了约18.2%。

A dynamic database of solid-state electrolyte(DDSE)picturing all-solid-state batteries

All-solid-state batteries(ASSBs)are a class of safer and higher-energy-density materials compared to conventional devices,from which solid-state electrolytes(SSEs)are their essential components.To date,investigations to search for high ion-conducting solid-state electrolytes have attracted broad concern.However,obtaining SSEs with high ionic conductivity is challenging due to the complex structural information and the less-explored structure-performance relationship.To provide a solution to these challenges,developing a database containing typical SSEs from available experimental reports would be a new avenue to understand the structureperformance relationships and find out new design guidelines for reasonable SSEs.Herein,a dynamic experimental database containing>600 materials was developed in a wide range of temperatures(132.40–1261.60 K),including mono-and divalent cations(e.g.,Li^(+),Na^(+),K^(+),Ag^(+),Ca^(2+),Mg^(2+),and Zn^(2+))and various types of anions(e.g.,halide,hydride,sulfide,and oxide).Data-mining was conducted to explore the relationships among different variates(e.g.,transport ion,composition,activation energy,and conductivity).Overall,we expect that this database can provide essential guidelines for the design and development of high-performance SSEs in ASSB applications.This database is dynamically updated,which can be accessed via our open-source online system.

Oracle数据库触发器技术研究与应用

Oracle触发器是数据库表中一种特殊的存储过程,为了实现对数据库表中相关数据的安全性、一致性和数据完整性等进行操作而定义了触发器。触发器的执行过程是由特定事件触发的。设计了跳块触发器、自动增加流水号、批量数据的同步,经测试表明,触发器能够保证用户数据的同步,在用户对目标数据库指定数据库实现更新前,数据库系统将触发器自动启动,保证在数据表批量更新出现错误时,能够使数据恢复到正常的状态。

Discrimination of polysorbate 20 by high-performance liquid chromatography-charged aerosol detection and characterization for components by expanding compound database and library

Analyzing polysorbate 20(PS20)composition and the impact of each component on stability and safety is crucial due to formulation variations and individual tolerance.The similar structures and polarities of PS20 components make accurate separation,identification,and quantification challenging.In this work,a high-resolution quantitative method was developed using single-dimensional high-performance liquid chromatography(HPLC)with charged aerosol detection(CAD)to separate 18 key components with multiple esters.The separated components were characterized by ultra-high-performance liquid chromatography-quadrupole time-of-flight mass spectrometry(UHPLC-Q-TOF-MS)with an identical gradient as the HPLC-CAD analysis.The polysorbate compound database and library were expanded over 7-time compared to the commercial database.The method investigated differences in PS20 samples from various origins and grades for different dosage forms to evaluate the composition-process relationship.UHPLC-Q-TOF-MS identified 1329 to 1511 compounds in 4 batches of PS20 from different sources.The method observed the impact of 4 degradation conditions on peak components,identifying stable components and their tendencies to change.HPLC-CAD and UHPLC-Q-TOF-MS results provided insights into fingerprint differences,distinguishing quasi products.

Enhancing AI System Privacy:An Automatic Tool for Achieving GDPR Compliance in NoSQL Databases

The EU’s Artificial Intelligence Act(AI Act)imposes requirements for the privacy compliance of AI systems.AI systems must comply with privacy laws such as the GDPR when providing services.These laws provide users with the right to issue a Data Subject Access Request(DSAR).Responding to such requests requires database administrators to identify information related to an individual accurately.However,manual compliance poses significant challenges and is error-prone.Database administrators need to write queries through time-consuming labor.The demand for large amounts of data by AI systems has driven the development of NoSQL databases.Due to the flexible schema of NoSQL databases,identifying personal information becomes even more challenging.This paper develops an automated tool to identify personal information that can help organizations respond to DSAR.Our tool employs a combination of various technologies,including schema extraction of NoSQL databases and relationship identification from query logs.We describe the algorithm used by our tool,detailing how it discovers and extracts implicit relationships from NoSQL databases and generates relationship graphs to help developers accurately identify personal data.We evaluate our tool on three datasets,covering different database designs,achieving an F1 score of 0.77 to 1.Experimental results demonstrate that our tool successfully identifies information relevant to the data subject.Our tool reduces manual effort and simplifies GDPR compliance,showing practical application value in enhancing the privacy performance of NOSQL databases and AI systems.

Comprehensive analysis of advanced glycation end-products in commonly consumed foods:presenting a database for dietary AGEs and associated exposure assessment

Advanced glycation end-products(AGEs)are a group of heterogeneous compounds formed in heatprocessed foods and are proven to be detrimental to human health.Currently,there is no comprehensive database for AGEs in foods that covers the entire range of food categories,which limits the accurate risk assessment of dietary AGEs in human diseases.In this study,we first established an isotope dilution UHPLCQq Q-MS/MS-based method for simultaneous quantification of 10 major AGEs in foods.The contents of these AGEs were detected in 334 foods covering all main groups consumed in Western and Chinese populations.Nε-Carboxymethyllysine,methylglyoxal-derived hydroimidazolone isomers,and glyoxal-derived hydroimidazolone-1 are predominant AGEs found in most foodstuffs.Total amounts of AGEs were high in processed nuts,bakery products,and certain types of cereals and meats(>150 mg/kg),while low in dairy products,vegetables,fruits,and beverages(<40 mg/kg).Assessment of estimated daily intake implied that the contribution of food groups to daily AGE intake varied a lot under different eating patterns,and selection of high-AGE foods leads to up to a 2.7-fold higher intake of AGEs through daily meals.The presented AGE database allows accurate assessment of dietary exposure to these glycotoxins to explore their physiological impacts on human health.

Database Search Behaviors: Insight from a Survey of Information Retrieval Practices

This study examines the database search behaviors of individuals, focusing on gender differences and the impact of planning habits on information retrieval. Data were collected from a survey of 198 respondents, categorized by their discipline, schooling background, internet usage, and information retrieval preferences. Key findings indicate that females are more likely to plan their searches in advance and prefer structured methods of information retrieval, such as using library portals and leading university websites. Males, however, tend to use web search engines and self-archiving methods more frequently. This analysis provides valuable insights for educational institutions and libraries to optimize their resources and services based on user behavior patterns.

Oracle数据库安全及参数配置

Oracle数据库在部署和使用之前决定是否部署安全措施很重要,用户在实施与维护的过程中都需要提前考虑好是否采取安全措施和实施安全策略。基于安全部署的数据库,可以为后期使用和等保测评避免很多麻烦。除了在网络硬件设备和防火墙设备上采用安全措施以外,还可以在系统的防火墙上实施数据库的访问IP及端口的限制策略。其次在数据库安装完成后也需要考虑数据库的补丁升级和是否对数据库的用户和资源做限制策略。

Databases of 2D material-substrate interfaces and 2D charged building blocks

Discovery of materials using“bottom-up”or“top-down”approach is of great interest in materials science.Layered materials consisting of two-dimensional(2D)building blocks provide a good platform to explore new materials in this respect.In van der Waals(vdW)layered materials,these building blocks are charge neutral and can be isolated from their bulk phase(top-down),but usually grow on substrate.In ionic layered materials,they are charged and usually cannot exist independently but can serve as motifs to construct new materials(bottom-up).In this paper,we introduce our recently constructed databases for 2D material-substrate interface(2DMSI),and 2D charged building blocks.For 2DMSI database,we systematically build a workflow to predict appropriate substrates and their geometries at substrates,and construct the 2DMSI database.For the 2D charged building block database,1208 entries from bulk material database are identified.Information of crystal structure,valence state,source,dimension and so on is provided for each entry with a json format.We also show its application in designing and searching for new functional layered materials.The 2DMSI database,building block database,and designed layered materials are available in Science Data Bank at https://doi.org/10.57760/sciencedb.j00113.00188.

Oracle数据库向国产数据库迁移的技术分析

Oracle数据库向国产数据库迁移是实现信息化技术自主可控的重要举措之一,同时也是打破国外数据库厂商垄断壁垒,促进国内信息技术(Information Technology,IT)行业长足发展的重要前提。本文简要分析了Oracle数据库向国产数据库迁移的必要性及技术前提,并对具体的数据迁移策略及流程和方法等进行了深入探讨,包括迁移的准备、转换、校验等各阶段要素以及迁移后的系统性能调优工作等,希望能够为相关行业工作人员提供一定技术参考和依据。

基于Oracle数据库的数据安全监控系统设计

提出基于Oracle数据库的数据安全监控系统,并采用B/S架构模式设计数据安全监控系统的总体结构。在硬件结构上,设计了数据采集系统硬件结构框图,建立了可视化展示模块。该系统支持多样性展示方式,可根据用户需求进行自定义展示、数据交互以及数据实时更新。在软件结构上,构建Oracle数据库,结合数据库索引推荐算法进行数据库管理模块设计,基于客户端请求的调用流程实现服务器端程序模块设计,并通过识别异常数据来判断数据的安全风险,完成数据安全监控模块的设计。结果表明,所设计系统的数据安全监控结果F1分数值为0.968,其功能完善且性能良好。

业务型主站数据库从Oracle到MySQL数据架构迁移的设计

探讨了业务型主站数据库选型从Oracle到MySQL迁移的原因、数据架构设计思路、注意事项及具体实现方式。通过对Oracle和MySQL的对比分析,明确了MySQL作为业务型主站数据库的可行性。介绍了数据架构的设计思路、注意事项和具体实现方式,并通过实例分析验证了迁移的实践效果。

Time Complexity of the Oracle Phase in Grover’s Algorithm

Since Grover’s algorithm was first introduced, it has become a category of quantum algorithms that can be applied to many problems through the exploitation of quantum parallelism. The original application was the unstructured search problems with the time complexity of O(). In Grover’s algorithm, the key is Oracle and Amplitude Amplification. In this paper, our purpose is to show through examples that, in general, the time complexity of the Oracle Phase is O(N), not O(1). As a result, the time complexity of Grover’s algorithm is O(N), not O(). As a secondary purpose, we also attempt to restore the time complexity of Grover’s algorithm to its original form, O(), by introducing an O(1) parallel algorithm for unstructured search without repeated items, which will work for most cases. In the worst-case scenarios where the number of repeated items is O(N), the time complexity of the Oracle Phase is still O(N) even after additional preprocessing.

Application of Thermodynamic Database to Corrosion of ZrO_(2) Containing Submerged Entry Nozzle in Steel Continuous Casting Process

The CALPHAD thermodynamic databases are very useful to analyze the complex chemical reactions happening in high temperature material process.The FactSage thermodynamic database can be used to calculate complex phase diagrams and equilibrium phases involving refractories in industrial process.In this study,the FactSage thermodynamic database relevant to ZrO_(2)-based refractories was reviewed and the application of the database to understanding the corrosion of continuous casting nozzle refractories in steelmaking was presented.

MetaOracle:A High-Throughput Decentralized Oracle for Web 3.0-Empowered Metaverse

Recent rapid advancements in communication technology have brought forth the era of Web 3.0,representing a substantial transformation in the Internet landscape.This shift has led to the emergence of various decentralized metaverse applications that leverage blockchain as their underlying technology to enable users to exchange value directly from point to point.However,blockchains are blind to the real world,and smart contracts cannot directly access data from the external world.To address this limitation,the technology of oracles has been introduced to provide real-world data for smart contracts and other blockchain applications.In this paper,we focus on mitigating the risks associated with oracles providing corrupt or incorrect data.We propose a novel Web 3.0 architecture for the Metaverse based on the multiidentifier network(MIN),and its decentralized blockchain oracle model called Meta Oracle.The experimental results show that the proposed scheme can achieve minor time investment in return for significantly more reliable data and increased throughput.

Impact of index admission cholecystectomy vs interval cholecystectomy on readmission rate in acute cholangitis: National Readmission Database survey

BACKGROUND Elective cholecystectomy(CCY)is recommended for patients with gallstone-related acute cholangitis(AC)following endoscopic decompression to prevent recurrent biliary events.However,the optimal timing and implications of CCY remain unclear.AIM To examine the impact of same-admission CCY compared to interval CCY on patients with gallstone-related AC using the National Readmission Database(NRD).METHODS We queried the NRD to identify all gallstone-related AC hospitalizations in adult patients with and without the same admission CCY between 2016 and 2020.Our primary outcome was all-cause 30-d readmission rates,and secondary outcomes included in-hospital mortality,length of stay(LOS),and hospitalization cost.RESULTS Among the 124964 gallstone-related AC hospitalizations,only 14.67%underwent the same admission CCY.The all-cause 30-d readmissions in the same admission CCY group were almost half that of the non-CCY group(5.56%vs 11.50%).Patients in the same admission CCY group had a longer mean LOS and higher hospitalization costs attrib-utable to surgery.Although the most common reason for readmission was sepsis in both groups,the second most common reason was AC in the interval CCY group.CONCLUSION Our study suggests that patients with gallstone-related AC who do not undergo the same admission CCY have twice the risk of readmission compared to those who undergo CCY during the same admission.These readmis-sions can potentially be prevented by performing same-admission CCY in appropriate patients,which may reduce subsequent hospitalization costs secondary to readmissions.

Large Language Model Based Semantic Parsing for Intelligent Database Query Engine

With the rapid development of artificial intelligence, large language models (LLMs) have demonstrated remarkable capabilities in natural language understanding and generation. These models have great potential to enhance database query systems, enabling more intuitive and semantic query mechanisms. Our model leverages LLM’s deep learning architecture to interpret and process natural language queries and translate them into accurate database queries. The system integrates an LLM-powered semantic parser that translates user input into structured queries that can be understood by the database management system. First, the user query is pre-processed, the text is normalized, and the ambiguity is removed. This is followed by semantic parsing, where the LLM interprets the pre-processed text and identifies key entities and relationships. This is followed by query generation, which converts the parsed information into a structured query format and tailors it to the target database schema. Finally, there is query execution and feedback, where the resulting query is executed on the database and the results are returned to the user. The system also provides feedback mechanisms to improve and optimize future query interpretations. By using advanced LLMs for model implementation and fine-tuning on diverse datasets, the experimental results show that the proposed method significantly improves the accuracy and usability of database queries, making data retrieval easy for users without specialized knowledge.

基于Oracle数据库性能异常诊断模型探析

当前,数据库系统成为信息技术(information technology,IT)架构下的重要支撑环节,数据库系统的健康状态在整个IT业务系统的可用性指标中起到了决定性的作用。基于此背景,实现数据库服务异常点快速定位、提前识别当前数据库系统隐患的工作变得至关重要。构建数据库软件性能异常诊断与健康度检查模型的意义在于当数据库系统出现性能异常时,可通过该模型快速地定位数据库异常点,并借助基于专家经验的根因分析模型输出最终解决方案,从而快速地解决当下数据库问题,恢复数据库服务。本文简述了诊断模型中专家经验模型、诊断路径模型与分析报告建议模型的探析思路,并分享了实际的组合建模工程化企业级落地现有成果,为该领域有关的研究提供参考。

医院oracle数据库系统维护浅析

现代医院各项操作都离不开数据,而这些数据都存储在数据库中,其作为信息系统中的核心部分,要保证正常运行,技术维护不可或缺。医院信息系统中,Oracle数据库作为一种关系型数据库,具有其他数据库所不具备的优势,使用灵活且效果良好。但是,数据库优势要保持长效性,数据库技术维护是重要途径,避免长期使用导致数据处理滞后性,做到部门之间数据信息实时交换,提高数据使用效率,本论文针对医院oracle数据库系统维护展开研究。

工程教育专业认证背景下的《Oracle数据库》课程改革研究

本文在工程教育专业认证的宏观背景下,深入剖析了《Oracle数据库》课程目前存在的问题,并紧密围绕工程认证委员会所设定的毕业要求,对课程大纲进行了全面的修订。改革涵盖了课程内容、实践能力的培养及考核方式等多个方面,旨在激发学生对Oracle数据库学习的热情,并显著提升学生的数据库工程实践能力。通过此次改革,期望能为培养具备国际视野和工程实践能力的优秀人才奠定坚实基础。