2013/10/21 memo

gseducation@naver.com

* a/b test 의 중요성.

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

[data 의 발생] 

- 사람

- service

- machine 등

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

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

* DFS (Hadoop, ...) + eco system 

* non- RDBMS(no sql DB)  - column : Hbase, ....         

   - Document : mongo DB      

   - key value : cassandra

   - graph : neo4j

   -

* RDBMS(SQL DB)

  [data store]

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

IoT (internet of things)

 = M2M

 = 사물인터넷

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

[ DB analysis]

- java, c++, python, ruby, ...

- sql

- R, spss, sas

- web service

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

data ---- batch ---- DFS(Hadoop)

data ---- 실시간 ---- no sql DB

data ---- 실시간/ batch --- RDBMS

* static data dictionary view

open 시에만 이용가능

data 의 생명이 instance 와 무관

user - all - dba

optimizer statics - > sql tuning

* dynamic performance view (V$.. )

- nomount, mount, open

- data 의 생명이 instance 와 동일

perfomance staitc- > server tuning

* v$table

- parameter file

- control file

- instance

* meta data

* datafile 

insternal table : obj$, tab$, user$...