FLEXIBLE DATA ACCESS IN ERP SYSTEMS

Vadym Borovskiy, Wolfgang Koch, Alexander Zeier

Abstract

Flexible data access is a necessary prerequisite to satisfy a number of acute needs of ERP system users and application developers. However, currently available ERP systems do not provide the ability to access and manipulate ERP data at any granularity level. 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. 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.

References

  1. Banerjee, J., Kim, W., Kim, H.-J., and Korth, H. F. (1987). Semantics and implementation of schema evolution in object-oriented databases. In Proceedings of the 1987 ACM SIGMOD international conference on Management of data, pages 311 - 322.
  2. Bertino, E. (1992). A view mechanism for objectoriented databases. In Proceedings of the 3rd International Conference on Extending Database Technology, pages 136 - 151.
  3. Bratsberg, S. E. (1992). Unified class evolution by objectoriented views. In Proceedings of the 11th International Conference on the Entity-Relationship Approach, pages 423 - 439.
  4. Curino, C. A., Moon, H. J., and Zaniolo, C. (2008). Graceful database schema evolution: the prism workbench. In Proceedings of the VLDB Endowment, pages 761- 772.
  5. Liu, C.-T., Chrysanthis, P. K., and Chang, S.-K. (1994). Database schema evolution through the specification and maintenance of changes on entities and relationships. In Proceedings of the13th International Conference on the Entity-Relationship Approach, pages 132 - 151.
  6. Monk, S. and Sommerville, I. (1993). Schema evolution in oodbs using class versioning. In ACM SIGMOD, pages 16 - 22.
  7. Shiling, J. J. and Sweeney, P. F. (1989). Three steps to views: extending the object-oriented paradigm. In Conference proceedings on Object-oriented programming systems, languages and applications, pages 353 - 361.
  8. Yu, J., Benatallah, B., Casati, F., and Daniel, F. (2008). Understanding mashup development. IEEE Internet Computing, pages 44-52.
Download


Paper Citation


in Harvard Style

Borovskiy V., Koch W. and Zeier A. (2010). FLEXIBLE DATA ACCESS IN ERP SYSTEMS . In Proceedings of the 12th International Conference on Enterprise Information Systems - Volume 1: ICEIS, ISBN 978-989-8425-04-1, pages 96-104. DOI: 10.5220/0002976700960104


in Bibtex Style

@conference{iceis10,
author={Vadym Borovskiy and Wolfgang Koch and Alexander Zeier},
title={FLEXIBLE DATA ACCESS IN ERP SYSTEMS},
booktitle={Proceedings of the 12th International Conference on Enterprise Information Systems - Volume 1: ICEIS,},
year={2010},
pages={96-104},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0002976700960104},
isbn={978-989-8425-04-1},
}


in EndNote Style

TY - CONF
JO - Proceedings of the 12th International Conference on Enterprise Information Systems - Volume 1: ICEIS,
TI - FLEXIBLE DATA ACCESS IN ERP SYSTEMS
SN - 978-989-8425-04-1
AU - Borovskiy V.
AU - Koch W.
AU - Zeier A.
PY - 2010
SP - 96
EP - 104
DO - 10.5220/0002976700960104