李文昊 Male 北京 China, mainland: Like

0 members like this; Share on Facebook

Share Twitter

李文昊's Likes

李文昊's Friends

View All

李文昊's Groups

Tsinghua University Data…

78 members
2 Comments 14 Likes
DatabaseLovers

6 members
1 Comment 0 Likes

View All

李文昊's Discussions

Proposal of Group 7

Started Oct 1, 2011 0 Replies 1 Like

Proposal of Group 7 Because in week 2 and week 3, all of our group members are fully engaged in the preparation for the lecture, we have just discussed our group proposal. The expectation of the…Continue

View All

李文昊's Page

Latest Activity

李文昊 liked 李文昊's discussion Final report of Group 7

Jan 20

李文昊 liked 宋瑞典's blog post Use After Effects Templates to Make Videos

Jan 16

宋瑞典 liked 李文昊's discussion Final report of Group 7

Jan 4

李文昊 added a discussion to the group DatabaseLovers

Final report of Group 7

Final report of Group 7 李文昊2009010872杨曹莹2009010866宋瑞典2009010664刘媛媛2009010828陶嘉羚2009010545李健桥2008010858 I. Plug-in Introduction1. Background1.1 Requirement analysis1.2 Data source analysis1.3 E-R model1.4 Normalization2. Plug-in feature2.1 login2.2 diet and exercise record2.3 calorie calculations2.4 data visualization2.5 sports recommendation3. Development tools and Implementation3.1 SQL3.2 PHP3.3 CSS3.4 JavaScript3.5 HighChartsII. System architecture1. Organization of all the files2. Operator and operands——a general classification for the system components3. Interaction between PHP files and databaseIII. Fault tolerance and compatibility analysisIV. Data recoveryV. Efficiency analysis-manage scalability1. Attributes design2. Normalization3. Query optimization4. Decide which type of lock to useVI. Further development1. Future expectation of iCalorie(local users)What can a local user do…See More

Jan 4

0 Comments 3 Likes

李文昊 posted a blog post

Efficiency analysis-manage scalability

Efficiency analysis-manage scalability As we can see, any applications can’t refuse to face the difficulty of handling a huge amount of data, especially the plugin is for further utilization. In order to handle a huge amount of data, there are two crucial factors: Whether each attribute of each table is designed appropriately Whether the degree of normalization is appropriate Whether query is optimized Whether the type of lock (i.e. isolation level) is chosen properly 1. Attributes designFor the first question, there is no definite answer. But the criterion is sure: the only judge is the user, whose requirement should be satisfied to the full extent. As industrial engineers, we should design a product with both high user satisfaction and low cost, which always requires a balance between different factors. For example, the sport name is the primary key of the sport_info table, which will be frequently used by all kinds of selection operations. So, the length of this attribute may…See More

Jan 4

0 Comments 0 Likes

陶嘉羚 liked 李文昊's blog post System architecture analysis of our plugin

Dec 30, 2011

李文昊 posted blog posts

Dec 29, 2011

林汀楠 liked 李文昊's blog post How to decide which type of locking(e.g. isolation level) to use?

Dec 29, 2011

李文昊 liked 杨曹莹's blog post E-R model and normalization of our plugin

Dec 28, 2011

宋瑞典 liked 李文昊's blog post How to decide which type of locking(e.g. isolation level) to use?

Dec 28, 2011

宋瑞典 liked 李文昊's blog post Summary for data visualization

Dec 21, 2011

杨曹莹 liked 李文昊's blog post Summary for data visualization

Dec 20, 2011

李文昊 posted a blog post

Summary for data visualization

Summary for data visualizationRecently, I’m keen for data visualization, which is a key issue for the improvement of our project and user satisfaction. More importantly, visualized information is much more direct and attracts our attention easily. In previous lectures, I have witnessed wonderful visual languages used by other groups and I greatly admire their innovation. After mid-term, I have been keen for some data visualization tools and find some sources on the internet. Then, I carefully studied the way for data visualization and made continuous progress step by step. Now it’s time for a summary of my efforts on data visualization and share my thoughts on it.First, I’ll take the example of our plugin- iCalorie to illustrate the point on data visualization: As you can see, a huge amount of information is presented on the…See More

