Nicely explained the concepts column store and row store and the differences between those, thanks for your efforts and sharing this video. One can easily understand the concepts.
2 Doubts please! 1. Do you mean business analytics is just only with whole colomn operation. 2. Is this computer concept is new after such long adaptations of RDBMS? And is this a new INNOVATION by SAP?
Why only select ? What about insert, update, delete. In insert rows are way faster same for update and delete. Best approach is to have a mixture not all in columns or rows.
It is still not clear why it is faster, i can see the number of hops is the same for both col and row. Another question when data is compressed (in col)how the system will know where is the end of the record?
He is wrong about it. A column with 10 million entries but only 10 different types of values will typically not "compress by 1 million times", because typically columnar stores have the same order for records in every column. Compression is big in that case but the numbers/examples he's giving are wrong.
Nicely explained the concepts column store and row store and the differences between those, thanks for your efforts and sharing this video. One can easily understand the concepts.
Excellent explanation of row and column store tables
Glad you liked it
Excellent! well appreciated your contribution. finally understood this apparently simple but considerably so complex topic. Thanks
Great to hear. thank you
@@Time4HANA need communication for course
Excellent! Very well explained, How it will read the compressed columns..?
Thank you NagaRaju
Read will happen in the dictionary decoding/encoding method.
Video chaala baa unadi.
Thank you very much, very well explained!
Thanks sir. Really understood the concept. :)
2 Doubts please!
1. Do you mean business analytics is just only with whole colomn operation.
2. Is this computer concept is new after such long adaptations of RDBMS? And is this a new INNOVATION by SAP?
Why only select ? What about insert, update, delete. In insert rows are way faster same for update and delete. Best approach is to have a mixture not all in columns or rows.
That’s very good point. Yes HANA have row store table for write operations. Take a look at delta merge video.
how to truncate 123465489 to 123465 in sap hana sql?
Many thanks good explain
Glad it was helpful!
Very well explained!
It is still not clear why it is faster, i can see the number of hops is the same for both col and row. Another question when data is compressed (in col)how the system will know where is the end of the record?
He is wrong about it. A column with 10 million entries but only 10 different types of values will typically not "compress by 1 million times", because typically columnar stores have the same order for records in every column. Compression is big in that case but the numbers/examples he's giving are wrong.
what is a CAMPETAR ?? is it part of KALAMS ?? and please explain ADAR also in detail
Thank you so much! 5*
thanks sir