Indian Curry

I went to teach ASP.Net to my Indian classmate. After finishing study, he invited me to his lunch. I love curry, so I was very glad to hear that!
He cooked Curry very well and he made Roti, which looks Nan. I had never eaten real Indian Curry. His curry is very nice!!
In Japan, Indian curry is usually oily, but his curry is not so oily. And they said they normally have more spicy curry.
Next time, I want to cook Japanese food:)

昨日はASP.Netをクラスメイトに教えてあげにいってきました。彼は寮に住んでいるので、学校で勉強した後、ランチに招待してもらった＾＾カレー大好き！！
クラスメイトはとっても料理上手で、カレーだけでなくナンのようなロティというパンも作ってくれて本格的！インドのお母さんは毎日昼と夜ロティをつくるらしい。力を入れて20分ぐらいこねないといけないから大変。日本人でよかったとふと思う。
カレーはとてもあっさりしていてすごくおいしかった！日本のインディアンレストランはたいていオイリーだけど、本当のカレーはすごくおいしー。今度は私が日本食を！って思うけどベジタリアンへの日本食。アボカドロールでしょうか？
だれかいいアイデアあったら教えてー。

jQuery UI

Recently, I learn about jQuery UI. I used reference of jQuery page and aggressive engineer blog.
It is very easy to use it. And there are many plug-ins, so I want to get more knowledge!

Without fridge diet (冷蔵庫なしダイエット)

When I came here, I have lost my weight. So, I don't want to need to be on diet. But I haven't gotten fridge yet for 2 weeks. I think my weight have decreased gradually.
Therefore, I'm thinking about fridge diet. If you do want to lose your weight, I think  without fridge diet is one of the most powerful diet.
However, please don't do that in summer.
I want to get our fridge this week!!

こっちに来てやせたので、ダイエットは特に必要ないと思うんだけど。
引越しして2週間、いまだ冷蔵庫がないまま。ちゃんと図ってないけど、徐々に体重も減ってきた。今までと食べてるものはそんなに変わらないんだけどね。
たぶん保管できないから余計なものを買わなくなったのかも。
冷蔵庫なしダイエットという新しいジャンルの本が書けるんじゃないかとちょっと思ったりして。。。。本当にダイエットしたい人、絶対効果があるダイエットのひとつです。
ただし、夏には決してやらないでね。（NZは冬が始まった感じなので、冷蔵庫なしダイエットができるんです。ってポジティブな響き）
 今週中にはぜひ冷蔵庫をゲットしたい！！

My room

 This is my room. I have moved into a new house  for 2 weeks. Now I got a good bed, which is only $47!
I bought at trade me Trade me. The Trade me is New Zealand auction site, but competition is not so keen because of population (?). Therefore, I can get an affordable bed.
And my friend and this seller is very helpful for me. So we could take this bed by normal car.
Can you imagine how to take this bed to my house?
The answer is we take the bed on the roof of the car! If I took the picture, I could upload this photo:)
Thank you for your help!!

これが私の新しい部屋です。移ってようやく2週間。家具もないので、最初は大変だったけど。ようやくベッドもゲット。47ドル（3,000円ぐらい）!
Trademeというオークションサイトで中古のベッドを買ったんです。NZは中古市場が充実しているので、みんな新品を買わずに中古を買います。まーお金もちの人はポンポンお金出して新品かっちゃうんだろうけど。なぜかというと、NZ自体で作っている製品って食べ物以外はあんまりないから、ベッドとか家具とかテレビとか全部輸入品だから高い！という訳で、安くいいものを買える中古市場がにぎわっているようです。
 このオークションサイトもNZで一番有名なオークションサイトだけど、日本ほど競争が激しいわけじゃないので（人口が少ないから？）、安くベッドをゲットできたわけですー。
そして友達とセラーの人がいろいろ助けてくれてようやく普通車でベッドを運ぶことができました。
ここで問題。どうやって普通車でベッドを運んだでしょうか？
答えは屋根に乗せて運んだ！です。いやー。写真とっておけば見せられたのに、残念><
セラーの人がとっても心優しいKIWIのおじさんで、車のメンテナンスの仕事をしてる人だったから、ルーフに乗せたベッドをきちんと固定できたけど。そうじゃなかったら運べなかったなーって思う＾＾；
我ながら強引な手をつかってしまいました。
どうもありがとー！

