Tuesday, August 18, 2009

什么是schema?觉得这个答案挺好的。

在一个数据库中可以有多个应用的数据表,这些不同应用的表可以放在不同的schema之中,同时,每一个schema对应一个用户,不同的应用可以以不同的用户连接数据库,这样,一个大数据库就可以根据应用把其表分开来管理。
不同的schema之间它们没有直接的关系,不同的shcema之间的表可以同名,也可以互相引用(但必须有权限),在没有操作别的schema的操作根权下,每个用户只能操作它自己的schema下的所有的表。不同的schema下的同名的表,可以存入不同的数据(即schema用户自己的数据)。

把schema翻译成 “方案”还是比较合理的。

其实,一个用户可以有多个Schema, 但是可以设置其中的一个为默认Schema.

Sunday, July 01, 2007

Hotpot

Share the birthday hotpot-party with friends, got a big birthday cake, looks good, but some part is not very successful :)



Girls are always on time, but they have to prepare and wait, totally unfair :((



Monopoly, men are always good at business, all girls are out,

30th Birthday Holiday

Finally, 30 years old, a BIG day, Steffi and Frank are so nice give me a big birthday present: inviting me to Allgau to have a long holiday, it is just NICE, I will never forget the beautiful place: only green landscape and blue sky.

First evening, we arrived besides a lake, take a break.



Check in a nice famliy hotel, we have a lovely balcony



and a comfortable kitchen,



Going out for a walk,



And take a break,



Meet a beautiful girl :)



See some lazy & sleepy guys :))



Find a nice lake, unfortunately, I forget my swimming pants, but I can do it, whatever I am not naked :(



Everywhere, there are cows, I have to show them as a collection







Finally, VICTORY!!




Take a ice break in Rotenbury, OMG, very expensive,



A huge nut-cracker, haha,



Our dinner,

Sunday, May 13, 2007

Beautiful April

This April is just nice, the spring comes sooner, and the weather is so lovly, have to do something outside, A BBQ followed by a football game might be a good idea,


Holiday in the South (4) _leaving

Before I left, I got my present for Easter, so beautiful :)



Still early to catch the train, take a walk somewhere, we find a old train, renewed for tourist, driven by WOOOOOOOD !!



The power source,



Preparing



Entrance of energy,



And smoking truck and non-smoking truck




The cute train is just beside the lake, which is the beautiful secen left in my memory as the end of the travel.

Holiday in the South (3)_ Funny man

Stefan's father is a very funny man, normally, German's impression on Chinese is that chinese eats dog, which is quite hard for them to understand, dog is so cute, why they eat it. Mr. Feitz knows something more about chinese, he knows Panda is in China, and they have to watch some sex movie before mating, haha, I didnot know it before. He can speak quite a lot english, hardly german old people can do it. Also he has a laptop, and can surf on internet, oh, quite a modern old man :) plus, he has a digital camera, and took many photos for us.



Take a tour to Heidberg,



actually, it is not a very special city except full of tourist, as the group Japanese behind us, they are well known of traveling and taking photoes, and moving fast to the next scene spot, hehe :))



Speyer, which is a small town close to Heidberg is more interesting, I guess some special evening is going on when we were there, LOTS of weird hair-style young guys are arround us, haha, cool heads

Holiday in the South (2)_Easter

Stefan and I took the Easter holiday to visit his parents, they are living in the west-south part of Germany, close to French, there are endless grapes fields, his father also shew me his collection of wine, lots of wine, the traditional beer is not working any more there, the Germans in this area prefer wine, I like it too. Here is some pictures of their nice house


From the other side,


The room for me,


Very nice cake and a afternoon tea,





Then took some walk outside,

Holiday in the South

Before the start of 2nd symester, Took a 8 days holiday at the south of Germany, to visit Stefan and travel arround several cities, Nuermberg is one I like most.

Nuermberg was the headquarter of former Nazi party, Hiterler had a huge plan to build up his empire including several unbelievable building and fields, unfortunately, or fortunately, he has finished nearly nothing before he cracked down, it was supposed to be the conference hall, he should stand in the center, then all of the members should be facing to him.



It is the entrance to the old town, there are many churchs, and a big castle, a nice place to take a tour, and also comportable to sit somewhere eating a icecream, the weather was just great when I was there.



The old german style house, someone told me that I can also find it in Qin dao.



Visited Renzberg which is 1 hour way from Nuermberg, there is a OLD-Bautiful church + a museum full of GOLD, "I have never seen so many golds", I left it at the notebook for tourists :)






Munich is not very interesting, or it is too big, totally got lost.

Nifenburg looks great, also HUGE, not time to visit,


because spend much time in the Olympia park, the biggest should be the LOGO of BMW

Saturday, March 24, 2007

Barbeque

Finally, the exams are almost over, have some fun before we get any result, just in case the result will ruin our mood,

Carnovar

The best time, I think, in germany, is Carnovar, it was so exciting and just great, lots of fun.