As recommended by Professor Koo, <beautiful data> was chosen as the sample of well written document for our final reports.

O'Reilly Media, the author of this book said that, “In this insightful book, you'll learn from the best data practitioners in the field just how wide ranging and beautiful working with data can be. Join 39 contributors as they explain how they developed simple and elegant solutions on projects ranging from the Mars lander to a Radiohead…

      In the process of writing the final report of our project, I find the concept of transaction is very important, hence I review the process of transaction again.

     1.  Definition of transaction

     A transaction is a unit of program execution that accesses and possibly updates various data items. (Reference: Database System Concepts, 4^th edition, P565, Abraham Silberschatz, Henry F.Korth, S. Sudarshan) Or in short, transaction is a sequence of read…

    A few days ago, Professor Koo recommended “Mendeley” to do academic research. I try to use it in my own research in managing download papers and benefit a lot, it’s efficient and convenient, the fast searching speed and clear data structure may result from its great database design and the interface of the software is also friendly. Although I have not started to use the powerful citing and grouping features, I’d like to list all its wonderful performance here. It deserves your attention…

    Recently, we have been processing our project with the common team SVN account. It helps us a lot in sharing and recording codes in every stage of our work, we really benefit from SVN, and in this blog, I’d like to discuss the necessity of subversion management system like SVN as the reflection of today’s illustration about SVN.

    SVN is famous for various functions like backup and data sharing. Here, I’d like to mention three important applications that benefit from SVN: backup…

      In the previous lesson, Professor Koo gives the speakers patient guidance as well as strict requirements. I quite appreciate the professor’s effort of improving the class’ lecture skill. In my opinion, making a lecture is a very important skill. We are always in need of sharing our view and findings with other people. This is how we make our work known and improve by sharing. Although students may sometimes feel embarrassed for going onto the stage or going over the same script again…

    This week, the combined team gives us a very inspiring lecture on data storage and querying. I have been doing some research on e-commerce, so I’m interested in e-commerce data processing method. Here, I’d like to share my understanding and personal opinion about data storage and querying of e- commerce after several days’ learning.

Background

    Emerging applications such as…

In the past few weeks, I’ve spent a lot of…

    Many groups should consider data visualization in their projects, JavaScript libraries can provide efficient and effective ways to realize this. Here, I’d like to introduce some most popular JS libraries for data visualization.

    A JavaScript library is a library of pre-written JavaScript which allows for easier development of JavaScript-based applications, especially for AJAX and other web-centric technologies.

-Wikipedia

    Popular…

Today, the 14-members team gives us a very inspiring lecture on technological process of application design an improvement. They progress to explain requirement analysis, data source analysis, the important concept ETL, database design implementation, operation and maintenance.

While In some related Database material, design process can be divided into the following 6 steps: Requirement analysis, Conceptual database design, Logical data base design, Schema refinement, Physical data…

Any usage of data on computer should be valued under two main criteria, one is the space it takes, and the other is the operation efficiency. Normal forms help decrease spaces to store data, but it decreases the efficiency too when you need to connect two tables to finish one operation. So we sometimes need to break the normal forms to get a balance of both space and efficiency. And that’s denormalization.

In database design, denormalization is the process of attempting to optimise…