信息管理系统数据库性能优化研究

随着信息化管理系统的发展,作为信息管理系统的重要组成部分,数据库技术已经得到了广泛的应用.为了保证信息管理系统的正常、高效、安全的运行,就必须要考虑数据库的性能问题.数据库的性能优化包括缩短查询响应时间,减小查询所需要的CPU时间和磁盘I/O时间,提高数据库服务器的吞吐量.数据库优化的方法主要包括数据库设计规范优化、SQL语句优化、改善查询计划等手段.通过对数据库优化方法的研究,并且以一个具体的信息管理系统数据库优化实例,对数据库优化方法的具体应用进行介绍.为数据库技术和信息管理系统的进一步发展尽自己的一点努力.     

基于SQL Server数据库查询优化的几点思考

优化数据库性能的一个很重要的方法就是优化查询,即提高SQL的执行效率,减少计算量和内存的使用量实现提高查询速度的目的.本文通过分析影响SQL Server数据库性能的数据库模型、查询语句等因素,提出了一些常用的查询优化的方案,实现有效提高查询效率,优化数据库性能的目的.     

B/S模式下查询方法性能分析

在B/S模式下,通常Web利用动态SQL语句或存储过程查询数据 库,本文对使用动态SQL语句和存储过程进行测试和比较,分析使用这两种方法的查询效率 及对Web服务器和数据库服务器负载的影响,对实际工程设计具有一定的参考价值.     

基于SQL数据库的性能优化的探讨

在数据库应用系统中的数据量不断增大的背景下,效率成为数据库在应用与开发管理中需要解决的首要关键,对于数据库的优化,不但要对逻辑性数据库与物理性数据硬件、服务器的硬件平台进行优化,还要对SQL语句的本身查询进行优化。该文主要对SQL数据库中对效率产生影响的问题进行分析,探讨相关的性能优化对策,从而提高SQL数据库的性能与运行效率。     

浅谈数据库的查询优化方法

目前数据库面临的主要问题是SQL查询语句的优化。本文主要探讨了在数据库的应用中对数据库查询优化的一些策略,其中包括基于索引、SQL语句的优化的方法,并简要对其他一些常用方法做了简单介绍,以拓宽优化数据查询的灵活性,有效提高查询效率以及数据库的整体性能。     

基于Oracle数据库SQL查询语句优化规则的研究

通过对Oracle数据库中SQL查询语句的执行原理和过程进行研究,以现有系统书号实名申领信息系统中的数据库为例,对执行的SQL查询语句的执行计划进行了分析,从SQL语句执行过程涉及到的系统资源和执行方式入手,对SQL查询语句进行优化,最后得出一系列的优化规则,并根据优化结果对这些规则进行验证。     

基于索引的关系数据库查询优化

查询优化是提高数据库性能的关键技术之一.在分析SQL Server关系数据库系统自动查询优化技术的基础上,介绍了索引的类型和使用原则,并结合实例讨论了SQL语句中使用索引进行查询优化的多种有效方法,有助于提高数据库的查询效率.     

基于索引的SQL语句查询优化方法的研究

查询是数据库中最基本、最常用的操作,而查询优化是数据库性能优化最为重要的手段之一.以索引技术为研究手段,介绍了索引的工作原理及索引类型,提出了建立索引的基本原则.通过举例,重点讨论了基于索引的SQL语句优化方法,以达到提高系统性能的目的.     

SQL查询优化技术初探

查询是数据库应用系统中使用最频繁的操作,查询语句的优劣直接影响数据库应用系统的性能。系统优化中一个很重要的方面就是SQL语句的优化。本文分析了影响SQL查询语句执行效率的因素,且从应用角度论述了SQL语句优化的主要方法,并提供了实例。     

基于ORACLE的查询优化

Oracle数据库系统性能优化是一个复杂的系统工程。本文论述了通过Oracle数据库查询的工作机制,并分析了一些影响应用性能的可能因素,主要从SQL语句的方面优化进行阐述,给出了一些可行的调整数据库应用性能的策略与方法。     

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.     

Characterization of Ordovician carbonate reservoirs, southeastern Saskatchewan, Canada

