测试

现在的时间是：2010年5月22 日 2:23
你的全名：紫气东来
你在哪里读书(工作)：北京
现在所在的城市：北京
现在的联系方式：135xxxx6140
最近在听谁的音乐：最近没有特别听谁的歌,foobar里面一千五百首来回颠倒.心情到谁了就听谁的
现在天气如何：完全告别了漫长的冬天,进入夏天的气候,开始炎热了.
你养过什么：一个人…..
有几个耳洞：没有
有纹身吗：没有,纹上了就不能去掉了,还不能确定有没有那样一种情感一辈子不变.
喜欢目前的生活吗：不喜欢,太无聊了,进退维谷,不过在积攒吧,攒能力,攒钱.希望能做自己想做的事情.
现在有暗恋的对象吗：没有,但是有一个感觉还不错的人.暗恋这个东西太伤了.
喜欢喝什么：纯净水,如果我正在喝纯净水的话说明我生活状态比较好,不忙碌,可以慢慢的平淡.
会因为害羞而不敢跟人表白吗：会,谁叫我没有恋爱过呢,都没有自信了.
你喜欢什么类型的异性：聪明,有自信,有追求,有想法,活得很透彻.
喜欢的数字：没有.
喜欢哪一种电影类型：类型算科幻片,其实现在就喜欢一些比较欢乐的片子,但不能太欢乐了,太欢乐了会让我难受.
最怀念的日子：大学的时候可以傻傻的看着湛蓝的天空的时候.
最喜欢星期几：没有
喜欢的运动：游泳,我喜欢游泳煅炼身体,也喜欢游泳游戏.
如果有来世：性格能够普通一点.
最讨厌的事：做重复的事情,或者是别人出尔反尔.
最喜欢的事：和心爱的人在一起.
寄这封邮件给你的上一个人是：小朋友.
无聊的时候你大多会做些什么：玩游戏.
世界上最好的事情：两情相悦,皆大欢喜.
如果有人误会你：无所谓了,如果还会继续交往的话会解释,只说事实,只说一遍.
你觉得谁是最不可能回复的：110
现在最想见的人：小刀,想知道她是什么样子.
最想什么时候结婚：找到一个我喜欢的也喜欢我人以后.
最希望谁回信：小刀.
现在最想干嘛：昨天在想组织一个活动,让不同身份的人能够互相交流,1on1,没有任何客套,形式,恶意的交流,充满诚意的,深刻的交流,能够有问必答,有想法就说地交流.
个人而言,最近最想换个工作,工资也不用涨,但是能做一些有趣的事情.希望能把一些需要解决的事情统统解决掉.让我可以开始有趣的生活.

在汇款小票丢失以后(2)

6月16日房子到期了,最担心的事情还是发生了.被中介发现转租了.而转租的后果是违反合同,对方可以扣下押金的.我的准备是死不认帐,然后要回押金.
简要的说,水电费交过以后,交涉押金的事情.交接的是一个业务员,以前也没有见过.开始先讨论转租这个事情,业务员当然是以后咬定我转租了,我也咬定没有转租.有点谈崩了.这时候这样僵持下去对我没有什么好处,然后就换种方式,给这个业务员点好处,然后他去帮我退租金.这家伙一开始还跟我废话,后来慢慢说说,然后他说你先说个价.我就想总共退我1350,给他350,但是这样又太显然以我为中心了,好像给他一点零头似的,所以就给说四百了.这家伙居然没有还价,然后说先这样吧.看来是可以了,后来听说隔壁退押金也给了他400,免得他说东西坏了什么的要赔,而那个租小间的小姑娘也给了四百的中介费续住.
最后顺利退租,给了业务员四百,没有用到去银行要的票据.所以这事也算告一段落了.
现在住的地方搬来一个新人,好像人还可以.后面就没有什么事情了,准备考研的事情了.

正月初三进派出所

