RocksDB: Persistent key-value store for fast storage http://ow.ly/2BzPfY

RocksDB: Persistent key-value store for fast storage

Embedded key-value store for fast storage

getdate()에 1초 더하기

SELECT getdate(),(dateadd(s,1,getdate()))

- 다수의 사용자 요청을 빠른 시간 내에 모두 처리

- 서비스에서 읽기/쓰기 비율 중 데이터 쓰기 비율이 높음

- 저장된 데이터의 일관성이 중요하게 여겨짐

- 스키마가 없는 데이터 형태(schema-less)

- 네트워크 기반 분산 데이터베이스가 가진 확장성

* 저장과 처리 시간 주기에 맞춰 데이터 종류를 나누어 보자.

 - 빠른 주기로 빈번하게 저장 및 처리되는 캐시 영역의 데이터

     : 수 ms 단위로 데이터 처리

 - 일정 주기로 아카이빙돼 시점 복원이 가능하도록 관리되는 데이터

     : 수 분 이내로 이전 상태로 복구 가능한 데이터 처리

 - 일정 주기로 데이터를 집계해 게임 내에 다시 반영하는 데이터

    : 실시간 랭킹, 개인 요약 정보, 최근 아이템 교환 비율 등

 - 각종 사용자 이벤트 발생에 따라 그 이력을 관리하는 로그 데이터

* 저장형태에 따른 구분

 Key-value

 Ordered Key-value

 Wide Column Store

 Document

 Graph

* NoSQL - 어떻게 선택해야 할까? : http://platformadvisory.kr/archives/608

* 한 눈에 살펴보는 PostgreSQL : http://helloworld.naver.com/helloworld/227936

-- 프로시져(Stored Procedure) 목록 보기
SELECT ROUTINE_NAME
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_TYPE='PROCEDURE'
ORDER BY ROUTINE_NAME
 
 
-- 프로시져 내용 보기
exec SP_HELPTEXT proc_Procedure

Robomongo 0.8.2

Shell-centric cross-platform MongoDB management tool

http://www.robomongo.org/

About

Robomongo — is a shell-centric cross-platform open source MongoDB management tool (i.e. Admin GUI). Robomongo embeds the same JavaScript engine that powers MongoDB's mongo shell. Everything you can write in mongo shell — you can write in Robomongo!

This is an early beta version of Robomongo, that we are publishing in a hope to validate usefulness of application. We really welcome your feedback! Please submit any issues and proposals to GitHub Issues.

Features

Full Power of MongoDB Shell

Robomongo embeds the same JavaScript engine (based on Mozilla SpiderMonkey), that powers MongoDB's mongo shell. It means that you can reuse your existing skills of MongoDB Shell in Robomongo!

Robomongo provides you with syntax highlighting, autocompletion, different view modes (text, tree, custom) and more.

With great power comes great responsibility. Robomongo will not stop you from executing "undesired" code. Be careful, as you do with MongoDB Shell!

Tip! Select any part of code and press Ctrl + Enter. Only selected code will be executed.

Multiple Shells

Open as many shells as you need. Every tab in Robomongo — is a MongoDB shell, fully isolated from each other.

You can have many opened shells for single MongoDB database, or many shells for many different databases.

Tip! Press Ctrl + T to open new shell, based on currenly opened.

Multiple Results

Robomongo executes your code in statement by statement way. That means that you will receive as many result as many statements you have.

This feature can assist you, for instance, when you would like to view and analyse documents side by side.

Tip! Press F10 to toggle results orientation from vertical to horizontal.

Autocompletion

Robomongo provides you with autocompletion for all objects (and thus functions) that are known by JavaScript runtime, including autocompletion for databases, collections and even your document objects.

To assist Robomongo autocompletion — execute your code. This will make your objects available to JavaScript runtime, and autocompletion will work even for your custom functions and documents.

Tip! To see code of any JavaScript function, just type its name and execute (Ctrl + Enter)

Articles

• UUID Support in Robomongo

Contribute

Please submit any issues, bugs and proposals via GitHub Issues:
https://github.com/paralect/robomongo/issues

Thank you for finding time to help us!

Credits

Robomongo would not be possible without great opensource projects:

• MongoDB
• Qt
• Boost
• Mozilla SpiderMonkey
• Esprima
• PCRE
• Scintilla and QScintilla
• QJson

Get in touch

Robomongo is maintained by Paralect and contributors. Get in touch with Dmitry, project maintainer: dima@paralect.com. 

[mssql]  숫자 앞에 0 으로 채우기, Replicate

-- 2013-9-2
select YEAR(getDate()), Month(getdate()), day(getdate())

-- 2013-09-02
select YEAR(getDate()), replicate('0',2 - len(Month(getdate()))) + cast(Month(getdate()) as varchar), replicate('0',2 - len(day(getdate()))) + cast(day(getdate()) as varchar)