Learn and Be Curious

Go

dev/Blockchain2017. 5. 21. 01:25

https://golang.org/doc/install?cm_mc_uid=42866394937514899237538&cm_mc_sid_50200000=1495296097



저작자표시

'dev > Blockchain' 카테고리의 다른 글

geth  (0) 2017.09.14
Ethereum mining at Linux (Ubuntu)  (0) 2017.06.28
개발 모드에서 스마트 컨트랙(체인코드) 개발  (0) 2017.05.21
Hyperledger Fabric Docker 이미지 받기  (0) 2017.05.21

vmware hyper-v 충돌

dev/etc2017. 5. 10. 00:58

http://stackoverflow.com/questions/39858200/vmware-workstation-and-device-credential-guard-are-not-compatible

저작자표시

'dev > etc' 카테고리의 다른 글

atom  (0) 2018.07.27
Designing Microservices using Spring Boot, Spring Cloud, Eureka and Zuul  (0) 2017.10.24
타이핑 교정  (0) 2017.04.25

mongodb GUI client

dev/NoSQL 모델링2017. 5. 9. 21:36

1. Tadpole



2. MonjaDB



3. mViewer



4. mongoHub



5. mongoVue



6. MongoExplorer



7. RockMongo



8. mongobooster

저작자표시

'dev > NoSQL 모델링' 카테고리의 다른 글

초간단 nasdaq 데이터분석  (0) 2017.04.27
정리  (0) 2017.01.26
카산드라  (0) 2017.01.25
NoSql 모델링 기법  (0) 2017.01.25
Shard Cluster  (1) 2017.01.25

초간단 nasdaq 데이터분석

dev/NoSQL 모델링2017. 4. 27. 21:40

[mongodb에서 Aggregation 방법]


 

 group

map / reduce

aggregate f/w

 map

 X

 O

 △

 reduce

 O

 O

O 

 분산집계 with shard

X 

 O

O 

실행결과

 document

-out collection

- document 

document 

 용도

online 

batch

o / b  



myung@JMYUNG C:\Users\myung
> mongod.exe --dbpath c:\data\db --port 27017



1. 복구

mongodump

- BSON형태로 저장

- 백업용도

- mongorestore로 복구