起因,早上起床,上卫生间去,发现灯开着,以为有人,过了20分钟再去,发现灯还开着,敲门,没人,嘟囔句"毛病",然后隔壁就闹起来了,闹着闹着,老太太就开始推我了,本着绝不动手打妇孺的原则,没有动手,然后那家男人冲出来了,也开始推我,这时候就有四个人(老太太,泼妇,小男人,大男人)来推我了.混乱中,共计眼镜被搞掉一副,衣服被推掉,鞋被推掉,抓痕若干,然后出手一次,标准的直拳哦.
推到最后,推到我们的房间里,觉得事情已经没有办法了,打110,居然第一次的时候挂我电话,对方还假装打电话给110,"喂,110吗?我是XXX",
太搞了,装做和对方认识的样子.我还以为他们打通了,在等警察同志来.后来还去问了下,没有回答我的问题,然后王同学就打电话啦,号称杀人了,然后说打起架来了.不一会儿警察来了(一个正式警察和一个保安).敲门还挺轻了,然后经验丰富知道是邻里纠纷开始询问,各自表达,我表现得极其冷静,对方和王同学就互相指责.泼妇生成老太太病了什么的,也太低级了,没有人相信,包括她自己,警察和我们.老太太则是使用了温情手段,还说孙子画了个东西,想让他们过来团年什么什么的,小男人没有出现,大男人一直在.询问了当,双方还是互相争执,警察烦啦,让我们去派出所协调去,然后一行若干人坐着警车去了派出所,协调人员来了,说了说情况,反正是各打三十大板,说说各自的损失,然后主要就是要赔我的眼镜了,皮外伤就算了.我的眼镜三年前买的,然后差不多300买的,要他们赔150,对方还价100,当然这个过程是双方各在一个房间里面.完事.
没有什么新奇的东西,倒是要小心有老人的时候.
另,王同学曾经踹开过中介的门,恐怕对方利用这点把里面的东西损坏了,或者偷走了,让我们背黑锅.这就麻烦了,本来回来的时候就准备说先让用手机拍一下房间,然后后反锁门的,回来以后发现门已经被反锁了,也不知道对方有没有做什么手脚.

study notes

check the disk space on AIX

check certain file du -ms  . m means size in megabyte, and s means return single line.

check the disk df -m 

这是一出悲剧么？

故事的开始总是美好的。

但是中间发生了一些事情，不知道是不是太年轻了。

之前说过说我四差。我是一个很容易认真的人，她也是。在愤怒的时候，她常常不能控制自己，使用最伤人心的话语。

从一开始的面对这些辱骂的愤怒和失望 到听到拒绝的话语的害怕 到听到责难的时候的宽容、无视 到心灰意冷。

2010.4.8

早上的时候做了一个梦，梦里和谁谁谁在一起，然后就在路上走着走着，碰到水坑啦（其实记不起来了），然后谁谁谁就说都怪你，blabla， 然后我就醒了，果然已经习惯了么。

Avoid warning when access remote server via ssh with multiple accounts on one client.

AT.

If you put all the public key of local client on the server, and then you connect it via ssh, it will promote a warning.

Warning: the RSA host key for 'a.b.com' differs from the key for the IP address 'x.x.x.x'.

This happened because the ssh server check the key according to the IP address, and since we have multiple account on local client,The server will recored different RSA key from a unique IP,It will result in conflict.

It could be solved by setting the option,

check out ssh_option(5)

e.g sudo -u super_a ssh -o checkhostip="no" username@remote_host 'echo "hi"'.

study notes

umask value

if the previous default permission for file is XXX,set the default permission to XXX &~ $value
perl Number 

$n = 1234; # decimal integer
$n = 0b1110011; # binary integer
$n = 01234; # octal integer
$n = 0x1234; # hexadecimal integer
$n = 12.34e-56; # exponential notation
$n = "-12.34e56"; # number specified as a string
$n = "1234"; # number specified as a string

