关于鸽子

鸽子,2006年开始接触Oracle,曾就职于高德地图6年,专注空间数据库的学习与使用,近11年DBA从业经历,同时,还爱好Java,H5技术,开发有Java版BBED,关键操作由C实现,用于对数据块的字节级操作。

目前从事Oracle,MySQL,Mongo相关技术支持与咨询工作。

2006年开始,鸽子就开始Oracle官方文档中文翻译的学习积累,后期还翻译汉化了大量的MySQL, MongoDB官方文档,历时10余年,积累了以下文档:

Oracle部分:

doc_Automatic Storage Management Administrator's Guide 11g Release 2 (11.2).docx
doc_Clusterware Administration and Deployment Guide 11g Release 2 (11.2).docx
doc_Data Guard Concepts and Administration 11g Release 2 (11.2).docx
doc_Database Administrator's Guide 11g Release 2 (11.2).docx
doc_Database Backup and Recovery User's Guide 11g Release 2 (11.2).docx
doc_Database Concepts 11g Release 2 (11.2).docx
doc_Database Installation Guide 11g Release 2 (11.2) for Linux.docx
doc_Database Net Services Administrator's Guide 11g Release 2 (11.2).docx
doc_Database Net Services Reference 11g Release 2 (11.2).docx
doc_Database Performance Tuning Guide11g Release 2 (11.2).docx
doc_Database PLSQL Packages and Types Reference 11g Release 2 (11.2).docx
doc_Database Reference11g Release 2 (11.2).docx
doc_Database Security Guide 11g Release 2 (11.2).docx
doc_Database Upgrade Guide 11g Release 2 (11.2).docx
doc_Database Utilities 11g Release 2 (11.2).docx
doc_Database VLDB and Partitioning Guide 11g Release 2 (11.2).docx
doc_Grid Infrastructure Installation Guide 11g Release 2 (11.2) for Linux.docx
doc_Real Application Clusters Administration and Deployment Guide 11g Release 2 (11.2).docx
doc_Real Application Clusters Installation Guide 11g Release 2 (11.2) for Linux and UNIX.docx
doc_Spatial Developer's Guide 11g Release 2 (11.2).docx
doc_Text Application Developer's Guide 11g Release 2 (11.2).docx
doc_Text Reference 11g Release 2 (11.2).docx

MySQL部分:

doc_Appendix A MySQL 5.7 Frequently Asked Questions_5.7.9+.docx
doc_Appendix B Errors, Error Codes, and Common Problems.docx
doc_Chapter 1 General Information.docx
doc_Chapter 10 Language Structure.docx
doc_Chapter 12 Data Types.docx
doc_Chapter 13 Functions and Operators.docx
doc_Chapter 14 SQL Statement Syntax.docx
doc_Chapter 15 The InnoDB Storage Engine.docx
doc_Chapter 16 Alternative Storage Engines.docx
doc_Chapter 17 Replication_5.7.9.docx
doc_Chapter 18 Replication.docx
doc_Chapter 2 Installing and Upgrading MySQL.docx
doc_Chapter 21 Partitioning.docx
doc_Chapter 21 Stored Programs and Views.docx
doc_Chapter 23 MySQL Performance Schema.docx
doc_Chapter 28 Extending MySQL.docx
doc_Chapter 4 Tutorial.docx
doc_Chapter 5 MySQL Programs.docx
doc_Chapter 6 MySQL Server Administration.docx
doc_Chapter 7 Security.docx
doc_Chapter 9 Optimization.docx
doc_MySQL Glossary.docx
doc_Percona-Xtra-Backup-2.4.5.docx

MongoDB部分:

