Database optimization is the most important job of system maintenance.
数据库的优化是系统维护工作中最重要的任务之一。
But to get the most out of your database optimization efforts, there are two things that you need to know.
但是,为了通过数据库优化获得最大的收益,您需要了解两件事。
In the next article, I'll write about some tricks that we use to do database optimization for another example of real world Rails.
在下一篇文章中,我将介绍一些实用技巧,您可以使用这些技巧来为另一个真实世界中的Rails示例进行数据库优化。
Database optimization can become a pretty advanced topic quickly, and I don't have nearly the space here to do this topic full justice.
数据库优化很快会成为一个前沿话题,我几乎没有空间在这里完全公正地做这个话题。
Methods the PACS system was optimized with hardware upgrades, software modifications, and database optimization by analyzing the operation of the existing system.
方法:通过分析现有系统的运行情况,采用硬件升级、软件修改和数据库优化的方式进行PACS优化。
If the query was written by adding a dimension followed by a fact and then another dimension, then the database optimization would include the materialization as necessary.
如果查询的创建是通过先添加维度再添加事实表然后又添加维度的方式构成,那么数据库优化则必须包含实体化。
The paper analyzes the factors that affect the performances of database, lists the principles that database should obey, and finally explores the methods of database optimization.
分析了影响数据库性能的各方面因素,以及数据库优化应遵循的方法,并就数据库优化技术方法进行了探讨。
However, optimization decisions are a complex function of various attributes, including the database environment and query characteristics, as well as the data itself.
然而,优化决策是各种属性的复杂函数,这些属性包括数据库环境、查询特征以及数据本身。
The discussion focused on a couple of big issues of database design without getting into the details of query optimization and application considerations.
本文着重讨论了数据库设计的两个比较大的问题,而没有深入研究查询优化和应用程序考虑事项的细节。
In the current economic climate, the immediate need for and value of database performance cost optimization and tuning cannot be overstated.
在当今的经济环境中,数据库性能和成本优化的重要性和价值怎么强调也不过分。
This is a result of the optimization efforts IBM performed to improve the performance of database queries.
这是IBM进行数据库查询来提高性能的优化努力的结果。
Optimization profiles allow you to influence plans without any application or database configuration changes.
优化概要文件允许您在无需更改应用程序或数据库配置的情况下影响访问计划。
The first of the three Storage Optimization components is compression, which examines each row in the database for recurring patterns of data.
三个StorageOptimization组件中最重要的是压缩,它分析数据库中的每一行,寻找重复出现的数据模式。
Those familiar with System I and database query performance analysis and tuning, understand that controlling the optimization goal is a critical step to optimizing performance.
那些熟悉systemi和数据库查询性能分析和调优的人就会理解控制优化目标是优化性能的关键步骤。
Query optimization focuses on CPUbound execution paths, while a fully cached database will still be preoccupied with optimizing page fetches to mass storage that are no longer an issue.
查询优化集中于cpu密集型(CPUbound)执行路径,而全缓存数据库将仍然集中于优化取页到大容量存储器的操作,而这已不再是问题。
The SQL Call Level Interface (CLI) has provided users with a new connection attribute to tune the optimization goal used with the database queries.
SQLCallLevelInterface (CLI)为用户提供了一个新的连接属性,用于调优数据库查询使用的优化目标。
Database query optimization for some of the APIs' operations like querying business process and task related objects (usage of materialized views or stored queries) (see the Resources section).
针对某些API操作(如查询与业务流程和任务相关的对象)的数据库查询优化(使用物化视图或存储查询)(请参见参考资料部分)。
Therefore, the database system performance tuning and optimization, involving multi-layers, are vital for the whole system to be in normal operation.
因此,基于数据库系统的性能调整与优化对于整个系统的正常运行起着至关重要的作用。
As join operation to relational database, structural join order selection is at the heart of query optimization in an XML database.
和关系数据库中的连接运算一样,结构连接顺序的选择是XML数据库查询优化的核心。
Finally, a summary and prospect on the problems of SQL SERVER database performance tuning and optimization are made in this paper.
最后,对SQLSERVER数据库性能调整与优化问题进行了总结和展望。
Decomposition and optimization of global query is one of hard problems in heterogeneous database integration.
全局查询的分解与优化是异构数据库的集成中许多难题之一。
Query optimization is the critical technique of parallel database systems.
查询优化是并行数据库系统的核心技术。
In this paper, the application of normalization and denormalization in the optimization of relational database design are discussed.
讨论了在大型关系数据库优化设计中关系的规范化和逆规范化的应用。
In this paper, we describe an algorithm, for query processing with semantic optimization in distributed relational database systems.
本文描述一个分布式关系数据库系统中具有语义优化的查询处理算法。
This software has functions of graphic editing, network topological analysis, power information database management, power flow calculating, power loss and reactive power optimization analysis.
该软件具有图形编辑、网络拓扑分析、电网信息数据库管理、潮流计算、电能损耗计算和无功优化分析等功能。
Data cube compressed storage is an important research content in large-scale database about data cube optimization calculation.
数据立方体的压缩存储是大型数据库中立方体优化计算的重要研究内容。
Therefore, performance tuning and optimization of database systems , which concern multiple aspects , are very vital to the normal running of the whole system .
因此,基于数据库系统的性能调整与优化对于整个系统的正常运行起着至关重要的作用。
Furthermore, the application of this axiom set on the query optimization in the incomplete information database is also discussed.
本文还讨论了该公理集合在不完全信息数据库查询优化上的应用。
The optimization of database performance directly influences the efficient operation of the entire database application system.
数据库的性能优化直接影响到整个数据库应用系统的高效运行。
Query optimization is an important element of database manager system.
查询优化是数据库管理系统的一个重要组成部分。
应用推荐