Business Object Query Language as Data Access API in ERP Systems

  • Vadym Borovskiy
  • Wolfgang Koch
  • Alexander Zeier
Part of the Lecture Notes in Business Information Processing book series (LNBIP, volume 73)


Efficient data manipulation API is a necessary prerequisite in satisfying a number of acute needs of ERP system developers and eventually end-users. The current work defines the efficiency as an ability of accessing and manipulating ERP data at any granularity level, while maintaining integrity of the data. This paper contributes with the concept of query-like service invocation implemented in the form of a business object query language (BOQL). Essentially, BOQL provides on-the-fly orchestration of CRUD-operations of business objects in an ERP system and allows to achieve both the flexibility of SQL and encapsulation of SOA. A special design effort has been dedicated to making BOQL scalable and resistant to changes in data schema of the system. To demonstrate the power of the suggested concept navigation, configuration and composite application development scenarios are presented in the paper. All suggestions have been prototyped with Microsoft .Net platform.


ERP data access Business object query language ERP system architecture Navigation in ERP systems Enterprise composite applications UI customization 


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 1.
    Banerjee, J., Kim, W., Kim, H.-J., Korth, H.F.: Semantics and implementation of schema evolution in object-oriented databases. In: Proceedings of the 1987 ACM SIGMOD international Conference on Management of Data, pp. 311–322 (1987)Google Scholar
  2. 2.
    Bertino, E.: A view mechanism for object-oriented databases. In: Pirotte, A., Delobel, C., Gottlob, G. (eds.) EDBT 1992. LNCS, vol. 580, pp. 136–151. Springer, Heidelberg (1992)CrossRefGoogle Scholar
  3. 3.
    Bratsberg, S.E.: Unified class evolution by object-oriented views. In: Pernul, G., Tjoa, A.M. (eds.) ER 1992. LNCS, vol. 645, pp. 423–439. Springer, Heidelberg (1992)CrossRefGoogle Scholar
  4. 4.
    Curino, C.A., Moon, H.J., Zaniolo, C.: Graceful database schema evolution: the prism workbench. In: Proceedings of the VLDB Endowment, pp. 761–772 (2008)Google Scholar
  5. 5.
    Liu, C.-T., Chrysanthis, P.K., Chang, S.-K.: Database schema evolution through the specification and maintenance of changes on entities and relationships. In: Loucopoulos, P. (ed.) ER 1994. LNCS, vol. 881, pp. 132–151. Springer, Heidelberg (1994)CrossRefGoogle Scholar
  6. 6.
    Monk, S., Sommerville, I.: Schema evolution in oodbs using class versioning. In: ACM SIGMOD, pp. 16–22 (1993)Google Scholar
  7. 7.
    Shiling, J.J., Sweeney, P.F.: Three steps to views: extending the object-oriented paradigm. In: Conference Proceedings on Object-Oriented Programming Systems, Languages and Applications, pp. 353–361 (1989)Google Scholar
  8. 8.
    Yu, J., Benatallah, B., Casati, F., Daniel, F.: Understanding mashup development. In: IEEE Internet Computing, pp. 44–52 (2008)Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2011

Authors and Affiliations

  • Vadym Borovskiy
    • 1
  • Wolfgang Koch
    • 1
  • Alexander Zeier
    • 1
  1. 1.Hasso Plattner Institute for Software Systems EngineeringPotsdamGermany

Personalised recommendations