doc_01_Replication and MongoDB_20140925.docx
doc_03_MongoDB-security-guide_20141013.docx
doc_2.6.4_02_Replication and MongoDB_20141104.docx
doc_2.6.4_03_Sharding and MongoDB_ERROR_20141105.docx
doc_2.6.4_04_MongoDB Security Guide_20150104.docx
doc_2.6.4_05_MongoDB Administration_20150515.docx
doc_Getting Started with MongoDB.docx
doc_Introduction to MongoDB.docx
doc_MongoDB 3.2_Reference.docx
doc_MongoDB 3.2_Security.docx
doc_MongoDB_Configuration File Options.docx
doc_MongoDB_FAQ.docx
doc_MongoDB_Indexes.docx
doc_MongoDB_Install.docx
doc_MongoDB_MongoDB CRUD Operations.docx
doc_MongoDB_Reference.docx
doc_MongoDB_Reference_3_mongo Shell Methods.docx
doc_MongoDB_Reference_4_MongoDB Package Components.docx
doc_MongoDB_Replication.docx
doc_MongoDB_Replication_old.docx
doc_MongoDB_Security.docx
doc_MongoDB_Sharding.docx
doc_The MongoDB 2.6 Manual_20140523.docx

有些文档随着版本的升级,也在不断整合中,保持同步更新,如Oracle最初是基于Oracle 10.2,现在慢慢全部更新为Oracle 11.2,对于官方文档中出现的某些错误,也进行了标注,对于一些难以理解的段落,也追加了示例说明。

摘自一些段落,来自,性能指南:Database Performance Tuning Guide 11g Release 2 (11.2)

2.5.4 使用视图(Views)
Using Views
视图可以加速和简化应用程序的设计。对于那些重点想要查询,显示,收集以及存储数据的程序员来说,一个简单的视图定义,可以屏蔽复杂的数据模型。Views can speed up and simplify application design. A simple view definition can mask data model complexity from the programmers whose priorities are to retrieve, display, collect, and store data.
 
但是,在视图提供清晰的编程接口的同时,它们可能会导致低性能(sub-optimal)的,资源密集性(resource-intensive)的查询。视图使用最坏的情况是,一个视图引用另一个视图,以及在查询中,将它们连接(join)在一起。在绝大多数情况下,开发人员可以直接使用表而不需要使用视图来满足其查询要求。通常,由于其固有的性质,视图会导致优化器很难生成最优的执行计划。However, while views provide clean programming interfaces, they can cause sub-optimal, resource-intensive queries. The worst type of view use is when a view references other views, and when they are joined in queries. In many cases, developers can satisfy the query directly from the table without using a view. Usually, because of their inherent properties, views make it difficult for the optimizer to generate the optimal execution plan.

目前还在做最后的整合,相信不久的一天,会有大量系统,权威,原始的Oracle,MySQL,MongoDB中文官方文档,供大家使用!

对于Oracle学习的同学,需要熟悉下列常用的文档:

Administrator's Guide
Administrator's Reference for Linux and UNIX-Based Operating Systems
Automatic Storage Management Administrator's Guide
Backup and Recovery Reference
Backup and Recovery User's Guide
Clusterware Administration and Deployment Guide
Concepts
Data Guard Concepts and Administration
Error Messages
Grid Infrastructure Installation Guide for Linux
Installation Guide for Linux
Net Services Administrator's Guide
Net Services Reference
Oracle Contents
Performance Tuning Guide
PL/SQL Language Reference
PL/SQL Packages and Types Reference
Real Application Clusters Administration and Deployment Guide
Real Application Clusters Installation Guide for Linux and UNIX
Reference
Security Guide
SQL Language Reference
SQL*Plus? User's Guide and Reference
Text Application Developer's Guide
Text Reference
Upgrade Guide
Utilities
VLDB and Partitioning Guide

对于特定的行业,可能还需要熟悉其它的一些文档,比如空间数据库,可能还需要去学习Spatial Developer's Guide相关的文档。

上面的文档,大多数并不需要全部的阅读,通常也没有办法进行全部的阅读,按需阅读即可。

如果想要一起学习数据库技术,如果官方文档中有理解模糊的地方,如果学习或工作中遇到麻烦的问题,都可以找我,一起探讨,共同进步。

另外,鸽子也会将原版的英文官方文档上传至dba86服务器,方便大家使用:http://www.dba86.com/

系统学习数据库并不是一件容易的事,仅仅通过阅读一些“How-to”快餐式的文章是不行的,必须要有更系统,更完整的资料指导学习,因此,建议大家在学习的时候,首选官方文档,系统、权威,原始!

更新于2016-02-19 --鸽子--