SEMANTICALLY RICH API FOR IN-DATABASE DATA MANIPULATION IN MAIN-MEMORY ERP SYSTEMS

Vadym Borovskiy, Christian Schwarz, Alexander Zeier, Wolfgang Koch

2011

Abstract

Assuming the feasibility of main-memory database management systems, the current research aims at designing a new type of data manipulation API, called Business Object Query Language (BOQL), specifically tailored for in-database data manipulation in main-memory ERP systems. The paper contributes the concept of business object virtualization and describes a query processor that takes advantage of this concept. The first serves as a means of grouping raw memory-resident data into high-level data structures, while the second exposes a flexible query-like API to manipulate the high-level data structures. Special effort has been dedicated to integrating the API into C++ programming language.

References

  1. Bernstein, P. A., Pal, S., and Shutt, D. (1999). Contextbased prefetch for implementing objects on relations. In VLDB 7899: Proceedings of the 25th International Conference on Very Large Data Bases, pages 327- 338.
  2. Bernstein, P. A., Pal, S., and Shutt, D. (1999). Contextbased prefetch for implementing objects on relations. In VLDB 7899: Proceedings of the 25th International Conference on Very Large Data Bases, pages 327- 338.
  3. Boral, H., Alexander, W., Clay, L., Copeland, G., Danforth, S., Franklin, M., Hart, B., Smith, M., and Valduriez, P. (1990). Prototyping bubba, a highly parallel database system. IEEE Transactions on Knowledge and Data Engineering, 2(1):24.
  4. Boral, H., Alexander, W., Clay, L., Copeland, G., Danforth, S., Franklin, M., Hart, B., Smith, M., and Valduriez, P. (1990). Prototyping bubba, a highly parallel database system. IEEE Transactions on Knowledge and Data Engineering, 2(1):24.
  5. Borovskiy, V., Enderlein, S., and Zeier, A. (2009). Generic web services - extensible functionality with stable interface. In IEEE International Conference on Web Services.
  6. Borovskiy, V., Enderlein, S., and Zeier, A. (2009). Generic web services - extensible functionality with stable interface. In IEEE International Conference on Web Services.
  7. DeWitt, D., Ghandeharizadeh, S., Schneider, D., Bricker, A., Hsiao, H., and Rasmussen, R. (1990). The gamma database machine project. IEEE Transactions on Knowledge and Data Engineering, pages 44-62.
  8. DeWitt, D., Ghandeharizadeh, S., Schneider, D., Bricker, A., Hsiao, H., and Rasmussen, R. (1990). The gamma database machine project. IEEE Transactions on Knowledge and Data Engineering, pages 44-62.
  9. Grund, M., Krueger, J., and Zeier, A. (2008). Declarative web service entities with virtual endpoints. In Proceedings of the IEEE International Conference on Services Computing.
  10. Grund, M., Krueger, J., and Zeier, A. (2008). Declarative web service entities with virtual endpoints. In Proceedings of the IEEE International Conference on Services Computing.
  11. Kallman, R., Kimura, H., Natkins, J., Pavlo, A., Rasin, A., Zdonik, S., Jones, E. P. C., Madden, S., Stonebraker, M., Zhang, Y., Hugg, J., and Abadi, D. J. (2008). Hstore: a high-performance, distributed main memory transaction processing system. Proc. VLDB Endow., 1(2):1496-1499.
  12. Kallman, R., Kimura, H., Natkins, J., Pavlo, A., Rasin, A., Zdonik, S., Jones, E. P. C., Madden, S., Stonebraker, M., Zhang, Y., Hugg, J., and Abadi, D. J. (2008). Hstore: a high-performance, distributed main memory transaction processing system. Proc. VLDB Endow., 1(2):1496-1499.
  13. Legler, T., Lehner, W., and Ross, A. (2006). Data mining with the sap netweaver bi accelerator. In Proceedings of the 32nd international conference on Very large data bases, VLDB 7806, pages 1059-1068. VLDB Endowment.
  14. Legler, T., Lehner, W., and Ross, A. (2006). Data mining with the sap netweaver bi accelerator. In Proceedings of the 32nd international conference on Very large data bases, VLDB 7806, pages 1059-1068. VLDB Endowment.
  15. Manegold, S., Boncz, P. A., and Kersten, M. L. (2000). Optimizing database architecture for the new bottleneck: memory access. The VLDB Journal, 9:231-246.
  16. Manegold, S., Boncz, P. A., and Kersten, M. L. (2000). Optimizing database architecture for the new bottleneck: memory access. The VLDB Journal, 9:231-246.
  17. Mehta, M. and DeWitt, D. (1997). Data placement in shared-nothing parallel database systems. The VLDB Journal, 6(1):53-72.
  18. Mehta, M. and DeWitt, D. (1997). Data placement in shared-nothing parallel database systems. The VLDB Journal, 6(1):53-72.
  19. Resende, L. (2007). Handling heterogeneous data sources in a soa environment with service data objects. In ACM SIGMOD international conference on Management of data.
  20. Resende, L. (2007). Handling heterogeneous data sources in a soa environment with service data objects. In ACM SIGMOD international conference on Management of data.
  21. Stonebraker, M., Madden, S., Abadi, D. J., Harizopoulos, S., Hachem, N., and Helland, P. (2007). The end of an architectural era: (it's time for a complete rewrite). In Proceedings of the 33rd international conference on Very large data bases, VLDB 7807, pages 1150-1160. VLDB Endowment.
  22. Stonebraker, M., Madden, S., Abadi, D. J., Harizopoulos, S., Hachem, N., and Helland, P. (2007). The end of an architectural era: (it's time for a complete rewrite). In Proceedings of the 33rd international conference on Very large data bases, VLDB 7807, pages 1150-1160. VLDB Endowment.
  23. Teeuw, W. and Blanken, H. (1993). Control versus data flow in parallel database machines. IEEE Transactions on Parallel and Distributed Systems, 4(11).
  24. Teeuw, W. and Blanken, H. (1993). Control versus data flow in parallel database machines. IEEE Transactions on Parallel and Distributed Systems, 4(11).
Download


Paper Citation


in Harvard Style

Borovskiy V., Schwarz C., Zeier A. and Koch W. (2011). SEMANTICALLY RICH API FOR IN-DATABASE DATA MANIPULATION IN MAIN-MEMORY ERP SYSTEMS . In Proceedings of the 13th International Conference on Enterprise Information Systems - Volume 1: ICEIS, ISBN 978-989-8425-53-9, pages 253-260. DOI: 10.5220/0003503502530260


in Harvard Style

Borovskiy V., Schwarz C., Zeier A. and Koch W. (2011). SEMANTICALLY RICH API FOR IN-DATABASE DATA MANIPULATION IN MAIN-MEMORY ERP SYSTEMS . In Proceedings of the 13th International Conference on Enterprise Information Systems - Volume 1: ICEIS, ISBN 978-989-8425-53-9, pages 253-260. DOI: 10.5220/0003503502530260


in Bibtex Style

@conference{iceis11,
author={Vadym Borovskiy and Christian Schwarz and Alexander Zeier and Wolfgang Koch},
title={SEMANTICALLY RICH API FOR IN-DATABASE DATA MANIPULATION IN MAIN-MEMORY ERP SYSTEMS},
booktitle={Proceedings of the 13th International Conference on Enterprise Information Systems - Volume 1: ICEIS,},
year={2011},
pages={253-260},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0003503502530260},
isbn={978-989-8425-53-9},
}


in Bibtex Style

@conference{iceis11,
author={Vadym Borovskiy and Christian Schwarz and Alexander Zeier and Wolfgang Koch},
title={SEMANTICALLY RICH API FOR IN-DATABASE DATA MANIPULATION IN MAIN-MEMORY ERP SYSTEMS},
booktitle={Proceedings of the 13th International Conference on Enterprise Information Systems - Volume 1: ICEIS,},
year={2011},
pages={253-260},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0003503502530260},
isbn={978-989-8425-53-9},
}


in EndNote Style

TY - CONF
JO - Proceedings of the 13th International Conference on Enterprise Information Systems - Volume 1: ICEIS,
TI - SEMANTICALLY RICH API FOR IN-DATABASE DATA MANIPULATION IN MAIN-MEMORY ERP SYSTEMS
SN - 978-989-8425-53-9
AU - Borovskiy V.
AU - Schwarz C.
AU - Zeier A.
AU - Koch W.
PY - 2011
SP - 253
EP - 260
DO - 10.5220/0003503502530260


in EndNote Style

TY - CONF
JO - Proceedings of the 13th International Conference on Enterprise Information Systems - Volume 1: ICEIS,
TI - SEMANTICALLY RICH API FOR IN-DATABASE DATA MANIPULATION IN MAIN-MEMORY ERP SYSTEMS
SN - 978-989-8425-53-9
AU - Borovskiy V.
AU - Schwarz C.
AU - Zeier A.
AU - Koch W.
PY - 2011
SP - 253
EP - 260
DO - 10.5220/0003503502530260