| MySQL数据库索引的研究 |
| |
| 引用本文： | 王贵生. MySQL数据库索引的研究[J]. 数字社区&智能家居, 2014, 0(12): 8079-8080 |
| |
| 作者姓名： | 王贵生 |
| |
| 作者单位： | 同济大学软件学院,上海201800 |
| |
| 摘 要： | 数据库索引是用于提高数据检索速度的关键数据结构,该文结合常用的数据库索引结构B树,分析索引的原理,并结合外存储的原理,分析大多数数据库使用B＋树作为索引结构的原因,并结合My SQL数据库中Inno DB存储引擎中的索引实现,分析其优缺点。
|
| 关 键 词： | B树结构 外存储原理 MySQL索引 |
Research on the Index of MySQL Database |
| |
| WANG Gui-sheng. Research on the Index of MySQL Database[J]. Digital Community & Smart Home, 2014, 0(12): 8079-8080 |
| |
| Authors: | WANG Gui-sheng |
| |
| Affiliation: | WANG Gui-sheng (School of Software Engineering, Tongji University, Shanghai 401800,China) |
| |
| Abstract: | Database index is the key data structure for improving the speed of data retrieval. In this paper, we analyze the index principle by combining with the principle of external storage and the B-tree structure of the database. We analyze of the reasons why many databases using B＋tree as the index structure. And we analyze the advantages and disadvantages of MySQL database index in the InnoDB storage engine. |
| |
| Keywords: | MySQL index B-/＋Tree External storage principle |
| 本文献已被 维普 等数据库收录！ |
|
