新書推薦：
《
读懂中国经济的优势和未来
》
售價：HK$
74.8
《
量子前沿：解密未来技术与产业生态
》
售價：HK$
87.8
《
服务的细节138：像销冠一样卖鞋
》
售價：HK$
54.8
《
硅基半导体应变理论与生长动力学
》
售價：HK$
51.7
《
智能图像处理
》
售價：HK$
64.9
《
善一分殊：儒家论形而上学、道德、礼、制度与性别 | 比较哲学翻译与研究丛书
》
售價：HK$
109.8
《
泛逻辑理论--统一智能理论的逻辑基础
》
售價：HK$
327.8
《
戏舞霓裳：中国传统戏曲服饰制作技艺研究
》
售價：HK$
184.8
|
| 內容簡介： |
|
本书以达梦数据库DM8 为蓝本，围绕DM8 性能为什么优化、谁来优化、优化什么、何时优化、优化到什么程度等问题进行详细介绍，从DM8 体系架构入手，分析了DM8 的运行机制，从DM8 的实例优化、I/O 优化、SQL 语句优化3 个方面详细地介绍了影响DM8 性能的核心问题。全书共6 章，内容包括DM8 性能优化概述、DM8体系架构、DM8 调优诊断工具、DM8 实例优化、DM8 I/O 优化和DM8 SQL 语句优化等。同时，本书还将DM8 参数配置文件相关参数、DM8 系统数据字典和DM8 常用动态性能视图作为附录，便于广大读者查阅。本书内容实用、示例丰富、语言通俗、格式规范，可以作为计算机、数据库等专业的教材，也可以作为工程技术人员的参考用书。
|
| 關於作者： |
|
曾昭文，教授，主要从事数据工程和知识管理相关研究，主持军队重大科研项目10余项，先后获军队科技进步二等奖1项、三等奖多项，获军队教学成果二等奖1项，出版专著4部。
|
| 目錄：
|
|
第1 章DM8 性能优化概述··············································································11.1 优化的基本概念·················································································11.1.1 为什么优化···············································································11.1.2 谁来优化··················································································21.1.3 优化什么··················································································21.1.4 何时优化··················································································41.1.5 优化到什么程度·········································································61.2 优化的基本思路·················································································71.2.1 数据库全面健康检查···································································71.2.2 优化阶段设计············································································71.2.3 数据库配置···············································································81.2.4 添加新的应用程序······································································81.2.5 运行过程的优化·········································································81.2.6 生产环境中优化的特殊问题··························································91.3 优化的基本步骤··············································································.101.3.1 问题分析···············································································.101.3.2 监控系统性能·········································································.111.3.3 数据库重演（REPLAY） ··························································.111.3.4 检查数据物理一致性································································.121.3.5 优化数据库布局······································································.121.4 数据库优化误区··············································································.13第2 章 DM8 体系架构·················································································.142.1 总体构成·······················································································.142.1.1 数据库··················································································.152.1.2 实例·····················································································.152.2 物理存储结构·················································································.152.2.1 配置文件···············································································.162.2.2 控制文件···············································································.162.2.3 数据文件···············································································.172.2.4 日志文件················································································182.2.5 备份文件················································································212.2.6 数据重演文件··········································································212.3 逻辑存储结构···················································································212.3.1 表空间···················································································212.3.2 段·························································································242.3.3 簇·························································································252.3.4 页·························································································262.3.5 记录······················································································272.4 DM8 内存结构··················································································272.4.1 内存池···················································································272.4.2 缓冲区···················································································282.4.3 排序区···················································································302.4.4 哈希区···················································································312.5 DM8 线程结构··················································································312.5.1 监听线程·······················2
|
|
購物車/收銀台(0) | 在線留言板
| 付款方式
| 運費計算
| 聯絡我們
| 幫助中心 |
加入書簽
HOME
新書上架