Dec 20, 2011

0 Comments 2 Likes

李文昊 liked 陶嘉羚's blog post Play with Android SDK

Dec 7, 2011

李文昊 liked 陶嘉羚's blog post Have Fun with Arduino

Dec 7, 2011

巨鑫 liked 李文昊's blog post Some thoughts inspired by the wonderful videos produced in our database class

Dec 7, 2011

李健桥 liked 李文昊's blog post Some thoughts inspired by the wonderful videos produced in our database class

Dec 7, 2011

李健桥 liked 李文昊's blog post Introduction to the use of Sharepoint- a useful software for team management

Dec 7, 2011

李健桥 liked 李文昊's blog post Towards continuous progress

Dec 7, 2011

李文昊 posted a blog post

Some thoughts inspired by the wonderful videos produced in our database class

Some thoughts inspired by the wonderful videos produced in our database classI’m not an expert in video making. However, after appreciating many excellent videos made by my classmates on the database class, I have been considerably inspired by their thoughts and skills. So, I can’t help keeping down my thoughts on how to make a good video.Components on how to make a good video.1. Build a common theme which acts like a thread that weaves the whole video.1) Repeat the outline many times so that the watchers can exactly know where they are in the whole lecture. Nobody likes to get lost, so it’s significant to have your listeners know where they are in the lecture.I have remembered that this technique is used by “Mr. Bookshelf” and the result is: until now I can clearly recall what…See More

Dec 1, 2011

0 Comments 2 Likes

李文昊's Photos

Loading…

Comment Wall (1 comment)

You need to be a member of Toyhouse to add comments!

Join Toyhouse

At 3:45pm on September 26, 2011, Oriol Rodriguez said…: Hi 李文昊 leader of team 7 Database Lovers, I'm Oriol the TA. All your team members are in your group less 曾新. Please tell her/him to register to Toyhouse and to your group. Bye!

No comments yet!

李文昊's Blog

Efficiency analysis-manage scalability

Posted on January 4, 2012 at 12:03am 0 Comments 0 Likes

Efficiency analysis-manage scalability

As we can see, any applications can’t refuse to face the difficulty of handling a huge amount of data, especially the plugin is for further utilization. In order to handle a huge amount of data, there are two crucial factors:

 Whether each attribute of each table is…

Continue

System architecture analysis of our plugin

Posted on December 29, 2011 at 4:21pm 0 Comments 1 Like

This part is not constrained to the definition given by ANSI/SPARC about the three levels of system architecture. A broader view of system architecture is provided here to illustrate a more profound idea of database design.

1. Organization of all the files

Although the organization files may not directly influence the function of the plugin, it has dramatic effects on the efficiency of implementation. At first, we don’t pay…

Continue

How to decide which type of locking(e.g. isolation level) to use?

Posted on December 28, 2011 at 8:53pm 0 Comments 2 Likes

How to decide which type of locking

(e.g. isolation level) to use?

Lock is widely used in all kinds of software such as 飞信, SVN, SharePoint and so on. As long as there are multiple users in the system that share the same information and modify the files simultaneously, locks are necessary to ensure the successful…

Continue

Summary for data visualization

Posted on December 20, 2011 at 10:00pm 0 Comments 2 Likes

Summary for data visualization

Recently, I’m keen for data visualization, which is a key issue for the improvement of our project and user satisfaction. More importantly, visualized information is much more direct and attracts our attention easily. In previous lectures, I have witnessed wonderful visual languages used by other groups and I greatly admire their innovation. After mid-term, I have been keen for some data visualization tools and find some sources on the…

Continue

Welcome to
Toyhouse

Sign Up
or Sign In

CC Creative Commons

Share your knowledge and creativity with the world, protect your work with CC Licenses and discover other creative works and CC activities around the world. For Chinese CC, please go to: (中文版知识共享协议网站请点击) http://cn.creativecommons.org.

Creative Commons licenses provide a flexible range of protections and freedoms for authors, artists, and educators.