mongodb Index(3)

本文涉及的产品
云数据库 MongoDB,独享型 2核8GB
推荐场景:
构建全方位客户视图
简介:

全文索引

    MongoDB有一个特殊的索引用在文档中搜索文本,之前的博客都是用精确匹配来查询字符串,这些技术有一定的限制。在搜索大块文本的速度非常慢,而且无法处理自然语言礼节的问题。全文本索引使用的是倒排索引的思想来做的,和当前非常开源的lucene(全文检索)项目是一样的思想来实现的。使用全文本索引可以非常快的进行文本搜索,MongoDB支持多种语言,可惜在免费版中,并不支持汉语。查MongoDB的官网可以看到,在企业版中安装第三方插件可以支持中文的全文索引。

    使用全文本检索需要专门开启这个功能才能进行使用。启动MongoDB时指定--setParameter textSearchEnabled=true选项,或者在运行时执行setParameter命令,都可以启用全文本索引。如 db.adminCommand({"setParameter":1,"textSearchEnabled":true});

例:

db.news.insert({"title":"SEOUL","context":"SEOUL, June 10 (Reuters) - South Korean prosecutors raided the offices of Lotte Group, the country's fifth-largest conglomerate, and several affiliates on Friday, dealing a further blow to its hotel unit's planned IPO, billed as the world's biggest this year."});

db.news.insert({"title":"Many Chinese people","context":"Many Chinese people think that a job on a diplomatic team is too good to quit. So when 28-year-old Liu Xiaoxi left her embassy post as an attache late last year to start a career in photography, she quickly became a popular topic among the Chinese online community."});

db.news.insert({"title":"About","context":"About 200 investigators searched 17 locations including group headquarters in central Seoul and the homes of Chairman Shin Dong-bin and other key executives, local news agency Yonhap reported, citing the Seoul Central Prosecutor's office."});

db.news.insert({"title":"Three people","context":"Three people with direct knowledge of the matter told Reuters that Friday's raids were part of an investigation into a possible slush fund. They also declined to be identified."});

db.news.insert({"title":"A Lotte Group spokesman","context":"A Lotte Group spokesman on Friday declined to comment on the reason for the raid, when asked whether it concerned a possible slush fund. He noted, however, that the situation was difficult given the IPO plans and Lotte Chemical's Axiall bid."});

db.news.insert({"title":"According","context":"According to bourse rules, the deadline for Hotel Lotte to list is July 27, six months from the preliminary approval for the IPO. If it needed to refile its prospectus to warn investors about risks from Friday's probe, which appeared likely, it would probably not be able to meet that deadline, an exchange official told Reuters on Friday."});

db.news.insert({"title":"Friday","context":"On Friday, dozens of Chinese tourists queued as usual to access elevators to the flagship Lotte Duty Free outlet in the group's headquarters complex, as TV cameras waited for investigators to emerge from office doors around the corner."});

db.news.insert({"title":"Named","context":"Named after the heroine of an 18th century Goethe novel, Lotte has grown from its founding in Japan 68 years ago as a maker of chewing gum to a corporate giant with interests ranging from hotels and retail to food and chemicals. The group has annual revenue of around $60 billion in Korea."});

db.news.insert({"title":"Hotel Lotte's","context":"Hotel Lotte's planned flotation of around 35 percent of its shares was intended to bring transparency and improve corporate governance at a group whose ownership structure is convoluted even by the opaque standards of South Korea's conglomerates."});

db.news.insert({"title":"Shares","context":"Shares in Lotte Shopping (023530.KS) , whose units Lotte Department Store and Lotte Home Shopping were raided, fell 1.6 percent on Friday. Lotte Himart (071840.KS) , a consumer electronics retailer, dropped 2.1 percent."});


> db.news.ensureIndex({"title":"text","context":"text"},{"weights":{"title":2,"context":1}})

{

"createdCollectionAutomatically" : false,

"numIndexesBefore" : 1,

"numIndexesAfter" : 2,

"ok" : 1

}

> db.news.find({$text:{$search:"flotation"}})

{ "_id" : ObjectId("57aa8a28fe5f255ba4328c0e"), "title" : "Hotel Lotte's", "context" : "Hotel Lotte's planned flotation of around 35 percent of its shares was intended to bring transparency and improve corporate governance at a group whose ownership structure is convoluted even by the opaque standards of South Korea's conglomerates." }

>

每个集合上最多只能有一个全文本索引,但是全文本索引可以包含多个字段。全文索引与普通的多键索引不同,全文本索引中的字段顺序不重要:每个字段都被同等对待,可以为每个字段指定不同的权重来控制不同字段的相对重要性。

