Skip to Content
avatar image
Former Member

row orientation in SanssouciDB

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Jan 23, 2013 at 09:19 AM

    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

    Add comment
    10|10000 characters needed characters exceeded