Building a Tool for Cost-Based Design of Object-Oriented Database Schemas
In the traditional waterfall approach for building a software application, the phases of requirements analysis, design, implementation, testing, and maintenance follow one another. Aiming at the efficiency of a database application, we see that the outcome of the implementation phase decisively determines how much time the execution of queries and updates requires and how much space is needed to store the application data. But, these costs of the application result from decisions made not only in the implementation phase but also before that during the design phase. In this paper, we describe a tool to support the cost-based design of database applications. Based on earlier research where we designed a cost-model for an abstract object-oriented database machine, the tool shall provide its user with cost estimates during the design phase. We discuss which modifications and additions to our cost-model we use to build the tool. Specifically, we portray how we adapt the tool to a concrete DBMS. After picturing a design process that employs our tool, we conclude by assessing the achievements of the present work and how we benefited from our earlier underlying research.
KeywordsCost Model Access Structure Object Type Cost Parameter Database Schema
Unable to display preview. Download preview PDF.
- 1.Agrawal, S., Chaudhuri, S., Kollár, L., Marathe, A.P., Narasayya, V.R., Syamala, M.: Database Tuning Advisor for Microsoft SQL Server 2005. In: Nascimento, M.A., et al. (eds.) , pp. 1110–1121 (2005)Google Scholar
- 7.Dageville, B., Das, D., Dias, K., Yagoub, K., Zaït, M., Ziauddin, M.: Automatic SQL tuning in Oracle 10g. In: Nascimento, M.A., et al. (eds.) , pp. 1098–1109.Google Scholar
- 9.Nascimento, M.A., Özsu, M.T., Kossmann, D., Miller, R.J., Blakeley, J.A., Schiefer, K.B. (eds.): Proceedings of the 30th International Conference on Very Large Data Bases, Toronto, Canada, August 27–September 3. Morgan Kaufmann, San Francisco (2004)Google Scholar
- 11.Royce, W.W.: Managing the development of large software systems. In: Proceedings, IEEE WESCON, pp. 1–9. The Institute of Electrical and Electronics Engineers, Inc. (August 1970)Google Scholar
- 12.Martin Steeg. RADD/raddstar: A Rule-based Database Schema Compiler, Evaluator, and Optimizer. PhD thesis, Fakultät Mathematik, Naturwissenschaften und Informatik der Brandenburgischen Technischen Universität Cottbus (2000)Google Scholar
- 14.Tupper, C.: The physics of logical modeling. Database Programming & Design 11(9) (September 1998)Google Scholar
- 15.Zilio, D.C., Rao, J., Lightstone, S., Lohman, G., Storm, A., Garcia-Arellano, C., Fadden, S.: DB2 Design Advisor: Integrated automatic physical database design. In: Nascimento, M.A., et al. (eds.) , pp. 1087–1097Google Scholar