Business Object Query Language as Data Access API in ERP Systems
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.
KeywordsERP 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.
- 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
- 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
- 6.Monk, S., Sommerville, I.: Schema evolution in oodbs using class versioning. In: ACM SIGMOD, pp. 16–22 (1993)Google Scholar
- 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.Yu, J., Benatallah, B., Casati, F., Daniel, F.: Understanding mashup development. In: IEEE Internet Computing, pp. 44–52 (2008)Google Scholar