Hot water bottle （湯たんぽ）

Do you know what is it? I used to use it in Japan. This is Hot Water Bottle.
I moved in the new house, which is not anything. We have to buy many things, so I don't want to spend money for the heater. That's why I bought this hot water bottle.
This is very useful!

これがなにかわかりますか？私は日本でも使ってました。実は湯たんぽ！
新しい家は何にもないので、いろいろ買わないといけなくて、ヒーターにあまりお金を使いたくないので、湯たんぽをかったんだけど。
意外に便利！湯たんぽって海外にもあるんだね。
まーNZの家は外より家の中の方が寒いから、日本よりも需要が高いかも。
$8だったのでだいたい500円ぐらい。

Review of my class

In this semester, I want to stop writing about class review, because I want to study jQuery, PHP, ASP.Net and javascript. If you wait my class review, sorry I will not write about class review.
But I write down my class briefly.

今回のセメスターはクラスの復習はかかないつもりです。理由は、授業以外にも勉強したいことがあるから。もし楽しみにしてた方がいたらごめんなさい。
とりあえず、2学期にやることを簡単に書いておくので、これでゆるしてくださいー！

Semester2

• HTML: HTML, CSS, javascript (only 3weeks)
• ASP.Net: Create Web application and windows application
• Network: Windows server, Windows Client, Linux
• SDI2: Usability, Web Design, Testing, User manual, Presentation

Move in a new house (引越し)

I have moved in a new house to live with my classmates. House rent is more expensive than before, but I want to improve my English:)
And the house is brand new, so there is very beautiful! Unfortunately, we don't have a refrigerator. I realized refrigerator is very very important. But now New Zealand is cool, I'm lucky.

クラスメイトと一緒に住むことにしたので、引越ししました。家賃は高くなってしまうものの英語をもっと上達させないといけないので、楽しくがんばろうと思ってます。
家は本当に新築（NZで新築の家はめずらしいです）なので、本当にきれいだけど、冷蔵庫がまだない。冷蔵庫って重要だねー。でも、NZはだいぶ寒くなってきたので、ラッキーだと思うことにしよう。家の写真は今度！

YUI CSS

I heard we can use YUI CSS. It's very easy to use, so I put on a sample page using YUI CSS. I was amazed, because the blogger allow us to use another css. However, h1 and h2 tags are still blogger's css, so this page is not only YUI CSS:)

Rugby

I went to see the New Zealand’s rugby game on Saturday. I expected the team members to perform Haka, which is traditional New Zealand’s war dance. However, this was not international game, so they didn’t do Haka. I was disappointed.

After going into stadium, we had chicken & chips and a beer! Players were very cool!!

Human?

This building is museum, but the design is very strange. Sometimes I can’t understand New Zealand’s design.
Is this human? Maybe.
They have ice cream:)

Back to Auckland

I came back to Auckland. My school, which has three term systems, will start next week again. Some of my classmates miss the school, but I don't. I want to do something during holiday, for example enjoying my trip, eating delicious foods and so on. However, two weeks go by so fast:) Auckland is completely different from Napier. In Napier, there are less people than Auckland. Therefore, Napier is peaceful and beautiful Art Deco Street. I want to go to south land next time!

Aquarium

I went to the aquarium in Napier. I thought this aquarium is not so interesting. After going inside, this is amazing!!
The ceiling was a big aquarium. I have never seen that, so I was very exited.
I turned around it twice and took photo of a shark.
I love an aquarium, because there is a quiet and peaceful space:)

Napier

I came to Napier as a holiday!
New Zealand is a beautiful country. I love here:)

Auckland University

I went to Auckland University. My exam has finished:)
Now I have 2 weeks holiday!! Wow!
Auckland University is located at Central Auckland with park, so there is very beautiful space. In New Zealand, there may be less than 10 universities.
Therefore, Auckland University students are very smart and enthusiastic. I went to library, and many students study hard. 

Amazon

