"New semester~~"
汪逸之's Groups
汪逸之's Page
Latest Activity
汪逸之 commented on 朴美花's blog post Data mining in the our life"Data Mining influence our life a lot, especially in the era of Internet and Information. The open API of some websites, such as sina micro-blog, makes it easy for people to collect personal data from the webpage using the technique of data mining."
汪逸之 posted a blog postPersonal Report ----Something Learnt about View
Personal Report ----Something Learnt about ViewWhat is view?A view consists of a stored query accessible as a virtual table in a relational database or a set of documents in a document-oriented database composed of the result set of a query or map and reduce functions. It is different from ordinary tables in a relational database in that a view does not form part of the physical schema. Instead, it is a dynamic virtual table. Changing the data in a table alters the data shown in the view,…See More
汪逸之 commented on 刘哲's blog post Something I learnt about View"I suddenly remember that we have already learnt something about view when we are studying ACCESS in Grade one!! But obviously we have forgotten all about that."
汪逸之 commented on 李木森's blog post Data Storage – view in enterprise database aspect"Reference: slides of database course in Hong Kong University~~haha~~I think the storage of data is a critical issue in designing a practical database system, concerning the scale of data."
汪逸之 commented on 巨鑫's blog post My impression after viewing some groups’ final report"Good reflection!! I think you have made an important summary of the merits and drawbacks of each group's presentation, and I agree with you on most of the points. I believe next week, we will witness a much better final report presentation."
汪逸之 posted a blog postPersonal Report on System Architecture
Last week, two groups of students delivered the last lecture in this semester, on the topic of system architecture. System architecture focuses on something that does not change in a system, according to the lecture.Key factors, say, time, space, uncertainty in designing a system are discussed. In addition, six steps of application design are provided, including requirement analysis, data source analysis, database design, implementation, operation and maintenance and so on. Database is used on…See More
汪逸之's Blog
Personal Final Summary
Posted on January 16, 2012 at 7:30am 0 Comments 2 Likes
Personal Summary
Wang Yizhi
It is time to summarize what I have learnt in database course in this semester. Frankly speaking, this is one of the courses which have exerted most stress on me. However, it is also the most unique and irreplaceable course I have ever taken, because I have acquired not only basic knowledge concerning database, but also study skills and creative ideas in various…
Continue Importance of SQL Optimization
Posted on January 15, 2012 at 10:30pm 0 Comments 0 Likes
The following SQL codes are used to select personal information that is inquired. The student ID and the inquired time of participation are typed in by users. The information of time, total score and score of each type of sport earned by the student during the month is returned.
All the information is selected from a view called indv_cmpr_view.
Version 1…
Continue Summary of Database Design Improvement
Posted on January 15, 2012 at 8:28pm 0 Comments 0 Likes
I have written a blog on the original data model design of our plug-in, but more improvement has been made later. I’d like to summarize the improvement here.
Improved E-R Model and Normalization
E-R model
After group…
Continue Personal Report ----Something Learnt about View
Posted on December 24, 2011 at 11:19am 0 Comments 2 Likes
Personal Report ----Something Learnt about View
What is view?
A view consists of a stored query accessible as a virtual table in a relational database or a set of documents in a document-oriented database composed of the result set of a query or map and reduce functions. It is different from ordinary tables in a relational database in that a view does not form…
ContinueCC 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.
Groups
Top Content
Events
Photos
Videos
Sponsors
Toyhouse.cc is licensed under a Creative Commons Attribution-NoDerivs 3.0 Unported License.
© 2012 Created by Toyhouse Administrator.
