1 / 19

TTA Studio Project

TTA Studio Project. Kim, HyungChoul Han, SangJin Hong, KangWoon DEC. 09, 2005. Project Overview. High-level function diagram. Internationalization Issue. DBGenerator ;should reflect the kinds of databases that TTA want to test. While the kinds of databases that

mahina
Download Presentation

TTA Studio Project

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. TTA Studio Project Kim, HyungChoul Han, SangJin Hong, KangWoon DEC. 09, 2005

  2. Project Overview High-level function diagram

  3. Internationalization Issue • DBGenerator ;should reflect the kinds of databases that TTA want to test. While the kinds of databases that our product supports are limited, local industry may require other kinds of databases.

  4. Solution 1 • Without considering client’s target nations, we design the product to support only three DBMS: Oracle, MS-SQL, and MySQL • Additional development or customization is needed ,but low initial cost

  5. Solution 2 • With considering client’s target nations, we intensively survey the kinds of DBMS used in the nations. • Based on the survey result, we design and develop the product to support all kinds of DBMS in the result report. • No additional development ,but high initial cost

  6. Economic Approach–Assumption(1-2) 1) The life of the product is five years because the recent big changes of TPC-H occurred every five year on average. 2) Interest rate is 5% based on 3-yr government bond rate in Korea.

  7. Economic Approach–Assumption(3-4) 3) THEORACTICE team  three members Each has equal development capacity : the economic value of each member is approximately 3,000,000 won per month, In addition, the present value of the wage is same for five years. 4) In the case of solution (1), the number of the new kinds of DBMS to be added annually is 0.6 on average.  In fact, TTA(our client) gets 3 requests annually on average. When the market share of Oracle, MS-SQL, and MySQL is almost 80%, 3 * (1- 0.8) = 0.6

  8. Economic Approach–Assumption(5-6) 5) In the case of solution (2), the number of the kinds of DBMS that DBAuditor supports is seven because some existing tools support those seven kinds of DBMS and TTA’s target nations are the same as the existing tools’ target nations. 6) The cost is calculated largely according to human resource used.

  9. Economic Approach–Assumption(7-8) 7) The time for three members to comprehend one DBMS and implement DBGenerator to support the DBMS is one month.  By estimation based on informal historical data of each member 8) TTA earns 10,000,000 won per one DBMS test. And, as mentioned on Assumption 4, there are 3 requests annually on average.

  10. Economic Approach – Assumption(9) 9) The time for three members to concentrate on software architecture is full one month.  Next spring semester is for 5 months and the portion of studio project is 20%. In addition, for next semester, we will make only software architecture. • For more extensible and robust architecture, 20 % of total time will be added; that is, 1.2 month for more extensible and robust one.

  11. Analysis – ROI (SOLUTION1) • Earning per year = 3 * 10M = 30M (won) • Initial Investment = 3 * 10M (for 3 DBMS support) + 1.2 month / person * 3M / month * 3 person (for more extensible and robust architecture) = 40.8M (won) • Additional Investment each year : 0.6 * 3M * 3 person = 5.4M (won)

  12. Analysis – ROI (SOLUTION1)

  13. Analysis – ROI (SOLUTION2) • Earning per year = 3 * 10M = 30M (won) • Total Investment = 7 * 10M (for 3 DBMS support) + 1 month / person * 3M / month * 3 person (for architecture) = 79M (won)

  14. Analysis – ROI (SOLUTION2)

  15. Analysis – Cost/benefit (SOLUTION1)

  16. Analysis – Cost/benefit (SOLUTION2)

  17. Analysis – Synthesis

  18. Conclusion • Based on the result, solution 1 is more desirable (solution1’s ROI > solution2’s ROI solution1’s cost/benefit ratio < solution2’s cost/benefit ratio) In terms of both ROI and Cost/benefit analysis, solution 1 is better than solution 2.

  19. Thank You

More Related