row orientation in SanssouciDB

[Former Member]

Hi everybody,

according to several papers and the "In-Memory Data Management" book out there, SanssouciDB uses a hybrid approach combining row- and column-oriented tables for storing data. But, in these papers as well as in the book, there are only column-oriented structures explained. The only point where rows came into play was in the introduction of combined columns.

My questions now are: Are there really pure row-oriented tables? And if there are any, where are they and how could a user/database administrator influence if row- or column-oriented tables are used?

Thanks in advance

Patrick

[Former Member]

Hi Patrick,

in HANA (I think SansouciDB was its code name during the design in Hasso-Plattner-Institute) you can choose, while creating the table, if it is column- or row-store. In my opinion the implementation of the row-store tables is no different from other DBMS, that's why it is not described with so much detail as column-store, which is an innovative approach.

Best,

Jakub