With the continuous expansion of a system，the reliability of a system becomes more and more  important. There is one thing that must be taken into consideration --- concurrency control. Using our project as an example, there may be multiple administrators trying to write to the database. That is to say, we have to run transactions concurrently to meet their performance requirements. Thus, without concurrency control our plugin can neither provide correct results nor maintain their databases…

I just wandered whether there is a method of combining the computing power of a high-level language like C/C++ and the database manipulation capabilities of SQL a few days ago. But now I find the answer, embedded SQL. We can use embedded SQL to execute any SQL statement from an application.

The first technique for sending SQL statements to the DBMS is embedded SQL. Because SQL does not use variables and control-of-flow statements, it is often used as a database sublanguage…

ADAM is the name of our team which was proposed after our team first meeting. I am very happy and proud of being a member of this team. All of us study hard and work hard to achieve our same goal.

After the task division by our group leader Liu, I am responsible for the technical development of our project. I still remember that I spent a lot of time to construct our basic database.

I had spent nearly two weeks learning about E-R model, relational model and…

1. Relational model

I still remember it is my first time to read such an academic article in detail. I have to say that it’s really a hard time for me at the beginning.  Edgar F. Codd originated the relational approach to database management in a series of research papers published commencing in 1970. After read the seminal paper "A Relational Model of Data for Large Shared Data Banks" which Prof.koo recommends us to read, I got some basic knowledge…