My exam has nearly finished. I have to prepare for my presentation of our project. I haven't made website, so I created about 10 web pages on this weekend.
And I use Amazon for references of online shopping site. Amazon is simple and easy to use, what's more clear to read. For example, button image and other images are very clear and visible. I created some buttons, but there are far from Amazon ones.

  I have to learn web design from Amazon and other sites!

試験も終わりに近づいたものの、プロジェクトのプレゼンの準備で大忙し。何もやってなかったので10ページぐらいウェブサイトをこの週末に作成。
で、参考にしたのがAmazon.com。あらためてAmazonを見るとシンプルで見やすく使いやすい。それでいて、古くさい感じではないってすごいことだなーと。あらためて感心。ボタンも視認性が高い！まねして作ってみたものの、ほど遠いね＾＾という感じ。
時間ができたらwebデザインの勉強もしたいなー。

Exam Preparation DataBase Concurrency Problem

Concurrency Problems

1. Concurrency problems

• If locking is not available and several users access a database concurrently, problems may occur
• If their transactions use the same data at the same time.
• 
  
• Lost updates.
• Uncommitted dependency (dirty read).
• Inconsistent analysis (non-repeatable read).
• Phantom reads.
• http://msdn.microsoft.com/en-us/library/aa213029%28SQL.80%29.aspx

2. Lost update

• Successfully completed update is overridden by another user.

3. Uncommitted dependency (dirty read).

• Occurs when one transaction can see intermediate results of another transaction before it has committed.

4. Inconsistent analysis (non-repeatable read).

• Inconsistent analysis occurs when a second transaction accesses the same row several times and reads different data each time.
• Inconsistent analysis is similar to uncommitted dependency in that another transaction is changing the data that a second transaction is reading.
• However, in inconsistent analysis, the data read by the second transaction was committed by the transaction that made the change.

5. Inconsistent analysis (non-repeatable read) example
6. Phantom Reads

• Records that appear in a set being read by another transaction.
• Phantom reads can occur when other transactions insert rows that would satisfy the WHERE clause of another transaction's statement.
• http://db.apache.org/derby/docs/10.0/manuals/develop/develop71.html

7. Phantom Reads example
8. Back to Marcia's Drycleaning

• Stored Procedure 01Insert a new record in SERVICE table
• Stored Procedure 02 Insert a new record or UPDATE in ORDER and ORDER_ITEM table Also select data from CUSTOMER and SERVICE
• Stored Procedure 03 Insert a new record in CUSTOMER table
• Concurrency problems may occur between 01 and 02, between 02 and 03.

9. Dirty read SP01(SP03)and SP02

• SP02 trusts SERVICE table data, but it has not been committed yet.

10. Non-repeatable reads SP02 and User Operation

• Non-repeatable reads may occur between SP02 and other user operations.

11. Phantom read SP01(SP03) and SP02

• SP02 trusts SERVICE table data, but it has not been committed yet.

12. Appropriate concurrency control

• SP01 INSERT SERVICE Read Committed
• SP03 INSERT CUSTOMER Read Committed
• SP02 INSERT ORDER or UPDATE and SELECT All table Serializable

If you are interested in my PPT, please check it:)
https://docs.google.com/leaf?id=0B8gU4bWkOtLvNjlhNTA1YWYtMGY0Zi00YTA2LWIwYTYtYjdhYzY4ZDE1Y2Vj&hl=en

Prepare our Project Presentation

We will have our Project presentation at end of this semester. I have a lot of exams, but I need to prepare this presentation also. I become very busy:)

Our project is not real project, and we practice for a real project by this virtual project. We chose Winery and Online wine shop.  In this semester, we have already written Project Proposal, Project Definition and Analysis Report. Therefore, this presentation will be final assignment.

I use Microsoft Expression Studio, which is less popular than DreamWeaver.

But I think this software has an ability of more flexible implementation than DreamWeaver. Because this software connects to Microsoft Visual Studio.

(Unfortunately,  SilverLight is minor application. If it became more popular, it would be very useful.)

I create SilverLight image, which program works behind C#. It is very interesting for me.

This capture is creating HTML.

This image is a browser image, but it's still draft. So we have to create much more beautiful. I want to have more time.....

Microsoft