The discovery of the prolific Ordovician Red River reservoirs in 1995 in southeastern Saskatchewan was the catalyst for extensive exploration activity which resulted in the discovery of more than 15 new Red River pools. The best yields of Red River production to date have been from dolomite reservoirs. Understanding the processes of dolomitization is, therefore, crucial for the prediction of the connectivity, spatial distribution and heterogeneity of dolomite reservoirs.The Red River reservoirs in the Midale area consist of 3～4 thin dolomitized zones, with a total thickness of about 20 m, which occur at the top of the Yeoman Formation. Two types of replacement dolomite were recognized in the Red River reservoir: dolomitized burrow infills and dolomitized host matrix. The spatial distribution of dolomite suggests that burrowing organisms played an important role in facilitating the fluid flow in the backfilled sediments. This resulted in penecontemporaneous dolomitization of burrow infills by normal seawater. The dolomite in the host matrix is interpreted as having occurred at shallow burial by evaporitic seawater during precipitation of Lake Almar anhydrite that immediately overlies the Yeoman Formation. However, the low δ18O values of dolomited burrow infills (-5.9‰～ -7.8‰, PDB) and matrix dolomites (-6.6‰～ -8.1‰, avg. -7.4‰ PDB) compared to the estimated values for the late Ordovician marine dolomite could be attributed to modification and alteration of dolomite at higher temperatures during deeper burial, which could also be responsible for its 87Sr/86Sr ratios (0.7084～0.7088) that are higher than suggested for the late Ordovician seawaters (0.7078～0.7080). The trace amounts of saddle dolomite cement in the Red River carbonates are probably related to "cannibalization" of earlier replacement dolomite during the chemical compaction.     

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.     

A computer generator for randomly layered structures

AcomputergeneratorforrandomlylayeredstructuresYUJia shun1,2,HEZhen hua2(1.TheInstituteofGeologicalandNuclearSciences,NewZealand;2.StateKeyLaboratoryofOilandGasReservoirGeologyandExploitation,ChengduUniversityofTechnology,China)Abstract:Analgorithmisintrod…     

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

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

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.     

海南岛地体及其毗邻陆缘晚中生代—新生代古地磁研究和构造演化

本文叙述了对海南岛及其毗邻大陆边缘白垩纪到第四纪地层岩石进行古地磁研究的全部工作过程。通过分析岩石中剩余磁矢量的磁偏角及磁倾角的变化,提出海南岛白垩纪以来经历的构造演化模式如下:早期伴随顺时针旋转而向南迁移,后期伴随逆时针转动并向北运移。联系该地区及邻区的地质、地球物理资料,对海南岛上述的构造地体运动提出以下认识:北部湾内早期有一拉张作用,主要是该作用使湾内地壳显著伸长减薄,形成北部湾盆地。从而导致了海南岛的早期构造运动,而海南岛后期的构造运动则主要是受南海海底扩张的影响。海南地体运动规律的阐明对于了解北部湾油气盆地的形成演化有重要的理论和实际意义。     

An Index mechanism for multi-scale view in spatial databases

There are numerous geometric objects stored in the spatial databases. An importance function in a spatial database is that users can browse the geometric objects as a map efficiently. Thus the spatial database should display the geometric objects users concern about swiftly onto the display window. This process includes two operations:retrieve data from database and then draw them onto screen. Accordingly, to improve the efficiency, we should try to reduce time of both retrieving object and displaying them. The former can be achieved with the aid of spatial index such as R-tree, the latter require to simplify the objects. Simplification means that objects are shown with sufficient but not with unnecessary detail which depend on the scale of browse. So the major problem is how to retrieve data at different detail level efficiently. This paper introduces the implementation of a multi-scale index in the spatial database SISP (Spatial Information Shared Platform) which is generalized from R-tree. The difference between the generalization and the R-tree lies on two facets: One is that every node and geometric object in the generalization is assigned with a importance value which denote the importance of them, and every vertex in the objects are assigned with a importance value,too. The importance value can be use to decide which data should be retrieve from disk in a query. The other difference is that geometric objects in the generalization are divided into one or more sub-blocks, and vertexes are total ordered by their importance value. With the help of the generalized R-tree, one can easily retrieve data at different detail levels.Some experiments are performed on real-life data to evaluate the performance of solutions that separately use normal spatial index and multi-scale spatial index. The results show that the solution using multi-scale index in SISP is satisfying.     

《Chinese Science Bulletin》SUBJECT INDEX TO VOLUME 59(2014)

正~~     

Achieving Unusual States of Matter Under High Pressure

The elongation method,originally proposed by Imamura was further developed for many years in our group.As a method towards O(N)with high efficiency and high accuracy for any dimensional systems.This treatment designed for one-dimensional(ID)polymers is now available for three-dimensional(3D)systems,but geometry optimization is now possible only for 1D-systems.As an approach toward post-Hartree-Fock,it was also extended to