- Created TPC-C’s database schema in MySQL
- Connected MySQL database by using ODBC
- Implemented TPC-C’s database population by using JDBC
- Implemented TPC-C’s transactions which interact with TPC-C’s database
- Testing and debugging before deployment
- Developed EJB by using JBoss to host the server for transactions
- Connected local client with EJB server
- Connected remote client with EJB server
- Monitoring the result provided by EJB server
- Developed Web Server by using Tomcat to host the server for transactions
- Connected local client with Web Server
- Monitoring the result provided
- Integrate server with GUI
- Designed the system structure
- Implement TPC-C Benchmark GUI
- Integrate server with GUI
- Implement the EJB and Web Service to host transactions
- Recorded all results as required and specified by TPC-C as closely as possible
- Draw performance diagram for monitoring the TPC-C result
Monday, November 12, 2012
Achievements
Project conclusion
The computer is becoming more and more important. Therefore to find a best tool or framework for measuring performance is becoming essential work as well. Therefore the performance testing tools are widely use in industry.
TPC does the good job in this area it helps user to measuring performance result for both hardware and software. But most of current TPC performance tools or frameworks are too expensive and very complicate. They are very hard to use. In order to provide the best result testers need a long time for training to learn how to use the tools. So performance testing become a costly and timing consuming activity in software development.
Our TPC-C benchmark is aim to provide as open source tool for any users. With an easy to use interface provided therefore it can be used for any levels of users even the person who has no programming experience at all can use it as well. So it don’t need to take a long time to learn reduce time cost and because our TPC-C is open source free to use so it can be saved a lot of money by using our framework.
TPC does the good job in this area it helps user to measuring performance result for both hardware and software. But most of current TPC performance tools or frameworks are too expensive and very complicate. They are very hard to use. In order to provide the best result testers need a long time for training to learn how to use the tools. So performance testing become a costly and timing consuming activity in software development.
Our TPC-C benchmark is aim to provide as open source tool for any users. With an easy to use interface provided therefore it can be used for any levels of users even the person who has no programming experience at all can use it as well. So it don’t need to take a long time to learn reduce time cost and because our TPC-C is open source free to use so it can be saved a lot of money by using our framework.
Wednesday, October 31, 2012
TPC-C Testing Result
Test on Single Computer
Although one of the purposes of this project is to build a remote testing framework, it is very necessary to build a base line of each computer. The results of tests on each computer can be used to analysis the data in later stages. For example, if the response time of remote test is longer than response time on single computer, it is very possible that the internet limit the performance. But it is impossible to get such conclusion without the test each computer independently.
First of all, the capacity of each compute had to be tested, since it could help to make decisions in the later stages. The usage rate of both CPUs and Memories were recorded with different number of threads ran. The table 4.6 is the record of all tests.
Figure 4.5 was generated with the data from Table 4.6. It is clear that the increasing rate of usage rates of CPUs slow down with the increasing of number of simulated clients. Both CPUs are capable with the tests, and can afford very large number of clients.These independent tests indicate a start point for following tests. The computers can afford large number of client, it is not necessary to start the test with small numbers. One reasonable number of clients will be 20.
Although one of the purposes of this project is to build a remote testing framework, it is very necessary to build a base line of each computer. The results of tests on each computer can be used to analysis the data in later stages. For example, if the response time of remote test is longer than response time on single computer, it is very possible that the internet limit the performance. But it is impossible to get such conclusion without the test each computer independently.
First of all, the capacity of each compute had to be tested, since it could help to make decisions in the later stages. The usage rate of both CPUs and Memories were recorded with different number of threads ran. The table 4.6 is the record of all tests.
Figure 4.5 was generated with the data from Table 4.6. It is clear that the increasing rate of usage rates of CPUs slow down with the increasing of number of simulated clients. Both CPUs are capable with the tests, and can afford very large number of clients.These independent tests indicate a start point for following tests. The computers can afford large number of client, it is not necessary to start the test with small numbers. One reasonable number of clients will be 20.Project Achievements
- Created TPC-Cˇs database schema in MySQL
- Connected MySQL database by using ODBC
- Implemented TPC-Cˇs database population by using JDBC
- Implemented TPC-Cˇs transactions which interact with TPC-Cˇs database
- Testing and debugging before deployment
- Developed EJB by using JBoss to host the server for transactions
- Connected local client with EJB server
- Connected remote client with EJB server
- Monitoring the result provided by EJB server
- Developed Web Server by using Tomcat to host the server for transactions
- Connected local client with Web Server
- Monitoring the result provided
- Integrate server with GUI
Thursday, October 11, 2012
ReadMe For Web Service
Today I was written the read me file for Web Service set up which contain the following features:
- Tomcat set up
- Add the JDK to the tomcat server
- Import project to eclipse
- Add project to Tomcat
- Start Tomcat
- run project
- get result
Wednesday, October 3, 2012
Read Me file for EJB
Today I had finish the Read Me file for EJB component and sent both Read me files of EJB and DATA LOADING componets to Dr.Shi Ping Chen and he is very satisfied with these two files. Then I am going to start the report soon.
Tuesday, September 25, 2012
Read Me for database load
Today I finished the read me file for TPC LOADING DATA part which is introduced following features:
1: Set up MySQL
2: Use ODBC to connect java code and MySQL
3: Create database tables
4: Loading data into the database table.
1: Set up MySQL
2: Use ODBC to connect java code and MySQL
3: Create database tables
4: Loading data into the database table.
Subscribe to:
Posts (Atom)