AN ADAPTABLE BUSINESS COMPONENT BASED ON PRE-DEFINED BUSINESS INTERFACES

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

2011

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. Bauer, C. & King, G. 2007. Java Persistence with Hibernate, Manning.
  3. Bracciali, A., Brogi, A. & Canal, C. 2005. A formal approach to component adaptation. Journal of Systems and Software, 74, 45-54.
  4. Bracciali, A., Brogi, A. & Canal, C. 2005. A formal approach to component adaptation. Journal of Systems and Software, 74, 45-54.
  5. Clements, P. & Northrop, L. 2001. Software Product Lines: Practices and Patterns, Addison-Wesley.
  6. Clements, P. & Northrop, L. 2001. Software Product Lines: Practices and Patterns, Addison-Wesley.
  7. Cook, W. & Ibrahim, A. 2006. Integrating programming languages and databases: what is the problem? Available: http://www.odbms.org/experts.aspx# article10 [Accessed 2006].
  8. Cook, W. & Ibrahim, A. 2006. Integrating programming languages and databases: what is the problem? Available: http://www.odbms.org/experts.aspx# article10 [Accessed 2006].
  9. 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.
  10. 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.
  11. David, M. 1990. Representing database programs as objects. Advances in Database Programming Languages. N.Y.: ACM.
  12. David, M. 1990. Representing database programs as objects. Advances in Database Programming Languages. N.Y.: ACM.
  13. 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.
  14. 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.
  15. 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.
  16. 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.
  17. Flower, M. 2002. Patterns of Enterprise Application Architecture, Addison-Wesley.
  18. Flower, M. 2002. Patterns of Enterprise Application Architecture, Addison-Wesley.
  19. 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.
  20. 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.
  21. Heineman, G. T. & Councill, W. T. 2001. ComponentBased Software Engineering:Putting the Pieces Together, Addison-Wesley.
  22. Heineman, G. T. & Councill, W. T. 2001. ComponentBased Software Engineering:Putting the Pieces Together, Addison-Wesley.
  23. 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.
  24. 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.
  25. ISO 2003. ISO/IEC 9075-3:2003. In: STANDARDS, I. (ed.). ISO.
  26. ISO 2003. ISO/IEC 9075-3:2003. In: STANDARDS, I. (ed.). ISO.
  27. 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].
  28. 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].
  29. Kung-Kiu, L. & Zheng, W. 2007. Software Component Models. Software Engineering, IEEE Transactions on, 33, 709-724.
  30. Kung-Kiu, L. & Zheng, W. 2007. Software Component Models. Software Engineering, IEEE Transactions on, 33, 709-724.
  31. 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].
  32. 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].
  33. Microsystems, S. 2008. JDBC Overview [Online]. Sun Microsystems. Available: http://java.sun.com/pro ducts/jdbc/overview.html [Accessed 2010 Feb 27].
  34. Microsystems, S. 2008. JDBC Overview [Online]. Sun Microsystems. Available: http://java.sun.com/pro ducts/jdbc/overview.html [Accessed 2010 Feb 27].
  35. Microsystems, S. 2010a. Interface ResultSet [Online]. Sun Microsystems. Available: http://java.sun.com/ javase/6/docs/api/java/sql/ResultSet.html [Accessed 2010 Jul].
  36. Microsystems, S. 2010a. Interface ResultSet [Online]. Sun Microsystems. Available: http://java.sun.com/ javase/6/docs/api/java/sql/ResultSet.html [Accessed 2010 Jul].
  37. 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].
  38. 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].
  39. Pohl, K., Bockle, G. & Linden, F. J. V. D. 2005. Software Product Line Engineering, Springer.
  40. Pohl, K., Bockle, G. & Linden, F. J. V. D. 2005. Software Product Line Engineering, Springer.
  41. 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.
  42. 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 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 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


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