If the database system you are monitoring is for decision support (DSS), and the queries are long and complicated, don't have the quality control (QC) agent run a large query.
如果要监视的数据库系统是用于决策支持(DSS)的,查询比较长而且比较复杂,那么不要让质量控制(QC)代理运行大型的查询。
For example, if your database is used for transaction processing and heavy decision-support (DSS) queries, you can be sure that a non-scheduled DSS query will trash your transaction performance.
例如,如果您的数据库用于事务处理和繁重的决策支持(DSS)查询,则可以确定非预定的DSS查询将牺牲您的事务性能。
General tuning tips are the same regardless of the database workload, but differences do exist between OLTP and DSS workloads.
无论数据库负载如何,通用的调优提示都是相同的,只是OLTP和DSS工作负载之间存在差别。
The DSS is planted in the transaction-processing environment for the sake of its data management based on the traditional database that is mainly used for transaction processing.
传统的决策支持系统以数据库作为数据管理的手段,而数据库系统主要用于事务处理,使得基于数据库的决策支持系统存在于事务处理环境之中。
MS offers DSS management language to provide the abilities of model base management, model file management and database usage.
管理系统提供DSS管理语言,实现对模型库的管理、模型文件的管理和对数据库的使用。
Relational database is the object processed by the DSS model.
该模型的作用对象是关系型数据库。
This paper describes the concept, system structure of the Decision Support system (DSS) firstly, then introduces the database, model library, knowledge library and arithmetic library of the DSS.
本文首先对决策支持系统(dss)的概念、体系结构进行了简要的介绍,阐述了DSS的数据库系统、模型库系统、知识库系统以及方法库系统。
In the application of the aforementioned theory, the design of database 's system model on DSS is elaborated, including data modeling, the choice and realization of relational database.
在实际应用中,详细论述了采用前述的建模方法进行决策支持系统数据仓库层模型的设计,包括数据建模、关系数据库选择及实现。
Data warehouse can meet the requirements of the database management subsystems of DSS and organize primitive data in the databases to analytical data suited to administrative decision.
数据仓库的出现解决了DSS应用的基础性问题——数据管理,即通过数据仓库将数据库系统中的原始数据组织成适合决策分析需要的分析型数据。
Abscract: data warehouse can meet the requirements of the database management subsystems of DSS and organize primitive data in the databases to analytical data suited to administrative decision.
摘要:数据仓库的出现解决了Dss应用的基础性问题一一数据管理,即通过数据仓库将数据库系统中的原始数据组织成适合决策分析需要的分析型数据。
Abscract: data warehouse can meet the requirements of the database management subsystems of DSS and organize primitive data in the databases to analytical data suited to administrative decision.
摘要:数据仓库的出现解决了Dss应用的基础性问题一一数据管理,即通过数据仓库将数据库系统中的原始数据组织成适合决策分析需要的分析型数据。
应用推荐