Gregor Hackenbroich
Gregor Hackenbroich has a total of 18 co-authors. Here are the top co-authors by number of shared publications:
- Anja Klein
SAP Research Dresden
4 shared publications - Bernhard Wolf
SAP SE
2 shared publications - Jürgen Anke
Hochschule für Technik und Wirtschaft Dresden, Dresden, Deutschland
2 shared publications - Mario Neugebauer
SAP Research CEC Dresden Dresden University of Technology Germany
2 shared publications - Zbigniew Jerzak
SAP SE
2 shared publications - Christof Bornhövd
SAP Research Center LLC
1 shared publication
Latest Publications
- 6 August 2015
- Published by Springer Nature in The VLDB Journal
- Vol. 25 (1) , 53-77
VDDA: automatic visualization-driven data aggregation in relational databases
- 6 August 2015
- Published by Springer Nature in The VLDB Journal
- Vol. 25 (1) , 53-77
VDDA: automatic visualization-driven data aggregation in relational databases
- Open Access
A Storage Advisor for Hybrid-Store Databases
With the SAP HANA database, SAP offers a high-performance in-memory hybrid-store database. Hybrid-store databases---that is, databases supporting row- and column-oriented data management---are getting more and more prominent. While the columnar management offers high-performance capabilities for analyzing large quantities of data, the row-oriented store can handle transactional point queries as well as inserts and updates more efficiently. To effectively take advantage of both stores at the same time the novel question whether to store the given data row- or column-oriented arises. We tackle this problem with a storage advisor tool that supports database administrators at this decision. Our proposed storage advisor recommends the optimal store based on data and query characteristics; its core is a cost model to estimate and compare query execution times for the different stores. Besides a per-table decision, our tool also considers to horizontally and vertically partition the data and manage the partitions on different stores. We evaluated the storage advisor for the use in the SAP HANA database; we show the recommendation quality as well as the benefit of having the data in the optimal store with respect to increased query performance.
Open AccessA Storage Advisor for Hybrid-Store Databases
With the SAP HANA database, SAP offers a high-performance in-memory hybrid-store database. Hybrid-store databases---that is, databases supporting row- and column-oriented data management---are getting more and more prominent. While the columnar management offers high-performance capabilities for analyzing large quantities of data, the row-oriented store can handle transactional point queries as well as inserts and updates more efficiently. To effectively take advantage of both stores at the same time the novel question whether to store the given data row- or column-oriented arises. We tackle this problem with a storage advisor tool that supports database administrators at this decision. Our proposed storage advisor recommends the optimal store based on data and query characteristics; its core is a cost model to estimate and compare query execution times for the different stores. Besides a per-table decision, our tool also considers to horizontally and vertically partition the data and manage the partitions on different stores. We evaluated the storage advisor for the use in the SAP HANA database; we show the recommendation quality as well as the benefit of having the data in the optimal store with respect to increased query performance.
- 24 May 2011
- Published by IGI Global Scientific Publishing
- p. 970-977
PROMISE
Product lifecycle management (PLM) processes can be greatly improved and extended if more information on the product and its use is available during the various lifecycle phases. The PROMISE project aims to close the information loop by employing product embedded information devices (PEIDs) in products. In this chapter, we present the goals and application scenarios of the project with special focus on the middleware that enables the communication between PEIDs and enterprise applications. Furthermore, we give details of the design and implementation of the middleware as well as the role of Universal Plug and Play (UPnP) as device-level protocol.
- 24 May 2011
- Published by IGI Global Scientific Publishing
- p. 970-977
PROMISE
Product lifecycle management (PLM) processes can be greatly improved and extended if more information on the product and its use is available during the various lifecycle phases. The PROMISE project aims to close the information loop by employing product embedded information devices (PEIDs) in products. In this chapter, we present the goals and application scenarios of the project with special focus on the middleware that enables the communication between PEIDs and enterprise applications. Furthermore, we give details of the design and implementation of the middleware as well as the role of Universal Plug and Play (UPnP) as device-level protocol.
- 18 January 2011
- Published by IGI Global Scientific Publishing
- p. 559-566
PROMISE
- 1 April 2007
- Published by Institute of Electrical and Electronics Engineers (IEEE)
- p. 3-10
Representing Data Quality for Streaming and Static Data
In smart item environments, multitude of sensors are applied to capture data about product conditions and usage to guide business decisions as well as production automation processes. A big issue in this application area is posed by the restricted quality of sensor data due to limited sensor precision as well as sensor failures and malfunctions. Decisions derived on incorrect or misleading sensor data are likely to be faulty. The issue of how to efficiently provide applications with information about data quality (DQ) is still an open research problem. In this paper, we present a flexible model for the efficient transfer and management of data quality for streaming as well as static data. We propose a data stream metamodel to allow for the propagation of data quality from the sensors up to the respective business application without a significant overhead of data. Furthermore, we present the extension of the traditional RDBMS metamodel to permit the persistent storage of data quality information in a relational database. Finally, we demonstrate a data quality metadata mapping to close the gap between the streaming environment and the target database. Our solution maintains a flexible number of DQ dimensions and supports applications directly consuming streaming data or processing data filed in a persistent database.
- 1 April 2007
- Published by Institute of Electrical and Electronics Engineers (IEEE)
- p. 3-10
Representing Data Quality for Streaming and Static Data
In smart item environments, multitude of sensors are applied to capture data about product conditions and usage to guide business decisions as well as production automation processes. A big issue in this application area is posed by the restricted quality of sensor data due to limited sensor precision as well as sensor failures and malfunctions. Decisions derived on incorrect or misleading sensor data are likely to be faulty. The issue of how to efficiently provide applications with information about data quality (DQ) is still an open research problem. In this paper, we present a flexible model for the efficient transfer and management of data quality for streaming as well as static data. We propose a data stream metamodel to allow for the propagation of data quality from the sensors up to the respective business application without a significant overhead of data. Furthermore, we present the extension of the traditional RDBMS metamodel to permit the persistent storage of data quality information in a relational database. Finally, we demonstrate a data quality metadata mapping to close the gap between the streaming environment and the target database. Our solution maintains a flexible number of DQ dimensions and supports applications directly consuming streaming data or processing data filed in a persistent database.
- 17 February 2006
- Published by Springer Nature
- p. 33-51
Optimizing Business Processes by Automatic Data Acquisition: RFID Technology and Beyond
- 17 February 2006
- Published by Springer Nature
- p. 33-51
Optimizing Business Processes by Automatic Data Acquisition: RFID Technology and Beyond