An Integrated Data Management for Enterprise Systems

Martin Boissier, Jens Krueger, Johannes Wust, Hasso Plattner

2014

Abstract

Over past decades, higher demands on performance for enterprise systems have led to an increased architectural complexity. Demands as real-time analytics or graph computation add further complexity to the technology stack by adding redundancy and distributing business data over multiple components. We argue that enterprises need to simplify data management and reduce complexity as well as data redundancy. We propose a structured approach using the shearing layer concept with a unified data management to improve adaptability as well as maintainability.

References

  1. Barbusinski, L. (May 2002). Can you use one database model for olap and oltp? DM Review.
  2. Brand, S. (1994). How buildings learn. Viking, New York.
  3. Bruno, N. (2009). Teaching an old elephant new tricks. In CIDR. www.crdrdb.org.
  4. Conn, S. (2005). Oltp and olap data integration: a review of feasible implementation methods and architectures for real time data analysis.
  5. Dresner, H. (2003). Business activity monitoring: Bam architecture. Gartner Symposium ITXPO (Cannes, France).
  6. Faerber, F., Cha, S. K., Primsch, J., Bornhoevd, C., Sigg, S., and Lehner, W. (2011). Sap hana database: data management for modern business applications. SIGMOD Record, 40(4):45-51.
  7. French, C. D. (1995). ”one size fits all” database architectures do not work for dss. SIGMOD Rec., 24:449-450.
  8. Gartner (2012). Pace-layered application strategy. http://www.gartner.com/it-glossary/pace-layeredapplication-strategy/. Accessed 2013-09-27.
  9. Golfarelli, M., Rizzi, S., and Cella, I. (2004). Beyond data warehousing: what's next in business intelligence? In DOLAP 7804: Proceedings of the 7th ACM international workshop on Data warehousing and OLAP.
  10. Grosse, P., Lehner, W., and May, N. (2013). Advanced analytics with the sap hana database. In DATA 2013.
  11. Grund, M., Krueger, J., Plattner, H., Zeier, A., CudreMauroux, P., and Madden, S. (2010). Hyrise: a main memory hybrid storage engine. Proc. VLDB Endow., 4:105-116.
  12. Haas, L. M., Freytag, J. C., Lohman, G. M., and Pirahesh, H. (1989). Extensible query processing in starburst. In SIGMOD Conference, pages 377-388. ACM Press.
  13. Howard, S. (May 2002). Can you use one database model for olap and oltp? DM Review.
  14. Inmon, W. H. (1999). Building the Operational Data Store. John Wiley & Sons, Inc., New York, NY, USA.
  15. Jaecksch, B., Lehner, W., and Faerber, F. (2010). A plan for olap. In EDBT, volume 426 of ACM International Conference Proceeding Series, pages 681-686. ACM.
  16. Kallman, R., Kimura, H., Natkins, J., Pavlo, A., Rasin, A., Zdonik, S. B., Jones, E. P. C., Madden, S., Stonebraker, M., Zhang, Y., Hugg, J., and Abadi, D. J. (2008). H-store: a high-performance, distributed main memory transaction processing system. PVLDB, 1(2):1496-1499.
  17. Kemper, A. and Neumann, T. (2011). Hyper: A hybrid oltp&olap main memory database system based on virtual memory snapshots. In ICDE, pages 195-206. IEEE Computer Society.
  18. Krueger, J., Grund, M., Tinnefeld, C., Plattner, H., Zeier, A., and Faerber, F. (2010a). Optimizing write performance for read optimized databases. In DASFAA (2), volume 5982, pages 291-305. Springer.
  19. Krueger, J., Tinnefeld, C., Grund, M., Zeier, A., and Plattner, H. (2010b). A case for online mixed workload processing. DBTest 7810, pages 8:1-8:6, New York, NY, USA. ACM.
  20. Lahiri, T., Neimat, M.-A., and Folkman, S. (2013). Oracle timesten: An in-memory database for enterprise applications. IEEE Data Eng. Bull., 36(2):6-13.
  21. Larson, P.-A., Zwilling, M., and Farlee, K. (2013). The hekaton memory-optimized oltp engine. IEEE Data Eng. Bull., 36(2):34-40.
  22. Lindstroem, J., Raatikka, V., Ruuth, J., Soini, P., and Vakkila, K. (2013). Ibm soliddb: In-memory database optimized for extreme speed and availability. IEEE Data Eng. Bull., 36(2):14-20.
  23. MacNicol, R. and French, B. (2004). Sybase iq multiplex - designed for analytics. In Proceedings of the Thirtieth international conference on Very large data bases - Volume 30, VLDB 7804.
  24. Mangisengi, O. and Huynh, N. T. (2008). Towards a closedloop business intelligence framework. In ICEIS, pages 210-217.
  25. Papantoniou, B., Nathanael, D., and Marmaras, N. (2003). Moving target: designing for evolving practice. In HCI International 2003.
  26. Plattner, H. (2009). A common database approach for oltp and olap using an in-memory column database. In SIGMOD Conference, pages 1-2. ACM.
  27. Plattner, H. (2013). A Course in In-Memory Data Management: The Inner Mechanics of In-Memory Databases.
  28. Rudolf, M., Paradies, M., Bornhövd, C., and Lehner, W. (2013). The Graph Story of the SAP HANA Database. In BTW, pages 403-420.
  29. Sadalage, P. and Fowler, M. (2012). NoSQL Distilled: A Brief Guide to the Emerging World of Polyglot Persistence. Addison Wesley Professional.
  30. Seufert, A. and Schiefer, J. (2005). Enhanced business intelligence - supporting business processes with real-time business analytics. In DEXA Workshops, pages 919- 925. IEEE Computer Society.
  31. Shute, J., Vingralek, R., Samwel, B., Handy, B., Whipkey, C., Rollins, E., Oancea, M., Littlefield, K., Menestrina, D., Ellner, S., Cieslewicz, J., Rae, I., Stancescu, T., and Apte, H. (2013). F1: A distributed sql database that scales. PVLDB, 6(11):1068-1079.
  32. Sikka, V., Färber, F., Lehner, W., Cha, S. K., Peh, T., and Bornhö vd, C. (2012). Efficient transaction processing in sap hana database: the end of a column store myth. In SIGMOD Conference, pages 731-742. ACM.
  33. Simmonds, I. and Ing, D. (2000). A shearing layers approach to information systems development. Technical Report RC 21694, IBM Research.
  34. Stonebraker, M. and C¸ etintemel, U. (2005). ”one size fits all”: An idea whose time has come and gone. In Proceedings of the 21st International Conference on Data Engineering, pages 2-11.
  35. Stonebraker, M. and Weisberg, A. (2013). The voltdb main memory dbms. IEEE Data Eng. Bull., 36(2):21-27.
  36. Tinnefeld, C., Mueller, S., Zeier, A., and Plattner, H. (2011). Available-to-promise on an in-memory column store. In Datenbanksysteme in Business, Technologie und Web (BTW 2011), Proceedings.
  37. Truex, D. P., Baskerville, R., and Klein, H. K. (1999). Growing systems in emergent organizations. Commun. ACM, 42(8):117-123.
  38. Watson, H. J. and Wixom, B. H. (2007). The current state of business intelligence. Computer, 40(9):96-99.
Download


Paper Citation


in Harvard Style

Boissier M., Krueger J., Wust J. and Plattner H. (2014). An Integrated Data Management for Enterprise Systems . In Proceedings of the 16th International Conference on Enterprise Information Systems - Volume 3: ICEIS, ISBN 978-989-758-029-1, pages 410-418. DOI: 10.5220/0004897204100418


in Bibtex Style

@conference{iceis14,
author={Martin Boissier and Jens Krueger and Johannes Wust and Hasso Plattner},
title={An Integrated Data Management for Enterprise Systems},
booktitle={Proceedings of the 16th International Conference on Enterprise Information Systems - Volume 3: ICEIS,},
year={2014},
pages={410-418},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0004897204100418},
isbn={978-989-758-029-1},
}


in EndNote Style

TY - CONF
JO - Proceedings of the 16th International Conference on Enterprise Information Systems - Volume 3: ICEIS,
TI - An Integrated Data Management for Enterprise Systems
SN - 978-989-758-029-1
AU - Boissier M.
AU - Krueger J.
AU - Wust J.
AU - Plattner H.
PY - 2014
SP - 410
EP - 418
DO - 10.5220/0004897204100418