在一个数据库中可以有多个应用的数据表,这些不同应用的表可以放在不同的schema之中,同时,每一个schema对应一个用户,不同的应用可以以不同的用户连接数据库,这样,一个大数据库就可以根据应用把其表分开来管理。
不同的schema之间它们没有直接的关系,不同的shcema之间的表可以同名,也可以互相引用(但必须有权限),在没有操作别的schema的操作根权下,每个用户只能操作它自己的schema下的所有的表。不同的schema下的同名的表,可以存入不同的数据(即schema用户自己的数据)。
把schema翻译成 “方案”还是比较合理的。
其实,一个用户可以有多个Schema, 但是可以设置其中的一个为默认Schema.
Tuesday, August 18, 2009
Sunday, July 01, 2007
Hotpot
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,
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
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.
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
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,
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
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
Subscribe to:
Posts (Atom)