基于SQLDMO的数据库备份与恢复的实现

介绍了数据库备份与恢复的基本方法,特别是封装数据库操作的作用.以SQL Server2000为例,在ASP.NET(C#语言)环境下实现了基于SQLDMO的数据库备份和还原.分析了备份和还原的几种方法、选择策略和SQLDMO的功能.详细给出了备份和还原的具体思路和类实现,存储过程和游标在还原中的应用.     

浅谈T-SQL语言之递归查询

文章以T-SQL技术为基础,介绍了基于CTE语句进行数据库查询的产生机理和实现方法,并针对CTE语句的特点,采用存储过程及自定义函数方式来实现基于CTE语句查询数据库的过程.以人员管理树型结构数据为基础,在SQL Server 2005中建立各种CTE临时结果集,进行递归查询操作,从而体现T-SQL语言中新增CTE递归查询的强大功能.     

基于Oracle的实时数据存储访问

面对快速发展的数据分析需求,流程工业实时数据库单纯的数据存储和回溯功能已不能满足实际的应用要求.以关系数据库为介质,研究了基于Oracle的实时数据获取、处理、存储和访问技术.重点探讨了实时数据的压缩存储,并给出采用Oracle数据库内部语言PL/SQL实现数据压缩算法,由于数据的存储和访问中引进了数据压缩技术,在低频率和点数较少时,该技术可作实时数据库的替代方案.给出的方法在Oracle10g企业版中测试通过,并成功应用在某大型石化企业的丁二烯分离装置上,取得了良好的效果.     

Oracle数据库大对象数据存取的两种实现方法及时间性能比较

随着云计算、物联网时代的到来,大对象数据的存储和读取将是不得不面对的现实,系统化的数据管理才能使我们的工作事半功倍.本文讨论利用SQL*Plus存储过程或借助JAVA编程语言,来实现了Oracle数据库中大对象数据存取,并对其操作的时间性能进行对比,得出借助JAVA语言读取Oracle数据库大对象远优于通过存储过程读取的结论.     

面向OceanBase的存储过程设计与实现

存储过程是数据库管理系统的一个重要特性,它是标准结构化查询语言(Structured Query Language,SQL)的一个扩展.OceanBase是一个新型的支持海量数据处理的分布式数据库系统,但现有OceanBase的开源版本不支持存储过程功能,影响了该系统在企业和机构中的推广和应用.本文在深度分析存储过程原理以及OceanBase查询处理策略的基础上,设计并实现了支持PL/SQL(Procedural Language/SQL)的存储过程机制.     

OPC技术在DCS数据访问中的应用

使用Visual C 设计了一个基于C/S模式并用于过程控制的对象链接和嵌入(OPC)的客户端.通过该客户端成功地实现了Visual C 与SIEMENS Windows控制中心(WinCC)之间的动态数据交换.利用Visual C 中的ActiveX数据对象(ADO)数据库接口,把WinCC中的数据存储到结构化查询语言数据库服务器(SQL server)中,实现了实时过程数据从WinCC到标准数据库的转存,解决了WinCC自带数据库中的数据访问困难的问题,为用户访问提供了标准数据源.最后给出了具体的实现步骤.     

用VC++ ADO实现SQL存储过程的调用

VisualC++6.0作为一款成熟的集成开发工具,已经获得了广泛的应用,它对于数据库开发提供了强大的支持.同时SQLServer2000在大型数据表的管理上,也比较成熟,特别是它提供了完善高效的存储过程,特别适合大中型数据库的软件开发.在VisualC++6.0集成开发环境中,实现对存储过程的调用,对于数据库应用软件的开发工作具有较大的意义.基于笔者对于高等学校教务学生成绩系统数据库的工程实际开发经验,在文中系统而完整地介绍了怎样去实现用VC++ADO对SQL存储过程的调用,并着重阐述了关键代码的作用和编写过程.     

基于Delphi的C/S结构数据库应用程序的开发

Delphi是当今数据库应用软件开发的主流工具.基于Delphi的Two-Tier结构的C/S开发模式,介绍了用Delphi开发C/S数据库应用程序的方法,并通过实例,描述了从ADO数据库程序设计标准、数据库控件的使用及存储过程的编写直到Delphi数据库应用程序实现的整个开发过程.     

基于数据库的模糊本体存储方法研究

为解决语义网中模糊信息的表示问题,提出了一种基于关系数据库的模糊本体存储方法,定义了推理机制,实现成员关系的推理和关系度的计算.实验采用PostgreSQL数据库存储本体及SPARQL语言进行检索,结果证明了该方法的可行性.     

基于网络数据库的存储过程和触发器应用研究

以成都市西南书城会员购书管理系统为例,针对该系统存在的不足,分析了存储过程和触发器的特征,最终提出了基于存储过程和触发器技术的解决方案.实践表明存储过程和触发器技术在网络数据库应用中能提高数据库的运行效率和解决数据库中较为复杂的业务规则.     

Markedness and its Interpretation in Language Use

Language markedness is a common phenomenon in languages, and is reflected from hearing, vision and sense, i.e. the variation in the three aspects such as phonology, morphology and semantics. This paper focuses on the interpretation of markedness in language use following the three perspectives, i.e. pragmatic interpretation, psychological interpretation and cognitive interpretation, with an aim to define the function of markedness.     

Features of Women's language

Language is a means of verbal communication. People use language to communicate with each other. In the society, no two speakers are exactly alike in the way of speaking. Some differences are due to age, gender, statue and personality. Above all, gender is one of the obvious reasons. The writer of this paper tries to describe the features of women＇s language from these perspectives： pronunciation, intonation, diction, subjects, grammar and discourse. From the discussion of the features of women＇s language, more attention should be paid to language use in social context. What＇s more, the linguistic phenomena in a speaking community can be understood more thoroughly.     

低渗透非均质砂岩油藏启动压力梯度研究

理论推导与室内实验相结合,建立了低渗透非均质砂岩油藏启动压力梯度确定方法。首先借助油藏流场与电场相似的原理,推导了非均质砂岩油藏启动压力梯度计算公式。其次基于稳定流实验方法,建立了非均质砂岩油藏启动压力梯度测试方法。结果表明:低渗透非均质砂岩油藏的启动压力梯度确定遵循两个等效原则。平面非均质油藏的启动压力梯度等于各级渗透率段的启动压力梯度关于长度的加权平均;纵向非均质油藏的启动压力梯度等于各渗透率层的启动压力梯度关于渗透率与渗流面积乘积的加权平均。研究成果可用于有效指导低渗透非均质砂岩油藏的合理井距确定,促进该类油藏的高效开发。     

On Tragic Consciousness In The Works By Ernest Hemingway

As an American modern novelist who were famous in the literary world, Hemingway was not a person who always followed the trend but a sharp observer. At the same time, he was a tragedy maestro, he paid great attention on existence, fate and end-result. The dramatis personae's tragedy of his works was an extreme limit by all means tragedy on the meaning of fearless challenge that failed. The beauty of tragedy was not produced on the destruction of life, but now this kind of value was in the impact activity. They performed for the reader about the tragedy on challenging for the limit and the death.     

Achieving Unusual States of Matter Under High Pressure

正The periodicity of the elements and the non-reactivity of the inner-shell electrons are two related principles of chemistry,rooted in the atomic shell structure.Within compounds,Group I elements,for example,invariably assume the+1 oxidation state,and their chemical properties differ completely from those of the p-block elements.These general rules govern our understanding of chemical structures and reactions.Using first principles calcula-     

Exchange-Correlation and Electronic Excitation Energies from Pairing Matrix Fluctuations

We have developed an adiabatic connection to formulate the ground-state exchange-correlation energy in terms of pairing matrix linear fluctuations.This formulation of the exchange-correlation energy opens a new channel for density functional approximations based on the many-body perturbation theory.We illustrate the potential of such approaches with an approximation based on the particle-particle Random Phase Approximation(pp-RPA).This re-     

Density Functional Theory for the Response of Periodic Systems to Electric Fields Based on the Vector Potential Approach

正The electronic and nuclear(structural/vibrational)response of 1D-3D nanoscale systems to electric fields gives rise to a host of optical,mechanical,spectral,etc.properties that are of high theoretical and applied interest.Due to the computational difficulty of treating such large systems it is convenient to model them as infinite and periodic(at least,in first approximation).The fundamental theoretical/computational problem in doing so is that     

On the Thermodynamic Limit for Responses to Static Electromagnetic Fields

For molecular systems,the quantum-mechanical treatment of their responses to static electromagnetic fields usually employs a scalar-potential treatment of the electric field and a vector-potential treatment of the magnetic field.Although the potential for each field separately is associated with the choice of an(unphysical)origin,the precise choice of the origin for the electrostatic field has little consequences for the results.This is different for the     

An affordable accurate evaluation of the binding conformations predicted by molecular docking studies in bio-system

Franck-Condon factors bridge the gap between theoretical modeling and experimental observations for molecular electronic spectroscopy and electron transfer.Under the displaced harmonic oscillator approximation,multidimensional Franck-Condon factors are decomposed into a product of many one-dimensional(1D)Franck-Condon(FC)factors,and each 1D-FC factor is associated with one Huang-Rhys factor that determines the leading contribution of     

Call for Papers

<正>"The Journal of Shanghai Normal University:Mathematics"is published by Shanghai Normal University as regular issues of The Journal of Shanghai Normal University each year from 2014 in English.The editors-in-chief of the issues are professors Yuhao Cong and Maoan Han.The Journal of Shanghai Normal University was started in 1958 with