The database course is about to end. Throughout the whole semester, it is painful but truly meaningful. Not only have I learnt the knowledge of database and database technology, I also have learnt much beyond the textbook. Surly we have to figure out or understand relational model, E-R model or objected-oriented model and other model, but more importantly, we have to acquire a way of thinking, an approach to deal with those in real world as well. To build a model is just a tool…

Last week, we studied system architecture, which I think is an overall summary of what we have learnt in some aspect, for its tightly connection with all the contents that we have in database knowledge.

A system architecture or systems architecture is the conceptual model that defines the structure, behavior, and more views of a system. In database, it is the stable properties of a system. Three key factors (time, space and uncertainty) are determined by system…

Suffering from an unsatisfied lecture, I had some so-called introspection. Although we give a lecture as a whole, we still have many disagreements on the interpretation of many key ideas in transaction inside our group. Combining all the ideas and my thoughts together, I have my final understanding on transaction, one of the most complicated but reasonable concept in database system.

It is universally acknowledged that transaction refers to a collection of operations that form a…

“Working on a nonlinear editing system is like working with a sophisticated word processor. Using a computer screen and a mouse you can randomly cut and past segments and move them around until you are satisfied with the result.

Working on a linear editing system is a bit like using a typewriter to type a term paper; you need to assemble everything in the proper sequence as you go along. After it's all on paper…