AN ADAPTABLE BUSINESS COMPONENT BASED ON PRE-DEFINED BUSINESS INTERFACES

Oscar M. Pereira, Rui L. Aguiar, Maribel Yasmina Santos

Abstract

Object-oriented and relational paradigms are simply too different to bridge seamlessly. Architectures of database applications relying on three tiers need business tiers to bridge application tiers and database tiers. Business tiers hide all the complexity to convert data between the other two tiers easing this way programmers’ work. Business tiers are critical components of database applications not only for their role but also for the effort spent on their development and their maintenance. In this paper we propose an adaptable business component (ABC) able to manage SQL statements on behalf of other components. Other components may create in run-time a pool of SQL statements of any complexity and delegate their management to the ABC component. The only constraint is that the SQL statements schema must be in conformance with one of the predefined schemas (interfaces) provided by the ABC component. The main contribution of this paper is twofold: 1) the presentation of an adaptable business component and 2) to show that the ABC source code may be automatically generated. The main outcome of this paper is the evidence that the ABC component is an effective alternative approach to build business tiers to bridge object-oriented and relational paradigms.

References

  1. Bauer, C. & King, G. 2007. Java Persistence with Hibernate, Manning.
  2. Bracciali, A., Brogi, A. & Canal, C. 2005. A formal approach to component adaptation. Journal of Systems and Software, 74, 45-54.
  3. Clements, P. & Northrop, L. 2001. Software Product Lines: Practices and Patterns, Addison-Wesley.
  4. Cook, W. & Ibrahim, A. 2006. Integrating programming languages and databases: what is the problem? Available: http://www.odbms.org/experts.aspx# article10 [Accessed 2006].
  5. Costa, C., Pérez, J. & Carsí, J. 2007. Dynamic Adaptation of Aspect-Oriented Components. In: Schmidt, H., Crnkovic, I., Heineman, G. & Stafford, J. (eds.) Component-Based Software Engineering. Springer Berlin / Heidelberg.
  6. David, M. 1990. Representing database programs as objects. Advances in Database Programming Languages. N.Y.: ACM.
  7. Elizondo, P. V. & Lau, K.-K. 2010. A catalogue of component connectors to support development with reuse. Journal of Systems and Software, 83, 1165- 1178.
  8. Erik, M., Brian, B. & Gavin, B. 2006. LINQ: reconciling object, relations and XML in the .NET framework. In: ACM SIGMOD International Conference on Management of Data, Chicago,IL,USA. ACM, 706- 706.
  9. Flower, M. 2002. Patterns of Enterprise Application Architecture, Addison-Wesley.
  10. Griss, M. L. 2000. Implementing product-line features by composing aspects. Proceedings of the first conference on Software product lines : experience and research directions. Denver, Colorado, United States: Kluwer Academic Publishers.
  11. Heineman, G. T. & Councill, W. T. 2001. ComponentBased Software Engineering:Putting the Pieces Together, Addison-Wesley.
  12. Hetrick, W. A., Krueger, C. W. & Moore, J. G. 2006. Incremental return on incremental investment: Engenio's transition to software product line practice. Companion to the 21st ACM SIGPLAN symposium on Object-oriented programming systems, languages, and applications. Portland, Oregon, USA: ACM.
  13. ISO 2003. ISO/IEC 9075-3:2003. In: STANDARDS, I. (ed.). ISO.
  14. Keene, C. 2004. Data Services for Next-Generation SOAs. WebServices Journal [Online], 4. Available: http://soa.sys-con.com/read/47283.htm [Accessed 2011 Jan].
  15. Kung-Kiu, L. & Zheng, W. 2007. Software Component Models. Software Engineering, IEEE Transactions on, 33, 709-724.
  16. Microsoft. 2010. Microsoft Open Database Connectivity [Online]. Microsoft. Available: http://msdn.micro soft.com/en-us/library/ms710252(VS.85).aspx [Acce ssed 2010 Mar 18].
  17. Microsystems, S. 2008. JDBC Overview [Online]. Sun Microsystems. Available: http://java.sun.com/pro ducts/jdbc/overview.html [Accessed 2010 Feb 27].
  18. Microsystems, S. 2010a. Interface ResultSet [Online]. Sun Microsystems. Available: http://java.sun.com/ javase/6/docs/api/java/sql/ResultSet.html [Accessed 2010 Jul].
  19. Microsystems, S. 2010b. Interface Statement [Online]. Sun Microsystems. Available: http://java.sun.com/ javase/6/docs/api/java/sql/Statement.html [Accessed 2010 Jul 2010].
  20. Pohl, K., Bockle, G. & Linden, F. J. V. D. 2005. Software Product Line Engineering, Springer.
  21. Schmoelzer, G., Teiniker, E., Kreiner, C. & Thonhauser, M. 2006. Model-typed Component Interfaces. In: Software Engineering and Advanced Applications, 2006. SEAA 7806. 32nd EUROMICRO Conference on, Aug. 29 2006-Sept. 1 2006. 54-63.
Download


Paper Citation


in Harvard Style

M. Pereira O., L. Aguiar R. and Santos M. (2011). AN ADAPTABLE BUSINESS COMPONENT BASED ON PRE-DEFINED BUSINESS INTERFACES . In Proceedings of the 6th International Conference on Evaluation of Novel Approaches to Software Engineering - Volume 1: ENASE, ISBN 978-989-8425-57-7, pages 92-103. DOI: 10.5220/0003462100920103


in Bibtex Style

@conference{enase11,
author={Oscar M. Pereira and Rui L. Aguiar and Maribel Yasmina Santos},
title={AN ADAPTABLE BUSINESS COMPONENT BASED ON PRE-DEFINED BUSINESS INTERFACES},
booktitle={Proceedings of the 6th International Conference on Evaluation of Novel Approaches to Software Engineering - Volume 1: ENASE,},
year={2011},
pages={92-103},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0003462100920103},
isbn={978-989-8425-57-7},
}


in EndNote Style

TY - CONF
JO - Proceedings of the 6th International Conference on Evaluation of Novel Approaches to Software Engineering - Volume 1: ENASE,
TI - AN ADAPTABLE BUSINESS COMPONENT BASED ON PRE-DEFINED BUSINESS INTERFACES
SN - 978-989-8425-57-7
AU - M. Pereira O.
AU - L. Aguiar R.
AU - Santos M.
PY - 2011
SP - 92
EP - 103
DO - 10.5220/0003462100920103