use taglist to improve vim

1 download Exuberant ctags extract it, add the dir to PATH.

2 download taglist plugin extract it to ~/.vim/

3 restart vim,run :TlistOpen in vim

4 done 

you may want to read

taglist option manul 

useful settings of vimrc

example of vim setting 

set nobackup
set nu
set tabstop=4 " numbers of spaces of tab character
set shiftwidth=4 " numbers of spaces to (auto)indent
set ignorecase " ignore case when searching
behave mswin
"taglist

let Tlist_Sort_Type = 1 "list the tag by name alphabetic
let Tlist_GainFocus_On_ToggleOpen =1 "jump on one click
let Tlist_Auto_Highlight_Tag=1 "Automatically highlight the current tag in the taglist.
let Tlist_Auto_Update =1 "Automatically update the taglist to include newly edited files.
let Tlist_Exit_OnlyWindow =1 "Close Vim if the taglist is the only window.

cygwin set display languge

add 

export LANG='C.UTF-8'

to set the language to English.

or

export LANG='zh-CN'

to set the language to Chinese .

study note

Perl sort a hash
1 sort by key
foreach $key (sort (keys(%hash_name))) {
  print "\t\t$key \t\t$hash_name{$key}\n";
}

2 sort by $value 

make use of perl sort

 foreach my $key ( sort { $rules{$a} <=> $rules{$b} } ( keys %hash_name ))
{
  print "$key => $hash_name{$key}\n";
}
if you want get the set sorted numeric and desc

switch $a and $b e.g

 foreach my $key ( sort { $rules{$b} <=> $rules{$a} } ( keys %hash_name ))
{
print "$key => $hash_name{$key}\n";
}

study notes

getopts for perl?

check out

getopts for perl on perldoc

my %options=();
getopts("a",\%options) or usage();

#HELP_MESSAGE();
addrule() if defined $options{"a"};

sub HELP_MESSAGE()
{
$Getopt::Std::STANDARD_HELP_VERSION=1;
usage;
}
sub VERSION_MESSAGE()
{
$Getopt::Std::STANDARD_HELP_VERSION=1;
#print `grep "^# VERSION" ./odssvn.pl`;
}

TEST;

perl t.pl --help

perl t.pl --version

perl t.pl -a

MD5 for perl

use Digest::MD5;

$ctx = Digest::MD5->new;
$ctx->add($data);
$ctx->addfile(*FILE);
$digest = $ctx->digest;
$digest = $ctx->hexdigest;
$digest = $ctx->b64digest;

gvim set nobackup

do not generate filename~ file.

try Edit->start setting-> add "set nobackup " under source $VIMRUNTIME/mswin.vim

done

study note

1 To change the owner of the file program.c:

chown jim program.c

The user access permissions for program.c now apply to jim. As the owner, jim can use the chmod command to permit or deny
other users access to program.c.

准备户口迁回家

现在算是口袋户口，身份证还有5年就要到期了，而且要是掉了还超级麻烦的样子。所以准备迁户口。

2从学校迁出 厦大派出所电话 0592-2185893，所需材料，户口页，毕业证，户口迁入地提供的证明。

 迁入地重庆老家 重庆户籍室电话 023-63962385

 太龙镇 派出所电话023-58501035 张

 万州区户政科电话 64880012

1写申请，表明迁入意愿，原因。到向坪社区（找冯春喜）里盖章，然后交给镇派出所 并包括毕业证复印件，新身份证照片（需要身份证制定点）。（本来可能需要本人办，但是乡下好办事，让家人托办就可以了）

 迁入地（太龙）派出所会给出迁出地所需的证明。
 然后到迁出地（厦大）办，

 然后到迁入地（太龙）办。
计划周末去照相，复印毕业证，用快递寄回家让办。

中国的户籍制度真是太可恶啦。

ksh detail