titlecontext字段建立全文本索引,给title字段2的权重,context字段1的权重。(权重的范围可以是1~1,000,000,000,默认权重是1


2d索引

2d索引也是MongoDB最常用的地理空间索引之一,用于游戏地图。2d索引用于扁平表面,而不是球体表面。如果用在球体表面上,在极点附近会出现大量的扭曲变形

> var map = [{

...   "gis" : {

...     "x" : 185,

...     "y" : 150

...   }

... },{

...   "gis" : {

...     "x" : 70,

...     "y" : 180

...   }

... },{

...   "gis" : {

...     "x" : 75,

...     "y" : 180

...   }

... },{

...   "gis" : {

...     "x" : 185,

...     "y" : 185

...   }

... },{

...   "gis" : {

...     "x" : 65,

...     "y" : 185

...   }

... },{

...   "gis" : {

...     "x" : 50,

...     "y" : 50

...   }

... },{

...   "gis" : {

...     "x" : 50,

...     "y" : 50

...   }

... },{

...   "gis" : {

...     "x" : 60,

...     "y" : 55

...   }

... },{

...   "gis" : {

...     "x" : 65,

...     "y" : 80

...   }

... },{

...   "gis" : {

...     "x" : 55,

...     "y" : 80

...   }

... },{

...   "gis" : {

...     "x" : 0,

...     "y" : 0

...   }

... },{

...   "gis" : {

...     "x" : 0,

...     "y" : 200

...   }

... },{

...   "gis" : {

...     "x" : 200,

...     "y" : 0

...   }

... },{

...   "gis" : {

...     "x" : 200,

...     "y" : 200

...   }

... }]

>

> for(var i=0;i<map.length;i++){ db.map.insert(map[i]) }

WriteResult({ "nInserted" : 1 })

> db.map.ensureIndex({gis:"2d"},{min:-1,max:201})

{

"createdCollectionAutomatically" : false,

"numIndexesBefore" : 1,

"numIndexesAfter" : 2,

"ok" : 1

}


查询(70,180)最近的3个点

> db.map.find({"gis":{$near:[70,180]}}).limit(3)

{ "_id" : ObjectId("57ab8ac5893a4e222430fcc1"), "gis" : { "x" : 70, "y" : 180 } }

{ "_id" : ObjectId("57ab8ac5893a4e222430fcc2"), "gis" : { "x" : 75, "y" : 180 } }

{ "_id" : ObjectId("57ab8ac5893a4e222430fcc4"), "gis" : { "x" : 65, "y" : 185 } }

>

查询以点(50,50)和点(190,190)为对角线的正方形中的所有点:

> db.map.find({gis:{"$within":{$box:[[50,50],[190,190]]}}},{_id:0,gis:1})

{ "gis" : { "x" : 50, "y" : 50 } }

{ "gis" : { "x" : 50, "y" : 50 } }

{ "gis" : { "x" : 60, "y" : 55 } }

{ "gis" : { "x" : 55, "y" : 80 } }

{ "gis" : { "x" : 65, "y" : 80 } }

{ "gis" : { "x" : 65, "y" : 185 } }

{ "gis" : { "x" : 70, "y" : 180 } }

{ "gis" : { "x" : 75, "y" : 180 } }

{ "gis" : { "x" : 185, "y" : 150 } }

{ "gis" : { "x" : 185, "y" : 185 } }

查询出以(56,80)为圆心,半径为50,圆面积中的点,如下所示:

> db.map.find({gis:{"$within":{$center:[[56,80],50]}}},{_id:0,gis:1})

{ "gis" : { "x" : 50, "y" : 50 } }

{ "gis" : { "x" : 50, "y" : 50 } }

{ "gis" : { "x" : 60, "y" : 55 } }

{ "gis" : { "x" : 55, "y" : 80 } }

{ "gis" : { "x" : 65, "y" : 80 } }

查看三角形内的所有点,如下所示:

> db.map.find({"gis": {"$within":{"$polygon":[[50,70],[70,90],[90,70]]}} })

{ "_id" : ObjectId("57ab8ac5893a4e222430fcc8"), "gis" : { "x" : 65, "y" : 80 } }

>多边形,可以指定$polygon$ploygon接受一个多元素的数组,每个元素对应多边形的点)










本文转自 meteor_hy 51CTO博客,原文链接:http://blog.51cto.com/caiyuanji/1836850,如需转载请自行联系原作者
相关实践学习
MongoDB数据库入门
MongoDB数据库入门实验。
快速掌握 MongoDB 数据库
本课程主要讲解MongoDB数据库的基本知识,包括MongoDB数据库的安装、配置、服务的启动、数据的CRUD操作函数使用、MongoDB索引的使用(唯一索引、地理索引、过期索引、全文索引等)、MapReduce操作实现、用户管理、Java对MongoDB的操作支持(基于2.x驱动与3.x驱动的完全讲解)。 通过学习此课程,读者将具备MongoDB数据库的开发能力,并且能够使用MongoDB进行项目开发。 &nbsp; 相关的阿里云产品:云数据库 MongoDB版 云数据库MongoDB版支持ReplicaSet和Sharding两种部署架构,具备安全审计,时间点备份等多项企业能力。在互联网、物联网、游戏、金融等领域被广泛采用。 云数据库MongoDB版(ApsaraDB for MongoDB)完全兼容MongoDB协议,基于飞天分布式系统和高可靠存储引擎,提供多节点高可用架构、弹性扩容、容灾、备份回滚、性能优化等解决方案。 产品详情: https://www.aliyun.com/product/mongodb
目录
相关文章
|
存储 NoSQL 数据可视化
MongoDB性能系列最佳实践-Index
MongoDB将会推出一系列介绍MongoDB性能最佳实践的文章,旨在帮助用户在多个关键方面实现规模化性能优化。
MongoDB性能系列最佳实践-Index
|
存储 NoSQL MongoDB
MongoDB系列--轻松应对面试中遇到的MongonDB索引(index)问题
索引是特殊的数据结构,索引存储在一个易于遍历读取的数据集合中( 索引存储在特定字段或字段集的值),而且是使用了B-tree结构。索引可以极大程度提升MongoDB查询效率。
334 0
MongoDB系列--轻松应对面试中遇到的MongonDB索引(index)问题
|
NoSQL 索引
|
自然语言处理 算法 NoSQL
MongoDB源码解析:Full Text Search Index
框架实现 FTS本质上也是Btree索引类型 索引AccessMethod定义: class FTSAccessMethod : public BtreeBasedAccessMethod 关键成员: fts::FTSSpec _ftsSpec; 获取索引的函数入口: void
3609 0
|
存储 NoSQL 索引