Recently, I see Microsoft page many times. For examaple, I want to get how to use SQL Server, Visual studio and Expression studio.
So I found some Microsoft pages are very cool!!
For Instance:
Microsoft Expression
MSDN
Silverlight Download
These pages have good balance, so I am confortable.
However, there are slightly heavy for my internet network.

Exam Preparation Database SQL Query

Create Stored Procedure

CREATE
PROCEDURE usp_AddCustomer

@CustomerID INT,

@FirstName    VARCHAR(30),

@LastName    VARCHAR(30),

@Phone        VARCHAR(20),

@Email        VARCHAR(30)

AS

INSERT
INTO CUSTOMER(CustomerID,FirstName,LastName,Phone,Email)

VALUES

(@CustomerID, @FirstName, @LastName, @Phone,@Email);

 

EXEC usp_AddCustomer
'8',
'John','Smith','723-555-3432','John@somewhere.com';

 

SELECT
*

FROM CUSTOMER

WHERE CustomerID=8;

 

Create Trigger part1

 

CREATE
TRIGGER reminder

ON CUSTOMER

AFTER
INSERT

AS
RAISERROR ('Notify new Customer inserted', 16, 10);    

 

INSERT
INTO CUSTOMER

VALUES

(8,'Mick',
'Jager','723-599-1111','MJager@somewhere.com');

 

 

Create Trigger part2

 

CREATE
TRIGGER SetOrederItem1

ON CLOTH_ITEM

AFTER
INSERT

AS

    DECLARE

        @OrderID        INT,

        @ItemNo        INT,

        @Item            VARCHAR(30),

        @Quantity        INT,

        @UnitPrice        MONEY,

        @S_ItemNo        INT,

        @S_UnitPrice    MONEY

    SELECT @ItemNo=ItemNo, @UnitPrice=UnitPrice

    FROM inserted i

 

    SELECT @S_ItemNo=S.ItemNo,@S_UnitPrice=S.UnitPrice

    FROM
SERVICE S

    WHERE S.ItemNo=@ItemNo

 

IF (@ItemNo=@S_ItemNo)AND(@UnitPrice<>@S_UnitPrice)

BEGIN

        RAISERROR ('Price is different from SERVICE table', 16, 1)

        ROLLBACK
TRANSACTION

END

ELSE

BEGIN

        PRINT'The modification excuted'

END;

 

INSERT
INTO CLOTH_ITEM

VALUES

(2009006,6,'Suit-Mens',10,'$6.00');

 

 

INSERT
INTO CLOTH_ITEM

VALUES

(2009008,6,'Suit-Mens',10,'$9.00');

 

 

Create View

 

CREATE
VIEW OrderSummaryView

AS
SELECT OrderID,DateIn,DateOut,TotalAmount

FROM ORDER_RECORD;

Exam Preparation C# Use ArrayList in ArrayList

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Collections;

 

namespace ConsoleApplication2

{

//Drow picture use ArrayList in ArrayList

class
Program

{

static
void Main(string[] args)

{

//Initialize parent arraylist

ArrayList al = new
ArrayList();

 

//Initialize child arraylist

ArrayList childal1 = new
ArrayList();

childal1.Add(" * ");

//Initialize child arraylist

ArrayList childal2 = new
ArrayList();

childal2.Add(" *** ");

//Initialize child arraylist

ArrayList childal3 = new
ArrayList();

childal3.Add(" ***** ");

//Initialize child arraylist

ArrayList childal4 = new
ArrayList();

childal4.Add("*******");

//Initialize child arraylist

ArrayList childal5 = new
ArrayList();

childal5.Add(" ***** ");

//Initialize child arraylist

ArrayList childal6 = new
ArrayList();

childal6.Add(" *** ");

//Initialize child arraylist

ArrayList childal7 = new
ArrayList();

childal7.Add(" * ");

 

//Put in child array into parent array

al.Add(childal1);

al.Add(childal2);

al.Add(childal3);

al.Add(childal4);

al.Add(childal5);

al.Add(childal6);

al.Add(childal7);

 

//Display ArrayList data

foreach (ArrayList array in al)

{

//Initialize IEnumerator

IEnumerator enm = array.GetEnumerator();

//Get data using IEnumerator

while (enm.MoveNext())

{

Console.WriteLine(enm.Current.ToString());

}

}

}

}

}