Website Database Done

After the debugging process, my database for the website finally finished.
Here I want to talk about the database and give a brief explaination to the database.

Above Image is a screen shot of my database, there are four seperate tab for this database: images, picNum, rating and scores.

Images Function : Record the URL address for a certain picture viewed by user.For instance so you will  see a address like this : http://farm5.static.flickr.com/4059/4475929936_a88c5f442c.jpg. and a id number.

Score :
ID-Will distribute a integer value to the access order
p_id-Is the integer values for a certain picture,which link to the Images, so we could track which picture has been voted.
type-Is a boolean values which only have 1 and 2 , "1" mean the emotion icon votes, "2" mean the axis panel vote.
score for "2"- This value comes from the emotion axis, which is a integer value arrange by the file point,
point is a flash object in the website ( I will give a detail discussion on future blog post). there are about 7000 points on the axis panel, as the following images shows.

score for "1" - This value is a average value, there are seven image icon on the website so. from 1 to 7,

if user A press the first one, user B  press the fifth one so the value for "1" is equal to (1+5)/2 = 3

Hopefully this post will give a better understanding to my database record process.

http://www.affectiveflickr.com/ is now online.

Further Application About SAM

Understanding emotions is vital to understanding people. Every decision is a combination of rational and emotional factors. And emotion has been shown to be the driver of behavior and preference.

So Why are emotions important?

Well,emotions is a powerful influencers which effect behavior, relationships, evaluation & consideration, to name a few.

Adsam is a assessment model which specialised applied to advertisement, brand and any other form of design, adsam is a non-verbal measure, which eliminates verbal biases and makes its appropriate for cross-cultural use. The globally recognized system includes measurement, analysis, consultation, written reports and recommendations. As we know SAM ( Self-Assessment Manikin) can analysis three aspect of emotion. Pleasure, Arousal, and Dominance, so the user of Adsam can get the result from those aspect and decide which of their advertisment design is more "Emotional".

New Improved Interface

The New Interface for the affectiveflickr has been done. It has the following Improvement.

1.More Friendly Interface which will give user more directly view the picture.
2.The picture now has the automatic fit to the layer. so the picture can be any resolution.
3.More flexible emotion evaluations. User now can point any coordinate in the axis panel,(before is fix point selection).
4. Drag function, User now can drug the emotion icon to the right hand panel.
5. History Function, user now can be review their or other's old submission on the picture.
6. Output file, we can get a new output file which anaylsis all the emotion submission data on a single picture.

Will Upload the Completed Version to the domain : www.affectiveflickr.com

Prototype is up NOW

After a week on debugging the prototype of the webisite is up.

http://www.affectiveflickr.com/

there are still some bugs on the website and I still working on it. There will be some major interface changes in the next two weeks. current version is just for prototype purpose.
Will meet Dr.Rafael today hopefully can get some more advice from him.

Some reference for the website. (ref to the screenshot on the top)

1、Default.htm is just a static interface page, in addition all the background work is handled by inde2.aspx and save.aspx.
2、bigsecond.aspx is used to display the history of all images pages.
3、second.aspx is used to display a picture of specific pages。
4、jquery libray is called from js/jquery-1[1].2.1.pack.js this file. The slide1.js in the root directory is use to call this jquery libary.
5、The ajax postback in the default.htm is used jquery framework $.Ajax () method to completed.*

Finally A BETA Version is finished

Here is some screen shot of my beta version. basically it take 5 weeks to finished, I hope it is not slow, will do some modification during the midterm break , but i don't there will be any huge layout change. Because it use a lots of layer in the code. that's AJAX :) , if any small change then i will need to change the entire layer.

Project Proposal

Problem Statement:
Determine the application of affective computing by using static image from Flickr.

Method of Attack:
Overall it will divide into two parts, theory and practical.
Theory: Before tackle the website, it is essential to understand affective computing. Book “Affective Computing” by R.Picards is required reading. Also the workshop arrange by Dr.Rafael is very important.
Practical: It is proposed to create a website which implementing “think-feeling axis” and SAM (Self-Assessment-Manikin). The entire website is web2.0 ideas, so it makes communications easier. The code of the website will base on AJAX, JavaScript, SQL and PHP. Development tool will use Visual Studio 2008 Professional Edition and other compatible platform.

Schedule:
This is shown in the attached table. A total of two semesters 20 week of time is estimated, which includes about 6 weeks of theory and 14 weeks of practicals. In the first 6 weeks basically is the readying and understanding the background concept. Then following 4 weeks will starting the website part generating the idea for the website. And the last 10 week will work fully on the website and the treatise.

"Affective Computing"

First Meeting about the Thesis

Topic : Affective Flickr!

Date: 10/08/2009

Basically the meeting is not long but there are lots of things covered in this meeting. firstly Dr Rafael give a more detail description about "what is affective". As he told me there is a system called IAPS stand for (International Affective Picture System ) which is a system that "provides normative ratings of emotion for a set of color photographs that provide a set of normative emotional stimuli for experimental investigations of emotion and attention" .

These days I've been reading the "Affective Computing" by W.Picard. Dr. Rafael said this book is very helpful for me understanding the background of the topic.

Althought this book is a bit old, the theory still very useful in nowaday computing. So I will keep updating the blog about the contect in this book before the thesis purposal date.