Author Erwin Homan
-
Column oriented storage in SAP HANA
All column oriented tables are also made available in row oriented form by SAP HANA. This makes it possible to choose the best way to access the data: via the row store or the column store. Changes to the data require extra work to update both the row and the column store.
Posted · Author Erwin Homan
-
SAP HANA database manager - introduction
The key challenge of designing contemporary database management software: on large data sets it has to work well for both row and column oriented operations. An ERP-application requests many, simple, row oriented read and write operations: request a row, update and store it. An analytics-application requests fewer operations, mostly reading, but on larger data sets. Simplified: the traditional row oriented organization of data is well-suited for Online Transactional Processing (OLTP, like ERP). The column store suits Online Analytical Processing (OLAP, like business intelligence) much better.
Posted · Author Erwin Homan
-
About the domain name
Posted · Author Erwin Homan
-
2017 will be crucial for SAP HANA
Posted · Author Erwin Homan
-
A new blog
Posted · Author Erwin Homan