ubuntu 에 mongodb설치해보자.

어찌어찌하다가 ubuntu10.10 LTS를 설치하게 되었으니 mongodb를 설치해보자.

관련참고자료 : www.mongodb.org
Downloads에서 리눅스버전 다운.
패키지를 풀고 해당 폴더/bin에가서 mongo명령어를 치니 관련모듈을 설치하라고 나옴.

sudo apt-get install mongodb

그리고 bin밑에 있는 mongo를 실행했는데, 뭐를 해야할지 막막 ㅎㅎㅎ

그래서 Document를 찾았다.

아래는 기존 RDBMS의 대표격인 MySql, Oracle과 MongoDB와의 실행명령어 및 용어를 비교한것이다.

MySQL executable	Oracle executable	Mongo executable
mysqld	oracle	mongod
mysql	sqlplus	mongo

MySQL 용어	Mongo 용어
database	database
table	collection
index	index
row	BSON document
column	BSON field
join	embedding and linking

SQL문장과 Mongo에서 사용하는 명령어를 비교한 것이다.

SQL 문장	Mongo 쿼리 문장
CREATE TALE USERS (a int, b int)	db.createCollection("mycoll")
INSERT INTO USERS VALUES (3,5)	db.users.insert({a:3, b:5})
SELECT a, b FROM USERS	db.users.find({}, {a:1, b:1})
SELECT * FROM users	db.users.find()
SELECT * FROM users WHERE age=33	db.users.find({age:33})
SELECT a,b FROM users WHERE age=33	db.users.find({age:33}, {a:1,b:1})
SELECT * FROM users WHERE age=33 ORDER BY name	db.users.find({age:33}).sort({name:1})
SELECT * FROM users WHERE age>33	db.users.find({'age':{$gt:33}})
SELECT * FROM users WHERE age<33	db.users.find({'age':{$lt:33}})
SELECT * FROM users WHERE name LIKE "%Joe%"	db.users.find({name:/Joe/})
SELECT * FROM users WHERE name LIKE "Joe%"	db.users.find({name:/^Joe/})
SELECT * FROM users WHERE age>33 AND age<=40	db.users.find({'age':{$gt:33,$lte:40}})
SELECT * FROM users ORDER BY name DESC	db.users.find().sort({name:-1})
SELECT * FROM users WHERE a=1 and b='q'	db.users.find({a:1,b:'q'})
SELECT * FROM users LIMIT 10 SKIP 20	SELECT * FROM users LIMIT 10 SKIP 20
SELECT * FROM users WHERE a=1 or b=2	db.users.find( { $or : [ { a : 1 } , { b : 2 } ] } )
SELECT * FROM users LIMIT 1	db.users.findOne()
SELECT DISTINCT last_name FROM users	db.users.distinct('last_name')
SELECT COUNT(*y) FROM users	db.users.count()

SELECT COUNT(*y) FROM users where AGE > 30	db.users.find({age: {'$gt': 30}}).count()
SELECT COUNT(AGE) from users	db.users.find({age: {'$exists': true}}).count()

CREATE INDEX myindexname ON users(name)	db.users.ensureIndex({name:1})
CREATE INDEX myindexname ON users(name,ts DESC)	db.users.ensureIndex({name:1,ts:-1})
EXPLAIN SELECT * FROM users WHERE z=3	db.users.find({z:3}).explain()
UPDATE users SET a=1 WHERE b='q'	db.users.update({b:'q'}, {$set:{a:1}}, false, true)
UPDATE users SET a=a+2 WHERE b='q'	db.users.update({b:'q'}, {$inc:{a:2}}, false, true)
DELETE FROM users WHERE z="abc"	db.users.remove({z:'abc'});

http://www.mongodb.org/display/DOCS/Java+Language+Center

http://www.springsource.org/spring-data/mongodb

http://java.dzone.com/articles/using-mongodb-sculptor