数据库性能

• It helps database administrators to diagnose the causes of database performance problems , such as non - optimal buffer and heap sizes , as well as monitor the health of database objects such as tables and nicknames that are used in applications
  它帮助数据库管理员诊断数据库性能问题（如缓冲区和堆大小不理想）的原因、监控在应用程序中使用的表格和别名之类的数据库对象的状态。
• Query optimization is an important technique for designing and implementing database management system ( dbms ) . it is a crucial factor that affects the capability of database . at present , this technique is successfully applied in all commercial databases
  查询优化是数据库管理系统设计和实现所采用的一项重要技术，它是影响数据库性能的关键因素，当前所有商用数据库都成功采用了这项技术。
• This paper starts with the project ’ s requirements , and discusses several methods to optimize db2 ’ s performance and then builds the database self - adapt tuning framework . through the established framework , the self - adapter based on database initiative characteristic is carried out
  本文根据项目调研所得到的信息,讨论了一组db2数据库性能调优的方法,并在此基础上提出数据库自适应调优( dsat )架构,实现基于数据库主动特性的自调优。
• Consulting with the customer regarding current network , system , and database performance , analysis of network bottlenecks and establishment of optimization programs , and communication with the customer organizations regarding technical testing , and data backup , to ensure continued operation
  听取顾客关于网络、系统、数据库性能的现状，现场分析瓶颈所在制定性能调优方案，并与顾客交流沟通组织相关的技术测试，顾客的数据备份，确保万无一失。
• Real _ time requirement and time sequence consistency are important symbols in dems , the paper analyses thoroughly factors that system real _ time is restricted , and merits that main memory is used as a storage medium . in order to satisfy system real _ time and openness , distributed database in experiment & measurement system unites real _ time main memory database and sql server 2000 . the paper discusses the time sequence consistency in dems and introduces the concept of absolute time sequence consistency and relative time sequence consistency
  实时性及时序一致性是试验与测试系统分布数据库性能的重要标志，论文深入分析了制约系统实时性的因素及以内存为存储介质的优点，为满足系统的实时性与开放性，引用了实时内存数据库与sqlserver2000相结合的试验与测试系统分布数据库设计思想；时序一致性表现为绝对时序一致性和相对时序一致性两方面，结合试验与测试系统自身特点，利用优先级解决绝对时序一致性和用数据视图解决相对时序一致性问题。
• Considering the above preconditions , aiming at tobacco daily business and requirements of data , this article presents the following : 1 . to analyze business logic and data info a flow chart , based on software including ibm aix os , db2 udb according to the tobacco number one ’ s total design thoughtfulness 2 . to analyze the factors affecting db2 database performance in detail in allusion to the characteristic of tobacco industry including large data , lots of users , data updating rapidly , and frequent visits ; 3
  基于以上前提,本文针对烟草企业日常业务和数据量的需求作了以下工作:从国家烟草专卖局烟草一号工程总体设计思路出发,分析工业企业的业务逻辑以及数据信息流图,涉及的相关平台,包括ibmaix操作系统、 db2udb通用数据库系统。针对烟草行业数据量、用户量庞大,数据更新迅速、用户访问频繁的特点,详细分析了影响db2数据库性能的因素。
• Transplant china cancer database from visual foxpro 6 to oracle8 . 17 and rewrite the internet interface with jsp / servlet . integrate software r with this database to update its chart function and accomplish the cancer distribution thematic maps materials and methods data : the data sources are extensively , including that twice death cause review investigated in the 70 ' s and the 90 ' s of the whole nation , the cancer register data , the cancer research data and the clinical information of tumor hospitals etc . hardware : legend t2600 , compaq evo w6000
  提升数据库性能，将全国肿瘤防治数据库所用的foxpro数据库移植到oracle8 . 17 ，并用jsp / servlet技术改造以前的php程序，整合统计软件r ，改善数据库统计作图功能；开发电子版的中国肿瘤分布地图材料方法：数据：全国70年代与90年代两次死亡回顾调查资料，肿瘤发病死亡登记资料，特定肿瘤、特定人群的大样本研究资料及各肿瘤医院的临床治疗信息等。
• In view of the engineering practice of chmavc " s assistant materials management information system , this paper discusses some engineering problems relation to the design of a large database and to the application of database technology . exposition of two important aspects - - then design of a large database and improvement of database performance concerning practice is given . it includes the design of a data model , the compress technique of data , indexes set - up , optimization of inquiry , integrity check and security control
  从工程实践的角度，论述了为实现系统功能而在数据库设计和软件结构设计中所采用的方法和技术；并论述了为达到系统性能而在实现中所采取的各项措施，重点讨论了大型数据库的设计和改善数据库性能这两个重要方面，内容包括设计数据模型、建立索引、查询优化、完整检查和安全控制等。
• The particularity and the advanced technology of the embedded system and edbms are introduced firstly . the author point out that the capability of edbms is decided by the spending of system resource but not the traditional number of i / o operation according to the peculiarity of embedded system and the appliances requirement
  本文分析了嵌入式系统以及嵌入式数据库系统的特点和技术发展现状，并根据嵌入式系统的应用需求和嵌入式系统普遍特征指出：基于内存操作的嵌入式数据库性能的决定因素是系统运行时资源开销而非传统的数据i o操作次数。
• Have introduced the demand analysis of the e - commerce web site of " yue tan shi jie " in detail in the thesis , have put forward the plan of structure design of the database on the basis of demand analysis , and during function of website , how be according to the actual conditions of the website , make procedure to control database space , memory change , data file change situation regularly ; how to carry on the database performance optimize according to the controlling report ; how to make backup schemes
  论文中详细介绍了在“月坛视界”网站需求分析的基础上提出的数据库结构设计方案，以及在网站的运行期间，如何依据网站的实际情况，编制程序实现对网站数据库的表空间变化、内存变化、数据文件变化等情况进行定时监控；如何基于监控报告进行数据库性能优化；如何从实际出发制定切实可行的数据库备份方案。