If you want to show the result of `ls` one entry by each line, try
argument -1 (1 not l)

数据仓库建模_9

type 3 slowly changing dimension is just added a historical column.
The type 3 slowly changing dimension technique allows us to see new and
historical fact data by either the new or prior attribute values.

关注

在对方如果获得成就的时候,即使他在主动的讲了,也要记得关切的询问.特别是如果对方的心情都为之改变了,请关心.

Intresting

Last night I was thinking about dirty things. All in a sudden,like there is a switch, I mind just became clean and I just be not drowned in it anymore. It's really a strange experience.

A memory

A new beginning for 2010

数据仓库建模_8

Common Matrix Mishaps

Departmental or overly encompassing rows.

Report-centric or too narrowly defined rows.

Overly generalized columns.

Separate columns for each level of a hierarchy.

Slowly Changing Dimensions
Type 1: Overwrite the Dimension Attribute 

         the original dimension, only the latest infor is saved.

Type 2: Add a New Dimension Row

         the time period attribute is added.

Type 3: Add a New Dimension Attribute

         add a version to attribute, user can choose any version of dimension. very useful when user want to switch the dimension.

Mini-Dimensions: Add a New Dimension

         break a huge dimension into stable parts and frequently changing parts.

Hybrid Slowly Changing Dimension Techniques

        try to adopt the advantage of above basic kinds of dimensions. Be care when use it.

Role-Playing Dimensions

        A single dimension used many place of a model could be addressed as 'Role-Playing Dimensions'

Junk Dimensions

        When the dimension cannot deal with legacy flag or text attribute. Try these

        Leave them in the fact table.

           but it's worst practice.

        Make them into separate dimensions.

           it may lead to the exploring of dimensions. RimBall says "we strive to have fewer than twenty foreign keys in a fact table for most industries and business processes. "

        Eliminate them. 

            if it's meaningless, yield them.

Note Junk dimension is a highly technical term; try use some neuter like "invoice indicator".

Snowflaking and Outriggers

        A snowflaking dimension is normalized dimension. seperated and then linked back .

        An outrigger is useful if most of the dimension records share handful common informations.

three types of dimension 

Transaction Fact Tables

Periodic Snapshot Fact Tables

Accumulating Snapshot Fact Tables

Factless Fact Tables

数据仓库建模_7

Application Architecture Document
• EXECUTIVE SUMMARY
o Business Understanding
o Project Focus
• METHODOLOGY
o Business Requirements
o High-Level Architecture Development
o Standards & Products
o Ongoing Refinement
• BUSINESS REQUIREMENTS AND ARCHITECTURAL IMPLICATIONS
o CRM (Campaign Management & Target Marketing)
o lSales Forecasting
o Inventory Planning
o Sales Performance
o Additional Business Issues
􀂃 Data Quality
􀂃 Common Data Elements and Business Definitions
• ARCHITECTURE OVERVIEW
o High Level Model
o Metadata Driven
o Flexible Services Layers
• MAJOR ARCHITECTURAL ELEMENTS
o Services and Functions
􀂃 ETL Services
􀂃 Customer Data Integration
􀂃 External Demographics
􀂃 Data Access Services
􀂃 BI Applications (CRM/Campaign Mgmt; Forecasting)
􀂃 Sales Management Dashboard
􀂃 Ad Hoc Query and Standard Reporting
􀂃 Metadata Maintenance
􀂃 User Maintained Data System
o Data Stores
􀂃 Sources and Reference Data
􀂃 ETL Data Staging and Data Quality Support
􀂃 Presentation Servers
􀂃 Business Metadata Repository
o Infrastructure and Utilities
o Metadata Strategy
• ARCHITECTURE DEVELOPMENT PROCESS
o Architecture Development Phases
o Architecture Proof of Concept
- 167 -
o Standards and Product Selection
o High Level Enterprise Bus Matrix
APPENDIX A—ARCHITECTURE MODELS