Database

mongodb数据导出为csv文件

March 21, 2018 Database, IT

mongoexport -h [IP]:[port] -d [db] -c [collection] -u [user] -p [password] --type=csv -f [field1[,field2,field3,...]] > [filename.csv]

elasticsearch 中文term精确匹配

February 27, 2018 Database, IT, Science ,

问题描述

用es需要用到精确匹配和模糊匹配的时候,发现term匹配中文短语时没有返回结果,而匹配数字和符号时有。

遂查阅官网的《term》描述,在下方有个Why doesn’t the term query match my document?内容,惊喜了一番,但在照着配置的时候,发现还是不行。[......]

Read more

经典数据库设计之CDM、LDM与PDM的区别

August 16, 2017 Database, IT ,

CDM、LDM与PDM的区别

PowerDesigner(五)-概念数据模型(CDM生成LDM,PDM和OOM)

ElasticSearch Note 3

August 10, 2017 Database, IT

search

there are two ways for searching

  • REST request body
  • REST request URI

REST request body

GET /bank/_search
{
  "query": { "match_all": {} },[......]

Read more

ElasticSearch Note 2

August 10, 2017 Database, IT

ElasticSearch comparied with SQL and NoSQL

ElasticSearch
SQL
NoSQL
Index
DataBase
Database
Type
Table
Collection
Document
Value
Docum[......]

Read more

Elastic Search初探

June 23, 2017 Database, Python , ,

研究了下ES,写了一个python版的关于ES的增删改查代码:

from datetime import datetime
from elasticsearch import Elasticsearch
es = Elasticsearch([{'host':'192.168.2.178','po[......]

Read more