myung@JMYUNG C:\Users\myung
> mongorestore --host localhost c:\nasdaq_sample
2017-05-09T15:47:07.454+0900    preparing collections to restore from
2017-05-09T15:47:07.566+0900    reading metadata for nasdaq.stocks from c:\nasdaq_sample\nasdaq\stocks.metadata.json
2017-05-09T15:47:07.566+0900    reading metadata for nasdaq.symbols from c:\nasdaq_sample\nasdaq\symbols.metadata.json
2017-05-09T15:47:07.586+0900    restoring nasdaq.stocks from c:\nasdaq_sample\nasdaq\stocks.bson
2017-05-09T15:47:07.605+0900    restoring nasdaq.symbols from c:\nasdaq_sample\nasdaq\symbols.bson
2017-05-09T15:47:07.707+0900    no indexes to restore
2017-05-09T15:47:07.707+0900    finished restoring nasdaq.symbols (5960 documents)
2017-05-09T15:47:10.446+0900    [#.......................]  nasdaq.stocks  33.0MB/715MB  (4.6%)
2017-05-09T15:47:13.445+0900    [##......................]  nasdaq.stocks  72.7MB/715MB  (10.2%)
2017-05-09T15:47:16.447+0900    [###.....................]  nasdaq.stocks  107MB/715MB  (15.0%)
2017-05-09T15:47:19.445+0900    [####....................]  nasdaq.stocks  145MB/715MB  (20.3%)
2017-05-09T15:47:22.446+0900    [######..................]  nasdaq.stocks  181MB/715MB  (25.4%)
2017-05-09T15:47:25.446+0900    [#######.................]  nasdaq.stocks  219MB/715MB  (30.6%)
2017-05-09T15:47:28.445+0900    [########................]  nasdaq.stocks  256MB/715MB  (35.8%)
2017-05-09T15:47:31.446+0900    [#########...............]  nasdaq.stocks  290MB/715MB  (40.6%)
2017-05-09T15:47:34.446+0900    [##########..............]  nasdaq.stocks  327MB/715MB  (45.7%)
2017-05-09T15:47:37.453+0900    [############............]  nasdaq.stocks  358MB/715MB  (50.1%)
2017-05-09T15:47:40.446+0900    [#############...........]  nasdaq.stocks  390MB/715MB  (54.5%)
2017-05-09T15:47:43.446+0900    [##############..........]  nasdaq.stocks  424MB/715MB  (59.2%)
2017-05-09T15:47:46.445+0900    [###############.........]  nasdaq.stocks  462MB/715MB  (64.6%)
2017-05-09T15:47:49.445+0900    [################........]  nasdaq.stocks  498MB/715MB  (69.6%)
2017-05-09T15:47:52.445+0900    [##################......]  nasdaq.stocks  537MB/715MB  (75.1%)
2017-05-09T15:47:55.446+0900    [###################.....]  nasdaq.stocks  572MB/715MB  (80.0%)
2017-05-09T15:47:58.445+0900    [####################....]  nasdaq.stocks  610MB/715MB  (85.3%)
2017-05-09T15:48:01.445+0900    [#####################...]  nasdaq.stocks  642MB/715MB  (89.8%)
2017-05-09T15:48:04.450+0900    [######################..]  nasdaq.stocks  679MB/715MB  (94.9%)
2017-05-09T15:48:07.446+0900    [#######################.]  nasdaq.stocks  708MB/715MB  (99.0%)
2017-05-09T15:48:08.030+0900    [########################]  nasdaq.stocks  715MB/715MB  (100.0%)
2017-05-09T15:48:08.031+0900    no indexes to restore
2017-05-09T15:48:08.031+0900    finished restoring nasdaq.stocks (4308303 documents)
2017-05-09T15:48:08.031+0900    done




2. 조회


> db

nasdaq


> use nasdaq
switched to db nasdaq


> show collections
stocks
symbols


collection

- rdb의 테이블

- 스키마없음



> db.users.insert({ userid:"myung" , name:"myung je sang"})
WriteResult({ "nInserted" : 1 })
> db.user.find()
> db.users.find()
{ "_id" : ObjectId("59116e3b52ae922ad8a03686"), "userid" : "myung", "name" : "myung je sang" }
> db.users.insert({ userid:"myung" , name:"myung je sang"})
WriteResult({ "nInserted" : 1 })
> db.users.find()
{ "_id" : ObjectId("59116e3b52ae922ad8a03686"), "userid" : "myung", "name" : "myung je sang" }
{ "_id" : ObjectId("59116e5152ae922ad8a03687"), "userid" : "myung", "name" : "myung je sang" }
> db.users.insert({ userid:"myung2" , name:"myung je sang", gender:"man"})
WriteResult({ "nInserted" : 1 })
> db.users.find()
{ "_id" : ObjectId("59116e3b52ae922ad8a03686"), "userid" : "myung", "name" : "myung je sang" }
{ "_id" : ObjectId("59116e5152ae922ad8a03687"), "userid" : "myung", "name" : "myung je sang" }
{ "_id" : ObjectId("59116e6952ae922ad8a03688"), "userid" : "myung2", "name" : "myung je sang", "gender" : "man" }
> db.users.insert({ _id:1, userid:"myung3" , name:"myung je sang", gender:"man"})
WriteResult({ "nInserted" : 1 })
> db.users.find()
{ "_id" : ObjectId("59116e3b52ae922ad8a03686"), "userid" : "myung", "name" : "myung je sang" }
{ "_id" : ObjectId("59116e5152ae922ad8a03687"), "userid" : "myung", "name" : "myung je sang" }
{ "_id" : ObjectId("59116e6952ae922ad8a03688"), "userid" : "myung2", "name" : "myung je sang", "gender" : "man" }
{ "_id" : 1, "userid" : "myung3", "name" : "myung je sang", "gender" : "man" }
> db.users.insert({ _id:1, userid:"myung3" , name:"myung je sang", gender:"man"})
WriteResult({
        "nInserted" : 0,
        "writeError" : {
                "code" : 11000,
                "errmsg" : "E11000 duplicate key error collection: test.users index: _id_ dup key: { : 1.0 }"
        }
})
> db.users.save({ _id:1, userid:"myung3" , name:"myung je sang", gender:"man"})
WriteResult({ "nMatched" : 1, "nUpserted" : 0, "nModified" : 0 })
> db.users.save({ _id:1, userid:"myung4" , name:"myung je sang", gender:"man"})
WriteResult({ "nMatched" : 1, "nUpserted" : 0, "nModified" : 1 })
> db.users.find()
{ "_id" : ObjectId("59116e3b52ae922ad8a03686"), "userid" : "myung", "name" : "myung je sang" }
{ "_id" : ObjectId("59116e5152ae922ad8a03687"), "userid" : "myung", "name" : "myung je sang" }
{ "_id" : ObjectId("59116e6952ae922ad8a03688"), "userid" : "myung2", "name" : "myung je sang", "gender" : "man" }
{ "_id" : 1, "userid" : "myung4", "name" : "myung je sang", "gender" : "man" }

- 컬렉션단위의 조회성능이 더 좋음

- 인덱싱은 컬렉션 단위




> db.stocks.find()
{ "_id" : ObjectId("4d094f58c96767d7a0099d49"), "exchange" : "NASDAQ", "stock_symbol" : "AACC", "date" : "2008-03-07", "open" : 8.4, "high" : 8.75, "low" : 8.08, "close" : 8.55, "volume" : 275800, "adj close" : 8.55 }
{ "_id" : ObjectId("4d094f58c96767d7a0099d4a"), "exchange" : "NASDAQ", "stock_symbol" : "AACC", "date" : "2008-03-06", "open" : 9.03, "high" : 9.03, "low" : 8.41, "close" : 8.56, "volume" : 353600, "adj close" : 8.56 }
{ "_id" : ObjectId("4d094f58c96767d7a0099d4b"), "exchange" : "NASDAQ", "stock_symbol" : "AACC", "date" : "2008-03-05", "open" : 9.12, "high" : 9.17, "low" : 8.85, "close" : 9.12, "volume" : 156200, "adj close" : 9.12 }
{ "_id" : ObjectId("4d094f58c96767d7a0099d4c"), "exchange" : "NASDAQ", "stock_symbol" : "AACC", "date" : "2008-03-04", "open" : 9.05, "high" : 9.14, "low" : 8.73, "close" : 9.09, "volume" : 420700, "adj close" : 9.09 }
{ "_id" : ObjectId("4d094f58c96767d7a0099d4d"), "exchange" : "NASDAQ", "stock_symbol" : "AACC", "date" : "2008-03-03", "open" : 9.68, "high" : 9.69, "low" : 8.98, "close" : 9.15, "volume" : 407200, "adj close" : 9.15 }
{ "_id" : ObjectId("4d094f58c96767d7a0099d4e"), "exchange" : "NASDAQ", "stock_symbol" : "AACC", "date" : "2008-02-29", "open" : 9.52, "high" : 9.76, "low" : 9.25, "close" : 9.75, "volume" : 269400, "adj close" : 9.75 }
{ "_id" : ObjectId("4d094f58c96767d7a0099d4f"), "exchange" : "NASDAQ", "stock_symbol" : "AACC", "date" : "2008-02-28", "open" : 9.7, "high" : 10.1, "low" : 9.67, "close" : 9.7, "volume" : 150200, "adj close" : 9.7 }
{ "_id" : ObjectId("4d094f58c96767d7a0099d50"), "exchange" : "NASDAQ", "stock_symbol" : "AACC", "date" : "2008-02-27", "open" : 9.8, "high" : 10.25, "low" : 9.58, "close" : 9.76, "volume" : 190700, "adj close" : 9.76 }
{ "_id" : ObjectId("4d094f58c96767d7a0099d51"), "exchange" : "NASDAQ", "stock_symbol" : "AACC", "date" : "2008-02-26", "open" : 9.4, "high" : 9.94, "low" : 9.25, "close" : 9.91, "volume" : 205100, "adj close" : 9.91 }
{ "_id" : ObjectId("4d094f58c96767d7a0099d52"), "exchange" : "NASDAQ", "stock_symbol" : "AACC", "date" : "2008-02-25", "open" : 9.84, "high" : 10, "low" : 9.37, "close" : 9.79, "volume" : 352200, "adj close" : 9.79 }
{ "_id" : ObjectId("4d094f58c96767d7a0099d53"), "exchange" : "NASDAQ", "stock_symbol" : "AACC", "date" : "2008-02-22", "open" : 10.19, "high" : 10.19, "low" : 9.75, "close" : 10, "volume" : 305400, "adj close" : 10 }
{ "_id" : ObjectId("4d094f58c96767d7a0099d54"), "exchange" : "NASDAQ", "stock_symbol" : "AACC", "date" : "2008-02-21", "open" : 10.42, "high" : 10.53, "low" : 10.25, "close" : 10.42, "volume" : 126100, "adj close" : 10.42 }
{ "_id" : ObjectId("4d094f58c96767d7a0099d55"), "exchange" : "NASDAQ", "stock_symbol" : "AACC", "date" : "2008-02-20", "open" : 9.91, "high" : 10.49, "low" : 9.91, "close" : 10.33, "volume" : 99700, "adj close" : 10.33 }
{ "_id" : ObjectId("4d094f58c96767d7a0099d56"), "exchange" : "NASDAQ", "stock_symbol" : "AACC", "date" : "2008-02-19", "open" : 10.31, "high" : 10.4, "low" : 9.94, "close" : 10.01, "volume" : 170100, "adj close" : 10.01 }
{ "_id" : ObjectId("4d094f58c96767d7a0099d57"), "exchange" : "NASDAQ", "stock_symbol" : "AACC", "date" : "2008-02-15", "open" : 10.08, "high" : 10.29, "low" : 9.93, "close" : 10.15, "volume" : 259700, "adj close" : 10.15 }
{ "_id" : ObjectId("4d094f58c96767d7a0099d58"), "exchange" : "NASDAQ", "stock_symbol" : "AACC", "date" : "2008-02-14", "open" : 9.98, "high" : 10.84, "low" : 9.98, "close" : 10.13, "volume" : 461300, "adj close" : 10.13 }
{ "_id" : ObjectId("4d094f58c96767d7a0099d59"), "exchange" : "NASDAQ", "stock_symbol" : "AACC", "date" : "2008-02-13", "open" : 9.64, "high" : 9.98, "low" : 9.57, "close" : 9.98, "volume" : 78700, "adj close" : 9.98 }
{ "_id" : ObjectId("4d094f58c96767d7a0099d5a"), "exchange" : "NASDAQ", "stock_symbol" : "AACC", "date" : "2008-02-12", "open" : 9.53, "high" : 9.62, "low" : 9.46, "close" : 9.53, "volume" : 60500, "adj close" : 9.53 }
{ "_id" : ObjectId("4d094f58c96767d7a0099d5b"), "exchange" : "NASDAQ", "stock_symbol" : "AACC", "date" : "2008-02-11", "open" : 9.51, "high" : 9.62, "low" : 9.17, "close" : 9.46, "volume" : 225800, "adj close" : 9.46 }
{ "_id" : ObjectId("4d094f58c96767d7a0099d5c"), "exchange" : "NASDAQ", "stock_symbol" : "AACC", "date" : "2008-02-08", "open" : 9.87, "high" : 9.99, "low" : 9.48, "close" : 9.49, "volume" : 114800, "adj close" : 9.49 }








> db.stocks.find({"stock_symbol": "GOOG"}).sort({date:1}).explain("executionStats")
{
        "queryPlanner" : {
                "plannerVersion" : 1,
                "namespace" : "nasdaq.stocks",
                "indexFilterSet" : false,
                "parsedQuery" : {
                        "stock_symbol" : {
                                "$eq" : "GOOG"
                        }
                },
                "winningPlan" : {
                        "stage" : "SORT",
                        "sortPattern" : {
                                "date" : 1
                        },
                        "inputStage" : {
                                "stage" : "SORT_KEY_GENERATOR",
                                "inputStage" : {
                                        "stage" : "COLLSCAN",
                                        "filter" : {
                                                "stock_symbol" : {
                                                        "$eq" : "GOOG"
                                                }
                                        },
                                        "direction" : "forward"
                                }
                        }
                },
                "rejectedPlans" : [ ]
        },
        "executionStats" : {
                "executionSuccess" : true,
                "nReturned" : 894,
                "executionTimeMillis" : 2051,
                "totalKeysExamined" : 0,
                "totalDocsExamined" : 4308303,
                "executionStages" : {
                        "stage" : "SORT",
                        "nReturned" : 894,
                        "executionTimeMillisEstimate" : 1711,
                        "works" : 4309201,
                        "advanced" : 894,
                        "needTime" : 4308306,
                        "needYield" : 0,
                        "saveState" : 33710,
                        "restoreState" : 33710,
                        "isEOF" : 1,
                        "invalidates" : 0,
                        "sortPattern" : {
                                "date" : 1
                        },
                        "memUsage" : 163584,
                        "memLimit" : 33554432,
                        "inputStage" : {
                                "stage" : "SORT_KEY_GENERATOR",
                                "nReturned" : 894,
                                "executionTimeMillisEstimate" : 1650,
                                "works" : 4308306,
                                "advanced" : 894,
                                "needTime" : 4307411,
                                "needYield" : 0,
                                "saveState" : 33710,
                                "restoreState" : 33710,
                                "isEOF" : 1,
                                "invalidates" : 0,
                                "inputStage" : {
                                        "stage" : "COLLSCAN",
                                        "filter" : {
                                                "stock_symbol" : {
                                                        "$eq" : "GOOG"
                                                }
                                        },
                                        "nReturned" : 894,
                                        "executionTimeMillisEstimate" : 1608,
                                        "works" : 4308305,
                                        "advanced" : 894,
                                        "needTime" : 4307410,
                                        "needYield" : 0,
                                        "saveState" : 33710,
                                        "restoreState" : 33710,
                                        "isEOF" : 1,
                                        "invalidates" : 0,
                                        "direction" : "forward",
                                        "docsExamined" : 4308303
                                }
                        }
                }
        },
        "serverInfo" : {
                "host" : "jmyung",
                "port" : 27017,
                "version" : "3.4.4",
                "gitVersion" : "888390515874a9debd1b6c5d36559ca86b44babd"
        },
        "ok" : 1
}





------------------------------------------------------------------------------------------------------



> db.stocks.count()
4308303
> db.stocks.find()
{ "_id" : ObjectId("4d094f58c96767d7a0099d49"), "exchange" : "NASDAQ", "stock_symbol" : "AACC", "date" : "2008-03-07", "open" : 8.4, "high" : 8.75, "low" : 8.08, "close" : 8.55, "volume" : 275800, "adj close" : 8.55 }
{ "_id" : ObjectId("4d094f58c96767d7a0099d4a"), "exchange" : "NASDAQ", "stock_symbol" : "AACC", "date" : "2008-03-06", "open" : 9.03, "high" : 9.03, "low" : 8.41, "close" : 8.56, "volume" : 353600, "adj close" : 8.56 }
{ "_id" : ObjectId("4d094f58c96767d7a0099d4b"), "exchange" : "NASDAQ", "stock_symbol" : "AACC", "date" : "2008-03-05", "open" : 9.12, "high" : 9.17, "low" : 8.85, "close" : 9.12, "volume" : 156200, "adj close" : 9.12 }
{ "_id" : ObjectId("4d094f58c96767d7a0099d4c"), "exchange" : "NASDAQ", "stock_symbol" : "AACC", "date" : "2008-03-04", "open" : 9.05, "high" : 9.14, "low" : 8.73, "close" : 9.09, "volume" : 420700, "adj close" : 9.09 }
{ "_id" : ObjectId("4d094f58c96767d7a0099d4d"), "exchange" : "NASDAQ", "stock_symbol" : "AACC", "date" : "2008-03-03", "open" : 9.68, "high" : 9.69, "low" : 8.98, "close" : 9.15, "volume" : 407200, "adj close" : 9.15 }
{ "_id" : ObjectId("4d094f58c96767d7a0099d4e"), "exchange" : "NASDAQ", "stock_symbol" : "AACC", "date" : "2008-02-29", "open" : 9.52, "high" : 9.76, "low" : 9.25, "close" : 9.75, "volume" : 269400, "adj close" : 9.75 }
{ "_id" : ObjectId("4d094f58c96767d7a0099d4f"), "exchange" : "NASDAQ", "stock_symbol" : "AACC", "date" : "2008-02-28", "open" : 9.7, "high" : 10.1, "low" : 9.67, "close" : 9.7, "volume" : 150200, "adj close" : 9.7 }
{ "_id" : ObjectId("4d094f58c96767d7a0099d50"), "exchange" : "NASDAQ", "stock_symbol" : "AACC", "date" : "2008-02-27", "open" : 9.8, "high" : 10.25, "low" : 9.58, "close" : 9.76, "volume" : 190700, "adj close" : 9.76 }
{ "_id" : ObjectId("4d094f58c96767d7a0099d51"), "exchange" : "NASDAQ", "stock_symbol" : "AACC", "date" : "2008-02-26", "open" : 9.4, "high" : 9.94, "low" : 9.25, "close" : 9.91, "volume" : 205100, "adj close" : 9.91 }
{ "_id" : ObjectId("4d094f58c96767d7a0099d52"), "exchange" : "NASDAQ", "stock_symbol" : "AACC", "date" : "2008-02-25", "open" : 9.84, "high" : 10, "low" : 9.37, "close" : 9.79, "volume" : 352200, "adj close" : 9.79 }
{ "_id" : ObjectId("4d094f58c96767d7a0099d53"), "exchange" : "NASDAQ", "stock_symbol" : "AACC", "date" : "2008-02-22", "open" : 10.19, "high" : 10.19, "low" : 9.75, "close" : 10, "volume" : 305400, "adj close" : 10 }
{ "_id" : ObjectId("4d094f58c96767d7a0099d54"), "exchange" : "NASDAQ", "stock_symbol" : "AACC", "date" : "2008-02-21", "open" : 10.42, "high" : 10.53, "low" : 10.25, "close" : 10.42, "volume" : 126100, "adj close" : 10.42 }
{ "_id" : ObjectId("4d094f58c96767d7a0099d55"), "exchange" : "NASDAQ", "stock_symbol" : "AACC", "date" : "2008-02-20", "open" : 9.91, "high" : 10.49, "low" : 9.91, "close" : 10.33, "volume" : 99700, "adj close" : 10.33 }
{ "_id" : ObjectId("4d094f58c96767d7a0099d56"), "exchange" : "NASDAQ", "stock_symbol" : "AACC", "date" : "2008-02-19", "open" : 10.31, "high" : 10.4, "low" : 9.94, "close" : 10.01, "volume" : 170100, "adj close" : 10.01 }
{ "_id" : ObjectId("4d094f58c96767d7a0099d57"), "exchange" : "NASDAQ", "stock_symbol" : "AACC", "date" : "2008-02-15", "open" : 10.08, "high" : 10.29, "low" : 9.93, "close" : 10.15, "volume" : 259700, "adj close" : 10.15 }
{ "_id" : ObjectId("4d094f58c96767d7a0099d58"), "exchange" : "NASDAQ", "stock_symbol" : "AACC", "date" : "2008-02-14", "open" : 9.98, "high" : 10.84, "low" : 9.98, "close" : 10.13, "volume" : 461300, "adj close" : 10.13 }
{ "_id" : ObjectId("4d094f58c96767d7a0099d59"), "exchange" : "NASDAQ", "stock_symbol" : "AACC", "date" : "2008-02-13", "open" : 9.64, "high" : 9.98, "low" : 9.57, "close" : 9.98, "volume" : 78700, "adj close" : 9.98 }
{ "_id" : ObjectId("4d094f58c96767d7a0099d5a"), "exchange" : "NASDAQ", "stock_symbol" : "AACC", "date" : "2008-02-12", "open" : 9.53, "high" : 9.62, "low" : 9.46, "close" : 9.53, "volume" : 60500, "adj close" : 9.53 }
{ "_id" : ObjectId("4d094f58c96767d7a0099d5b"), "exchange" : "NASDAQ", "stock_symbol" : "AACC", "date" : "2008-02-11", "open" : 9.51, "high" : 9.62, "low" : 9.17, "close" : 9.46, "volume" : 225800, "adj close" : 9.46 }
{ "_id" : ObjectId("4d094f58c96767d7a0099d5c"), "exchange" : "NASDAQ", "stock_symbol" : "AACC", "date" : "2008-02-08", "open" : 9.87, "high" : 9.99, "low" : 9.48, "close" : 9.49, "volume" : 114800, "adj close" : 9.49 }
Type "it" for more
> db.stocks.count({stock_symbol:"AACC"})
1016
> db.stocks.count({stock_symbol:"AACC", close:{$lt: 300}})
1016
> db.stocks.count({stock_symbol:"GOOG", close:{$lt: 300}})
262
> db.stocks.find({stock_symbol:"GOOG", close:{$lt: 300}})
{ "_id" : ObjectId("4d094f7ec96767d7a02a0d4f"), "exchange" : "NASDAQ", "stock_symbol" : "GOOG", "date" : "2005-10-14", "open" : 299.9, "high" : 300.23, "low" : 292.54, "close" : 296.14, "volume" : 8519100, "adj close" : 296.14 }
{ "_id" : ObjectId("4d094f7ec96767d7a02a0d50"), "exchange" : "NASDAQ", "stock_symbol" : "GOOG", "date" : "2005-10-13", "open" : 302, "high" : 302, "low" : 290.68, "close" : 297.44, "volume" : NumberLong(10567700), "adj close" : 297.44 }
{ "_id" : ObjectId("4d094f7ec96767d7a02a0d68"), "exchange" : "NASDAQ", "stock_symbol" : "GOOG", "date" : "2005-09-09", "open" : 297.28, "high" : 299.1, "low" : 296.56, "close" : 299.09, "volume" : 4390500, "adj close" : 299.09 }
{ "_id" : ObjectId("4d094f7ec96767d7a02a0d69"), "exchange" : "NASDAQ", "stock_symbol" : "GOOG", "date" : "2005-09-08", "open" : 294.83, "high" : 299.28, "low" : 293.36, "close" : 295.39, "volume" : 6613300, "adj close" : 295.39 }
{ "_id" : ObjectId("4d094f7ec96767d7a02a0d6a"), "exchange" : "NASDAQ", "stock_symbol" : "GOOG", "date" : "2005-09-07", "open" : 285.89, "high" : 295.5, "low" : 285.28, "close" : 294.87, "volume" : 7499500, "adj close" : 294.87 }
{ "_id" : ObjectId("4d094f7ec96767d7a02a0d6b"), "exchange" : "NASDAQ", "stock_symbol" : "GOOG", "date" : "2005-09-06", "open" : 289, "high" : 289.39, "low" : 286.8, "close" : 287.11, "volume" : 4212300, "adj close" : 287.11 }
{ "_id" : ObjectId("4d094f7ec96767d7a02a0d6c"), "exchange" : "NASDAQ", "stock_symbol" : "GOOG", "date" : "2005-09-02", "open" : 286.51, "high" : 289.99, "low" : 286.44, "close" : 288.45, "volume" : 3434500, "adj close" : 288.45 }
{ "_id" : ObjectId("4d094f7ec96767d7a02a0d6d"), "exchange" : "NASDAQ", "stock_symbol" : "GOOG", "date" : "2005-09-01", "open" : 285.91, "high" : 287.5, "low" : 285, "close" : 286.25, "volume" : 2742100, "adj close" : 286.25 }
{ "_id" : ObjectId("4d094f7ec96767d7a02a0d6e"), "exchange" : "NASDAQ", "stock_symbol" : "GOOG", "date" : "2005-08-31", "open" : 288.23, "high" : 288.5, "low" : 284.36, "close" : 286, "volume" : 5034000, "adj close" : 286 }
{ "_id" : ObjectId("4d094f7ec96767d7a02a0d6f"), "exchange" : "NASDAQ", "stock_symbol" : "GOOG", "date" : "2005-08-30", "open" : 287.39, "high" : 289.51, "low" : 285.88, "close" : 287.27, "volume" : 4792000, "adj close" : 287.27 }
{ "_id" : ObjectId("4d094f7ec96767d7a02a0d70"), "exchange" : "NASDAQ", "stock_symbol" : "GOOG", "date" : "2005-08-29", "open" : 282.24, "high" : 289.12, "low" : 282.24, "close" : 288.45, "volume" : 5903000, "adj close" : 288.45 }
{ "_id" : ObjectId("4d094f7ec96767d7a02a0d71"), "exchange" : "NASDAQ", "stock_symbol" : "GOOG", "date" : "2005-08-26", "open" : 283.48, "high" : 285.02, "low" : 282.66, "close" : 283.58, "volume" : 3755300, "adj close" : 283.58 }
{ "_id" : ObjectId("4d094f7ec96767d7a02a0d72"), "exchange" : "NASDAQ", "stock_symbol" : "GOOG", "date" : "2005-08-25", "open" : 282.55, "high" : 284, "low" : 279.97, "close" : 282.59, "volume" : 4376600, "adj close" : 282.59 }
{ "_id" : ObjectId("4d094f7ec96767d7a02a0d73"), "exchange" : "NASDAQ", "stock_symbol" : "GOOG", "date" : "2005-08-24", "open" : 277.57, "high" : 284.75, "low" : 276.45, "close" : 282.57, "volume" : 8593100, "adj close" : 282.57 }
{ "_id" : ObjectId("4d094f7ec96767d7a02a0d74"), "exchange" : "NASDAQ", "stock_symbol" : "GOOG", "date" : "2005-08-23", "open" : 276.16, "high" : 279.74, "low" : 274.12, "close" : 279.58, "volume" : 5821700, "adj close" : 279.58 }
{ "_id" : ObjectId("4d094f7ec96767d7a02a0d75"), "exchange" : "NASDAQ", "stock_symbol" : "GOOG", "date" : "2005-08-22", "open" : 281.24, "high" : 281.47, "low" : 273.35, "close" : 274.01, "volume" : 6813000, "adj close" : 274.01 }
{ "_id" : ObjectId("4d094f7ec96767d7a02a0d76"), "exchange" : "NASDAQ", "stock_symbol" : "GOOG", "date" : "2005-08-19", "open" : 280.99, "high" : 281.45, "low" : 279.62, "close" : 280, "volume" : 5542900, "adj close" : 280 }
{ "_id" : ObjectId("4d094f7ec96767d7a02a0d77"), "exchange" : "NASDAQ", "stock_symbol" : "GOOG", "date" : "2005-08-18", "open" : 275.91, "high" : 280.5, "low" : 275, "close" : 279.99, "volume" : NumberLong(11872800), "adj close" : 279.99 }
{ "_id" : ObjectId("4d094f7ec96767d7a02a0d78"), "exchange" : "NASDAQ", "stock_symbol" : "GOOG", "date" : "2005-08-17", "open" : 285.51, "high" : 286.57, "low" : 284, "close" : 285.1, "volume" : 3883300, "adj close" : 285.1 }
{ "_id" : ObjectId("4d094f7ec96767d7a02a0d79"), "exchange" : "NASDAQ", "stock_symbol" : "GOOG", "date" : "2005-08-16", "open" : 284.88, "high" : 287.79, "low" : 283.34, "close" : 285.65, "volume" : 7109200, "adj close" : 285.65 }
Type "it" for more


> db.stocks.find({stock_symbol:"GOOG", close:{$gt: 300}})
{ "_id" : ObjectId("4d094f7ec96767d7a02a0af6"), "exchange" : "NASDAQ", "stock_symbol" : "GOOG", "date" : "2008-03-07", "open" : 428.88, "high" : 440, "low" : 426.24, "close" : 433.35, "volume" : 8071800, "adj close" : 433.35 }
{ "_id" : ObjectId("4d094f7ec96767d7a02a0af7"), "exchange" : "NASDAQ", "stock_symbol" : "GOOG", "date" : "2008-03-06", "open" : 447.69, "high" : 453.3, "low" : 431.18, "close" : 432.7, "volume" : 7470100, "adj close" : 432.7 }
{ "_id" : ObjectId("4d094f7ec96767d7a02a0af8"), "exchange" : "NASDAQ", "stock_symbol" : "GOOG", "date" : "2008-03-05", "open" : 445.25, "high" : 454.17, "low" : 444, "close" : 447.7, "volume" : 7436600, "adj close" : 447.7 }
{ "_id" : ObjectId("4d094f7ec96767d7a02a0af9"), "exchange" : "NASDAQ", "stock_symbol" : "GOOG", "date" : "2008-03-04", "open" : 450.95, "high" : 453.36, "low" : 435.78, "close" : 444.6, "volume" : NumberLong(13621700), "adj close" : 444.6 }
{ "_id" : ObjectId("4d094f7ec96767d7a02a0afa"), "exchange" : "NASDAQ", "stock_symbol" : "GOOG", "date" : "2008-03-03", "open" : 471.51, "high" : 472.72, "low" : 450.11, "close" : 457.02, "volume" : 7554500, "adj close" : 457.02 }
{ "_id" : ObjectId("4d094f7ec96767d7a02a0afb"), "exchange" : "NASDAQ", "stock_symbol" : "GOOG", "date" : "2008-02-29", "open" : 471.87, "high" : 479.74, "low" : 464.65, "close" : 471.18, "volume" : 9425400, "adj close" : 471.18 }
{ "_id" : ObjectId("4d094f7ec96767d7a02a0afc"), "exchange" : "NASDAQ", "stock_symbol" : "GOOG", "date" : "2008-02-28", "open" : 470.5, "high" : 479.09, "low" : 467.36, "close" : 475.39, "volume" : 6586900, "adj close" : 475.39 }
{ "_id" : ObjectId("4d094f7ec96767d7a02a0afd"), "exchange" : "NASDAQ", "stock_symbol" : "GOOG", "date" : "2008-02-27", "open" : 460.13, "high" : 475.49, "low" : 459.64, "close" : 472.86, "volume" : NumberLong(10121900), "adj close" : 472.86 }
{ "_id" : ObjectId("4d094f7ec96767d7a02a0afe"), "exchange" : "NASDAQ", "stock_symbol" : "GOOG", "date" : "2008-02-26", "open" : 461.2, "high" : 466.47, "low" : 446.85, "close" : 464.19, "volume" : NumberLong(23287300), "adj close" : 464.19 }
{ "_id" : ObjectId("4d094f7ec96767d7a02a0aff"), "exchange" : "NASDAQ", "stock_symbol" : "GOOG", "date" : "2008-02-25", "open" : 505.95, "high" : 506.5, "low" : 485.74, "close" : 486.44, "volume" : 8350800, "adj close" : 486.44 }
{ "_id" : ObjectId("4d094f7ec96767d7a02a0b00"), "exchange" : "NASDAQ", "stock_symbol" : "GOOG", "date" : "2008-02-22", "open" : 502.06, "high" : 509, "low" : 497.55, "close" : 507.8, "volume" : 5515900, "adj close" : 507.8 }
{ "_id" : ObjectId("4d094f7ec96767d7a02a0b01"), "exchange" : "NASDAQ", "stock_symbol" : "GOOG", "date" : "2008-02-21", "open" : 512.85, "high" : 513.21, "low" : 499.5, "close" : 502.86, "volume" : 5677800, "adj close" : 502.86 }
{ "_id" : ObjectId("4d094f7ec96767d7a02a0b02"), "exchange" : "NASDAQ", "stock_symbol" : "GOOG", "date" : "2008-02-20", "open" : 503.51, "high" : 511.01, "low" : 498.82, "close" : 509, "volume" : 6662200, "adj close" : 509 }
{ "_id" : ObjectId("4d094f7ec96767d7a02a0b03"), "exchange" : "NASDAQ", "stock_symbol" : "GOOG", "date" : "2008-02-19", "open" : 534.94, "high" : 535.06, "low" : 506.5, "close" : 508.95, "volume" : 6350400, "adj close" : 508.95 }
{ "_id" : ObjectId("4d094f7ec96767d7a02a0b04"), "exchange" : "NASDAQ", "stock_symbol" : "GOOG", "date" : "2008-02-15", "open" : 528.31, "high" : 532.66, "low" : 524.33, "close" : 529.64, "volume" : 5240100, "adj close" : 529.64 }
{ "_id" : ObjectId("4d094f7ec96767d7a02a0b05"), "exchange" : "NASDAQ", "stock_symbol" : "GOOG", "date" : "2008-02-14", "open" : 538.35, "high" : 541.04, "low" : 531, "close" : 532.25, "volume" : 6476700, "adj close" : 532.25 }
{ "_id" : ObjectId("4d094f7ec96767d7a02a0b06"), "exchange" : "NASDAQ", "stock_symbol" : "GOOG", "date" : "2008-02-13", "open" : 522.5, "high" : 534.99, "low" : 518.69, "close" : 534.62, "volume" : 6624700, "adj close" : 534.62 }
{ "_id" : ObjectId("4d094f7ec96767d7a02a0b07"), "exchange" : "NASDAQ", "stock_symbol" : "GOOG", "date" : "2008-02-12", "open" : 523.39, "high" : 530.6, "low" : 513.03, "close" : 518.09, "volume" : 6662300, "adj close" : 518.09 }
{ "_id" : ObjectId("4d094f7ec96767d7a02a0b08"), "exchange" : "NASDAQ", "stock_symbol" : "GOOG", "date" : "2008-02-11", "open" : 520.52, "high" : 523.71, "low" : 513.4, "close" : 521.16, "volume" : 5826000, "adj close" : 521.16 }
{ "_id" : ObjectId("4d094f7ec96767d7a02a0b09"), "exchange" : "NASDAQ", "stock_symbol" : "GOOG", "date" : "2008-02-08", "open" : 509.41, "high" : 517.73, "low" : 508.7, "close" : 516.69, "volume" : 6828900, "adj close" : 516.69 }
Type "it" for more
>



3. 분석


db.stocks.distinct("stock_symbol", {close: {$gt:300}})


GO로 시작하는 종목명의 2006년 한해동안 평균종가와 최고종가


3-1. group함수이용

10000개 이상 처리 안됨 (10000개 미만은 m/r보다 좋은 선택)



> db.stocks.group({
... key : { stock_symbol : true },
... cond : { stock_symbol : /^GO/,
...          date : {$gte : '2006-01-01', $lte : '2016-12-31'}
...        },
... reduce : function(doc,prev) {
...        if (doc.close > prev.maxClose)
...           prev.maxClose = doc.close;
...        prev.sum += doc.close;
...        prev.count++;
... },
... initial : {sum:0, count:0, maxClose:0},
... finalize : function(prev) {
...        prev.avg = prev.sum / prev.count;
...        prev.max = prev.maxClose;
...        delete prev.maxClose;
...        delete prev.sum;
...        delete prev.count;
... }
... })
[
        {
                "stock_symbol" : "GOAM",
                "avg" : 5.132883211678831,
                "max" : 10.3
        },
        {
                "stock_symbol" : "GOLD",
                "avg" : 25.65408759124087,
                "max" : 55.65
        },
        {
                "stock_symbol" : "GOLF",
                "avg" : 7.4655319148936155,
                "max" : 11.49
        },
        {
                "stock_symbol" : "GOOD",
                "avg" : 19.049215328467145,
                "max" : 22.19
        },
        {
                "stock_symbol" : "GOODO",
                "avg" : 21.802142857142854,
                "max" : 22.45
        },
        {
                "stock_symbol" : "GOODP",
                "avg" : 24.28254641909813,
                "max" : 26.81
        },
        {
                "stock_symbol" : "GOOG",
                "avg" : 480.9729379562046,
                "max" : 741.79
        },
        {
                "stock_symbol" : "GORX",
                "avg" : 3.8033941605839385,
                "max" : 4.88
        }
]






저작자표시

'dev > NoSQL 모델링' 카테고리의 다른 글

mongodb GUI client  (0) 2017.05.09
정리  (0) 2017.01.26
카산드라  (0) 2017.01.25
NoSql 모델링 기법  (0) 2017.01.25
Shard Cluster  (1) 2017.01.25

타이핑 교정

dev/etc2017. 4. 25. 14:13

http://www.speedcoder.net/122


Ruby, C++, Python 등 다양한 언어별로 실제 코딩할 때의 영문 타이핑
손가락 위치를 교정받을 수 있습니다.

저작자표시

'dev > etc' 카테고리의 다른 글

atom  (0) 2018.07.27
Designing Microservices using Spring Boot, Spring Cloud, Eureka and Zuul  (0) 2017.10.24
vmware hyper-v 충돌  (0) 2017.05.10

lorem ipsum

dev2017. 4. 13. 00:51

로렘 입숨(lorem ipsum; 줄여서 립숨, lipsum)은 출판이나 그래픽 디자인 분야에서 폰트, 타이포그래피, 레이아웃 같은 그래픽 요소나 시각적 연출을 보여줄 때 사용하는 표준 채우기 텍스트로, 최종 결과물에 들어가는 실제적인 문장 내용이 채워지기 전에 시각 디자인 프로젝트 모형의 채움 글로도 이용된다. 이런 용도로 사용할 때 로렘 입숨을 그리킹(greeking)이라고도 부르며, 때로 로렘 입숨은 공간만 차지하는 무언가를 지칭하는 용어로도 사용된다.

로렘 입숨은 전통 라틴어와 닮은 점 때문에 종종 호기심을 유발하기도 하지만 그 이상의 의미를 담지는 않는다. 문서에서 텍스트가 보이면 사람들은 전체적인 프레젠테이션보다는 텍스트에 담긴 뜻에 집중하는 경향이 있어서 출판사들은 서체나 디자인을 보일 때는 프레젠테이션 자체에 초점을 맞추기 위해 로렘 입숨을 사용한다.

로렘 입숨은 영어에서 사용하는 문자들의 전형적인 분포에 근접하다고도 하는데, 이 점 때문에 프레젠테이션으로 초점을 이동하는 데에도 도움을 준다.

웹사이트 디자인의 제안에서 내용보다는 시각적 요소에 좀 더 초점을 맞추기 위해 로렘 입숨을 사용한 예

가장 일반적인 로렘 입숨 텍스트는 다음과 같다.

저작자표시

'dev' 카테고리의 다른 글

nexus ubunto  (0) 2017.03.27
ISDP  (0) 2017.02.02
Anti-OOP: if를 피하는 법  (0) 2017.02.01
XML vs JSON  (0) 2017.01.26
TDD 무엇을 테스트 할 것인가?  (0) 2017.01.23

faro sql script

dev/RDB2017. 4. 3. 00:16

@ddl/oracle/ship/DROP_TB_SHP.sql
@ddl/oracle/DROP_TB_FR.sql
@ddl/oracle/DROP_TB_SAM.sql
@ddl/oracle/TB_FR_CODE_INFO.sql
@initdata/oracle/TB_FR_CODE_INFO_INITDATA.sql
@ddl/oracle/TB_FR_DEPT_INFO.sql
@initdata/oracle/TB_FR_DEPT_INFO_INITDATA.sql
@ddl/oracle/TB_FR_FILE_INFO.sql
@initdata/oracle/TB_FR_FILE_INFO_INITDATA.sql
@ddl/oracle/TB_FR_LANGUAGE_INFO.sql
@initdata/oracle/TB_FR_LANGUAGE_INFO_INITDATA.sql
@ddl/oracle/TB_FR_MENU_INFO.sql
@initdata/oracle/TB_FR_MENU_INFO_INITDATA.sql
@ddl/oracle/TB_FR_MESSAGE_INFO.sql
@initdata/oracle/TB_FR_MESSAGE_INFO_INITDATA.sql
@ddl/oracle/TB_FR_ROLE_INFO.sql
@initdata/oracle/TB_FR_ROLE_INFO_INITDATA.sql
@ddl/oracle/TB_FR_SYS_IMPERSON_LOG.sql
@initdata/oracle/TB_FR_SYS_IMPERSON_LOG_INITDATA.sql
@ddl/oracle/TB_FR_SYS_LOG.sql
@initdata/oracle/TB_FR_SYS_LOG_INITDATA.sql
@ddl/oracle/TB_FR_TZ_INFO.sql
@initdata/oracle/TB_FR_TZ_INFO_INITDATA.sql
@ddl/oracle/TB_FR_WORKGROUP_INFO.sql
@initdata/oracle/TB_FR_WORKGROUP_INFO_INITDATA.sql
@ddl/oracle/TB_FR_CODE_MULTI_LANG_INFO.sql
@initdata/oracle/TB_FR_CODE_MULTI_LANG_INFO_INITDATA.sql
@ddl/oracle/TB_FR_FILE_ATTCH_INFO.sql
@initdata/oracle/TB_FR_FILE_ATTCH_INFO_INITDATA.sql
@ddl/oracle/TB_FR_MENU_MULTI_LANG_INFO.sql
@initdata/oracle/TB_FR_MENU_MULTI_LANG_INFO_INITDATA.sql
@ddl/oracle/TB_FR_MENU_PAGE_INFO.sql
@initdata/oracle/TB_FR_MENU_PAGE_INFO_INITDATA.sql
@ddl/oracle/TB_FR_MULTI_MESSAGE_INFO.sql
@initdata/oracle/TB_FR_MULTI_MESSAGE_INFO_INITDATA.sql
@ddl/oracle/TB_FR_USER_INFO.sql
@initdata/oracle/TB_FR_USER_INFO_INITDATA.sql
@ddl/oracle/TB_FR_WORKGROUP_ROLE_MAP.sql
@initdata/oracle/TB_FR_WORKGROUP_ROLE_MAP_INITDATA.sql
@ddl/oracle/TB_FR_ADMIN_IP_ADDR_INFO.sql
@initdata/oracle/TB_FR_ADMIN_IP_ADDR_INFO_INITDATA.sql
@ddl/oracle/TB_FR_DEPT_USER_MAP.sql
@initdata/oracle/TB_FR_DEPT_USER_MAP_INITDATA.sql
@ddl/oracle/TB_FR_MENU_AUTH_MAP.sql
@initdata/oracle/TB_FR_MENU_AUTH_MAP_INITDATA.sql
@ddl/oracle/TB_FR_USER_ROLE_MAP.sql
@initdata/oracle/TB_FR_USER_ROLE_MAP_INITDATA.sql
@ddl/oracle/TB_FR_WORKGROUP_USER_MAP.sql
@initdata/oracle/TB_FR_WORKGROUP_USER_MAP_INITDATA.sql
@initdata/oracle/ship/TB_FR_MENU_INFO_INITDATA.sql
@initdata/oracle/ship/TB_FR_MENU_MULTI_LANG_INFO_INITDATA.sql
@initdata/oracle/ship/TB_FR_MENU_AUTH_MAP_INITDATA.sql
@initdata/oracle/ship/TB_FR_MENU_PAGE_INFO_INITDATA.sql
@initdata/oracle/ship/TB_FR_MESSAGE_INFO_INITDATA.sql
@initdata/oracle/ship/TB_FR_MULTI_MESSAGE_INFO_INITDATA.sql
@initdata/oracle/ship/TB_FR_CODE_INFO_INITDATA.sql
@initdata/oracle/ship/TB_FR_CODE_MULTI_LANG_INFO_INITDATA.sql
@initdata/oracle/ship/TB_FR_USER_INFO_INITDATA.sql
@initdata/oracle/ship/TB_FR_DEPT_USER_MAP_INITDATA.sql
@initdata/oracle/ship/TB_FR_WORKGROUP_USER_MAP_INITDATA.sql
@ddl/oracle/ship/TB_SHP_CUSTOM_GRP_INFO.sql
@initdata/oracle/ship/TB_SHP_CUSTOM_GRP_INFO_INITDATA.sql
@ddl/oracle/ship/TB_SHP_FILE_DLD_LOG.sql
@initdata/oracle/ship/TB_SHP_FILE_DLD_LOG_INITDATA.sql
@ddl/oracle/ship/TB_SHP_MENU_LOG_INFO.sql
@initdata/oracle/ship/TB_SHP_MENU_LOG_INFO_INITDATA.sql
@ddl/oracle/ship/TB_SHP_TERMS_AGREE_INFO.sql
@initdata/oracle/ship/TB_SHP_TERMS_AGREE_INFO_INITDATA.sql
@ddl/oracle/ship/TB_SHP_SITE_INFO.sql
@initdata/oracle/ship/TB_SHP_SITE_INFO_INITDATA.sql
@ddl/oracle/ship/TB_SHP_LOB_FILE.sql
@ddl/oracle/ship/TB_SHP_DEFAULT_APPROVAL.sql
@ddl/oracle/ship/TB_SHP_ESB_USER.sql
@initdata/oracle/ship/TB_SHP_ESB_USER_INITDATA.sql
@ddl/oracle/ship/TB_SHP_APPROVAL.sql
@ddl/oracle/ship/TB_SHP_APPROVAL_STEP.sql
@ddl/oracle/ship/TB_SHP_MSG_SEND.sql
@ddl/oracle/ship/TB_SHP_MSG_RCVR.sql
@ddl/oracle/TB_SAM_MOVIE_INFO.sql
@initdata/oracle/TB_SAM_MOVIE_INFO_INITDATA.sql

저작자표시

'dev > RDB' 카테고리의 다른 글

AWS RDS MariaDB character set 문제  (0) 2017.06.09
aws mysql PRIVILEGES  (0) 2017.06.07
oracle characterset  (0) 2017.04.03

oracle characterset

dev/RDB2017. 4. 3. 00:13

http://loonyhyun.tistory.com/61


1. client set



export NLS_LANG=KOREAN_KOREA.KO16KSC5601 #한글

export NLS_LANG=KOREAN_KOREA.KO16MSWIN949 #한글(추천:지원캐릭터가 더 많음 -뷃,숖..)

export NLS_LANG=AMERICAN_AMERICA.UTF8 #유니코드



2. db 환경변수 확인



select * from nls_database_parameters where parameter like '%CHARACTERSET%';

select VALUE$ from sys.props$ where name='NLS_LANGUAGE';



3. db 환경변수 변경



update props$ set VALUE$='UTF-8' where name='NLS_CHARACTERSET';

update props$ set VALUE$='KO16MSWIN949' where name='NLS_CHARACTERSET';

update props$ set VALUE$='KO16KSC5601' where name='NLS_CHARACTERSET';



update props$ set VALUE$='KOREAN' where name='NLS_LANGUAGE';

update props$ set VALUE$='KOREA' where name='NLS_TERRITORY';



4. shutdown 및 startup



shutdown immediate;



startup;



------------------------------------------------------------------------------

# 두번째



1. sysdba 접속

sqlplus / as sysdba



2. 일반 사용자의 세션 가능 제한 모드

alter system enable restricted session;



3. job_queue_processes 에 등록된 job 프로세스 정지

alter system set job_queue_processes = 0;



4. aq_tm_processes에 등록된 job 프로세스 정지

alter system set aq_tm_processes = 0;



5. db 오픈

alter database open;



6. 변경할 캐릭터 셋으로 변경

alter database character set internal_use KO16MSWIN949;



7. shutdown 및 startup

shutdown immediate;

startup;















root@cc718514202e:~# su - oracle
oracle@cc718514202e:~$ sqlplus /nolog

SQL*Plus: Release 11.2.0.2.0 Production on Sun Apr 2 14:40:08 2017

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

SQL> conn / as sysdba;
Connected.
SQL> update props$ set VALUE$='KO16KSC5601' where name='NLS_CHARACTERSET';

1 row updated.

SQL> update sys.props$ set VALUE$='KOREAN' where name='NLS_LANGUAGE';

1 row updated.

SQL> update props$ set VALUE$='KOREA' where name='NLS_TERRITORY';

1 row updated.

SQL>
SQL>
SQL> shutdown immediate;
ORA-01097: cannot shutdown while in a transaction - commit or rollback first
SQL> commit;

Commit complete.

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> ^[[A^C

SQL> startup;
ORACLE instance started.

Total System Global Area  601272320 bytes
Fixed Size                  2228848 bytes
Variable Size             201330064 bytes
Database Buffers          394264576 bytes
Redo Buffers                3448832 bytes
Database mounted.
Database opened.

저작자표시

'dev > RDB' 카테고리의 다른 글

AWS RDS MariaDB character set 문제  (0) 2017.06.09
aws mysql PRIVILEGES  (0) 2017.06.07
faro sql script  (0) 2017.04.03

nexus ubunto

dev2017. 3. 27. 02:00

jmyung@jmyung-Virtual-Machine:/usr/local/nexus/bin$ ./nexus console
Running Nexus OSS...
wrapper  | ERROR: Could not write pid file /usr/local/nexus-2.14.3-02/bin/../bin/jsw/linux-x86-64/nexus.pid: Permission denied
Unable to open logfile logs/wrapper.log: Permission denied





https://issues.sonatype.org/browse/NEXUS-4452




https://books.sonatype.com/nexus-book/reference/running.html

저작자표시

'dev' 카테고리의 다른 글

lorem ipsum  (0) 2017.04.13
ISDP  (0) 2017.02.02
Anti-OOP: if를 피하는 법  (0) 2017.02.01
XML vs JSON  (0) 2017.01.26
TDD 무엇을 테스트 할 것인가?  (0) 2017.01.23

정상 로그

dev/spring framework2017. 2. 14. 00:45

2월 14, 2017 12:44:26 오전 org.apache.tomcat.util.digester.SetPropertiesRule begin

경고: [SetPropertiesRule]{Server/Service/Engine/Host/Context} Setting property 'source' to 'org.eclipse.jst.jee.server:first' did not find a matching property.

2월 14, 2017 12:44:26 오전 org.apache.tomcat.util.digester.SetPropertiesRule begin

경고: [SetPropertiesRule]{Server/Service/Engine/Host/Context} Setting property 'source' to 'org.eclipse.jst.jee.server:jqwidgets-spring' did not find a matching property.

2월 14, 2017 12:44:26 오전 org.apache.catalina.startup.VersionLoggerListener log

정보: Server version:        Apache Tomcat/9.0.0.M15

2월 14, 2017 12:44:26 오전 org.apache.catalina.startup.VersionLoggerListener log

정보: Server built:          Dec 5 2016 13:44:25 UTC

2월 14, 2017 12:44:26 오전 org.apache.catalina.startup.VersionLoggerListener log

정보: Server number:         9.0.0.0

2월 14, 2017 12:44:26 오전 org.apache.catalina.startup.VersionLoggerListener log

정보: OS Name:               Windows 10

2월 14, 2017 12:44:26 오전 org.apache.catalina.startup.VersionLoggerListener log

정보: OS Version:            10.0

2월 14, 2017 12:44:26 오전 org.apache.catalina.startup.VersionLoggerListener log

정보: Architecture:          amd64

2월 14, 2017 12:44:26 오전 org.apache.catalina.startup.VersionLoggerListener log

정보: Java Home:             C:\Program Files\Java\jre1.8.0_111

2월 14, 2017 12:44:26 오전 org.apache.catalina.startup.VersionLoggerListener log

정보: JVM Version:           1.8.0_111-b14

2월 14, 2017 12:44:26 오전 org.apache.catalina.startup.VersionLoggerListener log

정보: JVM Vendor:            Oracle Corporation

2월 14, 2017 12:44:26 오전 org.apache.catalina.startup.VersionLoggerListener log

정보: CATALINA_BASE:         C:\Users\myung\workspace\.metadata\.plugins\org.eclipse.wst.server.core\tmp1

2월 14, 2017 12:44:26 오전 org.apache.catalina.startup.VersionLoggerListener log

정보: CATALINA_HOME:         C:\dev\tomcat

2월 14, 2017 12:44:26 오전 org.apache.catalina.startup.VersionLoggerListener log

정보: Command line argument: -Dcatalina.base=C:\Users\myung\workspace\.metadata\.plugins\org.eclipse.wst.server.core\tmp1

2월 14, 2017 12:44:26 오전 org.apache.catalina.startup.VersionLoggerListener log

정보: Command line argument: -Dcatalina.home=C:\dev\tomcat

2월 14, 2017 12:44:26 오전 org.apache.catalina.startup.VersionLoggerListener log

정보: Command line argument: -Dwtp.deploy=C:\Users\myung\workspace\.metadata\.plugins\org.eclipse.wst.server.core\tmp1\wtpwebapps

2월 14, 2017 12:44:26 오전 org.apache.catalina.startup.VersionLoggerListener log

정보: Command line argument: -Djava.endorsed.dirs=C:\dev\tomcat\endorsed

2월 14, 2017 12:44:26 오전 org.apache.catalina.startup.VersionLoggerListener log

정보: Command line argument: -Dfile.encoding=UTF-8

2월 14, 2017 12:44:26 오전 org.apache.catalina.startup.VersionLoggerListener log

정보: Command line argument: -Xbootclasspath:C:\Program Files\Java\jre1.8.0_111\lib\resources.jar;C:\Program Files\Java\jre1.8.0_111\lib\rt.jar;C:\Program Files\Java\jre1.8.0_111\lib\jsse.jar;C:\Program Files\Java\jre1.8.0_111\lib\jce.jar;C:\Program Files\Java\jre1.8.0_111\lib\charsets.jar;C:\Program Files\Java\jre1.8.0_111\lib\jfr.jar;C:\Program Files\Java\jdk1.8.0_111\lib\tools.jar

2월 14, 2017 12:44:26 오전 org.apache.catalina.core.AprLifecycleListener lifecycleEvent

정보: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: C:\Program Files\Java\jre1.8.0_111\bin;C:\WINDOWS\Sun\Java\bin;C:\WINDOWS\system32;C:\WINDOWS;C:/Program Files/Java/jre1.8.0_111/bin/server;C:/Program Files/Java/jre1.8.0_111/bin;C:/Program Files/Java/jre1.8.0_111/lib/amd64;C:\ProgramData\Oracle\Java\javapath;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\Program Files\Git\cmd;C:\Program Files\nodejs\;C:\Users\myung\AppData\Local\Microsoft\WindowsApps;C:\Users\myung\AppData\Roaming\npm;C:\WINDOWS\system32;;.

2월 14, 2017 12:44:26 오전 org.apache.coyote.AbstractProtocol init

정보: Initializing ProtocolHandler ["http-nio-8080"]

2월 14, 2017 12:44:26 오전 org.apache.tomcat.util.net.NioSelectorPool getSharedSelector

정보: Using a shared selector for servlet write/read

2월 14, 2017 12:44:26 오전 org.apache.coyote.AbstractProtocol init

정보: Initializing ProtocolHandler ["ajp-nio-8009"]

2월 14, 2017 12:44:26 오전 org.apache.tomcat.util.net.NioSelectorPool getSharedSelector

정보: Using a shared selector for servlet write/read

2월 14, 2017 12:44:26 오전 org.apache.catalina.startup.Catalina load

정보: Initialization processed in 1025 ms

2월 14, 2017 12:44:26 오전 org.apache.catalina.core.StandardService startInternal

정보: Starting service Catalina

2월 14, 2017 12:44:26 오전 org.apache.catalina.core.StandardEngine startInternal

정보: Starting Servlet Engine: Apache Tomcat/9.0.0.M15

2월 14, 2017 12:44:30 오전 org.apache.jasper.servlet.TldScanner scanJars

정보: At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.

2월 14, 2017 12:44:30 오전 org.apache.catalina.core.ApplicationContext log

정보: No Spring WebApplicationInitializer types detected on classpath

2월 14, 2017 12:44:30 오전 org.apache.catalina.core.ApplicationContext log

정보: Initializing Spring root WebApplicationContext

2월 14, 2017 12:44:32 오전 org.apache.catalina.core.ApplicationContext log

정보: Initializing Spring FrameworkServlet 'action'

2월 14, 2017 12:44:35 오전 org.apache.jasper.servlet.TldScanner scanJars

정보: At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.

2월 14, 2017 12:44:35 오전 org.apache.catalina.core.ApplicationContext log

정보: No Spring WebApplicationInitializer types detected on classpath

2월 14, 2017 12:44:35 오전 org.apache.catalina.core.ApplicationContext log

정보: Initializing Spring FrameworkServlet 'mvc-dispatcher'

2월 14, 2017 12:44:35 오전 org.springframework.web.servlet.DispatcherServlet initServletBean

정보: FrameworkServlet 'mvc-dispatcher': initialization started

2월 14, 2017 12:44:35 오전 org.springframework.web.context.support.XmlWebApplicationContext prepareRefresh

정보: Refreshing WebApplicationContext for namespace 'mvc-dispatcher-servlet': startup date [Tue Feb 14 00:44:35 KST 2017]; root of context hierarchy

2월 14, 2017 12:44:35 오전 org.springframework.beans.factory.xml.XmlBeanDefinitionReader loadBeanDefinitions

정보: Loading XML bean definitions from ServletContext resource [/WEB-INF/mvc-dispatcher-servlet.xml]

2월 14, 2017 12:44:36 오전 org.springframework.web.servlet.handler.SimpleUrlHandlerMapping registerHandler

정보: Mapped URL path [/resources/**] onto handler 'org.springframework.web.servlet.resource.ResourceHttpRequestHandler#0'

2월 14, 2017 12:44:36 오전 org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping registerHandlerMethod

정보: Mapped "{[/chart/getProducts],methods=[POST],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public java.util.List<com.jqwidgets.Product> com.jqwidgets.ChartController.getProducts() throws java.lang.ClassNotFoundException

2월 14, 2017 12:44:36 오전 org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping registerHandlerMethod

정보: Mapped "{[/chart],methods=[GET],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public java.lang.String com.jqwidgets.ChartController.chart(org.springframework.ui.ModelMap)

2월 14, 2017 12:44:36 오전 org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping registerHandlerMethod

정보: Mapped "{[/datatable/getEmployees],methods=[POST],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public java.util.List<com.jqwidgets.Employee> com.jqwidgets.DataTableController.getEmployees() throws java.lang.ClassNotFoundException

2월 14, 2017 12:44:36 오전 org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping registerHandlerMethod

정보: Mapped "{[/datatable],methods=[GET],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public java.lang.String com.jqwidgets.DataTableController.dataTable(org.springframework.ui.ModelMap)

2월 14, 2017 12:44:36 오전 org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping registerHandlerMethod

정보: Mapped "{[/dgrid/getEmployees],methods=[POST],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public java.util.List<com.jqwidgets.Employee> com.jqwidgets.DynamicController.getEmployees() throws java.lang.ClassNotFoundException

2월 14, 2017 12:44:36 오전 org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping registerHandlerMethod

정보: Mapped "{[/dgrid],methods=[GET],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public java.lang.String com.jqwidgets.DynamicController.dataTable(org.springframework.ui.ModelMap)

2월 14, 2017 12:44:36 오전 org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping registerHandlerMethod

정보: Mapped "{[/grid/getEmployees],methods=[POST],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public java.util.List<com.jqwidgets.Employee> com.jqwidgets.GridController.getEmployees() throws java.lang.ClassNotFoundException

2월 14, 2017 12:44:36 오전 org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping registerHandlerMethod

정보: Mapped "{[/grid],methods=[GET],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public java.lang.String com.jqwidgets.GridController.grid(org.springframework.ui.ModelMap)

2월 14, 2017 12:44:36 오전 org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping registerHandlerMethod

정보: Mapped "{[/test/getEmployees],methods=[POST],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public java.util.List<com.jqwidgets.Employee> com.jqwidgets.TestController.getEmployees() throws java.lang.ClassNotFoundException

2월 14, 2017 12:44:36 오전 org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping registerHandlerMethod

정보: Mapped "{[/test],methods=[GET],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public java.lang.String com.jqwidgets.TestController.grid(org.springframework.ui.ModelMap)

2월 14, 2017 12:44:37 오전 org.springframework.web.servlet.DispatcherServlet initServletBean

정보: FrameworkServlet 'mvc-dispatcher': initialization completed in 1921 ms

2월 14, 2017 12:44:37 오전 org.apache.coyote.AbstractProtocol start

정보: Starting ProtocolHandler [http-nio-8080]

2월 14, 2017 12:44:37 오전 org.apache.coyote.AbstractProtocol start

정보: Starting ProtocolHandler [ajp-nio-8009]

2월 14, 2017 12:44:37 오전 org.apache.catalina.startup.Catalina start

정보: Server startup in 10704 ms



저작자표시

'dev > spring framework' 카테고리의 다른 글

Web Application Folder Structure for Spring MVC Web Projects  (0) 2017.02.13
Spring Legacy Project 에서 MVC Project가 안보일때 해결방법  (0) 2017.01.04

티스토리툴바