Isolation suitable for ETL

The best isolation level for ETL is DIRTY READ, Cauz it wont set any locks on anything , and wont consider lock exists on any anything , as we have a great chance to ETL DATA from a static data base, As a result, It will cost the least and execute in the fastest way.

In informix, the clause is SET ISOLATION TO DIRTY READ.

the following is the isolation performance in ORACLE. 

Read uncommitted is the same as DIRTY READ.

                  Dirty Read     NonRepeatabe Read       Phantom Read 
Read uncommitted  Possible       Possible                Possible
Read committed    not possible   Possible                Possible
Repeatabe read    not possible   not possible            Possible
Seriaizabe        not possible   not possible            not possible

change is difficult

I used to confused by the fact people are always not listening, And now I
have exprienced the same things, though it's me that not listening. Why is
that? lack of self-confidence?
Maybe,

自己在做什么

看到空间里面同学已经在暗自下决心要做hw的对手了.自己在做什么呢?

kill the current proccess in dbaccess on unix

try ctrl + \

昨夜遭遇

昨天下班回去,一个人乘电梯回房间,先看到电梯从二楼下来.门开了,里面有一个女的,装扮还挺正常,样子也还行,然后很奇怪的没有下电梯(电梯最低1层),我还以为她是要上去,还问她,'要上么?'然后那女的也没有怎么回答,然后我到三楼,她到五楼.然后我就转过身,感觉那个女的一直盯着我看,到二楼了,那女的突然问,你住那个房间.我:'呃~~嗯~~323'.然后那女的又问,是一个人么,可怜我还没有意识到这个女的是干什么的,心中暗感诡异,此时电梯也到三层了,我一边疾出电梯,一边脱口而出,'不是'.走出3,5米远之后我,我突然开始怀疑了.不会吧,我难道碰上了妓女?我已经到了这个年纪了么?会被妓女当成潜在的顾客.悲剧啊,可怜我单身这么多年了.

cognos sdk dev note

get all the members of an role
the search path is like "expandMembers(CAMID(\"::System Administrators\"))" 

got all the roles under certain namespace "CAMID(\":\")//role"

got the object the querier has read or traverse permission //folder[permission('read') or permission('traverse')]

get all the groups and role a user or set of user belongs to "membership(CAMID(\"dbAuth:u:8888888888\"))"

遗失了什么?

郁闷,今天升级opera 10, 把我之前写的一封信的草稿弄没了,虽然一直放在那个地方没有胆敢发出去,但是想要留在那里也许有一天自己回去看.

难道这其实是天意?让我不要纠缠在那里.

cognos sdk note

when use the search capability of cmservice in sdk, you can traverse the
name even if you dont have the permission to access that, although you
could not browse it.

The implements of the service interfaces are often ended with 'stub'.

/directory is the path of namespace .

use query(searchPath, properties, sortBy, options)
properties is the enumerator of the properties you want to get.

"execute, read, setPolicy, traverse, write" are the five permission of
NmtokenArrayProp which contain the list of the privaleges.